Yajra\Oci8\Schema\Comment

Complexity

Total Complexity

7

Size/Duplication

Total Lines	56
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes	3
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
B	setComments()	0	23	5
A	commentColumn()	0	4	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->comment != null)
        {
            $this->connection->statement(sprintf('comment on table %s is \'%s\'', $blueprint->getTable(), $blueprint->comment));
        }

        // Comments set by $table->string('column')->comment('comment');
        foreach ($blueprint->getColumns() as $column)
        {
            if (isset($column['comment']))
            {
                $this->commentColumn($blueprint->getTable(), $column['name'], $column['comment']);
            }
        }

        // Comments set by $table->commentColumns = ['column' => 'comment'];
        foreach ($blueprint->commentColumns as $column => $comment)
        {
            $this->commentColumn($blueprint->getTable(), $column, $comment);
        }
    }

    /**
     * Run the comment on column statement
     *
     * @param  string $table
     * @param  string $column
     * @param  string $comment
     */
    private function commentColumn($table, $column, $comment)
    {
        $this->connection->statement(sprintf('comment on column %s.%s is \'%s\'', $table, $column, $comment));
    }
}