PostgresGrammar::typeInet() - Code Metrics - Inspection of "add inet type" - phoenixgao/laravel-postgres-extended-schema - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 5188b8...bfce86 )

by Xiang

created 2016-01-26 10:38 UTC

PostgresGrammar::typeInet() A

↳ Parent: PostgresGrammar

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	1

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

<?php namespace Bosnadev\Database\Schema\Grammars;

use Illuminate\Support\Fluent;
use Bosnadev\Database\Schema\Blueprint;

/**
 * Class PostgresGrammar
 * @package Bosnadev\Database\Schema\Grammars
 */
class PostgresGrammar extends \Illuminate\Database\Schema\Grammars\PostgresGrammar
{
    /**
     * Create the column definition for a character type.
     *
     * @param Fluent $column
     * @return string
     */
    protected function typeCharacter(Fluent $column)
    {
        return "character({$column->length})";
    }

    /**
     * Create the column definition for a hstore type.
     *
     * @param Fluent $column
     * @return string
     */
    protected function typeHstore(Fluent $column)

    {
        return "hstore";
    }

    /**
     * Create the column definition for a uuid type.
     *
     * @param Fluent $column
     * @return string
     */
    protected function typeUuid(Fluent $column)
    {
        return "uuid";
    }

    /**
     * Create the column definition for a jsonb type.
     *
     * @param Fluent $column
     * @return string
     */
    protected function typeJsonb(Fluent $column)
    {
        return "jsonb";
    }

    /**
     * Create the column definition for an int4range type.
     *
     * @param Fluent $column
     *
     * @return string
     */
    protected function typeInt4range(Fluent $column)

    {
        return "int4range";
    }

    /**
     * Create the column definition for an int8range type.
     *
     * @param Fluent $column
     *
     * @return string
     */
    protected function typeInt8range(Fluent $column)

    {
        return "int8range";
    }

    /**
     * Create the column definition for an numrange type.
     *
     * @param Fluent $column
     *
     * @return string
     */
    protected function typeNumrange(Fluent $column)

    {
        return "numrange";
    }

    /**
     * Create the column definition for an tsrange type.
     *
     * @param Fluent $column
     *
     * @return string
     */
    protected function typeTsrange(Fluent $column)

    {
        return "tsrange";
    }

    /**
     * Create the column definition for an tstzrange type.
     *
     * @param Fluent $column
     *
     * @return string
     */
    protected function typeTstzrange(Fluent $column)

    {
        return "tstzrange";
    }

    /**
     * Create the column definition for an daterange type.
     *
     * @param Fluent $column
     *
     * @return string
     */
    protected function typeDaterange(Fluent $column)

    {
        return "daterange";
    }

    /**
     * Create the column definition for an inet type.
     *
     * @param Fluent $column
     *
     * @return string
     */
    protected function typeInet(Fluent $column)

    {
        return "inet";
    }

    /**
     * @param mixed $value
     * @return mixed|string
     */
    protected function getDefaultValue($value)
    {
        if($this->isUuid($value)) return strval($value);

        return parent::getDefaultValue($value);
    }

    /**
     * Check if string matches on of uuid_generate functions
     *
     * @param $value
     * @return int
     */
    protected function isUuid($value)
    {
        return preg_match('/^uuid_generate_v/', $value);
    }

    /**
     * Compile a gin index key command.
     *
     * @param  \Bosnadev\Database\Schema\Blueprint  $blueprint
     * @param  \Illuminate\Support\Fluent  $command
     * @return string
     */
    public function compileGin(Blueprint $blueprint, Fluent $command)
    {
        $columns = $this->columnize($command->columns);

        return sprintf('CREATE INDEX %s ON %s USING GIN(%s)', $command->index, $this->wrapTable($blueprint), $columns);
    }
}


1		<?php namespace Bosnadev\Database\Schema\Grammars;
2
3		use Illuminate\Support\Fluent;
4		use Bosnadev\Database\Schema\Blueprint;
5
6		/**
7		* Class PostgresGrammar
8		* @package Bosnadev\Database\Schema\Grammars
9		*/
10		class PostgresGrammar extends \Illuminate\Database\Schema\Grammars\PostgresGrammar
11		{
12		/**
13		* Create the column definition for a character type.
14		*
15		* @param Fluent $column
16		* @return string
17		*/
18	3	protected function typeCharacter(Fluent $column)
19		{
20	3	return "character({$column->length})";
21		}
22
23		/**
24		* Create the column definition for a hstore type.
25		*
26		* @param Fluent $column
27		* @return string
28		*/
29	3	protected function typeHstore(Fluent $column)
		0 ignored issues – show Unused Code introduced 2016-01-24 18:30 UTC by Report Bug Copy Issue Report The parameter `$column` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
30		{
31	3	return "hstore";
32		}
33
34		/**
35		* Create the column definition for a uuid type.
36		*
37		* @param Fluent $column
38		* @return string
39		*/
40	3	protected function typeUuid(Fluent $column)
41		{
42	3	return "uuid";
43		}
44
45		/**
46		* Create the column definition for a jsonb type.
47		*
48		* @param Fluent $column
49		* @return string
50		*/
51	3	protected function typeJsonb(Fluent $column)
52		{
53	3	return "jsonb";
54		}
55
56		/**
57		* Create the column definition for an int4range type.
58		*
59		* @param Fluent $column
60		*
61		* @return string
62		*/
63	3	protected function typeInt4range(Fluent $column)
		0 ignored issues – show Unused Code introduced 2016-01-24 18:30 UTC by Report Bug Copy Issue Report The parameter `$column` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
64		{
65	3	return "int4range";
66		}
67
68		/**
69		* Create the column definition for an int8range type.
70		*
71		* @param Fluent $column
72		*
73		* @return string
74		*/
75	3	protected function typeInt8range(Fluent $column)
		0 ignored issues – show Unused Code introduced 2016-01-24 18:30 UTC by Report Bug Copy Issue Report The parameter `$column` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
76		{
77	3	return "int8range";
78		}
79
80		/**
81		* Create the column definition for an numrange type.
82		*
83		* @param Fluent $column
84		*
85		* @return string
86		*/
87	3	protected function typeNumrange(Fluent $column)
		0 ignored issues – show Unused Code introduced 2016-01-24 18:30 UTC by Report Bug Copy Issue Report The parameter `$column` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
88		{
89	3	return "numrange";
90		}
91
92		/**
93		* Create the column definition for an tsrange type.
94		*
95		* @param Fluent $column
96		*
97		* @return string
98		*/
99	3	protected function typeTsrange(Fluent $column)
		0 ignored issues – show Unused Code introduced 2016-01-24 18:30 UTC by Report Bug Copy Issue Report The parameter `$column` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
100		{
101	3	return "tsrange";
102		}
103
104		/**
105		* Create the column definition for an tstzrange type.
106		*
107		* @param Fluent $column
108		*
109		* @return string
110		*/
111	3	protected function typeTstzrange(Fluent $column)
		0 ignored issues – show Unused Code introduced 2016-01-24 18:30 UTC by Report Bug Copy Issue Report The parameter `$column` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
112		{
113	3	return "tstzrange";
114		}
115
116		/**
117		* Create the column definition for an daterange type.
118		*
119		* @param Fluent $column
120		*
121		* @return string
122		*/
123	3	protected function typeDaterange(Fluent $column)
		0 ignored issues – show Unused Code introduced 2016-01-24 18:30 UTC by Report Bug Copy Issue Report The parameter `$column` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
124		{
125	3	return "daterange";
126		}
127
128		/**
129		* Create the column definition for an inet type.
130		*
131		* @param Fluent $column
132		*
133		* @return string
134		*/
135		protected function typeInet(Fluent $column)
		0 ignored issues – show Unused Code introduced 2016-01-26 10:56 UTC by Report Bug Copy Issue Report The parameter `$column` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
136		{
137		return "inet";
138		}
139
140		/**
141		* @param mixed $value
142		* @return mixed\|string
143		*/
144		protected function getDefaultValue($value)
145		{
146		if($this->isUuid($value)) return strval($value);
147
148		return parent::getDefaultValue($value);
149		}
150
151		/**
152		* Check if string matches on of uuid_generate functions
153		*
154		* @param $value
155		* @return int
156		*/
157	3	protected function isUuid($value)
158		{
159	3	return preg_match('/^uuid_generate_v/', $value);
160		}
161	3
162		/**
163		* Compile a gin index key command.
164		*
165		* @param \Bosnadev\Database\Schema\Blueprint $blueprint
166		* @param \Illuminate\Support\Fluent $command
167		* @return string
168		*/
169		public function compileGin(Blueprint $blueprint, Fluent $command)
170		{
171		$columns = $this->columnize($command->columns);
172
173		return sprintf('CREATE INDEX %s ON %s USING GIN(%s)', $command->index, $this->wrapTable($blueprint), $columns);
174		}
175		}
176

phoenixgao / laravel-postgres-extended-schema

Push — master ( 5188b8...bfce86 )

PostgresGrammar::typeInet() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like