libraries/SystemDatabase.class.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * hold PMA\SystemDatabase class
   5  *
   6  * @package PMA
   7  */
   8
   9 namespace PMA;
  10
  11 if (! defined('PHPMYADMIN')) {
  12     exit;
  13 }
  14
  15 require_once 'libraries/database_interface.inc.php';
  16
  17 /**
  18  * Class SystemDatabase
  19  *
  20  * @package PMA
  21  */
  22 class SystemDatabase
  23 {
  24     /**
  25      * @var \PMA_DatabaseInterface
  26      */
  27     protected $dbi;
  28
  29     /**
  30      * Get instance of SystemDatabase
  31      *
  32      * @param \PMA_DatabaseInterface $dbi Database interface for the system database
  33      *
  34      */
  35     function __construct(\PMA_DatabaseInterface $dbi)
  36     {
  37         $this->dbi = $dbi;
  38     }
  39
  40     /**
  41      * Get existing data on transformations applied for
  42      * columns in a particular table
  43      *
  44      * @param string $db Database name looking for
  45      *
  46      * @return \mysqli_result Result of executed SQL query
  47      */
  48     public function getExistingTransformationData($db)
  49     {
  50         $cfgRelation = \PMA_getRelationsParam();
  51
  52         // Get the existing transformation details of the same database
  53         // from pma__column_info table
  54         $pma_transformation_sql = sprintf(
  55             "SELECT * FROM %s.%s WHERE `db_name` = '%s'",
  56             \PMA_Util::backquote($cfgRelation['db']),
  57             \PMA_Util::backquote($cfgRelation['column_info']),
  58             \PMA_Util::sqlAddSlashes($db)
  59         );
  60
  61         return $this->dbi->tryQuery($pma_transformation_sql);
  62     }
  63
  64     /**
  65      * Get SQL query for store new transformation details of a VIEW
  66      *
  67      * @param object $pma_transformation_data Result set of SQL execution
  68      * @param array  $column_map              Details of VIEW columns
  69      * @param string $view_name               Name of the VIEW
  70      * @param string $db                      Database name of the VIEW
  71      *
  72      * @return string $new_transformations_sql SQL query for new transformations
  73      */
  74     function getNewTransformationDataSql(
  75         $pma_transformation_data, $column_map, $view_name, $db
  76     ) {
  77         $cfgRelation = \PMA_getRelationsParam();
  78
  79         // Need to store new transformation details for VIEW
  80         $new_transformations_sql = sprintf(
  81             "INSERT INTO %s.%s ("
  82             . "`db_name`, `table_name`, `column_name`, "
  83             . "`comment`, `mimetype`, `transformation`, "
  84             . "`transformation_options`) VALUES",
  85             \PMA_Util::backquote($cfgRelation['db']),
  86             \PMA_Util::backquote($cfgRelation['column_info'])
  87         );
  88
  89         $column_count = 0;
  90         $add_comma = false;
  91
  92         while ($data_row = $this->dbi->fetchAssoc($pma_transformation_data)) {
  93
  94             foreach ($column_map as $column) {
  95
  96                 if ($data_row['table_name'] != $column['table_name']
  97                     || $data_row['column_name'] != $column['refering_column']
  98                 ) {
  99                     continue;
 100                 }
 101
 102                 $new_transformations_sql .= sprintf(
 103                     "%s ('%s', '%s', '%s', '%s', '%s', '%s', '%s')",
 104                     $add_comma ? ', ' : '',
 105                     $db,
 106                     $view_name,
 107                     isset($column['real_column'])
 108                     ? $column['real_column']
 109                     : $column['refering_column'],
 110                     $data_row['comment'],
 111                     $data_row['mimetype'],
 112                     $data_row['transformation'],
 113                     \PMA_Util::sqlAddSlashes(
 114                         $data_row['transformation_options']
 115                     )
 116                 );
 117
 118                 $add_comma = true;
 119                 $column_count++;
 120                 break;
 121             }
 122
 123             if ($column_count == count($column_map)) {
 124                 break;
 125             }
 126         }
 127
 128         return ($column_count > 0) ? $new_transformations_sql : '';
 129     }
 130 }