@@ -110,14 +110,14 @@ discard block |
||
| 110 | 110 | $additionSql) |
| 111 | 111 | { |
| 112 | 112 | $helper = new CreateAuditTrigger($dataSchemaName, |
| 113 | - $auditSchemaName, |
|
| 114 | - $tableName, |
|
| 115 | - $triggerName, |
|
| 116 | - $triggerAction, |
|
| 117 | - $auditColumns, |
|
| 118 | - $tableColumns, |
|
| 119 | - $skipVariable, |
|
| 120 | - $additionSql); |
|
| 113 | + $auditSchemaName, |
|
| 114 | + $tableName, |
|
| 115 | + $triggerName, |
|
| 116 | + $triggerAction, |
|
| 117 | + $auditColumns, |
|
| 118 | + $tableColumns, |
|
| 119 | + $skipVariable, |
|
| 120 | + $additionSql); |
|
| 121 | 121 | $sql = $helper->buildStatement(); |
| 122 | 122 | |
| 123 | 123 | self::executeNone($sql); |
@@ -302,8 +302,8 @@ discard block |
||
| 302 | 302 | where TABLE_SCHEMA = %s |
| 303 | 303 | and TABLE_NAME = %s |
| 304 | 304 | order by ORDINAL_POSITION', |
| 305 | - self::$dl->quoteString($schemaName), |
|
| 306 | - self::$dl->quoteString($tableName)); |
|
| 305 | + self::$dl->quoteString($schemaName), |
|
| 306 | + self::$dl->quoteString($tableName)); |
|
| 307 | 307 | |
| 308 | 308 | return self::executeRows($sql); |
| 309 | 309 | } |
@@ -327,8 +327,8 @@ discard block |
||
| 327 | 327 | inner join information_schema.COLLATION_CHARACTER_SET_APPLICABILITY t2 on t2.COLLATION_NAME = t1.TABLE_COLLATION |
| 328 | 328 | WHERE t1.TABLE_SCHEMA = %s |
| 329 | 329 | AND t1.TABLE_NAME = %s', |
| 330 | - self::$dl->quoteString($schemaName), |
|
| 331 | - self::$dl->quoteString($tableName)); |
|
| 330 | + self::$dl->quoteString($schemaName), |
|
| 331 | + self::$dl->quoteString($tableName)); |
|
| 332 | 332 | |
| 333 | 333 | return self::executeRow1($sql); |
| 334 | 334 | } |
@@ -350,8 +350,8 @@ discard block |
||
| 350 | 350 | where TRIGGER_SCHEMA = %s |
| 351 | 351 | and EVENT_OBJECT_TABLE = %s |
| 352 | 352 | order by Trigger_Name', |
| 353 | - self::$dl->quoteString($schemaName), |
|
| 354 | - self::$dl->quoteString($tableName)); |
|
| 353 | + self::$dl->quoteString($schemaName), |
|
| 354 | + self::$dl->quoteString($tableName)); |
|
| 355 | 355 | |
| 356 | 356 | return self::executeRows($sql); |
| 357 | 357 | } |
@@ -393,7 +393,7 @@ discard block |
||
| 393 | 393 | where TRIGGER_SCHEMA = %s |
| 394 | 394 | order by EVENT_OBJECT_TABLE |
| 395 | 395 | , TRIGGER_NAME', |
| 396 | - self::$dl->quoteString($schemaName)); |
|
| 396 | + self::$dl->quoteString($schemaName)); |
|
| 397 | 397 | |
| 398 | 398 | return self::executeRows($sql); |
| 399 | 399 | } |
@@ -159,8 +159,8 @@ discard block |
||
| 159 | 159 | { |
| 160 | 160 | $this->io->writeln(sprintf('<info>Found new table %s</info>', $table['table_name'])); |
| 161 | 161 | $this->config['tables'][$table['table_name']] = ['audit' => false, |
| 162 | - 'alias' => null, |
|
| 163 | - 'skip' => null]; |
|
| 162 | + 'alias' => null, |
|
| 163 | + 'skip' => null]; |
|
| 164 | 164 | } |
| 165 | 165 | } |
| 166 | 166 | } |
@@ -180,8 +180,8 @@ discard block |
||
| 180 | 180 | if (preg_match('/trg_audit_.*_(insert|update|delete)/', $trigger['trigger_name'])) |
| 181 | 181 | { |
| 182 | 182 | $this->io->logInfo('Dropping trigger <dbo>%s</dbo> from obsolete table <dbo>%s</dbo>', |
| 183 | - $trigger['trigger_name'], |
|
| 184 | - $tableName); |
|
| 183 | + $trigger['trigger_name'], |
|
| 184 | + $tableName); |
|
| 185 | 185 | |
| 186 | 186 | AuditDataLayer::dropTrigger($schemaName, $trigger['trigger_name']); |
| 187 | 187 | } |
@@ -246,15 +246,15 @@ discard block |
||
| 246 | 246 | $tableColumns = []; |
| 247 | 247 | } |
| 248 | 248 | $configTable = new TableMetadata($table['table_name'], |
| 249 | - $this->config['database']['data_schema'], |
|
| 250 | - $tableColumns); |
|
| 249 | + $this->config['database']['data_schema'], |
|
| 250 | + $tableColumns); |
|
| 251 | 251 | |
| 252 | 252 | $currentTable = new AuditTable($this->io, |
| 253 | - $configTable, |
|
| 254 | - $this->config['database']['audit_schema'], |
|
| 255 | - $this->auditColumnsMetadata, |
|
| 256 | - $this->config['tables'][$table['table_name']]['alias'], |
|
| 257 | - $this->config['tables'][$table['table_name']]['skip']); |
|
| 253 | + $configTable, |
|
| 254 | + $this->config['database']['audit_schema'], |
|
| 255 | + $this->auditColumnsMetadata, |
|
| 256 | + $this->config['tables'][$table['table_name']]['alias'], |
|
| 257 | + $this->config['tables'][$table['table_name']]['skip']); |
|
| 258 | 258 | |
| 259 | 259 | // Ensure an audit table exists. |
| 260 | 260 | if (StaticDataLayer::searchInRowSet('table_name', $table['table_name'], $this->auditSchemaTables)===null) |