InstallSchema::install() - Code Metrics - lizardmedia/product-attachments-magento2 - Measure and Improve Code Quality continuously with Scrutinizer

InstallSchema::install() B
last analyzed 2021-02-28 20:03 UTC

↳ Parent: InstallSchema

Complexity

Conditions	1
Paths	1

Size

Total Lines

106

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	106
rs	8
c	0
b	0
f	0
cc	1
nc	1
nop	2

How to fix Long Method

<?php

declare(strict_types = 1);

/**
 * File: InstallSchema.php
 *
 * @author Bartosz Kubicki [email protected]>
 * @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();
    }
}


1			<?php
2
3			declare(strict_types = 1);
4
5			/**
6			* File: InstallSchema.php
7			*
8			* @author Bartosz Kubicki [email protected]>
9			* @copyright Copyright (C) 2019 Lizard Media (http://lizardmedia.pl)
10			*/
11
12			namespace LizardMedia\ProductAttachment\Setup;
13
14			use LizardMedia\ProductAttachment\Model\Attachment;
15			use Magento\Framework\Setup\InstallSchemaInterface;
16			use Magento\Framework\Setup\ModuleContextInterface;
17			use Magento\Framework\Setup\SchemaSetupInterface;
18			use Magento\Framework\DB\Ddl\Table;
19			use Zend_Db_Exception;
20
21			/**
22			* Class InstallSchema
23			* @package LizardMedia\ProductAttachment\Setup
24			*/
25			class InstallSchema implements InstallSchemaInterface
26			{
27			/**
28			* @param SchemaSetupInterface $setup
29			* @param ModuleContextInterface $context
30			*
31			* @throws Zend_Db_Exception
32			*
33			* @return void
34			*/
35			public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
36			{
37			$setup->startSetup();
38
39			$productAttachments = $setup->getConnection()->newTable(
40			$setup->getTable(Attachment::MAIN_TABLE)
41			)->addColumn(
42			Attachment::ID,
43			Table::TYPE_INTEGER,
44			11,
45			['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
46			'Id'
47			)->addColumn(
48			Attachment::PRODUCT_ID,
49			Table::TYPE_INTEGER,
50			11,
51			['unsigned' => true, 'nullable' => false],
52			'Product id'
53			)->addColumn(
54			Attachment::SORT_ORDER,
55			Table::TYPE_INTEGER,
56			11,
57			['unsigned' => true, 'nullable' => false],
58			'Sort order'
59			)->addColumn(
60			Attachment::ATTACHMENT_TYPE,
61			Table::TYPE_TEXT,
62			21,
63			['nullable' => false],
64			'Type'
65			)->addColumn(
66			Attachment::ATTACHMENT_FILE,
67			Table::TYPE_TEXT,
68			255,
69			['nullable' => true],
70			'File'
71			)->addColumn(
72			Attachment::ATTACHMENT_URL,
73			Table::TYPE_TEXT,
74			255,
75			['nullable' => true],
76			'File'
77			)->addForeignKey(
78			$setup->getFkName(
79			$setup->getTable(Attachment::MAIN_TABLE),
80			Attachment::PRODUCT_ID,
81			$setup->getTable('catalog_product_entity'),
82			'entity_id'
83			),
84			Attachment::PRODUCT_ID,
85			$setup->getTable('catalog_product_entity'),
86			'entity_id',
87			Table::ACTION_CASCADE
88			)->setComment(
89			'Product attachments'
90			);
91
92			$setup->getConnection()->createTable($productAttachments);
93
94
95
96			$productAttachmentsTitle = $setup->getConnection()->newTable(
97			$setup->getTable(Attachment::TITLE_TABLE)
98			)->addColumn(
99			Attachment::TITLE_ID,
100			Table::TYPE_INTEGER,
101			11,
102			['identity' => true, 'unsigned' => true, 'nullable' => false, 'primary' => true],
103			'Id'
104			)->addColumn(
105			Attachment::ATTACHMENT_ID,
106			Table::TYPE_INTEGER,
107			11,
108			['unsigned' => true, 'nullable' => false],
109			'Attachment id'
110			)->addColumn(
111			Attachment::STORE_ID,
112			Table::TYPE_INTEGER,
113			11,
114			['unsigned' => true, 'nullable' => false],
115			'Store id'
116			)->addColumn(
117			Attachment::TITLE,
118			Table::TYPE_TEXT,
119			120,
120			['nullable' => false],
121			'Title'
122			)->addForeignKey(
123			$setup->getFkName(
124			$setup->getTable(Attachment::TITLE_TABLE),
125			Attachment::ATTACHMENT_ID,
126			$setup->getTable(Attachment::MAIN_TABLE),
127			Attachment::ID
128			),
129			Attachment::ATTACHMENT_ID,
130			$setup->getTable(Attachment::MAIN_TABLE),
131			Attachment::ID,
132			Table::ACTION_CASCADE
133			)->setComment(
134			'Product attachments titles'
135			);
136
137			$setup->getConnection()->createTable($productAttachmentsTitle);
138
139			$setup->endSetup();
140			}
141			}
142

lizardmedia / product-attachments-magento2

InstallSchema::install() B last analyzed 2021-02-28 20:03 UTC

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like

InstallSchema::install() B
last analyzed 2021-02-28 20:03 UTC