FlexPHP\Database\Tests\Unit\Factories\User\SQLSrvUserFactoryTest

Complexity

Total Complexity

10

Size/Duplication

Total Lines	149
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	0

10 Methods

Rating	Name	Duplication	Size	Complexity
A	testItSrvGrantOptionsMultiple()	0	21	1
A	testItSrvGrantOptionOnAll()	0	14	1
A	testItSrvGrantOptionOnTable()	0	16	1
A	testItSrvCreate()	0	14	1
A	testItSrvCreateWithNameInvalidThrownException()	0	6	1
A	testItSrvDrop()	0	12	1
A	testItSrvGrantOptionOnDatabase()	0	15	1
A	getPermissionValid()	0	11	1
A	getNameInvalid()	0	4	1
A	getMappingPermission()	0	3	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\Unit\Factories\User;

use FlexPHP\Database\Exception\UserDatabaseException;
use FlexPHP\Database\Factories\User\SQLSrvUserFactory;
use FlexPHP\Database\Tests\TestCase;
use FlexPHP\Database\User;

class SQLSrvUserFactoryTest extends TestCase
{
    /**
     * @dataProvider getNameInvalid
     */
    public function testItSrvCreateWithNameInvalidThrownException(string $name): void
    {
        $this->expectException(UserDatabaseException::class);
        $user = new User($name, 'password');
        $user->setPlatform('SQLSrv');
        $user->toSqlCreate();
    }

    public function testItSrvCreate(): 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 testItSrvDrop(): void
    {
        $name = 'jon';
        $password = 'p4sw00rd';

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

    /**
     * @dataProvider getPermissionValid
     */
    public function testItSrvGrantOptionOnAll(string $permission): void
    {
        $name = 'jon';
        $password = 'p4sw00rd';
        $mappingPermission = $this->getMappingPermission($permission);

        $user = new User($name, $password);
        $user->setPlatform('SQLSrv');
        $user->setGrant($permission);
        $this->assertEquals(<<<T
GRANT $mappingPermission TO $name;
GO
T
, $user->toSqlPrivileges());
    }

    /**
     * @dataProvider getPermissionValid
     */
    public function testItSrvGrantOptionOnDatabase(string $permission): void
    {
        $name = 'jon';
        $password = 'p4sw00rd';
        $database = 'db';
        $mappingPermission = $this->getMappingPermission($permission);

        $user = new User($name, $password);
        $user->setPlatform('SQLSrv');
        $user->setGrant($permission, $database);
        $this->assertEquals(<<<T
GRANT $mappingPermission ON $database TO $name;
GO
T
, $user->toSqlPrivileges());
    }

    /**
     * @dataProvider getPermissionValid
     */
    public function testItSrvGrantOptionOnTable(string $permission): void
    {
        $name = 'jon';
        $password = 'p4sw00rd';
        $database = 'db';
        $table = 'table';
        $mappingPermission = $this->getMappingPermission($permission);

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

    public function testItSrvGrantOptionsMultiple(): void
    {
        $name = 'jon';
        $password = 'p4sw00rd';
        $database = 'db';
        $table = 'table';
        $permissions = [
            'CREATE',
            'UPDATE',
        ];

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

    public function getMappingPermission(string $permission): string
    {
        return SQLSrvUserFactory::MAPPING_PERMISSION[$permission];
    }

    public function getNameInvalid(): array
    {
        return [
            ['jon doe'],
        ];
    }

    public function getPermissionValid(): array
    {
        return [
            ['ALL PRIVILEGES'],
            ['CREATE'],
            ['DROP'],
            ['DELETE'],
            ['INSERT'],
            ['SELECT'],
            ['UPDATE'],
            ['GRANT OPTION'],
        ];
    }
}