8 |
|
|
9 |
=cut |
=cut |
10 |
|
|
11 |
use Jifty::Test tests => 18; |
use Jifty::Test tests => 20; |
12 |
|
|
13 |
|
use Data::Dump qw/dump/; |
14 |
|
|
15 |
use_ok('A3C::SQL'); |
use_ok('A3C::SQL'); |
16 |
use_ok('DBI'); |
use_ok('DBI'); |
38 |
ok( my $dbh = DBI->connect( 'DBI:Pg:dbname=template1' ), 'dbh' ); |
ok( my $dbh = DBI->connect( 'DBI:Pg:dbname=template1' ), 'dbh' ); |
39 |
ok( my $sql = A3C::SQL->new({ query => "select 5 as nr", dbh => $dbh }), 'new' ); |
ok( my $sql = A3C::SQL->new({ query => "select 5 as nr", dbh => $dbh }), 'new' ); |
40 |
cmp_ok( $sql->count, '==', 1, 'count' ); |
cmp_ok( $sql->count, '==', 1, 'count' ); |
41 |
|
is_deeply( [ $sql->_column_names ], [ 'nr' ], '_column_names' ); |
42 |
|
is_deeply( scalar $sql->_column_names, 1, 'scalar _column_names' ); |
43 |
ok( my $row2 = $sql->next, 'next' ); |
ok( my $row2 = $sql->next, 'next' ); |
44 |
isa_ok( $row2, 'A3C::SQL::row' ); |
isa_ok( $row2, 'A3C::SQL::row' ); |
45 |
ok( $row2->nr, 'row has accessor' ); |
ok( $row2->nr, 'row has accessor' ); |
46 |
diag $row2->nr; |
diag $row2->nr; |
47 |
is( $row2->nr, 5, 'nr' ); |
is( $row2->nr, 5, 'nr' ); |
48 |
|
|