public function testUpsertingATable()
{
$this->table->upsert(array('firstname' => 'Llama', 'lastname' => 'Herder'));
$this->assertRowCount(1, 'select * from user');
$this->assertEquals($this->connection()->execute("select * from user where userid=1")->row(), array('userid' => 1, 'firstname' => 'Llama', 'lastname' => 'Herder'));
}