SetBased / php-audit

src/MySql/AuditDataLayer.php

Indentation +26 added lines, -26 removed lines

@@ -76,9 +76,9 @@ 
    *                                              columns and columns of the data table).
    */
   public function createAuditTable(string $dataSchemaName,
-                                   string $auditSchemaName,
-                                   string $tableName,
-                                   TableColumnsMetadata $columns): void
+                                    string $auditSchemaName,
+                                    string $tableName,
+                                    TableColumnsMetadata $columns): void
   {
     $helper = new CreateAuditTable($dataSchemaName, $auditSchemaName, $tableName, $columns);
     $sql    = $helper->buildStatement();
@@ -101,24 +101,24 @@ 
    * @param string[]             $additionSql            Additional SQL statements.
    */
   public function createAuditTrigger(string $dataSchemaName,
-                                     string $auditSchemaName,
-                                     string $tableName,
-                                     string $triggerName,
-                                     string $triggerAction,
-                                     TableColumnsMetadata $additionalAuditColumns,
-                                     TableColumnsMetadata $tableColumns,
+                                      string $auditSchemaName,
+                                      string $tableName,
+                                      string $triggerName,
+                                      string $triggerAction,
+                                      TableColumnsMetadata $additionalAuditColumns,
+                                      TableColumnsMetadata $tableColumns,
                                      ?string $skipVariable,
-                                     array $additionSql): void
+                                      array $additionSql): void
   {
     $helper = new CreateAuditTrigger($dataSchemaName,
-                                     $auditSchemaName,
-                                     $tableName,
-                                     $triggerName,
-                                     $triggerAction,
-                                     $additionalAuditColumns,
-                                     $tableColumns,
-                                     $skipVariable,
-                                     $additionSql);
+                                      $auditSchemaName,
+                                      $tableName,
+                                      $triggerName,
+                                      $triggerAction,
+                                      $additionalAuditColumns,
+                                      $tableColumns,
+                                      $skipVariable,
+                                      $additionSql);
     $sql    = $helper->buildStatement();
 
     $this->executeNone($sql);
@@ -300,8 +300,8 @@ 
 where  TABLE_SCHEMA = %s
 and    TABLE_NAME   = %s
 order by ORDINAL_POSITION",
-                   $this->quoteString($schemaName),
-                   $this->quoteString($tableName));
+                    $this->quoteString($schemaName),
+                    $this->quoteString($tableName));
 
     return $this->executeRows($sql);
   }
@@ -327,8 +327,8 @@ 
 inner join information_schema.COLLATION_CHARACTER_SET_APPLICABILITY t2  on  t2.COLLATION_NAME = t1.TABLE_COLLATION
 where t1.TABLE_SCHEMA = %s
 and   t1.TABLE_NAME   = %s',
-                   $this->quoteString($schemaName),
-                   $this->quoteString($tableName));
+                    $this->quoteString($schemaName),
+                    $this->quoteString($tableName));
 
     return $this->executeRow1($sql);
   }
@@ -350,8 +350,8 @@ 
 where  TRIGGER_SCHEMA     = %s
 and    EVENT_OBJECT_TABLE = %s
 order by Trigger_Name',
-                   $this->quoteString($schemaName),
-                   $this->quoteString($tableName));
+                    $this->quoteString($schemaName),
+                    $this->quoteString($tableName));
 
     return $this->executeRows($sql);
   }
@@ -393,7 +393,7 @@ 
 where  TRIGGER_SCHEMA     = %s
 order by EVENT_OBJECT_TABLE
 ,        TRIGGER_NAME',
-                   $this->quoteString($schemaName));
+                    $this->quoteString($schemaName));
 
     return $this->executeRows($sql);
   }
@@ -422,7 +422,7 @@ 
    * @return TableColumnsMetadata
    */
   public function resolveCanonicalAdditionalAuditColumns(string $auditSchema,
-                                                         array $additionalAuditColumns): TableColumnsMetadata
+                                                          array $additionalAuditColumns): TableColumnsMetadata
   {
     if (empty($additionalAuditColumns))
     {

Spacing +1 added lines, -1 removed lines

@@ -119,7 +119,7 @@
                                      $tableColumns,
                                      $skipVariable,
                                      $additionSql);
-    $sql    = $helper->buildStatement();
+    $sql = $helper->buildStatement();
 
     $this->executeNone($sql);
   }

src/AuditTable.php

Indentation +9 added lines, -9 removed lines

@@ -332,29 +332,29 @@
    * @param TableColumnsMetadata $alteredColumns  The metadata of the altered columns.
    */
   private function logColumnInfo(TableColumnsMetadata $newColumns,
-                                 TableColumnsMetadata $obsoleteColumns,
-                                 TableColumnsMetadata $alteredColumns): void
+                                  TableColumnsMetadata $obsoleteColumns,
+                                  TableColumnsMetadata $alteredColumns): void
   {
     foreach ($newColumns->getColumns() as $column)
     {
       $this->io->logInfo('New column <dbo>%s.%s</dbo>',
-                         $this->tableName,
-                         $column->getName());
+                          $this->tableName,
+                          $column->getName());
     }
 
     foreach ($obsoleteColumns->getColumns() as $column)
     {
       $this->io->logInfo('Obsolete column <dbo>%s.%s</dbo>',
-                         $this->tableName,
-                         $column->getName());
+                          $this->tableName,
+                          $column->getName());
     }
 
     foreach ($alteredColumns->getColumns() as $column)
     {
       $this->io->logInfo('Type of <dbo>%s.%s</dbo> has been altered to <dbo>%s</dbo>',
-                         $this->tableName,
-                         $column->getName(),
-                         $column->getProperty('column_type'));
+                          $this->tableName,
+                          $column->getName(),
+                          $column->getProperty('column_type'));
     }
   }
 

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::$dl->dropTrigger($dataSchema, $trigger['trigger_name']);
     }

src/Command/BaseCommand.php

Indentation +4 added lines, -4 removed lines

@@ -99,10 +99,10 @@
   protected function connect(): void
   {
     $connector = new MySqlDefaultConnector($this->config->getManString('database.host'),
-                                           $this->config->getManString('database.user'),
-                                           $this->config->getManString('database.password'),
-                                           $this->config->getManString('database.data_schema'),
-                                           $this->config->getManInt('database.port', 3306));
+                                            $this->config->getManString('database.user'),
+                                            $this->config->getManString('database.password'),
+                                            $this->config->getManString('database.data_schema'),
+                                            $this->config->getManInt('database.port', 3306));
     $dl = new AuditDataLayer($connector, $this->io);
     $dl->connect();
   }

src/Audit/Audit.php

Indentation +6 added lines, -6 removed lines

@@ -160,12 +160,12 @@
       if ($audit===true)
       {
         $currentTable = new AuditTable($this->io,
-                                       $this->config->getManString('database.data_schema'),
-                                       $this->config->getManString('database.audit_schema'),
-                                       $table['table_name'],
-                                       $this->additionalAuditColumns,
-                                       $this->config->getOptString('tables.'.$table['table_name'].'.alias'),
-                                       $this->config->getOptString('tables.'.$table['table_name'].'.skip'));
+                                        $this->config->getManString('database.data_schema'),
+                                        $this->config->getManString('database.audit_schema'),
+                                        $table['table_name'],
+                                        $this->additionalAuditColumns,
+                                        $this->config->getOptString('tables.'.$table['table_name'].'.alias'),
+                                        $this->config->getOptString('tables.'.$table['table_name'].'.skip'));
 
         // Ensure the audit table exists.
         if (RowSetHelper::searchInRowSet($this->auditSchemaTables, 'table_name', $table['table_name'])===null)

src/Audit/AlterAuditTable.php

Indentation +10 added lines, -10 removed lines

@@ -105,8 +105,8 @@ 
       $maxLength = $diff->getLongestColumnNameLength();
 
       $this->codeStore->append(sprintf('alter table `%s`.`%s`',
-                                       $this->config->getManString('database.audit_schema'),
-                                       $auditTable->getTableName()));
+                                        $this->config->getManString('database.audit_schema'),
+                                        $auditTable->getTableName()));
 
       $first = true;
       foreach ($diff->getColumns() as $column)
@@ -117,11 +117,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;
       }
@@ -167,9 +167,9 @@ 
       }
 
       $this->codeStore->append(sprintf('alter table `%s`.`%s` %s;',
-                                       $this->config->getManString('database.audit_schema'),
-                                       $auditTable->getTableName(),
-                                       implode(' ', $parts)));
+                                        $this->config->getManString('database.audit_schema'),
+                                        $auditTable->getTableName(),
+                                        implode(' ', $parts)));
       $this->codeStore->append('');
     }
   }