From 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab Mon Sep 17 00:00:00 2001 From: Charles Cabergs Date: Mon, 27 Jul 2020 10:05:23 +0200 Subject: Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my familly --- srcs/phpmyadmin/normalization.php | 149 -------------------------------------- 1 file changed, 149 deletions(-) delete mode 100644 srcs/phpmyadmin/normalization.php (limited to 'srcs/phpmyadmin/normalization.php') diff --git a/srcs/phpmyadmin/normalization.php b/srcs/phpmyadmin/normalization.php deleted file mode 100644 index a93c117..0000000 --- a/srcs/phpmyadmin/normalization.php +++ /dev/null @@ -1,149 +0,0 @@ -get(Response::class); - -/** @var DatabaseInterface $dbi */ -$dbi = $containerBuilder->get(DatabaseInterface::class); - -/** @var Normalization $normalization */ -$normalization = $containerBuilder->get('normalization'); - -if (isset($_POST['getColumns'])) { - $html = '' - . ''; - //get column whose datatype falls under string category - $html .= $normalization->getHtmlForColumnsList( - $db, - $table, - _pgettext('string types', 'String') - ); - echo $html; - exit; -} -if (isset($_POST['splitColumn'])) { - $num_fields = min(4096, intval($_POST['numFields'])); - $html = $normalization->getHtmlForCreateNewColumn($num_fields, $db, $table); - $html .= Url::getHiddenInputs($db, $table); - echo $html; - exit; -} -if (isset($_POST['addNewPrimary'])) { - $num_fields = 1; - $columnMeta = [ - 'Field' => $table . "_id", - 'Extra' => 'auto_increment', - ]; - $html = $normalization->getHtmlForCreateNewColumn( - $num_fields, - $db, - $table, - $columnMeta - ); - $html .= Url::getHiddenInputs($db, $table); - echo $html; - exit; -} -if (isset($_POST['findPdl'])) { - $html = $normalization->findPartialDependencies($table, $db); - echo $html; - exit; -} - -if (isset($_POST['getNewTables2NF'])) { - $partialDependencies = json_decode($_POST['pd']); - $html = $normalization->getHtmlForNewTables2NF($partialDependencies, $table); - echo $html; - exit; -} - -if (isset($_POST['getNewTables3NF'])) { - $dependencies = json_decode($_POST['pd']); - $tables = json_decode($_POST['tables']); - $newTables = $normalization->getHtmlForNewTables3NF($dependencies, $tables, $db); - $response->disable(); - Core::headerJSON(); - echo json_encode($newTables); - exit; -} - -$header = $response->getHeader(); -$scripts = $header->getScripts(); -$scripts->addFile('normalization.js'); -$scripts->addFile('vendor/jquery/jquery.uitablefilter.js'); -$normalForm = '1nf'; -if (Core::isValid($_POST['normalizeTo'], ['1nf', '2nf', '3nf'])) { - $normalForm = $_POST['normalizeTo']; -} -if (isset($_POST['createNewTables2NF'])) { - $partialDependencies = json_decode($_POST['pd']); - $tablesName = json_decode($_POST['newTablesName']); - $res = $normalization->createNewTablesFor2NF($partialDependencies, $tablesName, $table, $db); - $response->addJSON($res); - exit; -} -if (isset($_POST['createNewTables3NF'])) { - $newtables = json_decode($_POST['newTables']); - $res = $normalization->createNewTablesFor3NF($newtables, $db); - $response->addJSON($res); - exit; -} -if (isset($_POST['repeatingColumns'])) { - $repeatingColumns = $_POST['repeatingColumns']; - $newTable = $_POST['newTable']; - $newColumn = $_POST['newColumn']; - $primary_columns = $_POST['primary_columns']; - $res = $normalization->moveRepeatingGroup( - $repeatingColumns, - $primary_columns, - $newTable, - $newColumn, - $table, - $db - ); - $response->addJSON($res); - exit; -} -if (isset($_POST['step1'])) { - $html = $normalization->getHtmlFor1NFStep1($db, $table, $normalForm); - $response->addHTML($html); -} elseif (isset($_POST['step2'])) { - $res = $normalization->getHtmlContentsFor1NFStep2($db, $table); - $response->addJSON($res); -} elseif (isset($_POST['step3'])) { - $res = $normalization->getHtmlContentsFor1NFStep3($db, $table); - $response->addJSON($res); -} elseif (isset($_POST['step4'])) { - $res = $normalization->getHtmlContentsFor1NFStep4($db, $table); - $response->addJSON($res); -} elseif (isset($_POST['step']) && $_POST['step'] == '2.1') { - $res = $normalization->getHtmlFor2NFstep1($db, $table); - $response->addJSON($res); -} elseif (isset($_POST['step']) && $_POST['step'] == '3.1') { - $tables = $_POST['tables']; - $res = $normalization->getHtmlFor3NFstep1($db, $tables); - $response->addJSON($res); -} else { - $response->addHTML($normalization->getHtmlForNormalizeTable()); -} -- cgit