add cursor support

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

diff --git a/tests/cursor001.phpt b/tests/cursor001.phpt
new file mode 100644 (file)
index 0000000..1e912b5
--- /dev/null
+++ b/tests/cursor001.phpt
@@ -0,0 +1,36 @@
+--TEST--
+cursor
+--SKIPIF--
+<?php include "_skipif.inc"; ?>
+--FILE--
+<?php
+echo "Test\n";
+
+include "_setup.inc";
+
+$c = new pq\Connection(PQ_DSN);
+$p = $c->declare("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--
+Test
+       0
+       2
+       6
+       8
+       12
+       14
+       18
+       20
+       24
+       26
+===DONE===