public function testWhereWithNotNullCondition()
{
$qb = new \Quark\Query\Select();
$query = $qb->select('id', 'username', 'pass')->from('users', 'u')->where('u.age', '!=', null)->compile();
$expectedQuery = "SELECT id, username, pass FROM users, u WHERE u.age IS NOT NULL";
$this->assertSame($expectedQuery, $query);
}
public function testExceptionWhenMixingUsingAndOn()
{
$qb = new \Quark\Query\Select();
try {
$qb->select('u.user_id', 'u.username', 'pass')->from('users', 'u')->join(array('posts', 'p'))->using('user_id')->on('p.user_id', '=', 'u.user_id')->compile();
$this->assertTrue(false, 'Exception not thrown');
} catch (\Quark\Exception\QuarkException $e) {
$this->assertTrue(true, 'Exception thrown');
}
}
public function testQueryWithMultipleOrderBy()
{
$qb = new \Quark\Query\Select();
$query = $qb->select('id', 'username', 'pass')->from('users', 'u')->limit(10)->offset(10)->compile();
$expectedQuery = "SELECT id, username, pass FROM users, u LIMIT 10 OFFSET 10";
$this->assertSame($expectedQuery, $query);
}
