/**
* Tests for PMA_getExistingTransformationData() method.
*
* @return void
* @test
*/
public function testPMAGetExistingTransformationData()
{
$db = "PMA_db";
$ret = PMA_getExistingTransformationData($db);
//validate that is the same as $GLOBALS['dbi']->tryQuery
$this->assertEquals('executeResult2', $ret);
}
}
$sql_query .= $sep . ' AS ' . $_REQUEST['view']['as'];
if (isset($_REQUEST['view']['with'])) {
if (in_array($_REQUEST['view']['with'], $view_with_options)) {
$sql_query .= $sep . ' WITH ' . $_REQUEST['view']['with'] . ' CHECK OPTION';
}
}
if ($GLOBALS['dbi']->tryQuery($sql_query)) {
include_once './libraries/tbl_views.lib.php';
// If different column names defined for VIEW
$view_columns = array();
if (isset($_REQUEST['view']['column_names'])) {
$view_columns = explode(',', $_REQUEST['view']['column_names']);
}
$column_map = PMA_getColumnMap($_REQUEST['view']['as'], $view_columns);
$pma_tranformation_data = PMA_getExistingTransformationData($GLOBALS['db']);
if ($pma_tranformation_data !== false) {
// SQL for store new transformation details of VIEW
$new_transformations_sql = PMA_getNewTransformationDataSql($pma_tranformation_data, $column_map, $_REQUEST['view']['name'], $GLOBALS['db']);
// Store new transformations
if ($new_transformations_sql != '') {
$GLOBALS['dbi']->tryQuery($new_transformations_sql);
}
}
unset($pma_tranformation_data);
if (!isset($_REQUEST['ajax_dialog'])) {
$message = PMA_Message::success();
include 'tbl_structure.php';
} else {
$response = PMA_Response::getInstance();
$response->addJSON('message', PMA_Util::getMessage(PMA_Message::success(), $sql_query));
