Comment::setComments() - Code Metrics - Inspection of "Table and column comments" - yajra/laravel-oci8 - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — 4.0 (#124)

unknown

created 2015-12-22 18:08 UTC

Comment::setComments() A

↳ Parent: Comment

Complexity

Conditions	2
Paths	2

Size

Total Lines	14
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

Metric	Value
c	2
b	0
f	0
dl	0
loc	14
rs	9.4286
cc	2
eloc	5
nc	2
nop	1

<?php

namespace Yajra\Oci8\Schema;

use Illuminate\Database\Connection;

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

    /**
     * @param Connection $connection
     */
    public function __construct(Connection $connection)
    {
        $this->connection = $connection;
    }

    /**
     * Set table and column comments.
     *
     * @param  \Yajra\Oci8\Schema\OracleBlueprint $blueprint
     */
    public function setComments(OracleBlueprint $blueprint)
    {
        // Comment set by $table->comment('comment');
        if ($blueprint->commentTable != null)
        {
            $this->connection->statement(sprintf('comment on table %s is \'%s\'', $blueprint->getTable(), $blueprint->commentTable));
        }

        // Comments set by $table->string('column')->comment('comment');
        $this->commentColumns($blueprint->getTable(), $blueprint->getColumns());

        // Comments set by $table->commentColumn('column', 'comment');
        $this->commentColumns($blueprint->getTable(), $blueprint->commentColumn);
    }

    /**
     * Set column comment.
     *
     * @param  string $table
     * @param  array  $columns
     */
    private function commentColumns($table, $columns)
    {
        foreach ($columns as $column)
        {
            if (isset($column['comment']))
            {
                $this->connection->statement(sprintf('comment on column %s.%s is \'%s\'', $table, $column['name'], $column['comment']));
            }
        }
    }
}


1			<?php
2
3			namespace Yajra\Oci8\Schema;
4
5			use Illuminate\Database\Connection;
6
7			class Comment
8			{
9			/**
10			* @var \Illuminate\Database\Connection
11			*/
12			protected $connection;
13
14			/**
15			* @param Connection $connection
16			*/
17			public function __construct(Connection $connection)
18			{
19			$this->connection = $connection;
20			}
21
22			/**
23			* Set table and column comments.
24			*
25			* @param \Yajra\Oci8\Schema\OracleBlueprint $blueprint
26			*/
27			public function setComments(OracleBlueprint $blueprint)
28			{
29			// Comment set by $table->comment('comment');
30			if ($blueprint->commentTable != null)
31			{
32			$this->connection->statement(sprintf('comment on table %s is \'%s\'', $blueprint->getTable(), $blueprint->commentTable));
33			}
34
35			// Comments set by $table->string('column')->comment('comment');
36			$this->commentColumns($blueprint->getTable(), $blueprint->getColumns());
37
38			// Comments set by $table->commentColumn('column', 'comment');
39			$this->commentColumns($blueprint->getTable(), $blueprint->commentColumn);
40			}
41
42			/**
43			* Set column comment.
44			*
45			* @param string $table
46			* @param array $columns
47			*/
48			private function commentColumns($table, $columns)
49			{
50			foreach ($columns as $column)
51			{
52			if (isset($column['comment']))
53			{
54			$this->connection->statement(sprintf('comment on column %s.%s is \'%s\'', $table, $column['name'], $column['comment']));
55			}
56			}
57			}
58			}
59

yajra / laravel-oci8

Pull Request — 4.0 (#124)

Comment::setComments() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like