Selecting date using DBIx::Class and InflateColumn

nybble_1 has asked for the wisdom of the Perl Monks concerning the following question:

I beseech you to right my wrongs!

I am unable retrieve a row using DBIx::Class when specifying the datatype as 'datetime' to use with InflateColumns. The SQL that is generated gives me an error: "You have an error in your SQL syntax;" ... blah blah blah; the key error in the SQL is the datatype hash below:

SELECT me.id, me.token, me.old_invoice, me.date, me.=>, me.{data_type,
+ me.'datetime'} FROM invoices me ...
[download]

I am able to save date data flawlessly; I am also able to retrieve data from this field when I remove the datetime datatype from my column declaration. My Class is:

    package SEM::Main::Invoices;
    use base qw/DBIx::Class/;
    __PACKAGE__->load_components(qw/PK::Auto InflateColumn::DateTime C
+ore/);
    __PACKAGE__->table('invoices');
    __PACKAGE__->add_columns(qw/id
                             token
                             old_invoice
                             date  => {data_type => 'datetime'}
                        /);
    __PACKAGE__->set_primary_key('id');
    1;
[download]

My code retrieving the result set is:

    my $rowI = $schema->resultset("Invoices")->search({token=>$sTarget
+})->first;
[download]

Any thoughts would be welcome;

TIA to those Monks of the digital cloth.

nybble

Comment on Selecting date using DBIx::Class and InflateColumn Select or Download Code

Replies are listed 'Best First'.
Re: Selecting date using DBIx::Class and InflateColumn by friedo (Prior) on Jul 11, 2008 at 20:20 UTC
The problem is that you're using `qw` in the list that you're passing to `add_columns`. What you're actually passing is the list `( 'id', 'token', 'old_invoice', 'date', '=>', '{data_type', '=>', \'datetime\'}' )` In order to pass a list of column-name => hashref pairs, you'll need to write it like this: `__PACKAGE__->add_columns(id => { }, token => { }, old_invoice => { }, date => {data_type => 'datetime'} );` [download] Alternatively, you can pass a list of the plain column names (no hashrefs) and specify the date column type later: `__PACKAGE__->add_columns(qw/id token old_invoice/); __PACKAGE__->add_columns(date => {data_type => 'datetime'});` [download] Update: Fixed typos	[reply] [d/l] [select]
Re^2: Selecting date using DBIx::Class and InflateColumn by nybble_1 (Novice) on Jul 11, 2008 at 22:11 UTC
That was it Thanks Friendo	[reply]