transactions

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

diff --git a/tests/trans001.phpt b/tests/trans001.phpt
new file mode 100644 (file)
index 0000000..02b8c17
--- /dev/null
+++ b/tests/trans001.phpt
@@ -0,0 +1,30 @@
+--TEST--
+transaction
+--SKIPIF--
+<?php include "_skipif.inc"; ?>
+--FILE--
+<?php
+echo "Test\n";
+
+include "_setup.inc";
+
+$c = new pq\Connection(PQ_DSN);
+$t = new pq\Transaction($c);
+$c->exec("CREATE TABLE test (id serial, data text)");
+$s = $c->prepare("test_insert", "INSERT INTO test (data) VALUES (\$1)", array($c->types->byName->text->oid));
+$s->exec(array("a"));
+$s->exec(array("b"));
+$s->exec(array("c"));
+$r = $c->exec("SELECT * FROM test");
+while ($row = $r->fetchRow(pq\Result::FETCH_OBJECT)) {
+       printf("%d => %s\n", $row->id, $row->data);
+}
+$t->rollback();
+?>
+DONE
+--EXPECT--
+Test
+1 => a
+2 => b
+3 => c
+DONE