public function testShouldExecuteSqlQuery()
{
$table = "tests";
$content = "Test Content 1001";
$statement = new InsertStatement($table);
$statement->addParameter("content", $content);
$database = new Database(self::$phactory->getConnection());
$lastInsertId = $database->execute($statement);
$this->assertThat($lastInsertId, $this->logicalNot($this->isNull()));
$query = Query::getInstance();
$query->select()->from($table)->where(Restrictions::eq("id", $lastInsertId));
$test = $database->query($query)->uniqueResult();
$this->assertThat($test['content'], $this->equalTo($content));
}
