} if (isset($_REQUEST['findPdl'])) { $html = PMA_findPartialDependencies($table, $db); echo $html; exit; } if (isset($_REQUEST['getNewTables2NF'])) { $partialDependencies = json_decode($_REQUEST['pd']); $html = PMA_getHtmlForNewTables2NF($partialDependencies, $table); echo $html; exit; } if (isset($_REQUEST['getNewTables3NF'])) { $dependencies = json_decode($_REQUEST['pd']); $tables = json_decode($_REQUEST['tables']); $newTables = PMA_getHtmlForNewTables3NF($dependencies, $tables, $db); PMA_Response::getInstance()->disable(); PMA_headerJSON(); echo json_encode($newTables); exit; } $response = PMA_Response::getInstance(); $header = $response->getHeader(); $scripts = $header->getScripts(); $scripts->addFile('normalization.js'); $scripts->addFile('jquery/jquery.uitablefilter.js'); $normalForm = '1nf'; if (isset($_REQUEST['normalizeTo'])) { $normalForm = $_REQUEST['normalizeTo']; } if (isset($_REQUEST['createNewTables2NF'])) {
/** * Test for PMA_getHtmlForNewTables3NF * * @return void */ public function testPMAGetHtmlForNewTables3NF() { $tables = array("PMA_table" => array('col1')); $db = 'PMA_db'; $dependencies = new stdClass(); $dependencies->col1 = array('col2'); $result = PMA_getHtmlForNewTables3NF($dependencies, $tables, $db); $this->assertEquals(array('html' => '', 'newTables' => array()), $result); $tables = array("PMA_table" => array('col1', 'PMA_table')); $dependencies->PMA_table = array('col4', 'col5'); $result1 = PMA_getHtmlForNewTables3NF($dependencies, $tables, $db); $this->assertInternalType('array', $result1); $this->assertContains('<input type="text" name="PMA_table"', $result1['html']); $this->assertEquals(array('PMA_table' => array('PMA_table' => array('pk' => 'col1', 'nonpk' => 'col2'), 'table2' => array('pk' => 'id', 'nonpk' => 'col4, col5'))), $result1['newTables']); }