class Tracking (View source)

PhpMyAdmin\Tracking\Tracking class

Methods

__construct(SqlQueryForm $sqlQueryForm, Template $template, Relation $relation, DatabaseInterface $dbi, TrackingChecker $trackingChecker)

No description

bool
deleteTracking(string $dbName, string $tableName, string $version = '')

Removes all tracking data for a table or a version of a table

array
filter(array $data, array $filterUsers, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo)

Filters tracking entries

ResultInterface|false
getListOfVersionsOfTable(string $db, string $table)

Function to get the list versions of the table

string
getHtmlForMainPage(string $db, string $table, array $urlParams, string $textDir)

Function to get html for main page parts that do not use $_REQUEST

int
getTableLastVersionNumber(ResultInterface $result)

Function to get the last version number of a table

string
getHtmlForTrackingReport(TrackedData $trackedData, array $urlParams, string $logType, array $filterUsers, string $version, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo, string $users)

Function to get html for tracking report and tracking report export

array
getHtmlForElementsOfTrackingReport(string $logType, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo, string $users)

Generate HTML element for report form

string
getHtmlForTrackingReportExportForm1(TrackedData $trackedData, array $urlParams, string $logType, array $filterUsers, string $str1, string $str2, string $str3, string $str4, string $str5, string $dropImageOrText, string $version, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo)

Generate HTML for export form

string
getHtmlForTrackingReportExportForm2(array $urlParams, string $str1, string $str2, string $str3, string $str4, string $str5, string $logType, string $version, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo, string $users)

Generate HTML for export form

string
getHtmlForDataManipulationStatements(TrackedData $trackedData, array $filterUsers, array $urlParams, int $ddlogCount, string $dropImageOrText, string $version, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo)

Function to get html for data manipulation statements

array
getHtmlForDataDefinitionStatements(TrackedData $trackedData, array $filterUsers, array $urlParams, string $dropImageOrText, string $version, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo)

Function to get html for data definition statements in schema snapshot

string
getHtmlForSchemaSnapshot(string $db, string $table, string $version, array $params)

Function to get html for schema snapshot

getTrackedData(string $dbname, string $tablename, string $version)

Gets the record of a tracking job.

string
getHtmlForColumns(array $columns)

Function to get html for displaying columns in the schema snapshot

string
getHtmlForIndexes(array $indexes)

Function to get html for the indexes in schema snapshot

string
deleteFromTrackingReportLog(string $db, string $table, string $version, array $logData, LogTypeEnum $logType, int $deleteId)

Function to delete from a tracking report log

bool
changeTrackingData(string $dbName, string $tableName, string $version, LogTypeEnum $logType, array $newData)

Changes tracking data of a table.

string
exportAsSqlDump(array $entries)

Function to export as sql dump

void
exportAsSqlExecution(array $entries)

Function to export as sql execution

array
getDownloadInfoForExport(string $table, array $entries)

No description

string
changeTracking(string $db, string $table, string $version, string $action)

Function to activate or deactivate tracking

string
getTrackingSet()

Function to get tracking set

string
deleteTrackingVersion(string $db, string $table, string $version)

Deletes a tracking version

string
createTrackingVersion(string $db, string $table, string $version)

Function to create the tracking version

void
createTrackingForMultipleTables(string $db, array $selected, string $version)

Create tracking version for multiple tables

array
getEntries(TrackedData $trackedData, array $filterUsers, string $logType, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo)

Function to get the entries

string
getHtmlForDbTrackingTables(string $db, array $urlParams, string $textDir)

Get HTML for tracked and untracked tables

Details

__construct(SqlQueryForm $sqlQueryForm, Template $template, Relation $relation, DatabaseInterface $dbi, TrackingChecker $trackingChecker)

No description

Parameters

SqlQueryForm $sqlQueryForm
Template $template
Relation $relation
DatabaseInterface $dbi
TrackingChecker $trackingChecker

bool deleteTracking(string $dbName, string $tableName, string $version = '')

Removes all tracking data for a table or a version of a table

Parameters

string $dbName

name of database

string $tableName

name of table

string $version version

Return Value

bool

array filter(array $data, array $filterUsers, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo)

Filters tracking entries

Parameters

array $data
array $filterUsers users
DateTimeImmutable $dateFrom
DateTimeImmutable $dateTo

Return Value

array

filtered entries

ResultInterface|false getListOfVersionsOfTable(string $db, string $table)

Function to get the list versions of the table

Parameters

string $db
string $table

Return Value

ResultInterface|false

string getHtmlForMainPage(string $db, string $table, array $urlParams, string $textDir)

Function to get html for main page parts that do not use $_REQUEST

Parameters

string $db
string $table
array $urlParams

url parameters

string $textDir

text direction

Return Value

string

int getTableLastVersionNumber(ResultInterface $result)

Function to get the last version number of a table

Parameters

ResultInterface $result

Return Value

int

string getHtmlForTrackingReport(TrackedData $trackedData, array $urlParams, string $logType, array $filterUsers, string $version, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo, string $users)

Function to get html for tracking report and tracking report export

Parameters

TrackedData $trackedData data
array $urlParams

url params

string $logType
array $filterUsers

filter users

string $version
DateTimeImmutable $dateFrom
DateTimeImmutable $dateTo
string $users

Return Value

string

array getHtmlForElementsOfTrackingReport(string $logType, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo, string $users)

Generate HTML element for report form

Parameters

string $logType
DateTimeImmutable $dateFrom
DateTimeImmutable $dateTo
string $users

Return Value

array

string getHtmlForTrackingReportExportForm1(TrackedData $trackedData, array $urlParams, string $logType, array $filterUsers, string $str1, string $str2, string $str3, string $str4, string $str5, string $dropImageOrText, string $version, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo)

Generate HTML for export form

Parameters

TrackedData $trackedData data
array $urlParams

url params

string $logType
array $filterUsers

filter users

string $str1

HTML for log_type select

string $str2

HTML for "from date"

string $str3

HTML for "to date"

string $str4

HTML for user

string $str5

HTML for "list report"

string $dropImageOrText

HTML for image or text

string $version
DateTimeImmutable $dateFrom
DateTimeImmutable $dateTo

Return Value

string

HTML for form

string getHtmlForTrackingReportExportForm2(array $urlParams, string $str1, string $str2, string $str3, string $str4, string $str5, string $logType, string $version, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo, string $users)

Generate HTML for export form

Parameters

array $urlParams Parameters
string $str1

HTML for log_type select

string $str2

HTML for "from date"

string $str3

HTML for "to date"

string $str4

HTML for user

string $str5

HTML for "list report"

string $logType
string $version
DateTimeImmutable $dateFrom
DateTimeImmutable $dateTo
string $users

Return Value

string

HTML for form

string getHtmlForDataManipulationStatements(TrackedData $trackedData, array $filterUsers, array $urlParams, int $ddlogCount, string $dropImageOrText, string $version, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo)

Function to get html for data manipulation statements

Parameters

TrackedData $trackedData data
array $filterUsers

filter users

array $urlParams

url parameters

int $ddlogCount

data definition log count

string $dropImageOrText

drop image or text

string $version
DateTimeImmutable $dateFrom
DateTimeImmutable $dateTo

Return Value

string

array getHtmlForDataDefinitionStatements(TrackedData $trackedData, array $filterUsers, array $urlParams, string $dropImageOrText, string $version, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo)

Function to get html for data definition statements in schema snapshot

Parameters

TrackedData $trackedData data
array $filterUsers

filter users

array $urlParams

url parameters

string $dropImageOrText

drop image or text

string $version
DateTimeImmutable $dateFrom
DateTimeImmutable $dateTo

Return Value

array

string getHtmlForSchemaSnapshot(string $db, string $table, string $version, array $params)

Function to get html for schema snapshot

Parameters

string $db
string $table
string $version
array $params

url parameters

Return Value

string

TrackedData getTrackedData(string $dbname, string $tablename, string $version)

Gets the record of a tracking job.

Parameters

string $dbname

name of database

string $tablename

name of table

string $version

version number

Return Value

TrackedData

string getHtmlForColumns(array $columns)

Function to get html for displaying columns in the schema snapshot

Parameters

array $columns columns

Return Value

string

string getHtmlForIndexes(array $indexes)

Function to get html for the indexes in schema snapshot

Parameters

array $indexes indexes

Return Value

string

string deleteFromTrackingReportLog(string $db, string $table, string $version, array $logData, LogTypeEnum $logType, int $deleteId)

Function to delete from a tracking report log

Parameters

string $db
string $table
string $version
array $logData
LogTypeEnum $logType DDL|DML
int $deleteId

Return Value

string

HTML for the message

bool changeTrackingData(string $dbName, string $tableName, string $version, LogTypeEnum $logType, array $newData)

Changes tracking data of a table.

Parameters

string $dbName

name of database

string $tableName

name of table

string $version version
LogTypeEnum $logType

type of data(DDL || DML)

array $newData

Return Value

bool

string exportAsSqlDump(array $entries)

Function to export as sql dump

Parameters

array $entries entries

Return Value

string

HTML SQL query form

void exportAsSqlExecution(array $entries)

Function to export as sql execution

Parameters

array $entries entries

Return Value

void

array getDownloadInfoForExport(string $table, array $entries)

No description

Parameters

string $table
array $entries

Return Value

array

string changeTracking(string $db, string $table, string $version, string $action)

Function to activate or deactivate tracking

Parameters

string $db
string $table
string $version
string $action activate|deactivate

Return Value

string

HTML for the success message

string getTrackingSet()

Function to get tracking set

Return Value

string

string deleteTrackingVersion(string $db, string $table, string $version)

Deletes a tracking version

Parameters

string $db
string $table
string $version

tracking version

Return Value

string

HTML of the success message

string createTrackingVersion(string $db, string $table, string $version)

Function to create the tracking version

Parameters

string $db
string $table
string $version

Return Value

string

HTML of the success message

void createTrackingForMultipleTables(string $db, array $selected, string $version)

Create tracking version for multiple tables

Parameters

string $db
array $selected

list of selected tables

string $version

Return Value

void

array getEntries(TrackedData $trackedData, array $filterUsers, string $logType, DateTimeImmutable $dateFrom, DateTimeImmutable $dateTo)

Function to get the entries

Parameters

TrackedData $trackedData
array $filterUsers

filter users

string $logType
DateTimeImmutable $dateFrom
DateTimeImmutable $dateTo

Return Value

array

string getHtmlForDbTrackingTables(string $db, array $urlParams, string $textDir)

Get HTML for tracked and untracked tables

Parameters

string $db

current database

array $urlParams

url parameters

string $textDir

text direction

Return Value

string HTML