1
# Test methods in Jifty::DBI::Handle::Pg
6
use Test::More tests => 2;
10
$package = 'Jifty::DBI::Handle::Pg';
13
use Jifty::DBI::Collection;
15
package Foo::Bar::Collection;
16
our @ISA = 'Jifty::DBI::Collection';
18
sub query_columns { "blah" }
24
# Test sub distinct_query
25
my $collection = bless {
58
column => 'session_offset',
62
}, 'Foo::Bar::Collection';
63
my $stmt = 'select * from users';
64
$package->distinct_query(\$stmt, $collection);
66
'SELECT blah FROM ( SELECT main.id FROM select * from users GROUP BY main.id'
67
. ' ORDER BY main.id ASC, min(main.name) DESC, min(foo.id) DESC, '
68
. 'min(foo.name) DESC, id ASC, min(blood) ASC, min(session_offset) ASC ) '
69
. 'distinctquery, bars main WHERE (main.id = distinctquery.id)',
70
'distinct_query works';