7 use DBIC::SqlMakerTest;
9 { # Fake storage driver for sqlite with autocast
10 package DBICTest::SQLite::AutoCast;
12 DBIx::Class::Storage::DBI::AutoCast
13 DBIx::Class::Storage::DBI::SQLite
18 datetime => 'DateTime',
20 int => undef, # no conversion
23 sub _native_data_type {
24 return $type_map->{$_[1]};
28 my $schema = DBICTest->init_schema (storage_type => 'DBICTest::SQLite::AutoCast');
30 # 'me.id' will be cast unlike the unqualified 'id'
31 my $rs = $schema->resultset ('CD')->search ({
33 'tracks.last_updated_at' => { '!=', undef },
34 'tracks.last_updated_on' => { '<', 2009 },
35 'tracks.position' => 4,
36 'me.single_track' => \[ '= ?', [ single_track => [1, 2, 3 ] ] ],
37 }, { join => 'tracks' });
40 [ { sqlt_datatype => 'integer', dbic_colname => 'cdid' }
42 [ { sqlt_datatype => 'integer', dbic_colname => 'single_track' }
44 [ { sqlt_datatype => 'datetime', dbic_colname => 'tracks.last_updated_on' }
46 [ { sqlt_datatype => 'int', dbic_colname => 'tracks.position' }
53 SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track
55 LEFT JOIN track tracks ON tracks.cd = me.cdid
58 AND me.single_track = ?
59 AND tracks.last_updated_at IS NOT NULL
60 AND tracks.last_updated_on < ?
61 AND tracks.position = ?
64 'expected sql with casting off',
67 $schema->storage->auto_cast (1);
72 SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track
74 LEFT JOIN track tracks ON tracks.cd = me.cdid
77 AND me.single_track = CAST(? AS INT)
78 AND tracks.last_updated_at IS NOT NULL
79 AND tracks.last_updated_on < CAST (? AS DateTime)
80 AND tracks.position = ?
83 'expected sql with casting on',