diff options
| author | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
|---|---|---|
| committer | Charles Cabergs <me@cacharle.xyz> | 2020-07-27 10:05:23 +0200 |
| commit | 5bf66662a9bdd62c5bccab15e607cd95cfb8fcab (patch) | |
| tree | 39a1a4629749056191c05dfd899f931701b7acf3 /srcs/phpmyadmin/normalization.php | |
| parent | 5afd237bbd22028b85532b8c0b3fcead49a00764 (diff) | |
| download | ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.gz ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.tar.bz2 ft_server-5bf66662a9bdd62c5bccab15e607cd95cfb8fcab.zip | |
Removed wordpress and phpmyadmin, my server doesn't handle it well and it brings shame on my famillyHEADmaster
Diffstat (limited to 'srcs/phpmyadmin/normalization.php')
| -rw-r--r-- | srcs/phpmyadmin/normalization.php | 149 |
1 files changed, 0 insertions, 149 deletions
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 @@ -<?php -/* vim: set expandtab sw=4 ts=4 sts=4: */ -/** - * Normalization process (temporarily specific to 1NF) - * - * @package PhpMyAdmin - */ -declare(strict_types=1); - -use PhpMyAdmin\Core; -use PhpMyAdmin\DatabaseInterface; -use PhpMyAdmin\Normalization; -use PhpMyAdmin\Response; -use PhpMyAdmin\Url; - -if (! defined('ROOT_PATH')) { - define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR); -} - -global $db, $table; - -require_once ROOT_PATH . 'libraries/common.inc.php'; - -/** @var Response $response */ -$response = $containerBuilder->get(Response::class); - -/** @var DatabaseInterface $dbi */ -$dbi = $containerBuilder->get(DatabaseInterface::class); - -/** @var Normalization $normalization */ -$normalization = $containerBuilder->get('normalization'); - -if (isset($_POST['getColumns'])) { - $html = '<option selected disabled>' . __('Select oneā¦') . '</option>' - . '<option value="no_such_col">' . __('No such column') . '</option>'; - //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()); -} |
