X-Git-Url: https://git.m6w6.name/?p=m6w6%2Fext-pq;a=blobdiff_plain;f=tests%2Ftrans001.phpt;fp=tests%2Ftrans001.phpt;h=d927d2e836497c2fa0a3b13d9226d2d0589e8993;hp=e6d53ee703593da20002af807b40f2ccd22aaaed;hb=d66c976b046e2b353cd3acb89a7eb17958a3dd9b;hpb=db92ec69957a3de3e09c86c0037ff36603b7ed48 diff --git a/tests/trans001.phpt b/tests/trans001.phpt index e6d53ee..d927d2e 100644 --- a/tests/trans001.phpt +++ b/tests/trans001.phpt @@ -9,11 +9,13 @@ echo "Test\n"; include "_setup.inc"; $c = new pq\Connection(PQ_DSN); +$c->exec("DROP TABLE IF EXISTS test"); new pq\Event($c, pq\Event::NOTICE, function($c, $notice) { echo "Got notice: $notice\n"; }); $t = new pq\Transaction($c); -$c->exec("DROP TABLE IF EXISTS test; CREATE TABLE test (id serial, data text)"); +$c->exec("DROP TABLE IF EXISTS test"); +$c->exec("CREATE TABLE test (id serial, data text)"); $s = $c->prepare("test_insert", "INSERT INTO test (data) VALUES (\$1)", array((new pq\Types($c))["text"]->oid)); $s->exec(array("a")); $s->exec(array("b"));