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 testLastInsertIdPreparedStatement()
{
$sql = "SELECT * FROM test WHERE foo='bar'";
$p = new Pseudo\Pdo();
$r = new Pseudo\Result();
$r->setInsertId(10);
$p->mock($sql, $r);
$statement = $p->prepare($sql);
$statement->execute();
$this->assertEquals(10, $p->lastInsertId());
}
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));
}
