flipbox\craft\scorecard\migrations\AbstractElementMetricMigration

Complexity

Total Complexity

6

Size/Duplication

Total Lines	104
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	tableName()	0	7	1
A	safeUp()	0	7	1
A	safeDown()	0	6	1
A	createTables()	0	4	1
A	tableAttributes()	0	17	1
A	addForeignKeys()	0	26	1

<?php

/**
 * @copyright  Copyright (c) Flipbox Digital Limited
 * @license    https://flipboxfactory.com/software/scorecard/license
 * @link       https://www.flipboxfactory.com/software/scorecard/
 */

namespace flipbox\craft\scorecard\migrations;

use craft\db\Migration;
use craft\records\Element as ElementRecord;
use flipbox\craft\scorecard\records\ElementMetric;

/**
 * @author Flipbox Factory <hello@flipboxfactory.com>
 * @since 1.0.0
 */
abstract class AbstractElementMetricMigration extends Migration
{
    /**
     * The record class
     */
    const RECORD_CLASS = ElementMetric::class;

    /**
     * @return string
     */
    protected static function tableName(): string
    {
        /** @var ElementMetric $recordClass */
        $recordClass = static::RECORD_CLASS;

        return $recordClass::tableName();
    }

    /**
     * @inheritdoc
     */
    public function safeUp()
    {
        $this->createTables();
        $this->addForeignKeys();

        return true;
    }

    /**
     * @inheritdoc
     */
    public function safeDown()
    {
        $this->dropTableIfExists(static::tableName());

        return true;
    }

    /**
     * Creates the table(s).
     *
     * @return void
     */
    protected function createTables()
    {
        $this->createTable(static::tableName(), $this->tableAttributes());
    }

    /**
     * The table attributes
     *
     * @return array
     */
    protected function tableAttributes(): array
    {
        return [
            'id' => $this->primaryKey(),
            'parentId' => $this->integer(),
            'elementId' => $this->integer()->notNull(),
            'class' => $this->string()->notNull(),
            'score' => $this->float(4),
            'weight' => $this->float(4)->notNull(),
            'version' => $this->string(50)->notNull(),
            'settings' => $this->text(),
            'dateCalculated' => $this->dateTime()->notNull(),
            'dateUpdated' => $this->dateTime()->notNull(),
            'dateCreated' => $this->dateTime()->notNull(),
            'uid' => $this->uid()
        ];
    }

    /**
     * Adds the foreign keys.
     *
     * @return void
     */
    protected function addForeignKeys()
    {
        $this->addForeignKey(
            $this->db->getForeignKeyName(
                static::tableName(),
                'elementId'
            ),
            static::tableName(),
            'elementId',
            ElementRecord::tableName(),
            'id',
            'CASCADE'
        );

        $this->addForeignKey(
            $this->db->getForeignKeyName(
                static::tableName(),
                'parentId'
            ),
            static::tableName(),
            'parentId',
            static::tableName(),
            'id',
            'CASCADE'
        );
    }
}