SetBased / php-audit

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/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');
   }
 
   //--------------------------------------------------------------------------------------------------------------------

src/MySql/AuditDataLayer.php

Spacing +1 added lines, -1 removed lines

@@ -90,7 +90,7 @@
                                      $tableColumns,
                                      $skipVariable,
                                      $additionSql);
-    $sql    = $helper->buildStatement();
+    $sql = $helper->buildStatement();
 
     static::executeNone($sql);
   }

Indentation +15 added lines, -15 removed lines

@@ -88,14 +88,14 @@ 
                                             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();
 
     static::executeNone($sql);
@@ -277,8 +277,8 @@ 
 where  TABLE_SCHEMA = %s
 and    TABLE_NAME   = %s
 order by ORDINAL_POSITION",
-                   static::quoteString($schemaName),
-                   static::quoteString($tableName));
+                    static::quoteString($schemaName),
+                    static::quoteString($tableName));
 
     return static::executeRows($sql);
   }
@@ -304,8 +304,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',
-                   static::quoteString($schemaName),
-                   static::quoteString($tableName));
+                    static::quoteString($schemaName),
+                    static::quoteString($tableName));
 
     return static::executeRow1($sql);
   }
@@ -327,8 +327,8 @@ 
 where  TRIGGER_SCHEMA     = %s
 and    EVENT_OBJECT_TABLE = %s
 order by Trigger_Name',
-                   static::quoteString($schemaName),
-                   static::quoteString($tableName));
+                    static::quoteString($schemaName),
+                    static::quoteString($tableName));
 
     return static::executeRows($sql);
   }
@@ -370,7 +370,7 @@ 
 where  TRIGGER_SCHEMA     = %s
 order by EVENT_OBJECT_TABLE
 ,        TRIGGER_NAME',
-                   static::quoteString($schemaName));
+                    static::quoteString($schemaName));
 
     return static::executeRows($sql);
   }

src/Metadata/TableColumnsMetadata.php

Indentation +1 added lines, -1 removed lines

@@ -80,7 +80,7 @@
    * @return TableColumnsMetadata
    */
   public static function notInOtherSet(TableColumnsMetadata $columns1,
-                                       TableColumnsMetadata $columns2): TableColumnsMetadata
+                                        TableColumnsMetadata $columns2): TableColumnsMetadata
   {
     $diff = new TableColumnsMetadata();
     foreach ($columns1->columns as $column_name => $column1)

Spacing +1 added lines, -1 removed lines

@@ -151,7 +151,7 @@
     $columns = array_keys($this->columns);
     $key     = array_search($columnName, $columns);
 
-    if ($key>=1)
+    if ($key >= 1)
     {
       return $columns[$key - 1];
     }

src/AuditTable.php

Indentation +17 added lines, -17 removed lines

@@ -257,14 +257,14 @@ 
                           $this->tableName);
 
     AuditDataLayer::createAuditTrigger($this->dataSchemaName,
-                                       $this->auditSchemaName,
-                                       $this->tableName,
-                                       $triggerName,
-                                       $action,
-                                       $this->additionalAuditColumns,
-                                       $this->dataTableColumnsDatabase,
-                                       $skipVariable,
-                                       $additionSql);
+                                        $this->auditSchemaName,
+                                        $this->tableName,
+                                        $triggerName,
+                                        $action,
+                                        $this->additionalAuditColumns,
+                                        $this->dataTableColumnsDatabase,
+                                        $skipVariable,
+                                        $additionSql);
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -333,29 +333,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/Style/AuditStyle.php

Spacing +5 added lines, -5 removed lines

@@ -41,7 +41,7 @@ 
   //--------------------------------------------------------------------------------------------------------------------
   public function logDebug()
   {
-    if ($this->getVerbosity()>=OutputInterface::VERBOSITY_DEBUG)
+    if ($this->getVerbosity() >= OutputInterface::VERBOSITY_DEBUG)
     {
       $args   = func_get_args();
       $format = array_shift($args);
@@ -53,7 +53,7 @@ 
   //--------------------------------------------------------------------------------------------------------------------
   public function logInfo()
   {
-    if ($this->getVerbosity()>=OutputInterface::VERBOSITY_NORMAL)
+    if ($this->getVerbosity() >= OutputInterface::VERBOSITY_NORMAL)
     {
       $args   = func_get_args();
       $format = array_shift($args);
@@ -65,7 +65,7 @@ 
   //--------------------------------------------------------------------------------------------------------------------
   public function logNote()
   {
-    if ($this->getVerbosity()>=OutputInterface::VERBOSITY_NORMAL)
+    if ($this->getVerbosity() >= OutputInterface::VERBOSITY_NORMAL)
     {
       $args   = func_get_args();
       $format = array_shift($args);
@@ -77,7 +77,7 @@ 
   //--------------------------------------------------------------------------------------------------------------------
   public function logVerbose()
   {
-    if ($this->getVerbosity()>=OutputInterface::VERBOSITY_VERBOSE)
+    if ($this->getVerbosity() >= OutputInterface::VERBOSITY_VERBOSE)
     {
       $args   = func_get_args();
       $format = array_shift($args);
@@ -89,7 +89,7 @@ 
   //--------------------------------------------------------------------------------------------------------------------
   public function logVeryVerbose()
   {
-    if ($this->getVerbosity()>=OutputInterface::VERBOSITY_VERY_VERBOSE)
+    if ($this->getVerbosity() >= OutputInterface::VERBOSITY_VERY_VERBOSE)
     {
       $args   = func_get_args();
       $format = array_shift($args);

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');
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -59,8 +59,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($dataSchema, $trigger['trigger_name']);
     }