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