Exemplo n.º 1
0
 public function testUpdate()
 {
     $update = $this->connection->update('test', ['foo' => 'bar']);
     $this->assertInstanceOf('Flame\\QueryBuilder\\UpdateQuery', $update);
     $this->assertAttributeSame('test', 'table', $update);
     $this->assertAttributeSame(['"foo"' => 'bar'], 'columns', $update);
 }
Exemplo n.º 2
0
 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);
 }