bytic / database

        );

    }

    public function testSimpleSelectDistinct()

    {

        $this->selectQuery->cols('id, name')->options('distinct')->from('table x')->where('id = 5');

        static::assertEquals(

            "SELECT DISTINCT id, name FROM table x WHERE id = 5",

            $this->selectQuery->assemble()

        );

    }

    public function testWhereAndWhere()

    {

        );

    }

    public function testWhereAndWhere()

    {

        $this->selectQuery->cols('id, name')->from('table x');

        $this->selectQuery->where('id = 5')->where("active = 'yes'");

        static::assertEquals(

            "SELECT id, name FROM table x WHERE id = 5 AND active = 'yes'",

            $this->selectQuery->assemble()

        );

    }

    public function testWhereOrWhere()

    {

        );

    }

    public function testWhereOrWhere()

    {

        $this->selectQuery->cols('id, name')->from('table x');

        $this->selectQuery->where('id = 5')->orWhere('id = 7');

        static::assertEquals(

            "SELECT id, name FROM table x WHERE id = 5 OR id = 7",

            $this->selectQuery->assemble()

        );

    }

    public function testInitializeCondition()

    {