Esempio n. 1
0
 public function testGetQuery()
 {
     $result = $this->getMock('r8\\iface\\DB\\Result\\Read');
     $result->expects($this->once())->method('getQuery')->will($this->returnValue("SELECT 1 + 1"));
     $dec = $this->getTestDecorator($result);
     \r8\Test\Constraint\SQL::assert("SELECT 1 + 1", $result->getQuery());
 }
Esempio n. 2
0
 public function testQuery_write()
 {
     $link = $this->getTestLink();
     $result = $link->query("CREATE TEMPORARY TABLE `" . MYSQLI_TABLE . "` (\n                `id` INT NOT NULL auto_increment,\n                PRIMARY KEY ( `id` )\n            )");
     $this->assertThat($result, $this->isInstanceOf('\\r8\\DB\\Result\\Write'));
     $this->assertSame(0, $result->getAffected());
     $this->assertNull($result->getInsertID());
     $result = $link->query("INSERT INTO " . MYSQLI_TABLE . " SET id = NULL");
     $this->assertThat($result, $this->isInstanceOf('\\r8\\DB\\Result\\Write'));
     $this->assertSame(1, $result->getAffected());
     $this->assertSame(1, $result->getInsertID());
     \r8\Test\Constraint\SQL::assert("INSERT INTO " . MYSQLI_TABLE . " SET id = NULL", $result->getQuery());
 }
Esempio n. 3
0
 public function testQuery_write()
 {
     $link = $this->getTestLink();
     $result = $link->query("CREATE TEMPORARY TABLE " . SQLITE_TABLE . "(id INT, str TEXT)");
     $this->assertThat($result, $this->isInstanceOf('\\r8\\DB\\Result\\Write'));
     $this->assertSame(0, $result->getAffected());
     $this->assertNull($result->getInsertID());
     $result = $link->query("INSERT INTO " . SQLITE_TABLE . " (str) VALUES ('alpha')");
     $this->assertThat($result, $this->isInstanceOf('\\r8\\DB\\Result\\Write'));
     $this->assertSame(1, $result->getAffected());
     $this->assertSame(1, $result->getInsertID());
     \r8\Test\Constraint\SQL::assert("INSERT INTO " . SQLITE_TABLE . " (str) VALUES ('alpha')", $result->getQuery());
 }