ColumnSchema::dbTypecast() - Code Metrics - Inspection of "simple varbinary support" - yiisoft/db-mssql - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#56)

by Def

created 2021-10-12 20:22 UTC

ColumnSchema::dbTypecast() A

↳ Parent: ColumnSchema

Complexity

Conditions	4
Paths	2

Size

Total Lines	11
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	20

Importance

Changes

Metric	Value
cc	4
eloc	6
nc	2
nop	1
dl	0
loc	11
ccs	0
cts	0
cp	0
crap	20
rs	10
c	0
b	0
f	0

<?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);
    }
}


1		<?php
2
3		declare(strict_types=1);
4
5		namespace Yiisoft\Db\Mssql;
6
7		use Yiisoft\Db\Expression\Expression;
8		use Yiisoft\Db\Schema\ColumnSchema as AbstractColumnSchema;
9
10		use function substr;
11
12		/**
13		* Class ColumnSchema for MSSQL database
14		*/
15		final class ColumnSchema extends AbstractColumnSchema
16		{
17		/**
18		* Prepares default value and converts it according to {@see phpType}.
19		*
20		* @param mixed $value default value
21		*
22		* @return mixed converted value
23	85	*/
24		public function defaultPhpTypecast($value)
25	85	{
26		if ($value !== null) {
27	62	/** convert from MSSQL column_default format, e.g. ('1') -> 1, ('string') -> string */
28		$value = substr(substr($value, 2), 0, -2);
29		}
30	85
31		return $this->phpTypecast($value);
32		}
33
34		public function dbTypecast($value)
35		{
36		if (
37		$this->getType() === Schema::TYPE_BINARY &&
38		$this->getDbType() === 'varbinary' &&
39		is_string($value)
40		) {
41		return new Expression('CONVERT(VARBINARY(MAX), '. ('0x' . bin2hex($value)) .')');
42		}
43
44		return parent::dbTypecast($value);
45		}
46		}
47

yiisoft / db-mssql

Pull Request — master (#56)

ColumnSchema::dbTypecast() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like