diff options
Diffstat (limited to 'hugo/libraries/tbl_views.lib.php')
| -rw-r--r-- | hugo/libraries/tbl_views.lib.php | 157 |
1 files changed, 157 insertions, 0 deletions
diff --git a/hugo/libraries/tbl_views.lib.php b/hugo/libraries/tbl_views.lib.php new file mode 100644 index 0000000..224f41a --- /dev/null +++ b/hugo/libraries/tbl_views.lib.php @@ -0,0 +1,157 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * Set of functions related to applying transformations for VIEWs + * + * @package PhpMyAdmin + */ +if (! defined('PHPMYADMIN')) { + exit; +} + + +/** + * Get the column details of VIEW with its original references + * + * @param string $sql_query SQL for original resource + * @param array $view_columns Columns of VIEW if defined new column names + * + * @return array $column_map Details of VIEW columns + */ +function PMA_getColumnMap($sql_query, $view_columns) +{ + + $column_map = array(); + // Select query which give results for VIEW + $real_source_result = PMA_DBI_try_query($sql_query); + + if ($real_source_result !== false) { + + $real_source_fields_meta = PMA_DBI_get_fields_meta($real_source_result); + + if (count($real_source_fields_meta) > 0) { + + for ($i=0; $i<count($real_source_fields_meta); $i++) { + + $map = array(); + $map['table_name'] = $real_source_fields_meta[$i]->table; + $map['refering_column'] = $real_source_fields_meta[$i]->name; + + if (count($view_columns) > 1) { + $map['real_column'] = $view_columns[$i]; + } + + $column_map[] = $map; + + } + + } + + } + unset($real_source_result); + + return $column_map; + +} + + +/** + * Get existing data on tranformations applyed for + * columns in a particular table + * + * @param string $db Database name looking for + * + * @return mysqli_result Result of executed SQL query + */ +function PMA_getExistingTranformationData($db) +{ + $cfgRelation = PMA_getRelationsParam(); + + // Get the existing transformation details of the same database + // from pma__column_info table + $pma_transformation_sql = 'SELECT * FROM ' + . PMA_Util::backquote($cfgRelation['db']) . '.' + . PMA_Util::backquote($cfgRelation['column_info']) + . ' WHERE `db_name` = \'' + . PMA_Util::sqlAddSlashes($db) . '\''; + + return PMA_DBI_try_query($pma_transformation_sql); + +} + + +/** + * Get SQL query for store new transformation details of a VIEW + * + * @param mysqli_result $pma_tranformation_data Result set of SQL execution + * @param array $column_map Details of VIEW columns + * @param string $view_name Name of the VIEW + * @param string $db Database name of the VIEW + * + * @return string $new_transformations_sql SQL query for new tranformations + */ +function PMA_getNewTransformationDataSql( + $pma_tranformation_data, $column_map, $view_name, $db +) { + $cfgRelation = PMA_getRelationsParam(); + + // Need to store new transformation details for VIEW + $new_transformations_sql = 'INSERT INTO ' + . PMA_Util::backquote($cfgRelation['db']) . '.' + . PMA_Util::backquote($cfgRelation['column_info']) + . ' (`db_name`, `table_name`, `column_name`, `comment`, ' + . '`mimetype`, `transformation`, `transformation_options`)' + . ' VALUES '; + + $column_count = 0; + $add_comma = false; + + while ($data_row = PMA_DBI_fetch_assoc($pma_tranformation_data)) { + + foreach ($column_map as $column) { + + if ($data_row['table_name'] == $column['table_name'] + && $data_row['column_name'] == $column['refering_column'] + ) { + + $new_transformations_sql .= $add_comma ? ', ' : ''; + + $new_transformations_sql .= '(' + . '\'' . $db . '\', ' + . '\'' . $view_name . '\', ' + . '\''; + + $new_transformations_sql .= (isset($column['real_column'])) + ? $column['real_column'] + : $column['refering_column']; + + $new_transformations_sql .= '\', ' + . '\'' . $data_row['comment'] . '\', ' + . '\'' . $data_row['mimetype'] . '\', ' + . '\'' . $data_row['transformation'] . '\', ' + . '\'' + . PMA_Util::sqlAddSlashes( + $data_row['transformation_options'] + ) + . '\')'; + + $add_comma = true; + $column_count++; + break; + + } + + } + + if ($column_count == count($column_map)) { + break; + } + + } + + return ($column_count > 0) ? $new_transformations_sql : ''; + +} + + +?> |