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