GinoPane\BlogTaxonomy\Updates\CreateRelatedSeriesTable

Complexity

Total Complexity

6

Size/Duplication

Total Lines	49
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	6	2
A	down()	0	6	2
A	dropRelation()	0	4	1
A	createRelation()	0	15	1

<?php

namespace GinoPane\BlogTaxonomy\Updates;

use Schema;
use System\Classes\PluginManager;
use GinoPane\BlogTaxonomy\Models\Series;
use October\Rain\Database\Updates\Migration;

/**
 * Class CreateRelatedSeriesTable
 *
 * @package GinoPane\BlogTaxonomy\Updates
 */
class CreateRelatedSeriesTable extends Migration
{
    /**
     * Execute migrations
     */
    public function up()
    {
        if (PluginManager::instance()->hasPlugin('RainLab.Blog')) {
            $this->createRelation();
        }
    }

    /**
     * Rollback migrations
     */
    public function down()
    {
        if (PluginManager::instance()->hasPlugin('RainLab.Blog')) {
            $this->dropRelation();
        }
    }

    /**
     * Rollback relation migration
     */
    private function dropRelation()
    {
        Schema::dropIfExists(Series::RELATED_SERIES_TABLE_NAME);
    }

    /**
     * Create relation table
     */
    private function createRelation()
    {
        Schema::create(
            Series::RELATED_SERIES_TABLE_NAME,
            function ($table) {
                $table->engine = 'InnoDB';

                $table->integer('series_id')->unsigned();
                $table->integer('related_series_id')->unsigned();
                $table->index(['series_id', 'related_series_id']);
                $table->foreign('series_id', 'Series reference')->references('id')->on(Series::TABLE_NAME)->onDelete('cascade');
                $table->foreign('related_series_id', 'Related series reference')->references('id')->on(Series::TABLE_NAME)->onDelete('cascade');
            }
        );
    }
}