FlexPHP\Database\Tests\UserTest

Complexity

Total Complexity

6

Size/Duplication

Total Lines	90
Duplicated Lines	0 %

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	testItUserSqlSrvCreate()	0	14	1
A	testItUserMySqlCreate()	0	11	1
A	testItUserSqlSrvGrants()	0	16	1
A	testItUserMySqlGrants()	0	14	1
A	testItUserMySqlDrop()	0	11	1
A	testItUserSqlSrvDrop()	0	12	1

<?php declare(strict_types=1);
/*
 * This file is part of FlexPHP.
 *
 * (c) Freddie Gar <freddie.gar@outlook.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */
namespace FlexPHP\Database\Tests;

use FlexPHP\Database\User;

class UserTest extends TestCase
{
    public function testItUserMySqlCreate(): void
    {
        $name = 'jon';
        $password = 'p4sw00rd';

        $user = new User($name, $password);
        $user->setPlatform('MySQL');
        $this->assertEquals(<<<T
CREATE USER '$name'@'%' IDENTIFIED BY '$password';
T
, $user->toSqlCreate());
    }

    public function testItUserMySqlDrop(): void
    {
        $name = 'jon';
        $password = 'p4sw00rd';

        $user = new User($name, $password);
        $user->setPlatform('MySQL');
        $this->assertEquals(<<<T
DROP USER '$name'@'%';
T
, $user->toSqlDrop());
    }

    public function testItUserMySqlGrants(): void
    {
        $name = 'jon';
        $password = 'p4sw00rd';
        $database = 'db';
        $table = 'table';

        $user = new User($name, $password);
        $user->setPlatform('MySQL');
        $user->setGrants(['CREATE'], $database, $table);
        $this->assertEquals(<<<T
GRANT CREATE ON $database.$table TO '$name'@'%';
T
, $user->toSqlPrivileges());
    }

    public function testItUserSqlSrvCreate(): void
    {
        $name = 'jon';
        $password = 'p4sw00rd';

        $user = new User($name, $password);
        $user->setPlatform('SQLSrv');
        $this->assertEquals(<<<T
CREATE LOGIN $name WITH PASSWORD = '$password';
GO
CREATE USER $name FOR LOGIN $name;
GO
T
, $user->toSqlCreate());
    }

    public function testItUserSqlSrvDrop(): void
    {
        $name = 'jon';
        $password = 'p4sw00rd';

        $user = new User($name, $password);
        $user->setPlatform('SQLSrv');
        $this->assertEquals(<<<T
DROP USER $name;
GO
T
, $user->toSqlDrop());
    }

    public function testItUserSqlSrvGrants(): void
    {
        $name = 'jon';
        $password = 'p4sw00rd';
        $database = 'db';
        $table = 'table';
        $permission = 'CREATE';

        $user = new User($name, $password);
        $user->setPlatform('SQLSrv');
        $user->setGrants(['CREATE'], $database, $table);
        $this->assertEquals(<<<T
GRANT $permission ON $database.$table TO $name;
GO
T
, $user->toSqlPrivileges());
    }
}