compatibility with ext-pq/master

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

diff --git a/tests/lib/pq/Gateway/CellTest.php b/tests/lib/pq/Gateway/CellTest.php
index 9dc96805f0dda5855d63f8e425ab4b0c5f3002c2..8ec28598ad220ff489ca8e3d1bf7c955125f9ea1 100644 (file)
--- a/tests/lib/pq/Gateway/CellTest.php
+++ b/tests/lib/pq/Gateway/CellTest.php
@@ -18,17 +18,14 @@ class CellTest 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);
        }
 
        /**
@@ -37,7 +34,7 @@ class CellTest extends \PHPUnit_Framework_TestCase {
        public function testBasic() {
                $row = $this->table->find(null, "id desc", 1)->current();
                foreach ($row->getData() as $key => $val) {
-                       $this->assertEquals($val, (string) $row->$key);
+                       $this->assertEquals($val, $row->$key->get());
                        $this->assertFalse($row->$key->isExpr());
                        $this->assertFalse($row->$key->isDirty());
                        $this->assertSame($val, $row->$key->get());
@@ -53,4 +50,78 @@ class CellTest extends \PHPUnit_Framework_TestCase {
                        $this->assertEquals("$key + 123 || 'foobar' - now()", (string) $row->$key);
                }
        }
+       
+       public function testRef() {
+               $rows = $this->table->find(null, "id desc", 2);
+               $reft = new Table("reftest");
+               $refs = new Rowset($reft);
+               $refs->append($rows->seek(0)->current()->reftest()->current());
+               $refs->append($rows->seek(1)->current()->reftest()->current());
+               $refs->seek(0)->current()->test = $rows->seek(1)->current();
+               $refs->seek(1)->current()->test = $rows->seek(0)->current();
+               $refs->update();
+       }
+       
+       public function testArray() {
+               $row = $this->table->find(["id="=>1])->current();
+               $this->assertEquals([-1,0,1], $row->list->get());
+               $row->list[] = 4;
+               $row->list[2] = null;
+               $row->update();
+               $this->assertEquals([-1,0,null,4], $row->list->get());
+       }
+       
+       public function testMultiArray() {
+               $row = $this->table->find(["id="=>2])->current();
+               $this->assertEquals([0,1,2], $row->list->get());
+               $row->list = [$row->list->get()];
+               $row->update();
+               $this->assertEquals([[0,1,2]], $row->list->get());
+               $this->setExpectedException("PHPUnit_Framework_Error_Notice", 
+                       "Indirect modification of overloaded element of pq\Gateway\Cell has no effect");
+               $row->list[0][0] = -1;
+       }
+               
+       public function testHstore() {
+               $this->conn->setConverter(new Hstore(new \pq\Types($this->conn)));
+               $row = $this->table->find(["id="=>3])->current();
+               $this->assertEquals(null, $row->prop->get());
+               $data = array("foo" => "bar", "a" => 1, "b" => 2);
+               $row->prop = $data;
+               $row->update();
+               $this->assertEquals($data, $row->prop->get());
+               $row->prop["a"] = null;
+               $row->update();
+               $data["a"] = null;
+               $this->assertEquals($data, $row->prop->get());
+               unset($data["a"], $row->prop["a"]);
+               $row->update();
+               $this->assertEquals($data, $row->prop->get());
+       }       
+}
+
+class Hstore implements \pq\Converter
+{
+       protected $types;
+       function __construct(\pq\Types $types) {
+               $this->types = $types["hstore"]->oid;
+       }
+       function convertTypes() {
+               return [$this->types];
+       }
+       function convertFromString($string, $type) {
+               return eval("return [$string];");
+       }
+       function convertToString($data, $type) {
+               $string = "";
+               foreach ($data as $k => $v) {
+                       $string .= "\"".addslashes($k)."\"=>";
+                       if (isset($v)) {
+                               $string .= "\"".addslashes($v)."\",";
+                       } else {
+                               $string .= "NULL,";
+                       }
+               }
+               return $string;
+       }
 }