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']); }