function testThrowsSyntaxErrorOnLimitedUpdate()
{
$users = new Table("users");
try {
$this->pdo->exec($users->update()->set(array('created_at' => new DateTime()))->take(2)->toSql());
$this->fail();
} catch (\PDOException $e) {
// Expect a Syntax Error
$this->assertEquals(1, $e->errorInfo[1]);
}
}
function testUpdate()
{
$users = new Table("users");
$rowsUpdated = $this->pdo->exec($users->update()->where($users['id']->eq(1))->set(array('password' => 'newpassword'))->toSql());
$this->assertEquals(1, $rowsUpdated);
$user = $this->pdo->query($users->where($users['id']->eq(1)))->fetch();
$this->assertEquals('newpassword', $user['password']);
}
