LizardMedia\ProductAttachment\Setup\InstallSchema

Complexity

Total Complexity

1

Size/Duplication

Total Lines	117
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
B	install()	0	106	1

<?php

declare(strict_types = 1);

/**
 * File: InstallSchema.php
 *
 * @author Bartosz Kubicki bartosz.kubicki@lizardmedia.pl>
 * @copyright Copyright (C) 2019 Lizard Media (http://lizardmedia.pl)
 */

namespace LizardMedia\ProductAttachment\Setup;

use LizardMedia\ProductAttachment\Model\Attachment;
use Magento\Framework\Setup\InstallSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Framework\DB\Ddl\Table;
use Zend_Db_Exception;

/**
 * Class InstallSchema
 * @package LizardMedia\ProductAttachment\Setup
 */
class InstallSchema implements InstallSchemaInterface
{
    /**
     * @param SchemaSetupInterface $setup
     * @param ModuleContextInterface $context
     *
     * @throws Zend_Db_Exception
     *
     * @return void
     */
    public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
    {
        $setup->startSetup();

        $productAttachments = $setup->getConnection()->newTable(
            $setup->getTable(Attachment::MAIN_TABLE)
        )->addColumn(
            Attachment::ID,
            Table::TYPE_INTEGER,
            11,
            ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary'  => true],
            'Id'
        )->addColumn(
            Attachment::PRODUCT_ID,
            Table::TYPE_INTEGER,
            11,
            ['unsigned' => true, 'nullable' => false],
            'Product id'
        )->addColumn(
            Attachment::SORT_ORDER,
            Table::TYPE_INTEGER,
            11,
            ['unsigned' => true, 'nullable' => false],
            'Sort order'
        )->addColumn(
            Attachment::ATTACHMENT_TYPE,
            Table::TYPE_TEXT,
            21,
            ['nullable' => false],
            'Type'
        )->addColumn(
            Attachment::ATTACHMENT_FILE,
            Table::TYPE_TEXT,
            255,
            ['nullable' => true],
            'File'
        )->addColumn(
            Attachment::ATTACHMENT_URL,
            Table::TYPE_TEXT,
            255,
            ['nullable' => true],
            'File'
        )->addForeignKey(
            $setup->getFkName(
                $setup->getTable(Attachment::MAIN_TABLE),
                Attachment::PRODUCT_ID,
                $setup->getTable('catalog_product_entity'),
                'entity_id'
            ),
            Attachment::PRODUCT_ID,
            $setup->getTable('catalog_product_entity'),
            'entity_id',
            Table::ACTION_CASCADE
        )->setComment(
            'Product attachments'
        );

        $setup->getConnection()->createTable($productAttachments);



        $productAttachmentsTitle = $setup->getConnection()->newTable(
            $setup->getTable(Attachment::TITLE_TABLE)
        )->addColumn(
            Attachment::TITLE_ID,
            Table::TYPE_INTEGER,
            11,
            ['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary'  => true],
            'Id'
        )->addColumn(
            Attachment::ATTACHMENT_ID,
            Table::TYPE_INTEGER,
            11,
            ['unsigned' => true, 'nullable' => false],
            'Attachment id'
        )->addColumn(
            Attachment::STORE_ID,
            Table::TYPE_INTEGER,
            11,
            ['unsigned' => true, 'nullable' => false],
            'Store id'
        )->addColumn(
            Attachment::TITLE,
            Table::TYPE_TEXT,
            120,
            ['nullable' => false],
            'Title'
        )->addForeignKey(
            $setup->getFkName(
                $setup->getTable(Attachment::TITLE_TABLE),
                Attachment::ATTACHMENT_ID,
                $setup->getTable(Attachment::MAIN_TABLE),
                Attachment::ID
            ),
            Attachment::ATTACHMENT_ID,
            $setup->getTable(Attachment::MAIN_TABLE),
            Attachment::ID,
            Table::ACTION_CASCADE
        )->setComment(
            'Product attachments titles'
        );

        $setup->getConnection()->createTable($productAttachmentsTitle);

        $setup->endSetup();
    }
}