@@ -19,8 +19,8 @@ |
||
| 19 | 19 | protected function configure() |
| 20 | 20 | { |
| 21 | 21 | $this->setName('about') |
| 22 | - ->setDescription('Short information about AuditApplication') |
|
| 23 | - ->setHelp('<info>audit about</info>'); |
|
| 22 | + ->setDescription('Short information about AuditApplication') |
|
| 23 | + ->setHelp('<info>audit about</info>'); |
|
| 24 | 24 | } |
| 25 | 25 | |
| 26 | 26 | //-------------------------------------------------------------------------------------------------------------------- |
@@ -34,7 +34,7 @@ |
||
| 34 | 34 | $this->io->write(<<<EOT |
| 35 | 35 | <info>AuditApplication - Database Auditing</info> |
| 36 | 36 | <comment>Creates audit tables and triggers to track data changes in databases.</comment> |
| 37 | -EOT |
|
| 37 | +eot |
|
| 38 | 38 | ); |
| 39 | 39 | } |
| 40 | 40 | |
@@ -70,8 +70,8 @@ |
||
| 70 | 70 | if ($mandatory) |
| 71 | 71 | { |
| 72 | 72 | throw new RuntimeException("Setting '%s' not found in section '%s' configuration file.", |
| 73 | - $settingName, |
|
| 74 | - $sectionName); |
|
| 73 | + $settingName, |
|
| 74 | + $sectionName); |
|
| 75 | 75 | } |
| 76 | 76 | else |
| 77 | 77 | { |
@@ -28,8 +28,8 @@ |
||
| 28 | 28 | protected function configure() |
| 29 | 29 | { |
| 30 | 30 | $this->setName('config') |
| 31 | - ->setDescription('Create or edit config file') |
|
| 32 | - ->addArgument('config file', InputArgument::OPTIONAL, 'The audit configuration file', 'etc/audit.json'); |
|
| 31 | + ->setDescription('Create or edit config file') |
|
| 32 | + ->addArgument('config file', InputArgument::OPTIONAL, 'The audit configuration file', 'etc/audit.json'); |
|
| 33 | 33 | } |
| 34 | 34 | |
| 35 | 35 | //-------------------------------------------------------------------------------------------------------------------- |
@@ -108,8 +108,8 @@ discard block |
||
| 108 | 108 | public function createAuditTable() |
| 109 | 109 | { |
| 110 | 110 | $this->io->logInfo('Creating audit table <dbo>%s.%s<dbo>', |
| 111 | - $this->auditSchemaName, |
|
| 112 | - $this->configTable->getTableName()); |
|
| 111 | + $this->auditSchemaName, |
|
| 112 | + $this->configTable->getTableName()); |
|
| 113 | 113 | |
| 114 | 114 | // In the audit table all columns from the data table must be nullable. |
| 115 | 115 | $dataTableColumnsDatabase = clone($this->dataTableColumnsDatabase); |
@@ -117,9 +117,9 @@ discard block |
||
| 117 | 117 | |
| 118 | 118 | $columns = TableColumnsMetadata::combine($this->auditColumns, $dataTableColumnsDatabase); |
| 119 | 119 | AuditDataLayer::createAuditTable($this->configTable->getSchemaName(), |
| 120 | - $this->auditSchemaName, |
|
| 121 | - $this->configTable->getTableName(), |
|
| 122 | - $columns); |
|
| 120 | + $this->auditSchemaName, |
|
| 121 | + $this->configTable->getTableName(), |
|
| 122 | + $columns); |
|
| 123 | 123 | } |
| 124 | 124 | |
| 125 | 125 | //-------------------------------------------------------------------------------------------------------------------- |
@@ -242,14 +242,14 @@ discard block |
||
| 242 | 242 | $this->configTable->getTableName()); |
| 243 | 243 | |
| 244 | 244 | AuditDataLayer::createAuditTrigger($this->configTable->getSchemaName(), |
| 245 | - $this->auditSchemaName, |
|
| 246 | - $this->configTable->getTableName(), |
|
| 247 | - $triggerName, |
|
| 248 | - $action, |
|
| 249 | - $this->auditColumns, |
|
| 250 | - $this->dataTableColumnsDatabase, |
|
| 251 | - $skipVariable, |
|
| 252 | - $additionSql); |
|
| 245 | + $this->auditSchemaName, |
|
| 246 | + $this->configTable->getTableName(), |
|
| 247 | + $triggerName, |
|
| 248 | + $action, |
|
| 249 | + $this->auditColumns, |
|
| 250 | + $this->dataTableColumnsDatabase, |
|
| 251 | + $skipVariable, |
|
| 252 | + $additionSql); |
|
| 253 | 253 | } |
| 254 | 254 | |
| 255 | 255 | //-------------------------------------------------------------------------------------------------------------------- |
@@ -366,23 +366,23 @@ discard block |
||
| 366 | 366 | foreach ($newColumns->getColumns() as $column) |
| 367 | 367 | { |
| 368 | 368 | $this->io->logInfo('New column <dbo>%s.%s</dbo>', |
| 369 | - $this->configTable->getTableName(), |
|
| 370 | - $column->getProperty('column_name')); |
|
| 369 | + $this->configTable->getTableName(), |
|
| 370 | + $column->getProperty('column_name')); |
|
| 371 | 371 | } |
| 372 | 372 | |
| 373 | 373 | foreach ($obsoleteColumns->getColumns() as $column) |
| 374 | 374 | { |
| 375 | 375 | $this->io->logInfo('Obsolete column <dbo>%s.%s</dbo>', |
| 376 | - $this->configTable->getTableName(), |
|
| 377 | - $column->getProperty('column_name')); |
|
| 376 | + $this->configTable->getTableName(), |
|
| 377 | + $column->getProperty('column_name')); |
|
| 378 | 378 | } |
| 379 | 379 | |
| 380 | 380 | foreach ($alteredColumns->getColumns() as $column) |
| 381 | 381 | { |
| 382 | 382 | $this->io->logInfo('Type of <dbo>%s.%s</dbo> has been altered to <dbo>%s</dbo>', |
| 383 | - $this->configTable->getTableName(), |
|
| 384 | - $column->getProperty('column_name'), |
|
| 385 | - $column->getProperty('column_type')); |
|
| 383 | + $this->configTable->getTableName(), |
|
| 384 | + $column->getProperty('column_name'), |
|
| 385 | + $column->getProperty('column_type')); |
|
| 386 | 386 | } |
| 387 | 387 | } |
| 388 | 388 | |
@@ -21,10 +21,10 @@ discard block |
||
| 21 | 21 | protected function configure() |
| 22 | 22 | { |
| 23 | 23 | $this->setName('drop-triggers') |
| 24 | - ->setDescription('Drops all triggers') |
|
| 25 | - ->setHelp('Drops all triggers (including triggers not created by audit) from all tables (including tables '. |
|
| 26 | - 'excluded for auditing) in the data schema.') |
|
| 27 | - ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file'); |
|
| 24 | + ->setDescription('Drops all triggers') |
|
| 25 | + ->setHelp('Drops all triggers (including triggers not created by audit) from all tables (including tables '. |
|
| 26 | + 'excluded for auditing) in the data schema.') |
|
| 27 | + ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file'); |
|
| 28 | 28 | } |
| 29 | 29 | |
| 30 | 30 | //-------------------------------------------------------------------------------------------------------------------- |
@@ -60,8 +60,8 @@ discard block |
||
| 60 | 60 | foreach ($triggers as $trigger) |
| 61 | 61 | { |
| 62 | 62 | $this->io->logInfo('Dropping trigger <dbo>%s</dbo> from table <dbo>%s</dbo>', |
| 63 | - $trigger['trigger_name'], |
|
| 64 | - $trigger['table_name']); |
|
| 63 | + $trigger['trigger_name'], |
|
| 64 | + $trigger['table_name']); |
|
| 65 | 65 | |
| 66 | 66 | AuditDataLayer::dropTrigger($data_schema, $trigger['trigger_name']); |
| 67 | 67 | } |
@@ -197,8 +197,7 @@ |
||
| 197 | 197 | && $audit_character_set_name==$config_character_set_name |
| 198 | 198 | && $audit_collation_name==$config_collation_name |
| 199 | 199 | && $audit_collation_name==$data_collation_name |
| 200 | - ) |
|
| 201 | - { |
|
| 200 | + ) { |
|
| 202 | 201 | return true; |
| 203 | 202 | } |
| 204 | 203 | } |
@@ -31,9 +31,9 @@ |
||
| 31 | 31 | protected function configure() |
| 32 | 32 | { |
| 33 | 33 | $this->setName('alter-audit-table') |
| 34 | - ->setDescription('Creates alter SQL statements for audit tables') |
|
| 35 | - ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file') |
|
| 36 | - ->addArgument('sql file', InputArgument::REQUIRED, 'The destination file for the SQL statements'); |
|
| 34 | + ->setDescription('Creates alter SQL statements for audit tables') |
|
| 35 | + ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file') |
|
| 36 | + ->addArgument('sql file', InputArgument::REQUIRED, 'The destination file for the SQL statements'); |
|
| 37 | 37 | |
| 38 | 38 | $this->setHelp(<<<EOL |
| 39 | 39 | Generates alter table SQL statements for aligning the audit tables with the |
@@ -49,7 +49,7 @@ |
||
| 49 | 49 | No SQL statements will be generated for missing or obsolete columns in the |
| 50 | 50 | audit tables. Use the command 'audit' for creating missing columns in audit |
| 51 | 51 | tables. |
| 52 | -EOL |
|
| 52 | +eol |
|
| 53 | 53 | ); |
| 54 | 54 | } |
| 55 | 55 | |
@@ -32,9 +32,9 @@ |
||
| 32 | 32 | protected function configure() |
| 33 | 33 | { |
| 34 | 34 | $this->setName('diff') |
| 35 | - ->setDescription('Compares data tables and audit tables') |
|
| 36 | - ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file') |
|
| 37 | - ->addOption('full', 'f', InputOption::VALUE_NONE, 'Show all columns'); |
|
| 35 | + ->setDescription('Compares data tables and audit tables') |
|
| 36 | + ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file') |
|
| 37 | + ->addOption('full', 'f', InputOption::VALUE_NONE, 'Show all columns'); |
|
| 38 | 38 | } |
| 39 | 39 | |
| 40 | 40 | //-------------------------------------------------------------------------------------------------------------------- |
@@ -22,12 +22,12 @@ |
||
| 22 | 22 | protected function configure() |
| 23 | 23 | { |
| 24 | 24 | $this->setName('audit') |
| 25 | - ->setDescription('Maintains audit tables and audit triggers') |
|
| 26 | - ->setHelp("Maintains audit tables and audit triggers:\n". |
|
| 27 | - "- creates new audit tables\n". |
|
| 28 | - "- adds new columns to exiting audit tables\n". |
|
| 29 | - "- creates new and recreates existing audit triggers\n") |
|
| 30 | - ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file'); |
|
| 25 | + ->setDescription('Maintains audit tables and audit triggers') |
|
| 26 | + ->setHelp("Maintains audit tables and audit triggers:\n". |
|
| 27 | + "- creates new audit tables\n". |
|
| 28 | + "- adds new columns to exiting audit tables\n". |
|
| 29 | + "- creates new and recreates existing audit triggers\n") |
|
| 30 | + ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file'); |
|
| 31 | 31 | } |
| 32 | 32 | |
| 33 | 33 | //-------------------------------------------------------------------------------------------------------------------- |