git.m6w6.name Git - m6w6/ext-pq/blob - tests/cursor001.phpt

   1 --TEST--
   2 cursor
   3 --SKIPIF--
   4 <?php include "_skipif.inc"; ?>
   5 --FILE--
   6 <?php
   7 echo "Test\n";
   8
   9 include "_setup.inc";
  10
  11 $c = new pq\Connection(PQ_DSN);
  12 $p = $c->declare("mycursor", pq\Cursor::WITH_HOLD,
  13         "SELECT * FROM generate_series(0,29) s WHERE (s%2)=0");
  14 for ($r = $p->fetch(2); $r->numRows; $p->move(1), $r = $p->fetch(2)) {
  15         foreach ($r as $row) {
  16                 foreach ($row as $col) {
  17                         echo "  $col";
  18                 }
  19                 echo "\n";
  20         }
  21 }
  22 try {
  23         $p = new pq\Cursor($c, "mycursor", pq\Cursor::WITH_HOLD,
  24                 "SELECT * FROM generate_series(0,29) s WHERE (s%2)=0");
  25 } catch (Exception $ex) {
  26         $p->close();
  27 }
  28 $p = new pq\Cursor($c, "mycursor", pq\Cursor::WITH_HOLD,
  29         "SELECT * FROM generate_series(0,29) s WHERE (s%2)=0");
  30 for ($r = $p->fetch(2); $r->numRows; $p->move(1), $r = $p->fetch(2)) {
  31         foreach ($r as $row) {
  32                 foreach ($row as $col) {
  33                         echo "  $col";
  34                 }
  35                 echo "\n";
  36         }
  37 }
  38 ?>
  39 ===DONE===
  40 --EXPECT--
  41 Test
  42         0
  43         2
  44         6
  45         8
  46         12
  47         14
  48         18
  49         20
  50         24
  51         26
  52         0
  53         2
  54         6
  55         8
  56         12
  57         14
  58         18
  59         20
  60         24
  61         26
  62 ===DONE===