public function testQueryReturnsMockedResults() { $p = new Pseudo\Pdo(); $expectedRows = new Pseudo\Result(); $expectedRows->addRow(["foo" => "bar", "id" => 1]); $p->mock("SELECT * FROM test WHERE foo='bar'", $expectedRows); $result = $p->query("SELECT * FROM test WHERE foo='bar'"); $this->assertEquals($expectedRows->getRows(), $result->fetchAll(PDO::FETCH_ASSOC)); }
public function testReset() { $row = ['id' => 1, 'foo' => 'bar']; $r = new Pseudo\Result(); $r->addRow($row); $this->assertEquals($row, $r->nextRow()); $this->assertEquals(null, $r->nextRow()); $r->reset(); $this->assertEquals($row, $r->nextRow()); }
public function testFetchColumn() { $row1 = ['id' => 1, 'foo' => 'bar']; $r = new Pseudo\Result(); $r->addRow($row1); $s = new Pseudo\PdoStatement($r); $this->assertEquals('bar', $s->fetchColumn(1)); $this->assertEquals(false, $s->fetchColumn(0)); }