flipbox\hubspot\migrations\ObjectTable

Complexity

Total Complexity

6

Size/Duplication

Total Lines	118
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

0%

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	getTableName()	0	4	1
A	safeUp()	0	7	1
A	createTables()	0	15	1
B	createIndexes()	0	35	1
A	addForeignKeys()	0	15	1
A	safeDown()	0	5	1

<?php

namespace flipbox\hubspot\migrations;

use craft\db\Migration;
use craft\records\Element as ElementRecord;

class ObjectTable extends Migration
{
    /**
     * @var array
     */
    public $tableAlias;

    /**
     * @return string
     */
    private function getTableName(): string
    {
        return '{{%' . $this->tableAlias . '}}';
    }

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

    /**
     * Creates the tables.
     *
     * @return void
     */
    protected function createTables()
    {
        $this->dropTableIfExists($this->getTableName());
        $this->createTable(
            $this->getTableName(),
            [
                'id' => $this->primaryKey(),
                'elementId' => $this->integer(),
                'hubspotId' => $this->char(48),
                'dateCreated' => $this->dateTime()->notNull(),
                'dateUpdated' => $this->dateTime()->notNull(),
                'uid' => $this->uid()
            ]
        );
    }

    /**
     * Creates the indexes.
     *
     * @return void
     */
    protected function createIndexes()
    {
        $this->createIndex(
            $this->db->getIndexName(
                $this->getTableName(),
                'elementId',
                true,
                true
            ),
            $this->getTableName(),
            'elementId',
            true
        );
        $this->createIndex(
            $this->db->getIndexName(
                $this->getTableName(),
                'hubspotId',
                false,
                false
            ),
            $this->getTableName(),
            'hubspotId',
            false
        );
        $this->createIndex(
            $this->db->getIndexName(
                $this->getTableName(),
                'elementId,hubspotId',
                true
            ),
            $this->getTableName(),
            'elementId,hubspotId',
            true
        );
    }

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

    /**
     * @inheritdoc
     */
    public function safeDown()
    {
        $this->dropTableIfExists($this->getTableName());
        return true;
    }
}