class SystemDatabase (View source)

Properties

protected DatabaseInterface $dbi

Methods

__construct(DatabaseInterface $dbi)

Get instance of SystemDatabase

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

Details

__construct(DatabaseInterface $dbi)

Get instance of SystemDatabase

Parameters

DatabaseInterface $dbi

Database interface for the system database

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

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