[ic] Interchange6::Schema

[Kaare Rasmussen]

Hi

I just tried to create an ic6 database as part of my table editor 
review. One thing that I noticed was that all tables are dropped 
unconditionally, producing errors all over when using PostgreSQL.

That's not pretty and makes it impossible to create the schema in one 
transaction, e.g.

psql -1 -f sql/Interchange6-Schema-0.007-PostgreSQL.sql

I know it's a minor issue, but it would signal an even higher attention 
to detail if the sql for PostgreSQL somehow could say DROP TABLE IF 
EXISTS instead of just DROP TABLE.

> On 11/15/2013 01:02 PM, Stefan Hornburg (Racke) wrote:
>> Hello,
>>
>> we have now a DBIx::Class schema for our new database schema in Interchange 6.
>>
>> You can install it from CPAN (or clone it from Github), e.g.
>>
>> cpanm Interchange6::Schema
>>
>> and create SQL scripts for MySQL + PostgreSQL with:
>>
>> interchange6-create-database
>>
>> These scripts will end up in sql/ directory.
>>
>> Just note we aren't done with our schema, but most tables should be close to
>> what we want.
>>
>> Documentation + Tests are coming, pull requests + feedback very appreciated.
>>
> I just released 0.004 with a few, but important changes:
>
> * Allow NULL values for foreign keys users_id and sessions_id in cart_products.
>
> - Anonymous users don't have an users_id.
> - I don't want to force DBIC based sessions (yet ?).
>
> * Add missing primary key directive to CartProduct resultset.
>
> - Allows to use DBIC ->update method, somehow the primary key directive
>    was missing.
>
> * Use datetime type in CartProduct resultset.
>
> Coming soon: Dancer plugin for Interchange6.
>
> I decided to do a new set of modules for Interchange6 instead of adjusting
> the Nitesi ones to DBIC.
>
> Regards
> 	Racke
>
> --
> Perl and Dancer Development
>
> Visit our Open Source conference on E-commerce:
>
> http://www.ecommerce-innovation.com/
>
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users