/** * Test for PMA_mergeAliases * * @return void */ public function testPMAMergeAliases() { $aliases1 = array('test_db' => array('alias' => 'aliastest', 'tables' => array('foo' => array('alias' => 'foobar', 'columns' => array('bar' => 'foo', 'baz' => 'barbaz')), 'bar' => array('alias' => 'foobaz', 'columns' => array('a' => 'a_alias', 'b' => 'b'))))); $aliases2 = array('test_db' => array('alias' => 'test', 'tables' => array('foo' => array('columns' => array('bar' => 'foobar')), 'baz' => array('columns' => array('a' => 'x'))))); $expected = array('test_db' => array('alias' => 'test', 'tables' => array('foo' => array('alias' => 'foobar', 'columns' => array('bar' => 'foobar', 'baz' => 'barbaz')), 'bar' => array('alias' => 'foobaz', 'columns' => array('a' => 'a_alias', 'b' => 'b')), 'baz' => array('columns' => array('a' => 'x'))))); $actual = PMA_mergeAliases($aliases1, $aliases2); $this->assertEquals($expected, $actual); }
} else { $tables = array(); } } elseif ($export_type == 'table' && mb_strlen($db) && mb_strlen($table)) { $err_url = 'tbl_export.php' . PMA_URL_getCommon(array('db' => $db, 'table' => $table)); } else { PMA_fatalError(__('Bad parameters!')); } // Merge SQL Query aliases with Export aliases from // export page, Export page aliases are given more // preference over SQL Query aliases. $parser = new SqlParser\Parser($sql_query); $aliases = array(); if (!empty($parser->statements[0]) && $parser->statements[0] instanceof SqlParser\Statements\SelectStatement) { if (!empty($_REQUEST['aliases'])) { $aliases = PMA_mergeAliases(SqlParser\Utils\Misc::getAliases($parser->statements[0], $db), $_REQUEST['aliases']); $_SESSION['tmpval']['aliases'] = $_REQUEST['aliases']; } else { $aliases = SqlParser\Utils\Misc::getAliases($parser->statements[0], $db); } } /** * Increase time limit for script execution and initializes some variables */ @set_time_limit($cfg['ExecTimeLimit']); if (!empty($cfg['MemoryLimit'])) { @ini_set('memory_limit', $cfg['MemoryLimit']); } register_shutdown_function('PMA_shutdownDuringExport'); // Start with empty buffer $dump_buffer = '';
// Check if we have something to export if (isset($table_select)) { $tables = $table_select; } else { $tables = array(); } } elseif ($export_type == 'table' && mb_strlen($db) && mb_strlen($table)) { $err_url = 'tbl_export.php' . PMA_URL_getCommon(array('db' => $db, 'table' => $table)); } else { PMA_fatalError(__('Bad parameters!')); } // Merge SQL Query aliases with Export aliases from // export page, Export page aliases are given more // preference over SQL Query aliases. if (!empty($_REQUEST['aliases'])) { $aliases = PMA_mergeAliases(PMA_SQP_getAliasesFromQuery($sql_query, $db), $_REQUEST['aliases']); $_SESSION['tmpval']['aliases'] = $_REQUEST['aliases']; } else { $aliases = PMA_SQP_getAliasesFromQuery($sql_query, $db); } /** * Increase time limit for script execution and initializes some variables */ @set_time_limit($cfg['ExecTimeLimit']); if (!empty($cfg['MemoryLimit'])) { @ini_set('memory_limit', $cfg['MemoryLimit']); } register_shutdown_function('PMA_shutdownDuringExport'); // Start with empty buffer $dump_buffer = ''; $dump_buffer_len = 0;
} } elseif ($export_type == 'table' && mb_strlen($db) && mb_strlen($table)) { $err_url = 'tbl_export.php' . URL::getCommon(array('db' => $db, 'table' => $table)); } else { PMA_fatalError(__('Bad parameters!')); } // Merge SQL Query aliases with Export aliases from // export page, Export page aliases are given more // preference over SQL Query aliases. $parser = new SqlParser\Parser($sql_query); $aliases = array(); if (!empty($parser->statements[0]) && $parser->statements[0] instanceof SqlParser\Statements\SelectStatement) { $aliases = SqlParser\Utils\Misc::getAliases($parser->statements[0], $db); } if (!empty($_REQUEST['aliases'])) { $aliases = PMA_mergeAliases($aliases, $_REQUEST['aliases']); $_SESSION['tmpval']['aliases'] = $_REQUEST['aliases']; } /** * Increase time limit for script execution and initializes some variables */ @set_time_limit($cfg['ExecTimeLimit']); if (!empty($cfg['MemoryLimit'])) { @ini_set('memory_limit', $cfg['MemoryLimit']); } register_shutdown_function('PMA_shutdownDuringExport'); // Start with empty buffer $dump_buffer = ''; $dump_buffer_len = 0; // Array of dump_buffers - used in separate file exports $dump_buffer_objects = array();