function testInsert()
{
$users = new Table("users");
$rowsInserted = $this->pdo->exec($users->insert()->values(array("id" => 4, "username" => "christoph", "password" => "christoph1234", "created_at" => new \DateTime("2011-06-01"), "display_name" => "Christoph Hochstrasser", "age" => 22))->toSql());
$this->assertEquals(1, $rowsInserted);
$user = $this->pdo->query($users->where($users['username']->eq('christoph'))->toSql())->fetch(PDO::FETCH_ASSOC);
$this->assertEquals(6, count($user));
$this->assertEquals("christoph", $user['username']);
$this->assertEquals("2011-06-01 00:00:00", $user['created_at']);
}
