Dave Cross wrote: > I'm revisiting an old project that I last worked on a year ago. I have > the DBIx::Class schema files, but the database itself disappeared in a > server move and I (stupidly) didn't put the DDL into git. > > Is there a way to take a set of DBIx::Class schema classes and > (re-)generate the DDL that was originally used to generate the classes? > > I know I can manually create the DDL by looking at the classes. And in > this case, that might well be the quickest solution. But in case I make > the same mistake again I'd like to know if DBIx::Class has a way to do this. > > This is for MySQL - I suppose that makes a difference.
http://search.cpan.org/~ribasushi/DBIx-Class-0.08118/lib/DBIx/Class/Storage/DBI.pm#deployment_statements This is the method used by $schema->deploy(), which will generate the database for you. As Ian already mentioned a lot of use chose to maintain the schema in DBIC/perl only, and use ::Versioned to reflect changes in the database. _______________________________________________ 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]
