public function testWhereWithQueryAsValue()
 {
     $b = new SelectBuilder();
     $b->root('Blog');
     $subQuery = User::query(null, 'articles.readers')->whereRelation(Article::relation('readers'), 'articles')->addAggregate('AVG', 'age')->getQuery();
     $b->where('articles/author/age', '>', $subQuery);
     $b->get(['*'], false);
     $components = $b->build();
     $values = $b->getValues();
     $c = new BaseCompiler();
     $sql = $c->compileComponents($components, 'select');
     $val = $c->compileValues($values, 'select');
     $expected = 'SELECT `_`.* FROM `blogs` `_` INNER JOIN `articles` `articles` ON `_`.`id` = `articles`.`blog_id` INNER JOIN `authors` `articles.author` ON `articles`.`author_id` = `articles.author`.`id` WHERE `articles.author`.`age` > (SELECT AVG(`articles.readers`.`age`) FROM `USERS` `articles.readers` INNER JOIN `articles_USERS` `articles.readers_m` ON `articles.readers`.`id` = `articles.readers_m`.`user_id` WHERE `articles.readers_m`.`article_id` = `articles`.`id`)';
     $expectedValues = [[]];
     $this->assertEquals($expected, $sql);
     $this->assertEquals($expectedValues, $val);
 }
 public function testDistinctObject()
 {
     $b = new SelectBuilder();
     $b->root('Article');
     $b->count(DB::distinct(Article::table()->getPrimaryKey()));
     $b->select(['*'], false);
     $components = $b->build();
     $c = new BaseCompiler();
     $sql = $c->compileSelect($components);
     $expected = 'SELECT * ,COUNT(DISTINCT `id`) FROM `articles`';
     $this->assertEquals($expected, $sql);
 }
 public function testCompileDistinct()
 {
     $components = ['columns' => ['_' => ['columns' => ['blogId' => 'blog_id', 'id' => 'id'], 'resAlias' => '']], 'from' => [new JoinClause('articles', '_')], 'distinct' => true];
     $expected = 'SELECT DISTINCT `blog_id` AS `blogId`,`id` AS `id` FROM `articles`';
     $c = new BaseCompiler();
     $this->assertEquals($expected, $c->compileSelect($components));
     $components['columns'] = ['_' => ['columns' => ['*'], 'resAlias' => '']];
     $expected = 'SELECT DISTINCT * FROM `articles`';
     $this->assertEquals($expected, $c->compileSelect($components));
 }