OracleAutoIncrementHelper::getPrimaryKey() - Code Metrics - Inspection of "Bump v4.0.1" - yajra/laravel-oci8 - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 3b8e4a...656576 )

by Arjay

created 2015-12-22 02:44 UTC

OracleAutoIncrementHelper::getPrimaryKey() B

↳ Parent: OracleAutoIncrementHelper

Complexity

Conditions	3
Paths	3

Size

Total Lines	24
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Metric	Value
dl	0
loc	24
rs	8.9714
cc	3
eloc	8
nc	3
nop	1

<?php

namespace Yajra\Oci8\Schema;

use Illuminate\Database\Connection;
use Illuminate\Database\Schema\Blueprint;

class OracleAutoIncrementHelper
{
    /**
     * @var \Illuminate\Database\Connection
     */
    protected $connection;

    /**
     * @var \Yajra\Oci8\Schema\Trigger
     */
    protected $trigger;

    /**
     * @var \Yajra\Oci8\Schema\Sequence
     */
    protected $sequence;

    /**
     * @param \Illuminate\Database\Connection $connection
     */
    public function __construct(Connection $connection)
    {
        $this->connection = $connection;
        $this->sequence   = new Sequence($connection);
        $this->trigger    = new Trigger($connection);
    }

    /**
     * create sequence and trigger for autoIncrement support
     *
     * @param  Blueprint $blueprint
     * @param  string $table
     * @return null
     */
    public function createAutoIncrementObjects(Blueprint $blueprint, $table)
    {
        $column = $this->getQualifiedAutoIncrementColumn($blueprint);

        // return if no qualified AI column
        if (is_null($column)) {
            return;
        }

        $col   = $column->name;
        $start = isset($column->start) ? $column->start : 1;

        // get table prefix
        $prefix = $this->connection->getTablePrefix();

        // create sequence for auto increment
        $sequenceName = $this->createObjectName($prefix, $table, $col, 'seq');
        $this->sequence->create($sequenceName, $start, $column->nocache);

        // create trigger for auto increment work around
        $triggerName = $this->createObjectName($prefix, $table, $col, 'trg');
        $this->trigger->autoIncrement($prefix . $table, $col, $triggerName, $sequenceName);
    }

    /**
     * get qualified autoincrement column
     *
     * @param  Blueprint $blueprint
     * @return Fluent|null
     */
    public function getQualifiedAutoIncrementColumn(Blueprint $blueprint)
    {
        $columns = $blueprint->getColumns();

        // search for primary key / autoIncrement column
        foreach ($columns as $column) {
            // if column is autoIncrement set the primary col name
            if ($column->autoIncrement) {
                return $column;
            }
        }

        return null;
    }

    /**
     * Create an object name that limits to 30chars
     *
     * @param  string $prefix
     * @param  string $table
     * @param  string $col
     * @param  string $type
     * @return string
     */
    private function createObjectName($prefix, $table, $col, $type)
    {
        // max object name length is 30 chars
        return substr($prefix . $table . '_' . $col . '_' . $type, 0, 30);
    }

    /**
     * drop sequence and triggers if exists, autoincrement objects
     *
     * @param  string $table
     * @return null
     */
    public function dropAutoIncrementObjects($table)
    {
        // drop sequence and trigger object
        $prefix = $this->connection->getTablePrefix();
        // get the actual primary column name from table
        $col = $this->getPrimaryKey($prefix . $table);
        // if primary key col is set, drop auto increment objects
        if (isset($col) and ! empty($col)) {
            // drop sequence for auto increment
            $sequenceName = $this->createObjectName($prefix, $table, $col, 'seq');
            $this->sequence->drop($sequenceName);

            // drop trigger for auto increment work around
            $triggerName = $this->createObjectName($prefix, $table, $col, 'trg');
            $this->trigger->drop($triggerName);
        }
    }

    /**
     * get table's primary key
     *
     * @param  string $table
     * @return string
     */
    public function getPrimaryKey($table)
    {
        if (! $table) {
            return '';
        }

        $data = $this->connection->selectOne("
            SELECT cols.column_name
            FROM all_constraints cons, all_cons_columns cols
            WHERE cols.table_name = upper('{$table}')
                AND cons.constraint_type = 'P'
                AND cons.constraint_name = cols.constraint_name
                AND cons.owner = cols.owner
                AND cols.position = 1
                AND cons.owner = (select user from dual)
            ORDER BY cols.table_name, cols.position
            ");

        if (count($data)) {
            return $data->column_name;
        }

        return '';
    }

    /**
     * @return Sequence
     */
    public function getSequence()
    {
        return $this->sequence;
    }

    /**
     * @param Sequence $sequence
     */
    public function setSequence($sequence)
    {
        $this->sequence = $sequence;
    }

    /**
     * @return Trigger
     */
    public function getTrigger()
    {
        return $this->trigger;
    }

    /**
     * @param Trigger $trigger
     */
    public function setTrigger($trigger)
    {
        $this->trigger = $trigger;
    }
}


1			<?php
2
3			namespace Yajra\Oci8\Schema;
4
5			use Illuminate\Database\Connection;
6			use Illuminate\Database\Schema\Blueprint;
7
8			class OracleAutoIncrementHelper
9			{
10			/**
11			* @var \Illuminate\Database\Connection
12			*/
13			protected $connection;
14
15			/**
16			* @var \Yajra\Oci8\Schema\Trigger
17			*/
18			protected $trigger;
19
20			/**
21			* @var \Yajra\Oci8\Schema\Sequence
22			*/
23			protected $sequence;
24
25			/**
26			* @param \Illuminate\Database\Connection $connection
27			*/
28			public function __construct(Connection $connection)
29			{
30			$this->connection = $connection;
31			$this->sequence = new Sequence($connection);
32			$this->trigger = new Trigger($connection);
33			}
34
35			/**
36			* create sequence and trigger for autoIncrement support
37			*
38			* @param Blueprint $blueprint
39			* @param string $table
40			* @return null
41			*/
42			public function createAutoIncrementObjects(Blueprint $blueprint, $table)
43			{
44			$column = $this->getQualifiedAutoIncrementColumn($blueprint);
45
46			// return if no qualified AI column
47			if (is_null($column)) {
48			return;
49			}
50
51			$col = $column->name;
52			$start = isset($column->start) ? $column->start : 1;
53
54			// get table prefix
55			$prefix = $this->connection->getTablePrefix();
56
57			// create sequence for auto increment
58			$sequenceName = $this->createObjectName($prefix, $table, $col, 'seq');
59			$this->sequence->create($sequenceName, $start, $column->nocache);
60
61			// create trigger for auto increment work around
62			$triggerName = $this->createObjectName($prefix, $table, $col, 'trg');
63			$this->trigger->autoIncrement($prefix . $table, $col, $triggerName, $sequenceName);
64			}
65
66			/**
67			* get qualified autoincrement column
68			*
69			* @param Blueprint $blueprint
70			* @return Fluent\|null
71			*/
72			public function getQualifiedAutoIncrementColumn(Blueprint $blueprint)
73			{
74			$columns = $blueprint->getColumns();
75
76			// search for primary key / autoIncrement column
77			foreach ($columns as $column) {
78			// if column is autoIncrement set the primary col name
79			if ($column->autoIncrement) {
80			return $column;
81			}
82			}
83
84			return null;
85			}
86
87			/**
88			* Create an object name that limits to 30chars
89			*
90			* @param string $prefix
91			* @param string $table
92			* @param string $col
93			* @param string $type
94			* @return string
95			*/
96			private function createObjectName($prefix, $table, $col, $type)
97			{
98			// max object name length is 30 chars
99			return substr($prefix . $table . '_' . $col . '_' . $type, 0, 30);
100			}
101
102			/**
103			* drop sequence and triggers if exists, autoincrement objects
104			*
105			* @param string $table
106			* @return null
107			*/
108			public function dropAutoIncrementObjects($table)
109			{
110			// drop sequence and trigger object
111			$prefix = $this->connection->getTablePrefix();
112			// get the actual primary column name from table
113			$col = $this->getPrimaryKey($prefix . $table);
114			// if primary key col is set, drop auto increment objects
115			if (isset($col) and ! empty($col)) {
116			// drop sequence for auto increment
117			$sequenceName = $this->createObjectName($prefix, $table, $col, 'seq');
118			$this->sequence->drop($sequenceName);
119
120			// drop trigger for auto increment work around
121			$triggerName = $this->createObjectName($prefix, $table, $col, 'trg');
122			$this->trigger->drop($triggerName);
123			}
124			}
125
126			/**
127			* get table's primary key
128			*
129			* @param string $table
130			* @return string
131			*/
132			public function getPrimaryKey($table)
133			{
134			if (! $table) {
135			return '';
136			}
137
138			$data = $this->connection->selectOne("
139			SELECT cols.column_name
140			FROM all_constraints cons, all_cons_columns cols
141			WHERE cols.table_name = upper('{$table}')
142			AND cons.constraint_type = 'P'
143			AND cons.constraint_name = cols.constraint_name
144			AND cons.owner = cols.owner
145			AND cols.position = 1
146			AND cons.owner = (select user from dual)
147			ORDER BY cols.table_name, cols.position
148			");
149
150			if (count($data)) {
151			return $data->column_name;
152			}
153
154			return '';
155			}
156
157			/**
158			* @return Sequence
159			*/
160			public function getSequence()
161			{
162			return $this->sequence;
163			}
164
165			/**
166			* @param Sequence $sequence
167			*/
168			public function setSequence($sequence)
169			{
170			$this->sequence = $sequence;
171			}
172
173			/**
174			* @return Trigger
175			*/
176			public function getTrigger()
177			{
178			return $this->trigger;
179			}
180
181			/**
182			* @param Trigger $trigger
183			*/
184			public function setTrigger($trigger)
185			{
186			$this->trigger = $trigger;
187			}
188			}
189

yajra / laravel-oci8

Push — develop ( 3b8e4a...656576 )

OracleAutoIncrementHelper::getPrimaryKey() B

Complexity

Size

Duplication

Duplication Side-by-Side

Filter issues like