FKchange::setColumnDefinitionAditionalPrefix() - Code Metrics - Inspection of "column definition determination function has been..." - danielgp/fk-scale-mysql - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 4fb88c...bcded9 )

by Daniel

created 2016-01-11 13:40 UTC

FKchange::setColumnDefinitionAditionalPrefix() B

↳ Parent: FKchange

Complexity

Conditions	5
Paths	5

Size

Total Lines	18
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
c	1
b	0
f	0
dl	0
loc	18
rs	8.8571
cc	5
eloc	13
nc	5
nop	2

<?php

/**
 *
 * The MIT License (MIT)
 *
 * Copyright (c) 2015 Daniel Popiniuc
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all
 * copies or substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 *  OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
 * SOFTWARE.
 *
 */

namespace danielgp\fk_scale_mysql;

/**
 * Description of FKchange
 *
 * @author Daniel Popiniuc <[email protected]>
 */
class FKchange
{

    use ConfigurationMySQL,
        ConfigurationForAction,
        \danielgp\common_lib\CommonCode,
        \danielgp\common_lib\MySQLiAdvancedOutput;

    private $applicationSpecificArray;

    public function __construct()
    {
        $rqst = new \Symfony\Component\HttpFoundation\Request;
        echo $this->setApplicationHeader()
        . $this->buildApplicationInterface(['SuperGlobals' => $rqst->createFromGlobals()])
        . $this->setFooterCommon();
    }

    private function buildApplicationInterface($inArray)
    {
        $mysqlConfig          = $this->configuredMySqlServer();
        $elToModify           = $this->targetElementsToModify(['SuperGlobals' => $inArray['SuperGlobals']]);
        $transmitedParameters = $this->countTransmitedParameters(['db', 'tbl', 'fld', 'dt']);
        $mConnection          = $this->connectToMySql($mysqlConfig);
        $sReturn              = [];
        $sReturn[]            = '<div class="tabber" id="tabberFKscaleMySQL">'
                . '<div class="tabbertab' . ($transmitedParameters ? '' : ' tabbertabdefault')
                . '" id="FKscaleMySQLparameters" title="Parameters for scaling">'
                . $this->buildInputFormForFKscaling($mysqlConfig, ['SuperGlobals' => $inArray['SuperGlobals']])
                . '</div><!-- end of Parameters tab -->';
        $sReturn[]            = $this->buildResultsTab($mConnection, $elToModify, $transmitedParameters);
        return implode('', $sReturn);
    }

    private function buildInputFormForFKscaling($mysqlConfig, $inArray)
    {
        $sReturn   = [];
        $sGb       = $inArray['SuperGlobals'];
        $sReturn[] = $this->buildInputs(['field' => 'db', 'label' => 'Database name to analyze'], $sGb);
        $sReturn[] = $this->buildInputs(['field' => 'tbl', 'label' => 'Table name to analyze'], $sGb);
        $sReturn[] = $this->buildInputs(['field' => 'fld', 'label' => 'Field name to analyze'], $sGb);
        $sReturn[] = $this->buildInputs(['field' => 'dt', 'label' => 'Data type to change to'], $sGb);
        $sReturn[] = '<input type="submit" value="Generate SQL queries for scaling" />';
        $sReturn[] = $this->displayMySqlConfiguration($mysqlConfig);
        return '<form method="get" action="' . filter_var($sGb->server->get('PHP_SELF'), FILTER_SANITIZE_URL) . '">'
                . implode('<br/>', $sReturn)
                . '</form>';
    }

    private function buildInputs($inArray, $sGb)
    {
        return '<label for="' . $inArray['field'] . 'Name">' . $inArray['label'] . ':</label>'
                . '<input type="text" id="' . $inArray['field'] . 'Name" name="' . $inArray['field']
                . '" placeholder="' . explode(' ', $inArray['label'])[0] . ' name" '
                . $this->returnInputsCleaned($inArray['field'], $sGb)
                . 'size="30" maxlength="64" class="labell" />';
    }

    private function buildResultsTab($mConnection, $elToModify, $transmitedParameters)
    {
        $sReturn             = [];
        $targetTableTextFlds = $this->getForeignKeys($elToModify);
        $sReturn[]           = '<div class="tabbertab' . ($transmitedParameters ? ' tabbertabdefault' : '')
                . '" id="FKscaleMySQLresults" title="Results">';
        if (is_array($targetTableTextFlds)) {
            $sReturn[]    = $this->createDropForeignKeysAndGetTargetColumnDefinition($targetTableTextFlds);
            $mainColArray = $this->packParameteresForMainChangeColumn($elToModify, $targetTableTextFlds);
            $sReturn[]    = $this->createChangeColumn($mainColArray, [
                'style'                => 'color:blue;font-weight:bold;',
                'includeOldColumnType' => true,
            ]);
            $sReturn[]    = $this->recreateFKs($elToModify, $targetTableTextFlds);
        } else {
            if (strlen($mConnection) === 0) {
                $sReturn[] = '<p style="color:red;">Check if provided parameters are correct '
                        . 'as the combination of Database. Table and Column name were not found as a Foreign Key!</p>';
            } else {
                $sReturn[] = '<p style="color:red;">Check your "configurationMySQL.php" file '
                        . 'for correct MySQL connection parameters '
                        . 'as the current ones were not able to be used to establish a connection!</p>';
            }
        }
        $sReturn[] = '</div><!-- end of FKscaleMySQLresults tab -->'
                . '</div><!-- tabberFKscaleMySQL -->';
        return implode('', $sReturn);
    }

    private function createChangeColumn($parameters, $aditionalFeatures = null)
    {
        return '<div style="'
                . (isset($aditionalFeatures['style']) ? $aditionalFeatures['style'] : 'color:blue;')
                . '">'
                . 'ALTER TABLE `' . $parameters['Database'] . '`.`' . $parameters['Table']
                . '` CHANGE `' . $parameters['Column'] . '` `' . $parameters['Column'] . '` '
                . $parameters['NewDataType'] . ' '
                . $this->setColumnDefinitionAditional($parameters['IsNullable'], $parameters['Default'])
                . (strlen($parameters['Extra']) > 0 ? ' AUTO_INCREMENT' : '')
                . (strlen($parameters['Comment']) > 0 ? ' COMMENT "' . $parameters['Comment'] . '"' : '')
                . ';'
                . (isset($aditionalFeatures['includeOldColumnType']) ? ' /* from '
                        . $parameters['OldDataType'] . ' */' : '')
                . '</div>';
    }

    private function createDropForeignKey($parameters)
    {
        return '<div style="color:red;">'
                . 'ALTER TABLE `' . $parameters['Database'] . '`.`' . $parameters['Table']
                . '` DROP FOREIGN KEY `' . $parameters['ForeignKeyName']
                . '`;'
                . '</div>';
    }

    private function createDropForeignKeysAndGetTargetColumnDefinition($targetTableTextFlds)
    {
        $sReturn = [];
        foreach ($targetTableTextFlds as $key => $value) {
            $sReturn[]                                    = $this->createDropForeignKey([
                'Database'       => $value['TABLE_SCHEMA'],
                'Table'          => $value['TABLE_NAME'],
                'ForeignKeyName' => $value['CONSTRAINT_NAME'],
            ]);
            $this->applicationSpecificArray['Cols'][$key] = $this->getMySQLlistColumns([
                'TABLE_SCHEMA' => $value['TABLE_SCHEMA'],
                'TABLE_NAME'   => $value['TABLE_NAME'],
                'COLUMN_NAME'  => $value['COLUMN_NAME'],
            ]);
        }
        return implode('', $sReturn);
    }

    private function createForeignKey($parameters)
    {
        return '<div style="color:green;">'
                . 'ALTER TABLE `' . $parameters['Database'] . '`.`' . $parameters['Table']
                . '` ADD CONSTRAINT `' . $parameters['ForeignKeyName'] . '` FOREIGN KEY (`'
                . $parameters['Column'] . '`) REFERENCES `' . $parameters['ReferencedDatabase'] . '`.`'
                . $parameters['ReferencedTable'] . '` (`' . $parameters['ReferencedColumn'] . '`) '
                . 'ON DELETE '
                . ($parameters['RuleDelete'] == 'NULL' ? 'SET NULL' : $parameters['RuleDelete']) . ' '
                . 'ON UPDATE '
                . ($parameters['RuleUpdate'] == 'NULL' ? 'SET NULL' : $parameters['RuleUpdate'])
                . ';'
                . '</div>';
    }

    private function displayMySqlConfiguration($mysqlConfig)
    {
        $styleForMySQLparams = 'color:green;font-weight:bold;font-style:italic;';
        return '<p>For security reasons the MySQL connection details are not available '
                . 'to be set/modified through the interface and must be set directly '
                . 'into the "configurationMySQL.php" file. Currently these settings are:<ul>'
                . '<li>Host name where MySQL server resides: <span style="' . $styleForMySQLparams . '">'
                . $mysqlConfig['host'] . '</span></li>'
                . '<li>MySQL port used: <span style="' . $styleForMySQLparams . '">'
                . $mysqlConfig['port'] . '</span></li>'
                . '<li>MySQL database to connect to: <span style="' . $styleForMySQLparams . '">'
                . $mysqlConfig['database'] . '</span></li>'
                . '<li>MySQL username used: <span style="' . $styleForMySQLparams . '">'
                . $mysqlConfig['username'] . '</span></li>'
                . '<li>MySQL password used: <span style="' . $styleForMySQLparams . '">'
                . 'cannot be disclosed due to security reasons</span></li>'
                . '</ul></p>';
    }

    private function getForeignKeys($elToModify)
    {
        $additionalFeatures = [
            'REFERENCED_TABLE_SCHEMA' => $elToModify['Database'],
            'REFERENCED_TABLE_NAME'   => $elToModify['Table'],
            'REFERENCED_COLUMN_NAME'  => $elToModify['Column'],
            'REFERENCED_TABLE_NAME'   => 'NOT NULL',
        ];
        $query              = $this->sQueryMySqlIndexes($additionalFeatures);
        return $this->setMySQLquery2Server($query, 'full_array_key_numbered')['result'];
    }

    private function packParameteresForMainChangeColumn($elToModify, $targetTableTextFlds)
    {
        $colToIdentify = [
            'TABLE_SCHEMA' => $elToModify['Database'],
            'TABLE_NAME'   => $elToModify['Table'],
            'COLUMN_NAME'  => $elToModify['Column'],
        ];
        $col           = $this->getMySQLlistColumns($colToIdentify);
        return [
            'Database'    => $targetTableTextFlds[0]['REFERENCED_TABLE_SCHEMA'],
            'Table'       => $targetTableTextFlds[0]['REFERENCED_TABLE_NAME'],
            'Column'      => $targetTableTextFlds[0]['REFERENCED_COLUMN_NAME'],
            'OldDataType' => strtoupper($col[0]['COLUMN_TYPE']) . ' '
            . $this->setColumnDefinitionAditional($col[0]['IS_NULLABLE'], $col[0]['COLUMN_DEFAULT'], $col[0]['EXTRA']),
            'NewDataType' => $elToModify['NewDataType'],
            'IsNullable'  => $col[0]['IS_NULLABLE'],
            'Default'     => $col[0]['COLUMN_DEFAULT'],
            'Extra'       => $col[0]['EXTRA'],
            'Comment'     => $col[0]['COLUMN_COMMENT'],
        ];
    }

    private function recreateFKs($elToModify, $targetTableTextFlds)
    {
        $sReturn = [];
        foreach ($targetTableTextFlds as $key => $value) {
            $sReturn[] = $this->createChangeColumn([
                'Database'    => $value['TABLE_SCHEMA'],
                'Table'       => $value['TABLE_NAME'],
                'Column'      => $value['COLUMN_NAME'],
                'NewDataType' => $elToModify['NewDataType'],
                'IsNullable'  => $this->applicationSpecificArray['Cols'][$key][0]['IS_NULLABLE'],
                'Default'     => $this->applicationSpecificArray['Cols'][$key][0]['COLUMN_DEFAULT'],
                'Extra'       => $this->applicationSpecificArray['Cols'][$key][0]['EXTRA'],
                'Comment'     => $this->applicationSpecificArray['Cols'][$key][0]['COLUMN_COMMENT'],
            ]);
            $sReturn[] = $this->createForeignKey([
                'Database'           => $value['TABLE_SCHEMA'],
                'Table'              => $value['TABLE_NAME'],
                'Column'             => $value['COLUMN_NAME'],
                'ForeignKeyName'     => $value['CONSTRAINT_NAME'],
                'ReferencedDatabase' => $value['REFERENCED_TABLE_SCHEMA'],
                'ReferencedTable'    => $value['REFERENCED_TABLE_NAME'],
                'ReferencedColumn'   => $value['REFERENCED_COLUMN_NAME'],
                'RuleDelete'         => $value['DELETE_RULE'],
                'RuleUpdate'         => $value['UPDATE_RULE'],
            ]);
        }
        return implode('', $sReturn);
    }

    private function returnInputsCleaned($inputFieldName, $sGb)
    {
        $sReturn = '';
        if (!is_null($sGb->get($inputFieldName))) {
            $sReturn = 'value="' . filter_var($sGb->get($inputFieldName), FILTER_SANITIZE_STRING) . '" ';
        }
        return $sReturn;
    }

    private function setApplicationHeader()
    {
        $pageTitle   = 'Foreign Keys Scale in MySQL';
        $headerArray = [
            'css'        => [
                'css/fk_scale_mysql.css',
            ],
            'javascript' => [
                'vendor/danielgp/common-lib/js/tabber/tabber-management.min.js',
                'vendor/danielgp/common-lib/js/tabber/tabber.min.js',
            ],
            'lang'       => 'en-US',
            'title'      => $pageTitle,
        ];
        return $this->setHeaderCommon($headerArray)
                . '<h1>' . $pageTitle . '</h1>';
    }

    private function setColumnDefinitionAditional($nullableYesNo, $defaultValue = '', $extra = '')
    {
        $columnDefAdtnl = $this->setColumnDefinitionAditionalPrefix($nullableYesNo, $defaultValue);
        if ($extra == 'auto_increment') {
            $columnDefAdtnl .= ' AUTO_INCREMENT';
        }
        return $columnDefAdtnl;
    }

    private function setColumnDefinitionAditionalPrefix($nullableYesNo, $defaultValue)
    {
        switch ($nullableYesNo) {
            case 'NO':
                $columnDefAdtnl = 'NOT NULL DEFAULT "' . $defaultValue . '"';
                if (is_null($defaultValue)) {
                    $columnDefAdtnl = 'NOT NULL';
                }
                break;
            case 'YES':
                $columnDefAdtnl = 'DEFAULT "' . $defaultValue . '"';
                if ($defaultValue === null) {
                    $columnDefAdtnl = 'DEFAULT NULL';
                }
                break;
        }
        return $columnDefAdtnl;
function myFunction($a) {
    switch ($a) {
        case 'foo':
            $x = 1;
            break;

        case 'bar':
            $x = 2;
            break;
    }

    // $x is potentially undefined here.
    echo $x;
}
    }
}


1			<?php
2
3			/**
4			*
5			* The MIT License (MIT)
6			*
7			* Copyright (c) 2015 Daniel Popiniuc
8			*
9			* Permission is hereby granted, free of charge, to any person obtaining a copy
10			* of this software and associated documentation files (the "Software"), to deal
11			* in the Software without restriction, including without limitation the rights
12			* to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
13			* copies of the Software, and to permit persons to whom the Software is
14			* furnished to do so, subject to the following conditions:
15			*
16			* The above copyright notice and this permission notice shall be included in all
17			* copies or substantial portions of the Software.
18			*
19			* THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
20			* IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
21			* FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
22			* AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
23			* LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
24			* OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
25			* SOFTWARE.
26			*
27			*/
28
29			namespace danielgp\fk_scale_mysql;
30
31			/**
32			* Description of FKchange
33			*
34			* @author Daniel Popiniuc <[email protected]>
35			*/
36			class FKchange
37			{
38
39			use ConfigurationMySQL,
40			ConfigurationForAction,
41			\danielgp\common_lib\CommonCode,
42			\danielgp\common_lib\MySQLiAdvancedOutput;
43
44			private $applicationSpecificArray;
45
46			public function __construct()
47			{
48			$rqst = new \Symfony\Component\HttpFoundation\Request;
49			echo $this->setApplicationHeader()
50			. $this->buildApplicationInterface(['SuperGlobals' => $rqst->createFromGlobals()])
51			. $this->setFooterCommon();
52			}
53
54			private function buildApplicationInterface($inArray)
55			{
56			$mysqlConfig = $this->configuredMySqlServer();
57			$elToModify = $this->targetElementsToModify(['SuperGlobals' => $inArray['SuperGlobals']]);
58			$transmitedParameters = $this->countTransmitedParameters(['db', 'tbl', 'fld', 'dt']);
59			$mConnection = $this->connectToMySql($mysqlConfig);
60			$sReturn = [];
61			$sReturn[] = '<div class="tabber" id="tabberFKscaleMySQL">'
62			. '<div class="tabbertab' . ($transmitedParameters ? '' : ' tabbertabdefault')
63			. '" id="FKscaleMySQLparameters" title="Parameters for scaling">'
64			. $this->buildInputFormForFKscaling($mysqlConfig, ['SuperGlobals' => $inArray['SuperGlobals']])
65			. '</div><!-- end of Parameters tab -->';
66			$sReturn[] = $this->buildResultsTab($mConnection, $elToModify, $transmitedParameters);
67			return implode('', $sReturn);
68			}
69
70			private function buildInputFormForFKscaling($mysqlConfig, $inArray)
71			{
72			$sReturn = [];
73			$sGb = $inArray['SuperGlobals'];
74			$sReturn[] = $this->buildInputs(['field' => 'db', 'label' => 'Database name to analyze'], $sGb);
75			$sReturn[] = $this->buildInputs(['field' => 'tbl', 'label' => 'Table name to analyze'], $sGb);
76			$sReturn[] = $this->buildInputs(['field' => 'fld', 'label' => 'Field name to analyze'], $sGb);
77			$sReturn[] = $this->buildInputs(['field' => 'dt', 'label' => 'Data type to change to'], $sGb);
78			$sReturn[] = '<input type="submit" value="Generate SQL queries for scaling" />';
79			$sReturn[] = $this->displayMySqlConfiguration($mysqlConfig);
80			return '<form method="get" action="' . filter_var($sGb->server->get('PHP_SELF'), FILTER_SANITIZE_URL) . '">'
81			. implode('<br/>', $sReturn)
82			. '</form>';
83			}
84
85			private function buildInputs($inArray, $sGb)
86			{
87			return '<label for="' . $inArray['field'] . 'Name">' . $inArray['label'] . ':</label>'
88			. '<input type="text" id="' . $inArray['field'] . 'Name" name="' . $inArray['field']
89			. '" placeholder="' . explode(' ', $inArray['label'])[0] . ' name" '
90			. $this->returnInputsCleaned($inArray['field'], $sGb)
91			. 'size="30" maxlength="64" class="labell" />';
92			}
93
94			private function buildResultsTab($mConnection, $elToModify, $transmitedParameters)
95			{
96			$sReturn = [];
97			$targetTableTextFlds = $this->getForeignKeys($elToModify);
98			$sReturn[] = '<div class="tabbertab' . ($transmitedParameters ? ' tabbertabdefault' : '')
99			. '" id="FKscaleMySQLresults" title="Results">';
100			if (is_array($targetTableTextFlds)) {
101			$sReturn[] = $this->createDropForeignKeysAndGetTargetColumnDefinition($targetTableTextFlds);
102			$mainColArray = $this->packParameteresForMainChangeColumn($elToModify, $targetTableTextFlds);
103			$sReturn[] = $this->createChangeColumn($mainColArray, [
104			'style' => 'color:blue;font-weight:bold;',
105			'includeOldColumnType' => true,
106			]);
107			$sReturn[] = $this->recreateFKs($elToModify, $targetTableTextFlds);
108			} else {
109			if (strlen($mConnection) === 0) {
110			$sReturn[] = '<p style="color:red;">Check if provided parameters are correct '
111			. 'as the combination of Database. Table and Column name were not found as a Foreign Key!</p>';
112			} else {
113			$sReturn[] = '<p style="color:red;">Check your "configurationMySQL.php" file '
114			. 'for correct MySQL connection parameters '
115			. 'as the current ones were not able to be used to establish a connection!</p>';
116			}
117			}
118			$sReturn[] = '</div><!-- end of FKscaleMySQLresults tab -->'
119			. '</div><!-- tabberFKscaleMySQL -->';
120			return implode('', $sReturn);
121			}
122
123			private function createChangeColumn($parameters, $aditionalFeatures = null)
124			{
125			return '<div style="'
126			. (isset($aditionalFeatures['style']) ? $aditionalFeatures['style'] : 'color:blue;')
127			. '">'
128			. 'ALTER TABLE `' . $parameters['Database'] . '`.`' . $parameters['Table']
129			. '` CHANGE `' . $parameters['Column'] . '` `' . $parameters['Column'] . '` '
130			. $parameters['NewDataType'] . ' '
131			. $this->setColumnDefinitionAditional($parameters['IsNullable'], $parameters['Default'])
132			. (strlen($parameters['Extra']) > 0 ? ' AUTO_INCREMENT' : '')
133			. (strlen($parameters['Comment']) > 0 ? ' COMMENT "' . $parameters['Comment'] . '"' : '')
134			. ';'
135			. (isset($aditionalFeatures['includeOldColumnType']) ? ' /* from '
136			. $parameters['OldDataType'] . ' */' : '')
137			. '</div>';
138			}
139
140			private function createDropForeignKey($parameters)
141			{
142			return '<div style="color:red;">'
143			. 'ALTER TABLE `' . $parameters['Database'] . '`.`' . $parameters['Table']
144			. '` DROP FOREIGN KEY `' . $parameters['ForeignKeyName']
145			. '`;'
146			. '</div>';
147			}
148
149			private function createDropForeignKeysAndGetTargetColumnDefinition($targetTableTextFlds)
150			{
151			$sReturn = [];
152			foreach ($targetTableTextFlds as $key => $value) {
153			$sReturn[] = $this->createDropForeignKey([
154			'Database' => $value['TABLE_SCHEMA'],
155			'Table' => $value['TABLE_NAME'],
156			'ForeignKeyName' => $value['CONSTRAINT_NAME'],
157			]);
158			$this->applicationSpecificArray['Cols'][$key] = $this->getMySQLlistColumns([
159			'TABLE_SCHEMA' => $value['TABLE_SCHEMA'],
160			'TABLE_NAME' => $value['TABLE_NAME'],
161			'COLUMN_NAME' => $value['COLUMN_NAME'],
162			]);
163			}
164			return implode('', $sReturn);
165			}
166
167			private function createForeignKey($parameters)
168			{
169			return '<div style="color:green;">'
170			. 'ALTER TABLE `' . $parameters['Database'] . '`.`' . $parameters['Table']
171			. '` ADD CONSTRAINT `' . $parameters['ForeignKeyName'] . '` FOREIGN KEY (`'
172			. $parameters['Column'] . '`) REFERENCES `' . $parameters['ReferencedDatabase'] . '`.`'
173			. $parameters['ReferencedTable'] . '` (`' . $parameters['ReferencedColumn'] . '`) '
174			. 'ON DELETE '
175			. ($parameters['RuleDelete'] == 'NULL' ? 'SET NULL' : $parameters['RuleDelete']) . ' '
176			. 'ON UPDATE '
177			. ($parameters['RuleUpdate'] == 'NULL' ? 'SET NULL' : $parameters['RuleUpdate'])
178			. ';'
179			. '</div>';
180			}
181
182			private function displayMySqlConfiguration($mysqlConfig)
183			{
184			$styleForMySQLparams = 'color:green;font-weight:bold;font-style:italic;';
185			return '<p>For security reasons the MySQL connection details are not available '
186			. 'to be set/modified through the interface and must be set directly '
187			. 'into the "configurationMySQL.php" file. Currently these settings are:<ul>'
188			. '<li>Host name where MySQL server resides: <span style="' . $styleForMySQLparams . '">'
189			. $mysqlConfig['host'] . '</span></li>'
190			. '<li>MySQL port used: <span style="' . $styleForMySQLparams . '">'
191			. $mysqlConfig['port'] . '</span></li>'
192			. '<li>MySQL database to connect to: <span style="' . $styleForMySQLparams . '">'
193			. $mysqlConfig['database'] . '</span></li>'
194			. '<li>MySQL username used: <span style="' . $styleForMySQLparams . '">'
195			. $mysqlConfig['username'] . '</span></li>'
196			. '<li>MySQL password used: <span style="' . $styleForMySQLparams . '">'
197			. 'cannot be disclosed due to security reasons</span></li>'
198			. '</ul></p>';
199			}
200
201			private function getForeignKeys($elToModify)
202			{
203			$additionalFeatures = [
204			'REFERENCED_TABLE_SCHEMA' => $elToModify['Database'],
205			'REFERENCED_TABLE_NAME' => $elToModify['Table'],
206			'REFERENCED_COLUMN_NAME' => $elToModify['Column'],
207			'REFERENCED_TABLE_NAME' => 'NOT NULL',
208			];
209			$query = $this->sQueryMySqlIndexes($additionalFeatures);
210			return $this->setMySQLquery2Server($query, 'full_array_key_numbered')['result'];
211			}
212
213			private function packParameteresForMainChangeColumn($elToModify, $targetTableTextFlds)
214			{
215			$colToIdentify = [
216			'TABLE_SCHEMA' => $elToModify['Database'],
217			'TABLE_NAME' => $elToModify['Table'],
218			'COLUMN_NAME' => $elToModify['Column'],
219			];
220			$col = $this->getMySQLlistColumns($colToIdentify);
221			return [
222			'Database' => $targetTableTextFlds[0]['REFERENCED_TABLE_SCHEMA'],
223			'Table' => $targetTableTextFlds[0]['REFERENCED_TABLE_NAME'],
224			'Column' => $targetTableTextFlds[0]['REFERENCED_COLUMN_NAME'],
225			'OldDataType' => strtoupper($col[0]['COLUMN_TYPE']) . ' '
226			. $this->setColumnDefinitionAditional($col[0]['IS_NULLABLE'], $col[0]['COLUMN_DEFAULT'], $col[0]['EXTRA']),
227			'NewDataType' => $elToModify['NewDataType'],
228			'IsNullable' => $col[0]['IS_NULLABLE'],
229			'Default' => $col[0]['COLUMN_DEFAULT'],
230			'Extra' => $col[0]['EXTRA'],
231			'Comment' => $col[0]['COLUMN_COMMENT'],
232			];
233			}
234
235			private function recreateFKs($elToModify, $targetTableTextFlds)
236			{
237			$sReturn = [];
238			foreach ($targetTableTextFlds as $key => $value) {
239			$sReturn[] = $this->createChangeColumn([
240			'Database' => $value['TABLE_SCHEMA'],
241			'Table' => $value['TABLE_NAME'],
242			'Column' => $value['COLUMN_NAME'],
243			'NewDataType' => $elToModify['NewDataType'],
244			'IsNullable' => $this->applicationSpecificArray['Cols'][$key][0]['IS_NULLABLE'],
245			'Default' => $this->applicationSpecificArray['Cols'][$key][0]['COLUMN_DEFAULT'],
246			'Extra' => $this->applicationSpecificArray['Cols'][$key][0]['EXTRA'],
247			'Comment' => $this->applicationSpecificArray['Cols'][$key][0]['COLUMN_COMMENT'],
248			]);
249			$sReturn[] = $this->createForeignKey([
250			'Database' => $value['TABLE_SCHEMA'],
251			'Table' => $value['TABLE_NAME'],
252			'Column' => $value['COLUMN_NAME'],
253			'ForeignKeyName' => $value['CONSTRAINT_NAME'],
254			'ReferencedDatabase' => $value['REFERENCED_TABLE_SCHEMA'],
255			'ReferencedTable' => $value['REFERENCED_TABLE_NAME'],
256			'ReferencedColumn' => $value['REFERENCED_COLUMN_NAME'],
257			'RuleDelete' => $value['DELETE_RULE'],
258			'RuleUpdate' => $value['UPDATE_RULE'],
259			]);
260			}
261			return implode('', $sReturn);
262			}
263
264			private function returnInputsCleaned($inputFieldName, $sGb)
265			{
266			$sReturn = '';
267			if (!is_null($sGb->get($inputFieldName))) {
268			$sReturn = 'value="' . filter_var($sGb->get($inputFieldName), FILTER_SANITIZE_STRING) . '" ';
269			}
270			return $sReturn;
271			}
272
273			private function setApplicationHeader()
274			{
275			$pageTitle = 'Foreign Keys Scale in MySQL';
276			$headerArray = [
277			'css' => [
278			'css/fk_scale_mysql.css',
279			],
280			'javascript' => [
281			'vendor/danielgp/common-lib/js/tabber/tabber-management.min.js',
282			'vendor/danielgp/common-lib/js/tabber/tabber.min.js',
283			],
284			'lang' => 'en-US',
285			'title' => $pageTitle,
286			];
287			return $this->setHeaderCommon($headerArray)
288			. '<h1>' . $pageTitle . '</h1>';
289			}
290
291			private function setColumnDefinitionAditional($nullableYesNo, $defaultValue = '', $extra = '')
292			{
293			$columnDefAdtnl = $this->setColumnDefinitionAditionalPrefix($nullableYesNo, $defaultValue);
294			if ($extra == 'auto_increment') {
295			$columnDefAdtnl .= ' AUTO_INCREMENT';
296			}
297			return $columnDefAdtnl;
298			}
299
300			private function setColumnDefinitionAditionalPrefix($nullableYesNo, $defaultValue)
301			{
302			switch ($nullableYesNo) {
303			case 'NO':
304			$columnDefAdtnl = 'NOT NULL DEFAULT "' . $defaultValue . '"';
305			if (is_null($defaultValue)) {
306			$columnDefAdtnl = 'NOT NULL';
307			}
308			break;
309			case 'YES':
310			$columnDefAdtnl = 'DEFAULT "' . $defaultValue . '"';
311			if ($defaultValue === null) {
312			$columnDefAdtnl = 'DEFAULT NULL';
313			}
314			break;
315			}
316			return $columnDefAdtnl;
			0 ignored issues – show Bug introduced 2016-01-03 19:06 UTC by Report Bug Copy Issue Report The variable `$columnDefAdtnl` does not seem to be defined for all execution paths leading up to this point. If you define a variable conditionally, it can happen that it is not defined for all execution paths. Let’s take a look at an example: function myFunction($a) { switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; } // $x is potentially undefined here. echo $x; } In the above example, the variable `$x` is defined if you pass “foo” or “bar” as argument for `$a`. However, since the `switch` statement has no default case statement, if you pass any other value, the variable `$x` would be undefined. Available Fixes Check for existence of the variable explicitly: function myFunction($a) { switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; } if (isset($x)) { // Make sure it's always set. echo $x; } } Define a default value for the variable: function myFunction($a) { $x = ''; // Set a default which gets overridden for certain paths. switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; } echo $x; } Add a value for the missing path: function myFunction($a) { switch ($a) { case 'foo': $x = 1; break; case 'bar': $x = 2; break; // We add support for the missing case. default: $x = ''; break; } echo $x; } Loading history...
317			}
318			}
319

danielgp / fk-scale-mysql

Push — master ( 4fb88c...bcded9 )

FKchange::setColumnDefinitionAditionalPrefix() B

Complexity

Size

Duplication

Importance

Available Fixes

Duplication Side-by-Side

Filter issues like