Yajra\Oci8\Schema\Comment

Complexity

Total Complexity

6

Size/Duplication

Total Lines	52
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes	2
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	setComments()	0	14	2
A	commentColumns()	0	10	3

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