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