}
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']);
}
