shinbuntu / db-user

     *

     * @return void

     */

    public function testCreateUserQuery()

    {

        $connection = $this->getConnection();

        $this

            ->if($this->newTestedInstance($connection))

            ->string($this->testedInstance->createUserQuery('test_username', '!super_secure_password$'))

                ->isEqualTo('CREATE USER test_username@localhost IDENTIFIED BY "!super_secure_password$";');

    }

    /**

     * Test dropUser method.

     *

     * @return void

     */

    public function testDropUserQuery()

    {

        $connection = $this->getConnection();

        $this

            ->if($this->newTestedInstance($connection))

            ->string($this->testedInstance->dropUserQuery('test_username', '!super_secure_password$'))

                ->isEqualTo('DROP USER test_username@localhost;');

    }

    /**

     * Test userExistQuery method.

     *

     * @return void

     */

    public function testUserExistQuery()

    {

        $connection = $this->getConnection();

        $this

            ->if($this->newTestedInstance($connection))

            ->string($this->testedInstance->userExistQuery('test_username'))

                ->isEqualTo('SELECT EXISTS(SELECT 1 FROM mysql.user WHERE user = "test_username");');

    }

    /**

     * Test flushPrivilegesQuery method.