Yiisoft\Db\Mssql\ColumnSchema

Complexity

Total Complexity

6

Size/Duplication

Total Lines	30
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	dbTypecast()	0	11	4
A	defaultPhpTypecast()	0	8	2

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Mssql;

use Yiisoft\Db\Expression\Expression;
use Yiisoft\Db\Schema\ColumnSchema as AbstractColumnSchema;

use function substr;

/**
 * Class ColumnSchema for MSSQL database
 */
final class ColumnSchema extends AbstractColumnSchema
{
    /**
     * Prepares default value and converts it according to {@see phpType}.
     *
     * @param mixed $value default value
     *
     * @return mixed converted value
     */
    public function defaultPhpTypecast($value)
    {
        if ($value !== null) {
            /** convert from MSSQL column_default format, e.g. ('1') -> 1, ('string') -> string */
            $value = substr(substr($value, 2), 0, -2);
        }

        return $this->phpTypecast($value);
    }

    public function dbTypecast($value)
    {
        if (
            $this->getType() === Schema::TYPE_BINARY &&
            $this->getDbType() === 'varbinary' &&
            is_string($value)
        ) {
            return new Expression('CONVERT(VARBINARY(MAX), ' . ('0x' . bin2hex($value)) . ')');
        }

        return parent::dbTypecast($value);
    }
}