GinoPane\BlogTaxonomy\Updates\CreatePostTypeTable

Complexity

Total Complexity

8

Size/Duplication

Total Lines	116
Duplicated Lines	18.97 %

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	dropPostTypes()	16	16	2
A	createPostTypes()	6	35	2

<?php

namespace GinoPane\BlogTaxonomy\Updates;

use DB;
use Schema;
use Carbon\Carbon;
use System\Classes\PluginManager;
use GinoPane\BlogTaxonomy\Models\PostType;
use October\Rain\Database\Updates\Migration;

/**
 * Class CreatePostTypeTable
 *
 * @package GinoPane\BlogTaxonomy\Updates
 */
class CreatePostTypeTable extends Migration
{
    const GAME_REVIEW_TYPE = [
        [
            'name' => 'Release Date',
            'code' => 'release-date',
            'type' => 'datepicker',
            'datepicker_mode' => 'date'
        ],
        [
            'name' => 'Publisher',
            'code' => 'publisher',
            'type' => 'text'
        ],
        [
            'name' => 'Editor',
            'code' => 'editor',
            'type' => 'text'
        ],
        [
            'name' => 'Rating',
            'code' => 'rating',
            'type' => 'dropdown',
            'dropdown_options' => '1,2,3,4,5,6,7,8,9,10',
        ],
        [
            'name' => 'Pros',
            'code' => 'pros',
            'type' => 'textarea'
        ],
        [
            'name' => 'Cons',
            'code' => 'cons',
            'type' => 'textarea'
        ],
    ];

    /**
     * Execute migrations
     */
    public function up()
    {
        if (PluginManager::instance()->hasPlugin('RainLab.Blog')) {
            $this->createPostTypes();
        }
    }

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

    /**
     * Rollback PostType migration
     */
    private function dropPostTypes()

This method seems to be duplicated in your project.

    {
        Schema::table('rainlab_blog_posts', static function ($table) {
            $table->dropForeign([PostType::TABLE_NAME . '_id']);

            $table->dropColumn(PostType::TABLE_NAME. '_attributes');
        });

        if (Schema::hasColumn('rainlab_blog_posts', PostType::TABLE_NAME . '_id')) {
            Schema::table('rainlab_blog_posts', static function ($table) {
                $table->dropColumn(PostType::TABLE_NAME . '_id');
            });
        }

        Schema::dropIfExists(PostType::TABLE_NAME);
    }

    /**
     * Create PostType table
     */
    private function createPostTypes()
    {
        if (!Schema::hasTable(PostType::TABLE_NAME)) {
            Schema::create(
                PostType::TABLE_NAME,
                static function ($table) {
                    $table->engine = 'InnoDB';

                    $table->increments('id');
                    $table->string('name')->unique();
                    $table->string('slug')->unique();
                    $table->text('description')->nullable();
                    $table->json('type_attributes')->nullable();
                    $table->timestamps();
                }
            );

            Schema::table('rainlab_blog_posts', function ($table) {

This code seems to be duplicated across your project.

                $table->integer(PostType::TABLE_NAME . '_id')->unsigned()->nullable()->default(null);
                $table->foreign(PostType::TABLE_NAME . '_id')->references('id')->on(PostType::TABLE_NAME)->onDelete('cascade');

                $table->json(PostType::TABLE_NAME. '_attributes')->nullable();
            });

            DB::table(PostType::TABLE_NAME)->insert(
                [
                    'name' => 'Game Review',
                    'slug' => 'game-review',
                    'type_attributes' => json_encode(self::GAME_REVIEW_TYPE),
                    'created_at' => Carbon::now(),
                    'updated_at' => Carbon::now(),
                ]
            );
        }
    }
}