agoalofalife\database\migrations\CitiesMigration

Complexity

Total Complexity

4

Size/Duplication

Total Lines	34
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

0%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	execute()	0	13	1
A	check()	0	7	2
A	down()	0	4	1

<?php


namespace agoalofalife\database\migrations;
use agoalofalife\Contracts\Checker;
use agoalofalife\Contracts\ContractMigration;
use \Illuminate\Database\Capsule\Manager as Capsule;

class CitiesMigration implements ContractMigration, Checker
{
    public function execute()
    {
        Capsule::schema()->create('cities', function ($table) {
            $table->increments('id');
            $table->integer('region_id')->unsigned()->index()->nullable();
            $table->foreign('region_id')->references('id')->on('regions')->onDelete('cascade');
            $table->string('title', 100);
            $table->string('area', 100);
            $table->text('description')->nullable();
            $table->string('code')->nullable()->comments('unique value');
            $table->timestamps();
        });
    }

    public function check(callable $callback)
    {
        if ( Capsule::schema()->hasTable('cities') === false )
        {
            call_user_func($callback, $this);
        }
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Capsule::schema()->dropIfExists('cities');
    }
}