I thought this would be easy. Apparently I'm stupid.
I have a schema, which has a $VERSION. I've loaded the Versioned
component and created two scripts. The first script simply calls
$schema->create_ddl_dir with the current/prev versions and directory.
The second script simply calls $schema->upgrade
I've had no issues creating the versioned sql files themselves; both for
each version (Schema-1.sql, Schema-2.sql) and for the diffs between
versions (Schema-1-2.sql). Those files contain nothing extraordinary. I
just added column.
What has me stumnped is the initial deploy. If I simply do:
$schema->connect('dbi:SQLite:database.db')->upgrade;
I get warnings about the db not being versioned, and then the versioned
table is created. However, no other schema tables are created. I thought
that update() by itself ran all statements (run_upgrade sets ||= qr//;)
I know Versioned is finding the right upgrade_directory because if I
upgrade to a non-existing .sql file version, if bitches about not
finding the file (but it does find 1-2*.sql from above).
Yes, I'm using SQLite, but the upgrade does a simple alter. No indexes
or any other odd magic are involved it would seem.
What am I missing?
-=Chris
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
