7 use DBIC::SqlMakerTest;
12 my $schema = DBICTest->init_schema();
14 my $sql_maker = $schema->storage->sql_maker;
16 my $date = DateTime->new(
25 my $date2 = $date->clone->set_day(16);
28 \[ $sql_maker->select ('artist', '*', { 'artist.when_began' => { -dt => $date } } ) ],
31 WHERE artist.when_began = ?
33 [['artist.when_began', '2010-12-14 12:12:12']],
37 \[ $sql_maker->update ('artist',
38 { 'artist.when_began' => { -dt => $date } },
39 { 'artist.when_ended' => { '<' => { -dt => $date2 } } },
42 SET artist.when_began = ?
43 WHERE artist.when_ended < ?
46 ['artist.when_began', '2010-12-14 12:12:12'],
47 ['artist.when_ended', '2010-12-16 12:12:12'],
52 \[ $sql_maker->select ('artist', '*', {
54 { -op => [ '=', 12, { -dt_month => { -ident => 'artist.when_began' } } ] },
55 { -op => [ '=', 2010, { -dt_get => [year => \'artist.when_began'] } ] },
56 { -op => [ '=', 14, { -dt_get => [day_of_month => \'artist.when_began'] } ] },
57 { -op => [ '=', 10, { -dt_diff => [second => { -ident => 'artist.when_began' }, \'artist.when_ended'] } ] },
63 ( ? = STRFTIME('%m', artist.when_began) ) AND
64 ( ? = STRFTIME('%Y', artist.when_began) ) AND
65 ( ? = STRFTIME('%d', artist.when_began) ) AND
66 ( ? = ( STRFTIME('%s', artist.when_began) - STRFTIME('%s', artist.when_ended)))