1. class
  2. PhpMyAdmin
  3. \
  4. SystemDatabase

SystemDatabase

class SystemDatabase (View source)

Methods

__construct(DatabaseInterface $dbi)

Get instance of SystemDatabase

ResultInterface|false
getExistingTransformationData(string $db)

Get existing data on transformations applied for columns in a particular table

string
getNewTransformationDataSql(ResultInterface $transformationData, array $columnMap, string $viewName, string $db)

Get SQL query for store new transformation details of a VIEW

array
getColumnMapFromSql(string $sqlQuery, array $viewColumns)

No description

Details

at line 22
__construct(DatabaseInterface $dbi)

Get instance of SystemDatabase

Parameters

DatabaseInterface $dbi

Database interface for the system database

at line 35
ResultInterface|false getExistingTransformationData(string $db)

Get existing data on transformations applied for columns in a particular table

Parameters

string $db

Database name looking for

Return Value

ResultInterface|false

Result of executed SQL query

at line 64
string getNewTransformationDataSql(ResultInterface $transformationData, array $columnMap, string $viewName, string $db)

Get SQL query for store new transformation details of a VIEW

Parameters

ResultInterface $transformationData

Result set of SQL execution
array $columnMap

Details of VIEW columns
string $viewName

Name of the VIEW
string $db

Database name of the VIEW

Return Value

string

SQL query for new transformations

at line 129
array getColumnMapFromSql(string $sqlQuery, array $viewColumns)

No description

Parameters

string $sqlQuery
array $viewColumns

Return Value

array