Yiisoft\Db\Mssql\QueryBuilder

Complexity

Total Complexity

2

Size/Duplication

Total Lines	47
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	7	1
A	getColumnType()	0	7	1

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Mssql;

use Yiisoft\Db\QueryBuilder\AbstractQueryBuilder;
use Yiisoft\Db\Schema\Builder\ColumnInterface;
use Yiisoft\Db\Schema\QuoterInterface;
use Yiisoft\Db\Schema\SchemaInterface;

use function preg_replace;

/**
 * Implements the MSSQL Server specific query builder.
 */
final class QueryBuilder extends AbstractQueryBuilder
{
    /**
     * @psalm-var string[] $typeMap Mapping from abstract column types (keys) to physical column types (values).
     */
    protected array $typeMap = [
        SchemaInterface::TYPE_PK => 'int IDENTITY PRIMARY KEY',
        SchemaInterface::TYPE_UPK => 'int IDENTITY PRIMARY KEY',
        SchemaInterface::TYPE_BIGPK => 'bigint IDENTITY PRIMARY KEY',
        SchemaInterface::TYPE_UBIGPK => 'bigint IDENTITY PRIMARY KEY',
        SchemaInterface::TYPE_CHAR => 'nchar(1)',
        SchemaInterface::TYPE_STRING => 'nvarchar(255)',
        SchemaInterface::TYPE_TEXT => 'nvarchar(max)',
        SchemaInterface::TYPE_TINYINT => 'tinyint',
        SchemaInterface::TYPE_SMALLINT => 'smallint',
        SchemaInterface::TYPE_INTEGER => 'int',
        SchemaInterface::TYPE_BIGINT => 'bigint',
        SchemaInterface::TYPE_FLOAT => 'float',
        SchemaInterface::TYPE_DOUBLE => 'float',
        SchemaInterface::TYPE_DECIMAL => 'decimal(18,0)',
        SchemaInterface::TYPE_DATETIME => 'datetime',
        SchemaInterface::TYPE_TIMESTAMP => 'datetime',
        SchemaInterface::TYPE_TIME => 'time',
        SchemaInterface::TYPE_DATE => 'date',
        SchemaInterface::TYPE_BINARY => 'varbinary(max)',
        SchemaInterface::TYPE_BOOLEAN => 'bit',
        SchemaInterface::TYPE_MONEY => 'decimal(19,4)',
        SchemaInterface::TYPE_UUID => 'UNIQUEIDENTIFIER',
        SchemaInterface::TYPE_UUID_PK => 'UNIQUEIDENTIFIER PRIMARY KEY',
    ];

    public function __construct(QuoterInterface $quoter, SchemaInterface $schema)
    {
        $ddlBuilder = new DDLQueryBuilder($this, $quoter, $schema);
        $dmlBuilder = new DMLQueryBuilder($this, $quoter, $schema);
        $dqlBuilder = new DQLQueryBuilder($this, $quoter);

        parent::__construct($quoter, $schema, $ddlBuilder, $dmlBuilder, $dqlBuilder);
    }

    public function getColumnType(ColumnInterface|string $type): string
    {
        $columnType = parent::getColumnType($type);

        /** remove unsupported keywords*/
        $columnType = preg_replace("/\s*comment '.*'/i", '', $columnType);
        return preg_replace('/ first$/i', '', $columnType);
    }
}