/[A3C]/t/20-sql.t
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /t/20-sql.t

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 159 by dpavlin, Sun Jun 15 14:40:50 2008 UTC revision 220 by dpavlin, Sun Jun 22 14:55:55 2008 UTC
# Line 8  test SQL module Line 8  test SQL module
8    
9  =cut  =cut
10    
11  use Jifty::Test tests => 20;  use Jifty::Test tests => 25;
12    
13  use Data::Dump qw/dump/;  use Data::Dump qw/dump/;
14    
# Line 24  is( $sql->query, $query, 'sql' ); Line 24  is( $sql->query, $query, 'sql' );
24    
25  cmp_ok( $sql->count, '==', 1, 'count' );  cmp_ok( $sql->count, '==', 1, 'count' );
26    
27    ok( my $duration = $sql->duration, 'duration' );
28    diag "duration: $duration";
29    
30  ok( my $row = $sql->next, 'next' );  ok( my $row = $sql->next, 'next' );
31    
32  isa_ok( $row, 'A3C::SQL::row' );  isa_ok( $row, 'A3C::SQL::row' );
33    
34  ok( $row->nr, 'row has accessor' );  ok( $row->nr, 'row has accessor' );
35    
 diag $row->nr;  
36  is( $row->nr, 42, 'nr' );  is( $row->nr, 42, 'nr' );
37    
38  ok( ! $sql->next, 'last row' );  ok( ! $sql->next, 'last row' );
39    
40  ok( my $dbh = DBI->connect( 'DBI:Pg:dbname=template1' ), 'dbh' );  ok( my $dbh = DBI->connect( 'DBI:Pg:dbname=template1' ), 'dbh' );
41  ok( my $sql = A3C::SQL->new({ query => "select 5 as nr", dbh => $dbh }), 'new' );  ok( $sql = A3C::SQL->new({ query => "select 5 as nr", dbh => $dbh }), 'new' );
42  cmp_ok( $sql->count, '==', 1, 'count' );  cmp_ok( $sql->count, '==', 1, 'count' );
43  is_deeply( [ $sql->_column_names ], [ 'nr' ], '_column_names' );  is_deeply( [ $sql->_column_names ], [ 'nr' ], '_column_names' );
44  is_deeply( scalar $sql->_column_names, 1, 'scalar _column_names' );  is_deeply( scalar $sql->_column_names, 1, 'scalar _column_names' );
45  ok( my $row2 = $sql->next, 'next' );  ok( my $row2 = $sql->next, 'next' );
46  isa_ok( $row2, 'A3C::SQL::row' );  isa_ok( $row2, 'A3C::SQL::row' );
47  ok( $row2->nr, 'row has accessor' );  ok( $row2->nr, 'row has accessor' );
 diag $row2->nr;  
48  is( $row2->nr, 5, 'nr' );  is( $row2->nr, 5, 'nr' );
49    
50    ok( $sql = A3C::SQL->new({ query => "select 'čevapćić' as test", dbh => $dbh, encoding => 'iso-8859-2' }), 'new + encoding' );
51    cmp_ok( $sql->count, '==', 1, 'count' );
52    ok( my $row3 = $sql->next, 'next' );
53    is_deeply( $row3->test, "\x{10D}evap\x{107}i\x{107}", 'correct encoding' );
54    

Legend:
Removed from v.159  
changed lines
  Added in v.220

  ViewVC Help
Powered by ViewVC 1.1.26