public function testStatement()
{
$stmt = $this->connection->query('SELECT * FROM users');
$this->assertInstanceOf('Flame\\Statement', $stmt);
$this->assertSame(3, $stmt->columnCount());
$stmt = $this->connection->query('SELECT * FROM users WHERE id = i:id', ['id' => 1]);
$this->assertAttributeSame(['id'], 'placeholders', $stmt);
$this->assertAttributeSame(['id' => \PDO::PARAM_INT], 'types', $stmt);
}
public function testValueConverters()
{
$this->insertStatement->execute(['username' => null, 'age' => '20foobar']);
$user = $this->connection->query('SELECT username, age FROM users ORDER BY id DESC')->fetch(\PDO::FETCH_ASSOC);
$this->assertEquals(['username' => null, 'age' => '20'], $user);
$date = new \DateTime();
$this->insertStatement->execute(['username' => 'foo', 'date' => $date, 'time' => $date]);
$user = $this->connection->query('SELECT registered, spend_time FROM users WHERE username = "******"')->fetch(\PDO::FETCH_ASSOC);
$this->assertEquals(['registered' => $date->format(Grammar::DATE_TIME_FORMAT), 'spend_time' => $date->format(Grammar::TIME_FORMAT)], $user);
}
