SetBased / php-audit

src/Command/BaseCommand.php

Spacing +1 added lines, -1 removed lines

@@ -90,7 +90,7 @@
   {
     $content = file_get_contents($this->configFileName);
 
-    $this->config = (array)json_decode($content, true);
+    $this->config = (array) json_decode($content, true);
     if (json_last_error()!=JSON_ERROR_NONE)
     {
       throw new RuntimeException("Error decoding JSON: '%s'.", json_last_error_msg());

Indentation +5 added lines, -5 removed lines

@@ -58,9 +58,9 @@ 
    * @throws RuntimeException
    */
   protected static function getSetting(array $settings,
-                                       bool $mandatory,
-                                       string $sectionName,
-                                       string $settingName): ?string
+                                        bool $mandatory,
+                                        string $sectionName,
+                                        string $settingName): ?string
   {
     // Test if the section exists.
     if (!array_key_exists($sectionName, $settings))
@@ -81,8 +81,8 @@ 
       if ($mandatory)
       {
         throw new RuntimeException("Setting '%s' not found in section '%s' configuration file.",
-                                   $settingName,
-                                   $sectionName);
+                                    $settingName,
+                                    $sectionName);
       }
       else
       {

src/Audit/Audit.php

Indentation +9 added lines, -9 removed lines

@@ -62,7 +62,7 @@ 
 
     $this->additionalAuditColumns =
       AuditDataLayer::resolveCanonicalAdditionalAuditColumns($this->config['database']['audit_schema'],
-                                                             $this->config['audit_columns']);
+                                                              $this->config['audit_columns']);
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -135,8 +135,8 @@ 
       {
         $this->io->writeln(sprintf('<info>Found new table %s</info>', $table['table_name']));
         $this->config['tables'][$table['table_name']] = ['audit' => null,
-                                                         'alias' => null,
-                                                         'skip'  => null];
+                                                          'alias' => null,
+                                                          'skip'  => null];
       }
     }
   }
@@ -152,12 +152,12 @@ 
       if ($this->config['tables'][$table['table_name']]['audit'])
       {
         $currentTable = new AuditTable($this->io,
-                                       $this->config['database']['data_schema'],
-                                       $this->config['database']['audit_schema'],
-                                       $table['table_name'],
-                                       $this->additionalAuditColumns,
-                                       $this->config['tables'][$table['table_name']]['alias'],
-                                       $this->config['tables'][$table['table_name']]['skip']);
+                                        $this->config['database']['data_schema'],
+                                        $this->config['database']['audit_schema'],
+                                        $table['table_name'],
+                                        $this->additionalAuditColumns,
+                                        $this->config['tables'][$table['table_name']]['alias'],
+                                        $this->config['tables'][$table['table_name']]['skip']);
 
         // Ensure the audit table exists.
         if (AuditDataLayer::searchInRowSet('table_name', $table['table_name'], $this->auditSchemaTables)===null)

src/Audit/Diff.php

Indentation +1 added lines, -1 removed lines

@@ -70,7 +70,7 @@
 
     $this->additionalAuditColumns =
       AuditDataLayer::resolveCanonicalAdditionalAuditColumns($this->config['database']['audit_schema'],
-                                                             $this->config['audit_columns']);
+                                                              $this->config['audit_columns']);
   }
 
   //--------------------------------------------------------------------------------------------------------------------

Spacing +1 added lines, -1 removed lines

@@ -123,7 +123,7 @@
     $dataTableColumns = TableColumnsMetadata::combine($this->additionalAuditColumns, $dataTableColumns);
 
     // In the audit table columns coming from the data table don't have defaults.
-    foreach($auditTableColumns->getColumns() as $column)
+    foreach ($auditTableColumns->getColumns() as $column)
     {
       if (!in_array($column->getName(), $this->additionalAuditColumns->getColumnNames()))
       {

src/Audit/AlterAuditTable.php

Indentation +11 added lines, -11 removed lines

@@ -48,7 +48,7 @@ 
 
     $this->additionalAuditColumns =
       AuditDataLayer::resolveCanonicalAdditionalAuditColumns($this->config['database']['audit_schema'],
-                                                             $this->config['audit_columns']);
+                                                              $this->config['audit_columns']);
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -103,8 +103,8 @@ 
       $maxLength = $diff->getLongestColumnNameLength();
 
       $this->codeStore->append(sprintf('alter table `%s`.`%s`',
-                                       $this->config['database']['audit_schema'],
-                                       $auditTable->getTableName()));
+                                        $this->config['database']['audit_schema'],
+                                        $auditTable->getTableName()));
 
       $first = true;
       foreach ($diff->getColumns() as $column)
@@ -115,11 +115,11 @@ 
         if (!$first) $this->codeStore->appendToLastLine(',');
 
         $this->codeStore->append(sprintf('change column `%s`%s`%s`%s%s',
-                                         $name,
-                                         $filler,
-                                         $name,
-                                         $filler,
-                                         $column->getColumnAuditDefinition()));
+                                          $name,
+                                          $filler,
+                                          $name,
+                                          $filler,
+                                          $column->getColumnAuditDefinition()));
 
         $first = false;
       }
@@ -165,9 +165,9 @@ 
       }
 
       $this->codeStore->append(sprintf('alter table `%s`.`%s` %s;',
-                                       $this->config['database']['audit_schema'],
-                                       $auditTable->getTableName(),
-                                       implode(' ', $parts)));
+                                        $this->config['database']['audit_schema'],
+                                        $auditTable->getTableName(),
+                                        implode(' ', $parts)));
       $this->codeStore->append('');
     }
   }

src/DiffTable.php

Indentation +23 added lines, -23 removed lines

@@ -229,20 +229,20 @@ 
       if (in_array($column, $auditColumns))
       {
         $this->rows[] = ['name'     => $column,
-                         'audit'    => $this->auditTable->getColumns()->getColumn($column),
-                         'data'     => $this->dataTable->getColumns()->getColumn($column),
-                         'type'     => 'column',
-                         'new'      => false,
-                         'obsolete' => false];
+                          'audit'    => $this->auditTable->getColumns()->getColumn($column),
+                          'data'     => $this->dataTable->getColumns()->getColumn($column),
+                          'type'     => 'column',
+                          'new'      => false,
+                          'obsolete' => false];
       }
       else
       {
         $this->rows[] = ['name'     => $column,
-                         'audit'    => null,
-                         'data'     => $this->dataTable->getColumns()->getColumn($column),
-                         'type'     => 'column',
-                         'new'      => true,
-                         'obsolete' => false];
+                          'audit'    => null,
+                          'data'     => $this->dataTable->getColumns()->getColumn($column),
+                          'type'     => 'column',
+                          'new'      => true,
+                          'obsolete' => false];
       }
     }
 
@@ -251,11 +251,11 @@ 
       if (!in_array($column, $dataColumns))
       {
         $this->rows[] = ['name'     => $column,
-                         'audit'    => $this->auditTable->getColumns()->getColumn($column),
-                         'data'     => null,
-                         'type'     => 'column',
-                         'new'      => false,
-                         'obsolete' => true];
+                          'audit'    => $this->auditTable->getColumns()->getColumn($column),
+                          'data'     => null,
+                          'type'     => 'column',
+                          'new'      => false,
+                          'obsolete' => true];
       }
     }
   }
@@ -272,10 +272,10 @@ 
     foreach ($dataOptions as $option)
     {
       $this->rows[] = ['name'    => $option,
-                       'audit1'  => $this->auditTable->getProperty($option),
-                       'data1'   => $this->dataTable->getProperty($option),
-                       'type'    => 'option',
-                       'rowspan' => 1];
+                        'audit1'  => $this->auditTable->getProperty($option),
+                        'data1'   => $this->dataTable->getProperty($option),
+                        'type'    => 'option',
+                        'rowspan' => 1];
     }
 
     foreach ($auditOptions as $option)
@@ -283,10 +283,10 @@ 
       if (!in_array($option, $dataOptions))
       {
         $this->rows[] = ['name'    => $option,
-                         'audit1'  => $this->auditTable->getProperty($option),
-                         'data2'   => null,
-                         'type'    => 'option',
-                         'rowspan' => 1];
+                          'audit1'  => $this->auditTable->getProperty($option),
+                          'data2'   => null,
+                          'type'    => 'option',
+                          'rowspan' => 1];
       }
     }
   }

src/Command/DiffCommand.php

Indentation +3 added lines, -3 removed lines

@@ -32,9 +32,9 @@
   protected function configure()
   {
     $this->setName('diff')
-         ->setDescription('Compares data tables and audit tables')
-         ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file')
-         ->addOption('full', 'f', InputOption::VALUE_NONE, 'Show all columns');
+          ->setDescription('Compares data tables and audit tables')
+          ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file')
+          ->addOption('full', 'f', InputOption::VALUE_NONE, 'Show all columns');
   }
 
   //--------------------------------------------------------------------------------------------------------------------

src/Command/DropTriggersCommand.php

Indentation +6 added lines, -6 removed lines

@@ -21,10 +21,10 @@ 
   protected function configure()
   {
     $this->setName('drop-triggers')
-         ->setDescription('Drops all triggers')
-         ->setHelp('Drops all triggers (including triggers not created by audit) from all tables (including tables '.
-                   'excluded for auditing) in the data schema.')
-         ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file');
+          ->setDescription('Drops all triggers')
+          ->setHelp('Drops all triggers (including triggers not created by audit) from all tables (including tables '.
+                    'excluded for auditing) in the data schema.')
+          ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file');
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -60,8 +60,8 @@ 
     foreach ($triggers as $trigger)
     {
       $this->io->logInfo('Dropping trigger <dbo>%s</dbo> from table <dbo>%s</dbo>',
-                         $trigger['trigger_name'],
-                         $trigger['table_name']);
+                          $trigger['trigger_name'],
+                          $trigger['table_name']);
 
       AuditDataLayer::dropTrigger($data_schema, $trigger['trigger_name']);
     }

src/Command/AlterAuditTableCommand.php

Indentation +3 added lines, -3 removed lines

@@ -31,9 +31,9 @@
   protected function configure()
   {
     $this->setName('alter-audit-table')
-         ->setDescription('Creates alter SQL statements for audit tables')
-         ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file')
-         ->addArgument('sql file', InputArgument::OPTIONAL, 'The destination file for the SQL statements');
+          ->setDescription('Creates alter SQL statements for audit tables')
+          ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file')
+          ->addArgument('sql file', InputArgument::OPTIONAL, 'The destination file for the SQL statements');
 
     $this->setHelp(<<<EOL
 Generates alter table SQL statements for aligning the audit tables with the 

Upper-Lower-Casing +1 added lines, -1 removed lines

@@ -49,7 +49,7 @@
 No SQL statements will be generated for missing or obsolete columns in the 
 audit tables. Use the command 'audit' for creating missing columns in audit
 tables.
-EOL
+eol
     );
   }
 

src/Command/AuditCommand.php

Indentation +6 added lines, -6 removed lines

@@ -22,12 +22,12 @@
   protected function configure()
   {
     $this->setName('audit')
-         ->setDescription('Maintains audit tables and audit triggers')
-         ->setHelp("Maintains audit tables and audit triggers:\n".
-                   "- creates new audit tables\n".
-                   "- adds new columns to exiting audit tables\n".
-                   "- creates new and recreates existing audit triggers\n")
-         ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file');
+          ->setDescription('Maintains audit tables and audit triggers')
+          ->setHelp("Maintains audit tables and audit triggers:\n".
+                    "- creates new audit tables\n".
+                    "- adds new columns to exiting audit tables\n".
+                    "- creates new and recreates existing audit triggers\n")
+          ->addArgument('config file', InputArgument::REQUIRED, 'The audit configuration file');
   }
 
   //--------------------------------------------------------------------------------------------------------------------