use standard SplObserver

[m6w6/pq-gateway] / tests / lib / pq / Gateway / RowTest.php

diff --git a/tests/lib/pq/Gateway/RowTest.php b/tests/lib/pq/Gateway/RowTest.php
index fc0809468ea0a7aa2f804de834263ab8c410e5ab..7b88e1993b298c894b2746622613068aaa684628 100644 (file)
--- a/tests/lib/pq/Gateway/RowTest.php
+++ b/tests/lib/pq/Gateway/RowTest.php
@@ -18,29 +18,29 @@ class RowTest extends \PHPUnit_Framework_TestCase {
 
        protected function setUp() {
                $this->conn = new \pq\Connection(PQ_TEST_DSN);
-               $this->conn->exec(PQ_TEST_TABLE_CREATE);
-               $this->conn->exec(PQ_TEST_REFTABLE_CREATE);
-               $this->conn->exec(PQ_TEST_DATA);
+               $this->conn->exec(PQ_TEST_SETUP_SQL);
                Table::$defaultConnection = $this->conn;
                $this->table = new Table("test");
+               $this->table->getQueryExecutor()->attach(new \QueryLogger());
        }
 
        protected function tearDown() {
-               $this->conn->exec(PQ_TEST_REFTABLE_DROP);
-               $this->conn->exec(PQ_TEST_TABLE_DROP);
+               $this->conn->exec(PQ_TEST_TEARDOWN_SQL);
        }
 
        function testBasic() {
                $row = new Row($this->table, array("id" => 3), true);
                $this->assertTrue($row->isDirty());
                $row->refresh();
-               $this->assertSame(
+               $this->assertEquals(
                        array(
                                "id" => "3",
-                               "created" => date("Y-m-d H:i:s", strtotime("tomorrow")),
+                               "created" => new \pq\DateTime("tomorrow"),
                                "counter" => "1",
                                "number" => "1.1",
-                               "data" => "tomorrow"
+                               "data" => "tomorrow",
+                               "list" => array(1,2,3),
+                               "prop" => null
                        ),
                        $row->getData()
                );
@@ -51,4 +51,58 @@ class RowTest extends \PHPUnit_Framework_TestCase {
                $row = new Row($this->table);
                $this->assertSame($this->table, $row->getTable());
        }
+       
+       function testPessimisticLock() {
+               $this->table->attach(new Table\PessimisticLock);
+               $txn = $this->table->getConnection()->startTransaction();
+               $row = $this->table->find(null, null, 1)->current();
+               $row->data = "foo";
+               $row->update();
+               $txn->commit();
+               $this->assertSame("foo", $row->data->get());
+       }
+       
+       function testPessimisticLockFail() {
+               $this->table->attach(new Table\PessimisticLock);
+               $txn = $this->table->getConnection()->startTransaction();
+               $row = $this->table->find(null, null, 1)->current();
+               $row->data = "foo";
+               executeInConcurrentTransaction(
+                       $this->table->getQueryExecutor(),
+                       "UPDATE {$this->table->getName()} SET data='bar' WHERE id=\$1", 
+                       array($row->id->get()));
+               $this->setExpectedException("\\UnexpectedValueException", "Row has already been modified");
+               $row->update();
+               $txn->commit();
+       }
+       
+       function testOptimisticLock() {
+               $this->table->attach(new Table\OptimisticLock("counter"));
+               $row = $this->table->find(null, null, 1)->current();
+               $cnt = $row->counter->get();
+               $row->data = "foo";
+               $row->update();
+               $this->assertEquals("foo", $row->data->get());
+               $this->assertEquals($cnt +1, $row->counter->get());
+       }
+       
+       function testOptimisticLockFail() {
+               $this->table->attach(new Table\OptimisticLock("counter"));
+               $row = $this->table->find(null, null, 1)->current();
+               $row->data = "foo";
+               executeInConcurrentTransaction(
+                       $this->table->getQueryExecutor(), 
+                       "UPDATE {$this->table->getName()} SET counter = 10 WHERE id=\$1", 
+                       array($row->id->get()));
+               $this->setExpectedException("\\UnexpectedValueException", "No row updated");
+               $row->update();
+       }
+       
+       function testRef() {
+               foreach ($this->table->find() as $row) {
+                       foreach ($row->reftest() as $ref) {
+                               $this->assertEquals($row->id->get(), $ref->test->current()->id->get());
+                       }
+               }
+       }
 }