pq\Cursor::__construct

[m6w6/ext-pq] / tests / cursor001.phpt

diff --git a/tests/cursor001.phpt b/tests/cursor001.phpt
index 1e912b5552274cb8929f76b60e1003ec2f20f73a..f4493f09c8f5d7f6057eca575a0bb6b007728363 100644 (file)
--- a/tests/cursor001.phpt
+++ b/tests/cursor001.phpt
@@ -19,6 +19,22 @@ for ($r = $p->fetch(2); $r->numRows; $p->move(1), $r = $p->fetch(2)) {
                echo "\n";
        }
 }
+try {
+       $p = new pq\Cursor($c, "mycursor", pq\Cursor::WITH_HOLD,
+               "SELECT * FROM generate_series(0,29) s WHERE (s%2)=0");
+} catch (Exception $ex) {
+       $p->close();
+}
+$p = new pq\Cursor($c, "mycursor", pq\Cursor::WITH_HOLD,
+       "SELECT * FROM generate_series(0,29) s WHERE (s%2)=0");
+for ($r = $p->fetch(2); $r->numRows; $p->move(1), $r = $p->fetch(2)) {
+       foreach ($r as $row) {
+               foreach ($row as $col) {
+                       echo "  $col";
+               }
+               echo "\n";
+       }
+}
 ?>
 ===DONE===
 --EXPECT--
@@ -33,4 +49,14 @@ Test
        20
        24
        26
+       0
+       2
+       6
+       8
+       12
+       14
+       18
+       20
+       24
+       26
 ===DONE===