Phalcon\Test\Unit\Mvc\Model\Query\BuilderTest::testSelectDistinctAll PHP Метод

testSelectDistinctAll() публичный Метод

    public function testSelectDistinctAll()
    {
        $this->specify("Query Builders don't work with SELECT ALL / SELECT DISTINCT statements", function () {
            $di = $this->di;
            $builder = new Builder();
            $phql = $builder->setDi($di)->distinct(true)->columns(["Robots.name"])->from(Robots::class)->getPhql();
            expect($phql)->equals("SELECT DISTINCT Robots.name FROM [" . Robots::class . "]");
            $builder = new Builder();
            $phql = $builder->setDi($di)->distinct(false)->columns(["Robots.name"])->from(Robots::class)->getPhql();
            expect($phql)->equals("SELECT ALL Robots.name FROM [" . Robots::class . "]");
            $builder = new Builder();
            $phql = $builder->setDi($di)->distinct(true)->distinct(null)->columns(["Robots.name"])->from(Robots::class)->getPhql();
            expect($phql)->equals("SELECT Robots.name FROM [" . Robots::class . "]");
            $builder = new Builder();
            $phql = $builder->setDi($di)->distinct(true)->from(Robots::class)->getPhql();
            expect($phql)->equals("SELECT DISTINCT [" . Robots::class . "].* FROM [" . Robots::class . "]");
        });
    }