1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
<?php
declare(strict_types=1);
namespace PhpMyAdmin;
use PhpMyAdmin\ConfigStorage\Relation;
use PhpMyAdmin\Dbal\ResultInterface;
use function count;
use function sprintf;
class SystemDatabase
{
/** @var DatabaseInterface */
protected $dbi;
/** @var Relation */
private $relation;
/**
* Get instance of SystemDatabase
*
* @param DatabaseInterface $dbi Database interface for the system database
*/
public function __construct(DatabaseInterface $dbi)
{
$this->dbi = $dbi;
$this->relation = new Relation($this->dbi);
}
/**
* Get existing data on transformations applied for
* columns in a particular table
*
* @param string $db Database name looking for
*
* @return ResultInterface|false Result of executed SQL query
*/
public function getExistingTransformationData($db)
{
$browserTransformationFeature = $this->relation->getRelationParameters()->browserTransformationFeature;
if ($browserTransformationFeature === null) {
return false;
}
// Get the existing transformation details of the same database
// from pma__column_info table
$transformationSql = sprintf(
"SELECT * FROM %s.%s WHERE `db_name` = '%s'",
Util::backquote($browserTransformationFeature->database),
Util::backquote($browserTransformationFeature->columnInfo),
$this->dbi->escapeString($db)
);
return $this->dbi->tryQuery($transformationSql);
}
/**
* Get SQL query for store new transformation details of a VIEW
*
* @param ResultInterface $transformationData Result set of SQL execution
* @param array $columnMap Details of VIEW columns
* @param string $viewName Name of the VIEW
* @param string $db Database name of the VIEW
*
* @return string SQL query for new transformations
*/
public function getNewTransformationDataSql(
ResultInterface $transformationData,
array $columnMap,
$viewName,
$db
) {
$browserTransformationFeature = $this->relation->getRelationParameters()->browserTransformationFeature;
if ($browserTransformationFeature === null) {
return '';
}
// Need to store new transformation details for VIEW
$newTransformationsSql = sprintf(
'INSERT INTO %s.%s ('
. '`db_name`, `table_name`, `column_name`, '
. '`comment`, `mimetype`, `transformation`, '
. '`transformation_options`) VALUES',
Util::backquote($browserTransformationFeature->database),
Util::backquote($browserTransformationFeature->columnInfo)
);
$columnCount = 0;
$addComma = false;
while ($dataRow = $transformationData->fetchAssoc()) {
foreach ($columnMap as $column) {
if (
$dataRow['table_name'] != $column['table_name']
|| $dataRow['column_name'] != $column['refering_column']
) {
continue;
}
$newTransformationsSql .= sprintf(
"%s ('%s', '%s', '%s', '%s', '%s', '%s', '%s')",
$addComma ? ', ' : '',
$db,
$viewName,
$column['real_column'] ?? $column['refering_column'],
$dataRow['comment'],
$dataRow['mimetype'],
$dataRow['transformation'],
$GLOBALS['dbi']->escapeString(
$dataRow['transformation_options']
)
);
$addComma = true;
$columnCount++;
break;
}
if ($columnCount == count($columnMap)) {
break;
}
}
return $columnCount > 0 ? $newTransformationsSql : '';
}
}
|
