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