[Catalyst] SchemaLoader?

Jon jon+catalyst at youramigo.com
Mon Dec 25 22:31:16 GMT 2006


Likewise I couldn't get sqlt to work with DBIx::Class; it doesn't seem
to be set up to take the DBIx::Class options.  But you can achieve the
same end like this:

use SQL::Translator;

my $translator = SQL::Translator->new(
				      debug => 0,
				      trace => 0,
				      parser => 'SQL::Translator::Parser::DBIx::Class',
				      parser_args => { 'DBIx::Schema' => 'Your::Schema' },
				      to => 'MySQL',
				      );
my $output = $translator->translate();
print STDERR $translator->error unless $output;
print $output;


On Mon, 2006-12-25 at 07:21 -0800, Octavian Rasnita wrote:

> But I have another question about using the DBIx::Class, or better said 
> about SQL::Translator...
> 
> I have read in the POD docs that an .sql file can be created from a 
> DBIx::Class schema, and I have tried doing this in more ways, but without 
> success. If you know the syntax of the command line, can you please tell me?
> 
> I have tried:
> 
> sqlt --from DBIx::Class --to MySQL Schema.pm > mysql.sql
> 
> It gives an error telling that there is no subroutine DBIx::Class::Parser.
> 
> Thank you.
> 
> Octavian
> 




More information about the Catalyst mailing list