normalization.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Normalization process (temporarily specific to 1NF)
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 /**
  10  *
  11  */
  12 require_once 'libraries/common.inc.php';
  13 require_once 'libraries/transformations.lib.php';
  14 require_once 'libraries/normalization.lib.php';
  15
  16 if (isset($_REQUEST['getColumns'])) {
  17     $html = '<option selected disabled>' . __('Select one…') . '</option>'
  18         . '<option value="no_such_col">' . __('No such column') . '</option>';
  19     //get column whose datatype falls under string category
  20     $html .= PMA_getHtmlForColumnsList(
  21         $db,
  22         $table,
  23         _pgettext('string types', 'String')
  24     );
  25     echo $html;
  26     exit;
  27 }
  28 if (isset($_REQUEST['splitColumn'])) {
  29     $num_fields = $_REQUEST['numFields'];
  30     $html = PMA_getHtmlForCreateNewColumn($num_fields, $db, $table);
  31     $html .= PMA_URL_getHiddenInputs($db, $table);
  32     echo $html;
  33     exit;
  34 }
  35 if (isset($_REQUEST['addNewPrimary'])) {
  36     $num_fields = 1;
  37     $columnMeta = array('Field'=>$table . "_id", 'Extra'=>'auto_increment');
  38     $html = PMA_getHtmlForCreateNewColumn(
  39         $num_fields, $db, $table, $columnMeta
  40     );
  41     $html .= PMA_URL_getHiddenInputs($db, $table);
  42     echo $html;
  43     exit;
  44 }
  45 if (isset($_REQUEST['findPdl'])) {
  46     $html = PMA_findPartialDependencies($table, $db);
  47     echo $html;
  48     exit;
  49 }
  50
  51 if (isset($_REQUEST['getNewTables2NF'])) {
  52     $partialDependencies = json_decode($_REQUEST['pd']);
  53     $html = PMA_getHtmlForNewTables2NF($partialDependencies, $table);
  54     echo $html;
  55     exit;
  56 }
  57
  58 if (isset($_REQUEST['getNewTables3NF'])) {
  59     $dependencies = json_decode($_REQUEST['pd']);
  60     $tables = json_decode($_REQUEST['tables']);
  61     $newTables = PMA_getHtmlForNewTables3NF($dependencies, $tables, $db);
  62     echo json_encode($newTables);
  63     exit;
  64 }
  65
  66 $response = PMA\libraries\Response::getInstance();
  67 $header = $response->getHeader();
  68 $scripts = $header->getScripts();
  69 $scripts->addFile('normalization.js');
  70 $scripts->addFile('jquery/jquery.uitablefilter.js');
  71 $normalForm = '1nf';
  72 if (isset($_REQUEST['normalizeTo'])) {
  73     $normalForm = $_REQUEST['normalizeTo'];
  74 }
  75 if (isset($_REQUEST['createNewTables2NF'])) {
  76     $partialDependencies = json_decode($_REQUEST['pd']);
  77     $tablesName = json_decode($_REQUEST['newTablesName']);
  78     $res = PMA_createNewTablesFor2NF($partialDependencies, $tablesName, $table, $db);
  79     $response->addJSON($res);
  80     exit;
  81 }
  82 if (isset($_REQUEST['createNewTables3NF'])) {
  83     $newtables = json_decode($_REQUEST['newTables']);
  84     $res = PMA_createNewTablesFor3NF($newtables, $db);
  85     $response->addJSON($res);
  86     exit;
  87 }
  88 if (isset($_POST['repeatingColumns'])) {
  89     $repeatingColumns = $_POST['repeatingColumns'];
  90     $newTable = $_POST['newTable'];
  91     $newColumn = $_POST['newColumn'];
  92     $primary_columns = $_POST['primary_columns'];
  93     $res = PMA_moveRepeatingGroup(
  94         $repeatingColumns, $primary_columns, $newTable, $newColumn, $table, $db
  95     );
  96     $response->addJSON($res);
  97     exit;
  98 }
  99 if (isset($_REQUEST['step1'])) {
 100     $html = PMA_getHtmlFor1NFStep1($db, $table, $normalForm);
 101     $response->addHTML($html);
 102 } else if (isset($_REQUEST['step2'])) {
 103     $res = PMA_getHtmlContentsFor1NFStep2($db, $table);
 104     $response->addJSON($res);
 105 } else if (isset($_REQUEST['step3'])) {
 106     $res = PMA_getHtmlContentsFor1NFStep3($db, $table);
 107     $response->addJSON($res);
 108 } else if (isset($_REQUEST['step4'])) {
 109     $res = PMA_getHtmlContentsFor1NFStep4($db, $table);
 110     $response->addJSON($res);
 111 } else if (isset($_REQUEST['step']) && $_REQUEST['step'] == '2.1') {
 112     $res = PMA_getHtmlFor2NFstep1($db, $table);
 113     $response->addJSON($res);
 114 } else if (isset($_REQUEST['step']) && $_REQUEST['step'] == '3.1') {
 115     $tables = $_REQUEST['tables'];
 116     $res = PMA_getHtmlFor3NFstep1($db, $tables);
 117     $response->addJSON($res);
 118 } else {
 119     $response->addHTML(PMA_getHtmlForNormalizetable());
 120 }