X-Git-Url: https://git.m6w6.name/?p=m6w6%2Fext-pq;a=blobdiff_plain;f=tests%2Ftrans001.phpt;fp=tests%2Ftrans001.phpt;h=02b8c1779f5b5d56834e53b5317e83fd78300d7f;hp=0000000000000000000000000000000000000000;hb=01a3a98f9a7fa77699a21ed9fe39b5f5eff3b0c3;hpb=53220e4b7f293ed8c1c8418efc98c57d4b205e1d

diff --git a/tests/trans001.phpt b/tests/trans001.phpt
new file mode 100644
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