/[pgestraier]/trunk/t/pgest.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 /trunk/t/pgest.t

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

revision 12 by dpavlin, Wed May 25 23:38:37 2005 UTC revision 22 by dpavlin, Thu May 26 20:16:34 2005 UTC
# Line 2  Line 2 
2    
3  use strict;  use strict;
4    
5  use Test::More tests => 49;  use Test::More tests => 67;
6    
7  BEGIN {  BEGIN {
8          use_ok('DBI');          use_ok('DBI');
# Line 25  if ($pwd !~ m#^/#) { Line 25  if ($pwd !~ m#^/#) {
25  ok($pwd, "pwd: $pwd");  ok($pwd, "pwd: $pwd");
26  my $index = "$pwd/../data/casket/";  my $index = "$pwd/../data/casket/";
27    
28  my $sql = "select * from pgest('$index',?,?,?,?)";  my $sql = "select * from pgest('$index',?,?,?,?,?) as (id text)";
29  diag "$sql";  diag "$sql";
30    
31  my $sth = $dbh->prepare($sql) || die $dbh->errstr();  my $sth = $dbh->prepare($sql) || die $dbh->errstr();
32  ok($sth, "sth");  ok($sth, "sth");
33    
34  sub pgest {  sub pgest {
35          $sth->execute(@_) || die $sth->errstr();          $sth->execute(@_, "{'\@id'}" ) || die $sth->errstr();
36          {          {
37                  no warnings;                  no warnings;
38                  ok($sth, "execute(".join(",",@_).")");                  ok($sth, "execute(".join(",",@_).")");
# Line 95  cmp_ok($hits, '==', pgest('blade runner' Line 95  cmp_ok($hits, '==', pgest('blade runner'
95  cmp_ok($hits, '==', pgest('blade runner', '', 0, undef), "null offset");  cmp_ok($hits, '==', pgest('blade runner', '', 0, undef), "null offset");
96  cmp_ok($hits, '==', pgest('blade runner', undef, undef, undef), "null optional");  cmp_ok($hits, '==', pgest('blade runner', undef, undef, undef), "null optional");
97    
98    # test limit, offset and global mess
99    my $d = int($hits / 3);
100    cmp_ok($d, '==', pgest('blade runner',undef, $d, undef), "limit $d");
101    cmp_ok($hits, '==', pgest('blade runner', undef, undef, undef), "check");
102    
103    cmp_ok(($hits - $d), '==', pgest('blade runner',undef, undef, $d), "offset $d");
104    cmp_ok($hits, '==', pgest('blade runner', undef, undef, undef), "check");
105    
106    cmp_ok(($hits - $d - $d), '==', pgest('blade runner',undef, ($hits - $d), $d), "limit $d offset $d");
107    cmp_ok($hits, '==', pgest('blade runner', undef, undef, undef), "check");
Legend:
Removed from v.12  
changed lines
  Added in v.22
  ViewVC Help
Powered by ViewVC 1.1.26