[Catalyst] DBIx::Class::Loader::mysql

ben.norman at qmunity.net ben.norman at qmunity.net
Wed Nov 16 00:43:28 CET 2005


Andy,
I was putting a simple little front end together for a database of keys (the
kind of keys that open a door) for a client.

catalyst.pl Keys
mv Keys keys
cd keys
script/keys_create.pl model DB DBIC 'dbi:mysql:keys' keys keys

Ran the create script using DBIC as the model helper, it failed to create for
the table named key.
I applied the following mod which made it work.

l0027:/opt/ewide # diff perl/DBIx/Class/Loader/mysql.pm
/usr/lib/perl5/site_perl/5.8.7/DBIx/Class/Loader/mysql.pm
86c86
<     my $query = "DESCRIBE `$table`";
---
>     my $query = "DESCRIBE $table";

I dont have control over the table name and I assume that the word key in mysql
is a keyword.
Is this something that could make it into the next release?

thanks
Ben

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.



More information about the Catalyst mailing list