X-Git-Url: https://git.m6w6.name/?p=m6w6%2Fext-pq;a=blobdiff_plain;f=tests%2Ftrans001.phpt;h=0524cffd8be1fbd1d401952a9c95cd91d3d0578a;hp=d927d2e836497c2fa0a3b13d9226d2d0589e8993;hb=ec79f18c30c64021ff78b631f713a4b1b380fd86;hpb=d66c976b046e2b353cd3acb89a7eb17958a3dd9b diff --git a/tests/trans001.phpt b/tests/trans001.phpt index d927d2e..0524cff 100644 --- a/tests/trans001.phpt +++ b/tests/trans001.phpt @@ -10,10 +10,12 @@ 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) { +$c->on(pq\Connection::EVENT_NOTICE, function($c, $notice) { echo "Got notice: $notice\n"; }); +var_dump($c->transactionStatus == pq\Connection::TRANS_IDLE); $t = new pq\Transaction($c); +var_dump($t->connection->transactionStatus == pq\Connection::TRANS_INTRANS); $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)); @@ -25,13 +27,17 @@ while ($row = $r->fetchRow(pq\Result::FETCH_OBJECT)) { printf("%d => %s\n", $row->id, $row->data); } $t->rollback(); +var_dump($c->transactionStatus == pq\Connection::TRANS_IDLE); ?> DONE --EXPECT-- Test +bool(true) +bool(true) Got notice: NOTICE: table "test" does not exist, skipping Got notice: NOTICE: CREATE TABLE will create implicit sequence "test_id_seq" for serial column "test.id" 1 => a 2 => b 3 => c +bool(true) DONE