On 2012-11-06 03:10, Bill Moseley wrote: I've been looking over DBIx::Class::DeploymentHandler but not sure it's really what I'm after.
We manage our schema DDL separately from our DBIC classes (it's not just DBIC that accesses the database). That is, we don't generate the schema DDL from DBIC. Here's the problem that came up recently: We have one large app that uses a DBIC model layer. Someone working on this app added a new column to a result class and ran the ALTER script on their test database. A ticket was created to make sure the ALTER script is run at (or before, really) release time on the production database. Now, in the mean time another developer worked on a second app that also uses the same DBIC model code. They did not notice the new column had been added because they use the same dev database. Of course, when that app got pushed to production the ALTER script had not been run yet for the first app. Essentially, I'm looking for ideas how to make sure that the DBIC model has its dependencies met -- which includes schema updates -- in some automated way. Hopefully in a foolproof way, too. What system do you use to make sure changes are tracked and are on the right database at the right time? What about a version table with a single version column that is checked at model connect time if the database schema version is what the model expects? -- Bill Moseley mose...@hank.org<mailto:mose...@hank.org> _______________________________________________ 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/dbix-class@lists.scsys.co.uk *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien Handelsgericht Wien, FN 79340b *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* Notice: This e-mail contains information that is confidential and may be privileged. If you are not the intended recipient, please notify the sender and then delete this e-mail immediately. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
_______________________________________________ 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/dbix-class@lists.scsys.co.uk