/**
* 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();
