PMA\libraries\SystemDatabase::getNewTransformationDataSql PHP Method

getNewTransformationDataSql() public method

Get SQL query for store new transformation details of a VIEW
public getNewTransformationDataSql ( object $pma_transformation_data, array $column_map, string $view_name, string $db ) : string
$pma_transformation_data object Result set of SQL execution
$column_map array Details of VIEW columns
$view_name string Name of the VIEW
$db string Database name of the VIEW
return string $new_transformations_sql SQL query for new transformations
    function getNewTransformationDataSql($pma_transformation_data, $column_map, $view_name, $db)
    {
        $cfgRelation = \PMA_getRelationsParam();
        // Need to store new transformation details for VIEW
        $new_transformations_sql = sprintf("INSERT INTO %s.%s (" . "`db_name`, `table_name`, `column_name`, " . "`comment`, `mimetype`, `transformation`, " . "`transformation_options`) VALUES", Util::backquote($cfgRelation['db']), Util::backquote($cfgRelation['column_info']));
        $column_count = 0;
        $add_comma = false;
        while ($data_row = $this->dbi->fetchAssoc($pma_transformation_data)) {
            foreach ($column_map as $column) {
                if ($data_row['table_name'] != $column['table_name'] || $data_row['column_name'] != $column['refering_column']) {
                    continue;
                }
                $new_transformations_sql .= sprintf("%s ('%s', '%s', '%s', '%s', '%s', '%s', '%s')", $add_comma ? ', ' : '', $db, $view_name, isset($column['real_column']) ? $column['real_column'] : $column['refering_column'], $data_row['comment'], $data_row['mimetype'], $data_row['transformation'], $GLOBALS['dbi']->escapeString($data_row['transformation_options']));
                $add_comma = true;
                $column_count++;
                break;
            }
            if ($column_count == count($column_map)) {
                break;
            }
        }
        return $column_count > 0 ? $new_transformations_sql : '';
    }