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