5 include __DIR__
."/../../../setup.inc";
7 class CellTest
extends \PHPUnit_Framework_TestCase
{
15 * @var \pq\Gateway\Table
19 protected function setUp() {
20 $this->conn
= new \pq\
Connection(PQ_TEST_DSN
);
21 $this->conn
->exec(PQ_TEST_TABLE_CREATE
);
22 $this->conn
->exec(PQ_TEST_REFTABLE_CREATE
);
23 $this->conn
->exec(PQ_TEST_DATA
);
24 Table
::$defaultConnection = $this->conn
;
25 $this->table
= new Table("test");
28 protected function tearDown() {
29 $this->conn
->exec(PQ_TEST_REFTABLE_DROP
);
30 $this->conn
->exec(PQ_TEST_TABLE_DROP
);
34 * This is a very bad test…
36 public function testBasic() {
37 $row = $this->table
->find(null, "id desc", 1)->current();
38 foreach ($row->getData() as $key => $val) {
39 $this->assertEquals($val, (string) $row->$key);
40 $this->assertFalse($row->$key->isExpr());
41 $this->assertFalse($row->$key->isDirty());
42 $this->assertSame($val, $row->$key->get());
44 $this->assertNotEquals($val, (string) $row->$key);
45 $this->assertTrue($row->$key->isExpr());
46 $this->assertTrue($row->$key->isDirty());
47 $this->assertNotSame($val, $row->$key->get());
48 $this->assertEquals("$key + 123", (string) $row->$key->get());
49 $row->$key->mod("foobar");
50 $this->assertEquals("$key + 123 || 'foobar'", (string) $row->$key);
51 $row->$key->mod(new \pq\Query\
Expr(" - %s()", "now"));
52 $this->assertEquals("$key + 123 || 'foobar' - now()", (string) $row->$key);