SqlFile::__construct() - Code Metrics - ggoffy/modulebuilder - Measure and Improve Code Quality continuously with Scrutinizer

SqlFile::__construct() A
last analyzed 2021-11-25 07:12 UTC

↳ Parent: SqlFile

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	1
nc	1
nop	0
dl	0
loc	3
rs	10
c	0
b	0
f	0

<?php

namespace XoopsModules\Modulebuilder\Files\Sql;

use XoopsModules\Modulebuilder;
use XoopsModules\Modulebuilder\Files;

/*
 You may not change or alter any portion of this comment or credits
 of supporting developers from this source code or any supporting source code
 which is considered copyrighted (c) material of the original comment or credit authors.

 This program is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 */
/**
 * modulebuilder module.
 *
 * @copyright       XOOPS Project (https://xoops.org)
 * @license         GNU GPL 2 (https://www.gnu.org/licenses/old-licenses/gpl-2.0.html)
 *
 * @since           2.5.0
 *
 * @author          Txmod Xoops https://xoops.org 
 *                  Goffy https://myxoops.org
 *
 */

/**
 * Class SqlFile.
 */
class SqlFile extends Files\CreateFile
{
    /**
     * @public function constructor
     *
     * @param null
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * @static function getInstance
     *
     * @param null
     *
     * @return SqlFile
     */
    public static function getInstance()
    {
        static $instance = false;
        if (!$instance) {
            $instance = new self();
        }

        return $instance;
    }

    /**
     * @public function write
     *
     * @param $module
     * @param $filename
     */
    public function write($module, $filename)
    {
        $this->setModule($module);
        $this->setFileName($filename);
    }

    /**
     * @private function getHeaderSqlComments
     *
     * @param $moduleName
     *
     * @return string
     */
    private function getHeaderSqlComments($moduleName)
    {
        $date          = date('D M d, Y');
        $time          = date('H:i:s');
        $serverName    = \Xmf\Request::getString('SERVER_NAME', '', 'SERVER');
        $serverVersion = $GLOBALS['xoopsDB']->getServerVersion();
        $phpVersion    = PHP_VERSION;
        // Header Sql Comments
        $ret             = null;
        $arrayServerInfo = [
            "# SQL Dump for {$moduleName} module",
            '# PhpMyAdmin Version: 4.0.4',
            '# http://www.phpmyadmin.net',
            '#',
            "# Host: {$serverName}",
            "# Generated on: {$date} to {$time}",
            "# Server version: {$serverVersion}",
            "# PHP Version: {$phpVersion}\n",
        ];
        foreach ($arrayServerInfo as $serverInfo) {
            $ret .= $this->getSimpleString($serverInfo);
        }

        return $ret;
    }

    /**
     * @private function getHeadDatabaseTable
     * @param     $moduleDirname
     * @param     $tableName
     * @param int $fieldsNumb
     *
     *  Unused IF NOT EXISTS
     *
     * @return string
     */
    private function getHeadDatabaseTable($moduleDirname, $tableName, $fieldsNumb)
    {
        $ret          = null;
        $arrayDbTable = [
            '#',
            "# Structure table for `{$moduleDirname}_{$tableName}` {$fieldsNumb}",
            '#',
            "\nCREATE TABLE `{$moduleDirname}_{$tableName}` (",
        ];
        foreach ($arrayDbTable as $dbTable) {
            $ret .= $this->getSimpleString($dbTable);
        }

        return $ret;
    }

    /**
     * @private function getDatabaseTables
     *
     * @param $module
     *
     * @return null|string
     */
    private function getDatabaseTables($module)
    {
        $ret                = null;
        $moduleDirname      = \mb_strtolower($module->getVar('mod_dirname'));
        $tables             = $this->getTableTables($module->getVar('mod_id'), 'table_order ASC, table_id');
        $tableMid           = 0;

        $tableId            = 0;

        $tableName          = 0;

        $tableAutoincrement = 0;

        $fieldsNumb         = 0;

        $tableRate          = 0;
        foreach (\array_keys($tables) as $t) {
            $tableId            = $tables[$t]->getVar('table_id');
            $tableMid           = $tables[$t]->getVar('table_mid');
            $tableName          = $tables[$t]->getVar('table_name');
            $tableAutoincrement = $tables[$t]->getVar('table_autoincrement');
            $fieldsNumb         = $tables[$t]->getVar('table_nbfields');
            if (1 === (int)$tables[$t]->getVar('table_rate')) {
                $tableRate = 1;
            }
            $ret .= $this->getDatabaseFields($moduleDirname, $tableMid, $tableId, $tableName, $tableAutoincrement, $fieldsNumb);
        }

        if (1 === $tableRate) {
            $ret .= $this->getTableRatings($moduleDirname);
        }

        return $ret;
    }

    /**
     * @private function getDatabaseFields
     *
     * @param $moduleDirname
     * @param $tableMid
     * @param $tableId
     * @param $tableName
     * @param $tableAutoincrement
     * @param $fieldsNumb
     * @return null|string
     */
    private function getDatabaseFields($moduleDirname, $tableMid, $tableId, $tableName, $tableAutoincrement, $fieldsNumb)
    {
        $helper = Modulebuilder\Helper::getInstance();
        $ret    = null;
        $j      = 0;
        $comma  = [];
        $row    = [];
        //$type          = '';
        $fieldTypeName = '';
        $fields        = $this->getTableFields($tableMid, $tableId, 'field_order ASC, field_id');
        foreach (\array_keys($fields) as $f) {
            // Creation of database table
            $ret            = $this->getHeadDatabaseTable($moduleDirname, $tableName, $fieldsNumb);
            $fieldName      = $fields[$f]->getVar('field_name');
            $fieldType      = $fields[$f]->getVar('field_type');
            $fieldValue     = \str_replace('&#039;', '', $fields[$f]->getVar('field_value')); //remove single quotes
            $fieldAttribute = $fields[$f]->getVar('field_attribute');
            $fieldNull      = $fields[$f]->getVar('field_null');
            $fieldDefault   = \str_replace('&#039;', '', $fields[$f]->getVar('field_default')); //remove single quotes
            $fieldKey       = $fields[$f]->getVar('field_key');
            if ($fieldType > 1) {
                $fType         = $helper->getHandler('Fieldtype')->get($fieldType);
                $fieldTypeName = $fType->getVar('fieldtype_name');
            } else {
                $fieldType = null;
            }
            if ($fieldAttribute > 1) {
                $fAttribute     = $helper->getHandler('Fieldattributes')->get($fieldAttribute);
                $fieldAttribute = $fAttribute->getVar('fieldattribute_name');
            } else {
                $fieldAttribute = null;
            }
            if ($fieldNull > 1) {
                $fNull     = $helper->getHandler('Fieldnull')->get($fieldNull);
                $fieldNull = $fNull->getVar('fieldnull_name');
            } else {
                $fieldNull = null;
            }
            if (!empty($fieldName)) {
                switch ($fieldType) {
                    case 2:
                    case 3:
                    case 4:
                    case 5:
                        $type = $fieldTypeName . '(' . $fieldValue . ')';
                        if (empty($fieldDefault)) {
                            $default = "DEFAULT '0'";
                        } else {
                            $default = "DEFAULT '{$fieldDefault}'";
                        }
                        break;
                    case 6:
                    case 7:
                    case 8:
                        $type = $fieldTypeName . '(' . $fieldValue . ')';
                        if (empty($fieldDefault)) {
                            $default = "DEFAULT '0'"; // From MySQL 5.7 Manual
                        } else {
                            $default = "DEFAULT '{$fieldDefault}'";
                        }
                        break;
                    case 9:
                    case 10:
                        $fValues = \str_replace(',', "', '", \str_replace(' ', '', $fieldValue));
                        $type    = $fieldTypeName . '(\'' . $fValues . '\')'; // Used with comma separator
                        $default = "DEFAULT '{$fieldDefault}'";
                        break;
                    case 11:
                        $type = $fieldTypeName . '(' . $fieldValue . ')';
                        if (empty($fieldDefault)) {
                            $default = "DEFAULT '[email protected]'";
                        } else {
                            $default = "DEFAULT '{$fieldDefault}'";
                        }
                        break;
                    case 12:
                        $type = $fieldTypeName . '(' . $fieldValue . ')';
                        if (empty($fieldDefault)) {
                            $default = "DEFAULT 'https:\\'";
                        } else {
                            $default = "DEFAULT '{$fieldDefault}'";
                        }
                        break;
                    case 13:
                    case 14:
                        $type    = $fieldTypeName . '(' . $fieldValue . ')';
                        $default = "DEFAULT '{$fieldDefault}'";
                        break;
                    case 15:
                    case 16:
                    case 17:
                    case 18:
                        $type    = $fieldTypeName;
                        $default = null;
                        break;
                    case 19:
                    case 20:
                    case 21:
                    case 22:
                        $type    = $fieldTypeName . '(' . $fieldValue . ')';
                        $default = "DEFAULT '{$fieldDefault}'";
                        break;
                    case 23:
                        $type = $fieldTypeName;
                        if (empty($fieldDefault)) {
                            $default = "DEFAULT '1970'"; // From MySQL 5.7 Manual
                        } else {
                            $default = "DEFAULT '{$fieldDefault}'";
                        }
                        break;
                    default:
                        $type    = $fieldTypeName . '(' . $fieldValue . ')';
                        $default = "DEFAULT '{$fieldDefault}'";
                        break;
                }
                if ((0 == $f) && (1 == $tableAutoincrement)) {
                    $row[]     = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, null, 'AUTO_INCREMENT');
                    $comma[$j] = $this->getKey(2, $fieldName);
                    ++$j;
                } elseif ((0 == $f) && (0 == $tableAutoincrement)) {
                    $row[]     = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                    $comma[$j] = $this->getKey(2, $fieldName);
                    ++$j;
                } else {
                    if (3 == $fieldKey || 4 == $fieldKey || 5 == $fieldKey || 6 == $fieldKey) {
                        switch ($fieldKey) {
                            case 3:
                                $row[]     = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                                $comma[$j] = $this->getKey(3, $fieldName);
                                ++$j;
                                break;
                            case 4:
                                $row[]     = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                                $comma[$j] = $this->getKey(4, $fieldName);
                                ++$j;
                                break;
                            case 5:
                                $row[]     = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                                $comma[$j] = $this->getKey(5, $fieldName);
                                ++$j;
                                break;
                            case 6:
                                $row[]     = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                                $comma[$j] = $this->getKey(6, $fieldName);
                                ++$j;
                                break;
                        }
                    } else {
                        $row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
                    }
                }
            }
        }
        // ================= COMMA ================= //
        for ($i = 0; $i < $j; ++$i) {
            if ($i != $j - 1) {
                $row[] = $comma[$i] . ',';
            } else {
                $row[] = $comma[$i];
            }
        }
        // ================= COMMA CICLE ================= //
        $ret .= \implode("\n", $row);
        unset($j);
        $ret .= $this->getFootDatabaseTable();

        return $ret;
    }

    /**
     * @private function getDatabaseFields
     *
     * @param $moduleDirname
     * @return null|string
     */
    private function getTableRatings($moduleDirname)
    {
        $row   = [];
        $ret   = $this->getHeadDatabaseTable($moduleDirname, 'ratings', 6);
        $row[] = $this->getFieldRow('rate_id', 'INT(8)', 'UNSIGNED', 'NOT NULL', null, 'AUTO_INCREMENT');
        $row[] = $this->getFieldRow('rate_itemid', 'INT(8)', null, 'NOT NULL', "DEFAULT '0'");
        $row[] = $this->getFieldRow('rate_source', 'INT(8)', null, 'NOT NULL', "DEFAULT '0'");
        $row[] = $this->getFieldRow('rate_value', 'INT(1)', null, 'NOT NULL', "DEFAULT '0'");
        $row[] = $this->getFieldRow('rate_uid', 'INT(8)', null, 'NOT NULL', "DEFAULT '0'");
        $row[] = $this->getFieldRow('rate_ip', 'VARCHAR(60)', null, 'NOT NULL', "DEFAULT ''");
        $row[] = $this->getFieldRow('rate_date', 'INT(8)', null, 'NOT NULL', "DEFAULT '0'");
        $row[] = $this->getKey(2, 'rate_id');

        $ret .= \implode("\n", $row);
        $ret .= $this->getFootDatabaseTable();

        return $ret;
    }

    /**
     * @private function getFootDatabaseTable
     *
     * @param null
     *
     * @return string
     */
    private function getFootDatabaseTable()
    {
        return "\n) ENGINE=InnoDB;\n\n";
    }

    /**
     * @private function getFieldRow
     *
     * @param $fieldName
     * @param $fieldTypeValue
     * @param $fieldAttribute
     * @param $fieldNull
     * @param $fieldDefault
     * @param $autoincrement
     *
     * @return string
     */
    private function getFieldRow($fieldName, $fieldTypeValue, $fieldAttribute = null, $fieldNull = null, $fieldDefault = null, $autoincrement = null)
    {
        $retAutoincrement  = "  `{$fieldName}` {$fieldTypeValue} {$fieldAttribute} {$fieldNull} {$autoincrement},";
        $retFieldAttribute = "  `{$fieldName}` {$fieldTypeValue} {$fieldAttribute} {$fieldNull} {$fieldDefault},";
        $fieldDefault      = "  `{$fieldName}` {$fieldTypeValue} {$fieldNull} {$fieldDefault},";
        $retShort          = "  `{$fieldName}` {$fieldTypeValue},";

        $ret = $retShort;
        if (null != $autoincrement) {
            $ret = $retAutoincrement;
        } elseif (null != $fieldAttribute) {
            $ret = $retFieldAttribute;
        } elseif (null === $fieldAttribute) {
            $ret = $fieldDefault;
        }

        return $ret;
    }

    /**
     * @private function getKey
     *
     * @param $key
     * @param $fieldName
     * @return string
     */
    private function getKey($key, $fieldName)
    {
        $ret = null;
        switch ($key) {
            case 2: // PRIMARY KEY
                $ret = "  PRIMARY KEY (`{$fieldName}`)";
                break;
            case 3: // UNIQUE KEY
                $ret = "  UNIQUE KEY `{$fieldName}` (`{$fieldName}`)";
                break;
            case 4: // KEY
                $ret = "  KEY `{$fieldName}` (`{$fieldName}`)";
                break;
            case 5: // INDEX
                $ret = "  INDEX (`{$fieldName}`)";
                break;
            case 6: // FULLTEXT KEY
                $ret = "  FULLTEXT KEY `{$fieldName}` (`{$fieldName}`)";
                break;
        }

        return $ret;
    }

    /**
     * @public function render
     *
     * @param null
     *
     * @return bool|string
     */
    public function render()
    {
        $module        = $this->getModule();
        $filename      = $this->getFileName();
        $moduleName    = \mb_strtolower($module->getVar('mod_name'));
        $moduleDirname = \mb_strtolower($module->getVar('mod_dirname'));
        $content       = $this->getHeaderSqlComments($moduleName);
        $content       .= $this->getDatabaseTables($module);

        $this->create($moduleDirname, 'sql', $filename, $content, \_AM_MODULEBUILDER_FILE_CREATED, \_AM_MODULEBUILDER_FILE_NOTCREATED);

        return $this->renderFile();
    }
}


1			<?php
2
3			namespace XoopsModules\Modulebuilder\Files\Sql;
4
5			use XoopsModules\Modulebuilder;
6			use XoopsModules\Modulebuilder\Files;
7
8			/*
9			You may not change or alter any portion of this comment or credits
10			of supporting developers from this source code or any supporting source code
11			which is considered copyrighted (c) material of the original comment or credit authors.
12
13			This program is distributed in the hope that it will be useful,
14			but WITHOUT ANY WARRANTY; without even the implied warranty of
15			MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
16			*/
17			/**
18			* modulebuilder module.
19			*
20			* @copyright XOOPS Project (https://xoops.org)
21			* @license GNU GPL 2 (https://www.gnu.org/licenses/old-licenses/gpl-2.0.html)
22			*
23			* @since 2.5.0
24			*
25			* @author Txmod Xoops https://xoops.org
26			* Goffy https://myxoops.org
27			*
28			*/
29
30			/**
31			* Class SqlFile.
32			*/
33			class SqlFile extends Files\CreateFile
34			{
35			/**
36			* @public function constructor
37			*
38			* @param null
39			*/
40			public function __construct()
41			{
42			parent::__construct();
43			}
44
45			/**
46			* @static function getInstance
47			*
48			* @param null
49			*
50			* @return SqlFile
51			*/
52			public static function getInstance()
53			{
54			static $instance = false;
55			if (!$instance) {
56			$instance = new self();
57			}
58
59			return $instance;
60			}
61
62			/**
63			* @public function write
64			*
65			* @param $module
66			* @param $filename
67			*/
68			public function write($module, $filename)
69			{
70			$this->setModule($module);
71			$this->setFileName($filename);
72			}
73
74			/**
75			* @private function getHeaderSqlComments
76			*
77			* @param $moduleName
78			*
79			* @return string
80			*/
81			private function getHeaderSqlComments($moduleName)
82			{
83			$date = date('D M d, Y');
84			$time = date('H:i:s');
85			$serverName = \Xmf\Request::getString('SERVER_NAME', '', 'SERVER');
86			$serverVersion = $GLOBALS['xoopsDB']->getServerVersion();
87			$phpVersion = PHP_VERSION;
88			// Header Sql Comments
89			$ret = null;
90			$arrayServerInfo = [
91			"# SQL Dump for {$moduleName} module",
92			'# PhpMyAdmin Version: 4.0.4',
93			'# http://www.phpmyadmin.net',
94			'#',
95			"# Host: {$serverName}",
96			"# Generated on: {$date} to {$time}",
97			"# Server version: {$serverVersion}",
98			"# PHP Version: {$phpVersion}\n",
99			];
100			foreach ($arrayServerInfo as $serverInfo) {
101			$ret .= $this->getSimpleString($serverInfo);
102			}
103
104			return $ret;
105			}
106
107			/**
108			* @private function getHeadDatabaseTable
109			* @param $moduleDirname
110			* @param $tableName
111			* @param int $fieldsNumb
112			*
113			* Unused IF NOT EXISTS
114			*
115			* @return string
116			*/
117			private function getHeadDatabaseTable($moduleDirname, $tableName, $fieldsNumb)
118			{
119			$ret = null;
120			$arrayDbTable = [
121			'#',
122			"# Structure table for `{$moduleDirname}_{$tableName}` {$fieldsNumb}",
123			'#',
124			"\nCREATE TABLE `{$moduleDirname}_{$tableName}` (",
125			];
126			foreach ($arrayDbTable as $dbTable) {
127			$ret .= $this->getSimpleString($dbTable);
128			}
129
130			return $ret;
131			}
132
133			/**
134			* @private function getDatabaseTables
135			*
136			* @param $module
137			*
138			* @return null\|string
139			*/
140			private function getDatabaseTables($module)
141			{
142			$ret = null;
143			$moduleDirname = \mb_strtolower($module->getVar('mod_dirname'));
144			$tables = $this->getTableTables($module->getVar('mod_id'), 'table_order ASC, table_id');
145			$tableMid = 0;
			0 ignored issues – show Unused Code introduced 2020-06-09 14:03 UTC by Report Bug Copy Issue Report The assignment to `$tableMid` is dead and can be removed. Loading history...
146			$tableId = 0;
			0 ignored issues – show Unused Code introduced 2020-06-09 14:03 UTC by Report Bug Copy Issue Report The assignment to `$tableId` is dead and can be removed. Loading history...
147			$tableName = 0;
			0 ignored issues – show Unused Code introduced 2020-06-09 14:03 UTC by Report Bug Copy Issue Report The assignment to `$tableName` is dead and can be removed. Loading history...
148			$tableAutoincrement = 0;
			0 ignored issues – show Unused Code introduced 2020-06-09 14:03 UTC by Report Bug Copy Issue Report The assignment to `$tableAutoincrement` is dead and can be removed. Loading history...
149			$fieldsNumb = 0;
			0 ignored issues – show Unused Code introduced 2020-06-09 14:03 UTC by Report Bug Copy Issue Report The assignment to `$fieldsNumb` is dead and can be removed. Loading history...
150			$tableRate = 0;
151			foreach (\array_keys($tables) as $t) {
152			$tableId = $tables[$t]->getVar('table_id');
153			$tableMid = $tables[$t]->getVar('table_mid');
154			$tableName = $tables[$t]->getVar('table_name');
155			$tableAutoincrement = $tables[$t]->getVar('table_autoincrement');
156			$fieldsNumb = $tables[$t]->getVar('table_nbfields');
157			if (1 === (int)$tables[$t]->getVar('table_rate')) {
158			$tableRate = 1;
159			}
160			$ret .= $this->getDatabaseFields($moduleDirname, $tableMid, $tableId, $tableName, $tableAutoincrement, $fieldsNumb);
161			}
162
163			if (1 === $tableRate) {
164			$ret .= $this->getTableRatings($moduleDirname);
165			}
166
167			return $ret;
168			}
169
170			/**
171			* @private function getDatabaseFields
172			*
173			* @param $moduleDirname
174			* @param $tableMid
175			* @param $tableId
176			* @param $tableName
177			* @param $tableAutoincrement
178			* @param $fieldsNumb
179			* @return null\|string
180			*/
181			private function getDatabaseFields($moduleDirname, $tableMid, $tableId, $tableName, $tableAutoincrement, $fieldsNumb)
182			{
183			$helper = Modulebuilder\Helper::getInstance();
184			$ret = null;
185			$j = 0;
186			$comma = [];
187			$row = [];
188			//$type = '';
189			$fieldTypeName = '';
190			$fields = $this->getTableFields($tableMid, $tableId, 'field_order ASC, field_id');
191			foreach (\array_keys($fields) as $f) {
192			// Creation of database table
193			$ret = $this->getHeadDatabaseTable($moduleDirname, $tableName, $fieldsNumb);
194			$fieldName = $fields[$f]->getVar('field_name');
195			$fieldType = $fields[$f]->getVar('field_type');
196			$fieldValue = \str_replace(''', '', $fields[$f]->getVar('field_value')); //remove single quotes
197			$fieldAttribute = $fields[$f]->getVar('field_attribute');
198			$fieldNull = $fields[$f]->getVar('field_null');
199			$fieldDefault = \str_replace(''', '', $fields[$f]->getVar('field_default')); //remove single quotes
200			$fieldKey = $fields[$f]->getVar('field_key');
201			if ($fieldType > 1) {
202			$fType = $helper->getHandler('Fieldtype')->get($fieldType);
203			$fieldTypeName = $fType->getVar('fieldtype_name');
204			} else {
205			$fieldType = null;
206			}
207			if ($fieldAttribute > 1) {
208			$fAttribute = $helper->getHandler('Fieldattributes')->get($fieldAttribute);
209			$fieldAttribute = $fAttribute->getVar('fieldattribute_name');
210			} else {
211			$fieldAttribute = null;
212			}
213			if ($fieldNull > 1) {
214			$fNull = $helper->getHandler('Fieldnull')->get($fieldNull);
215			$fieldNull = $fNull->getVar('fieldnull_name');
216			} else {
217			$fieldNull = null;
218			}
219			if (!empty($fieldName)) {
220			switch ($fieldType) {
221			case 2:
222			case 3:
223			case 4:
224			case 5:
225			$type = $fieldTypeName . '(' . $fieldValue . ')';
226			if (empty($fieldDefault)) {
227			$default = "DEFAULT '0'";
228			} else {
229			$default = "DEFAULT '{$fieldDefault}'";
230			}
231			break;
232			case 6:
233			case 7:
234			case 8:
235			$type = $fieldTypeName . '(' . $fieldValue . ')';
236			if (empty($fieldDefault)) {
237			$default = "DEFAULT '0'"; // From MySQL 5.7 Manual
238			} else {
239			$default = "DEFAULT '{$fieldDefault}'";
240			}
241			break;
242			case 9:
243			case 10:
244			$fValues = \str_replace(',', "', '", \str_replace(' ', '', $fieldValue));
245			$type = $fieldTypeName . '(\'' . $fValues . '\')'; // Used with comma separator
246			$default = "DEFAULT '{$fieldDefault}'";
247			break;
248			case 11:
249			$type = $fieldTypeName . '(' . $fieldValue . ')';
250			if (empty($fieldDefault)) {
251			$default = "DEFAULT '[email protected]'";
252			} else {
253			$default = "DEFAULT '{$fieldDefault}'";
254			}
255			break;
256			case 12:
257			$type = $fieldTypeName . '(' . $fieldValue . ')';
258			if (empty($fieldDefault)) {
259			$default = "DEFAULT 'https:\\'";
260			} else {
261			$default = "DEFAULT '{$fieldDefault}'";
262			}
263			break;
264			case 13:
265			case 14:
266			$type = $fieldTypeName . '(' . $fieldValue . ')';
267			$default = "DEFAULT '{$fieldDefault}'";
268			break;
269			case 15:
270			case 16:
271			case 17:
272			case 18:
273			$type = $fieldTypeName;
274			$default = null;
275			break;
276			case 19:
277			case 20:
278			case 21:
279			case 22:
280			$type = $fieldTypeName . '(' . $fieldValue . ')';
281			$default = "DEFAULT '{$fieldDefault}'";
282			break;
283			case 23:
284			$type = $fieldTypeName;
285			if (empty($fieldDefault)) {
286			$default = "DEFAULT '1970'"; // From MySQL 5.7 Manual
287			} else {
288			$default = "DEFAULT '{$fieldDefault}'";
289			}
290			break;
291			default:
292			$type = $fieldTypeName . '(' . $fieldValue . ')';
293			$default = "DEFAULT '{$fieldDefault}'";
294			break;
295			}
296			if ((0 == $f) && (1 == $tableAutoincrement)) {
297			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, null, 'AUTO_INCREMENT');
298			$comma[$j] = $this->getKey(2, $fieldName);
299			++$j;
300			} elseif ((0 == $f) && (0 == $tableAutoincrement)) {
301			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
302			$comma[$j] = $this->getKey(2, $fieldName);
303			++$j;
304			} else {
305			if (3 == $fieldKey \|\| 4 == $fieldKey \|\| 5 == $fieldKey \|\| 6 == $fieldKey) {
306			switch ($fieldKey) {
307			case 3:
308			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
309			$comma[$j] = $this->getKey(3, $fieldName);
310			++$j;
311			break;
312			case 4:
313			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
314			$comma[$j] = $this->getKey(4, $fieldName);
315			++$j;
316			break;
317			case 5:
318			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
319			$comma[$j] = $this->getKey(5, $fieldName);
320			++$j;
321			break;
322			case 6:
323			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
324			$comma[$j] = $this->getKey(6, $fieldName);
325			++$j;
326			break;
327			}
328			} else {
329			$row[] = $this->getFieldRow($fieldName, $type, $fieldAttribute, $fieldNull, $default);
330			}
331			}
332			}
333			}
334			// ================= COMMA ================= //
335			for ($i = 0; $i < $j; ++$i) {
336			if ($i != $j - 1) {
337			$row[] = $comma[$i] . ',';
338			} else {
339			$row[] = $comma[$i];
340			}
341			}
342			// ================= COMMA CICLE ================= //
343			$ret .= \implode("\n", $row);
344			unset($j);
345			$ret .= $this->getFootDatabaseTable();
346
347			return $ret;
348			}
349
350			/**
351			* @private function getDatabaseFields
352			*
353			* @param $moduleDirname
354			* @return null\|string
355			*/
356			private function getTableRatings($moduleDirname)
357			{
358			$row = [];
359			$ret = $this->getHeadDatabaseTable($moduleDirname, 'ratings', 6);
360			$row[] = $this->getFieldRow('rate_id', 'INT(8)', 'UNSIGNED', 'NOT NULL', null, 'AUTO_INCREMENT');
361			$row[] = $this->getFieldRow('rate_itemid', 'INT(8)', null, 'NOT NULL', "DEFAULT '0'");
362			$row[] = $this->getFieldRow('rate_source', 'INT(8)', null, 'NOT NULL', "DEFAULT '0'");
363			$row[] = $this->getFieldRow('rate_value', 'INT(1)', null, 'NOT NULL', "DEFAULT '0'");
364			$row[] = $this->getFieldRow('rate_uid', 'INT(8)', null, 'NOT NULL', "DEFAULT '0'");
365			$row[] = $this->getFieldRow('rate_ip', 'VARCHAR(60)', null, 'NOT NULL', "DEFAULT ''");
366			$row[] = $this->getFieldRow('rate_date', 'INT(8)', null, 'NOT NULL', "DEFAULT '0'");
367			$row[] = $this->getKey(2, 'rate_id');
368
369			$ret .= \implode("\n", $row);
370			$ret .= $this->getFootDatabaseTable();
371
372			return $ret;
373			}
374
375			/**
376			* @private function getFootDatabaseTable
377			*
378			* @param null
379			*
380			* @return string
381			*/
382			private function getFootDatabaseTable()
383			{
384			return "\n) ENGINE=InnoDB;\n\n";
385			}
386
387			/**
388			* @private function getFieldRow
389			*
390			* @param $fieldName
391			* @param $fieldTypeValue
392			* @param $fieldAttribute
393			* @param $fieldNull
394			* @param $fieldDefault
395			* @param $autoincrement
396			*
397			* @return string
398			*/
399			private function getFieldRow($fieldName, $fieldTypeValue, $fieldAttribute = null, $fieldNull = null, $fieldDefault = null, $autoincrement = null)
400			{
401			$retAutoincrement = " `{$fieldName}` {$fieldTypeValue} {$fieldAttribute} {$fieldNull} {$autoincrement},";
402			$retFieldAttribute = " `{$fieldName}` {$fieldTypeValue} {$fieldAttribute} {$fieldNull} {$fieldDefault},";
403			$fieldDefault = " `{$fieldName}` {$fieldTypeValue} {$fieldNull} {$fieldDefault},";
404			$retShort = " `{$fieldName}` {$fieldTypeValue},";
405
406			$ret = $retShort;
407			if (null != $autoincrement) {
408			$ret = $retAutoincrement;
409			} elseif (null != $fieldAttribute) {
410			$ret = $retFieldAttribute;
411			} elseif (null === $fieldAttribute) {
412			$ret = $fieldDefault;
413			}
414
415			return $ret;
416			}
417
418			/**
419			* @private function getKey
420			*
421			* @param $key
422			* @param $fieldName
423			* @return string
424			*/
425			private function getKey($key, $fieldName)
426			{
427			$ret = null;
428			switch ($key) {
429			case 2: // PRIMARY KEY
430			$ret = " PRIMARY KEY (`{$fieldName}`)";
431			break;
432			case 3: // UNIQUE KEY
433			$ret = " UNIQUE KEY `{$fieldName}` (`{$fieldName}`)";
434			break;
435			case 4: // KEY
436			$ret = " KEY `{$fieldName}` (`{$fieldName}`)";
437			break;
438			case 5: // INDEX
439			$ret = " INDEX (`{$fieldName}`)";
440			break;
441			case 6: // FULLTEXT KEY
442			$ret = " FULLTEXT KEY `{$fieldName}` (`{$fieldName}`)";
443			break;
444			}
445
446			return $ret;
447			}
448
449			/**
450			* @public function render
451			*
452			* @param null
453			*
454			* @return bool\|string
455			*/
456			public function render()
457			{
458			$module = $this->getModule();
459			$filename = $this->getFileName();
460			$moduleName = \mb_strtolower($module->getVar('mod_name'));
461			$moduleDirname = \mb_strtolower($module->getVar('mod_dirname'));
462			$content = $this->getHeaderSqlComments($moduleName);
463			$content .= $this->getDatabaseTables($module);
464
465			$this->create($moduleDirname, 'sql', $filename, $content, \_AM_MODULEBUILDER_FILE_CREATED, \_AM_MODULEBUILDER_FILE_NOTCREATED);
466
467			return $this->renderFile();
468			}
469			}
470

ggoffy / modulebuilder

SqlFile::__construct() A last analyzed 2021-11-25 07:12 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

SqlFile::__construct() A
last analyzed 2021-11-25 07:12 UTC