[Dbix-class] how to set advanced SQL::Translator arguments properlyin schema deploy() method

Hermida, Leandro Leandro.Hermida at fmi.ch
Sun May 31 14:39:05 GMT 2009



Figured it out by looking into the DBIx::Class code, the documentation
for the schema convenience method for deployment_statements
ma.pm#deployment_statements needs to be updated as the parameter list
has grown/changed.  The parameter list is correctly shown in the storage


For those new users to deploy() and deployment_statements() a working
example would be:


my $sqlt_args = { show_warnings => 1, producer_args => { mysql_version
=> '5.0.51' } };


my $ddl_statements = $schema->deployment_statements(undef, undef, undef,





From: Hermida, Leandro [mailto:Leandro.Hermida at fmi.ch] 
Sent: Sunday, May 24, 2009 16:46
To: dbix-class at lists.scsys.co.uk
Subject: [Dbix-class] how to set advanced SQL::Translator arguments
properlyin schema deploy() method




I am having trouble understanding how to set the more advanced SQLT
arguments correctly in the $schema->deploy() method.   In particular,
how does one set the SQL::Translator::Producer mysql_version argument
via $schema->deploy()?  My issue is that no matter what I try it keeps
turning any DBIx::Class column data_type VARCHAR with a size greater
than 255 to a TEXT field and I want to tell it that I have MySQL 5.0.xx
which has much longer varchars. 


Thanks for any help,



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20090531/8691bd00/attachment.htm

More information about the DBIx-Class mailing list