X-Git-Url: https://git.m6w6.name/?p=m6w6%2Fpq-gateway;a=blobdiff_plain;f=tests%2Flib%2Fpq%2FGateway%2FCellTest.php;h=9235a39ec81487278d4ecb79494384505f33088f;hp=9dc96805f0dda5855d63f8e425ab4b0c5f3002c2;hb=b39e14404cfeac177d41b152690b6adbb2b1e4bf;hpb=580991717f5e8bb237403757e2111a8d04aca616

diff --git a/tests/lib/pq/Gateway/CellTest.php b/tests/lib/pq/Gateway/CellTest.php
index 9dc9680..9235a39 100644
--- 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);
 	}
 
 	/**
@@ -53,4 +50,15 @@ 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();
+	}
 }