class SystemDatabase

Class SystemDatabase

Properties

protected DatabaseInterface $dbi

Methods

__construct(DatabaseInterface $dbi)

Get instance of SystemDatabase

mysqli_result
getExistingTransformationData(string $db)

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

string
getNewTransformationDataSql(object $pma_transformation_data, array $column_map, string $view_name, string $db)

Get SQL query for store new transformation details of a VIEW

Details

at line 39
__construct(DatabaseInterface $dbi)

Get instance of SystemDatabase

Parameters

DatabaseInterface $dbi Database interface for the system database

at line 53
mysqli_result getExistingTransformationData(string $db)

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

Parameters

string $db Database name looking for

Return Value

mysqli_result Result of executed SQL query

at line 79
string getNewTransformationDataSql(object $pma_transformation_data, array $column_map, string $view_name, string $db)

Get SQL query for store new transformation details of a VIEW

Parameters

object $pma_transformation_data Result set of SQL execution
array $column_map Details of VIEW columns
string $view_name Name of the VIEW
string $db Database name of the VIEW

Return Value

string SQL query for new transformations