SetBased / php-audit

src/Command/AboutCommand.php

Indentation +2 added lines, -2 removed lines

@@ -19,8 +19,8 @@
   protected function configure()
   {
     $this->setName('about')
-         ->setDescription('Short information about AuditApplication')
-         ->setHelp('<info>audit about</info>');
+          ->setDescription('Short information about AuditApplication')
+          ->setHelp('<info>audit about</info>');
   }
 
   //--------------------------------------------------------------------------------------------------------------------

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

@@ -34,7 +34,7 @@
     $this->io->write(<<<EOT
 <info>AuditApplication - Database Auditing</info>
 <comment>Creates audit tables and triggers to track data changes in databases.</comment>
-EOT
+eot
     );
   }
 

src/Command/BaseCommand.php

Indentation +2 added lines, -2 removed lines

@@ -70,8 +70,8 @@
       if ($mandatory)
       {
         throw new RuntimeException("Setting '%s' not found in section '%s' configuration file.",
-                                   $settingName,
-                                   $sectionName);
+                                    $settingName,
+                                    $sectionName);
       }
       else
       {

src/Command/ConfigCommand.php

Indentation +2 added lines, -2 removed lines

@@ -28,8 +28,8 @@
   protected function configure()
   {
     $this->setName('config')
-         ->setDescription('Create or edit config file')
-         ->addArgument('config file', InputArgument::OPTIONAL, 'The audit configuration file', 'etc/audit.json');
+          ->setDescription('Create or edit config file')
+          ->addArgument('config file', InputArgument::OPTIONAL, 'The audit configuration file', 'etc/audit.json');
   }
 
   //--------------------------------------------------------------------------------------------------------------------

src/MySql/AuditDataLayer.php

Spacing +1 added lines, -1 removed lines

@@ -117,7 +117,7 @@
                                      $auditColumns,
                                      $skipVariable,
                                      $additionSql);
-    $sql    = $helper->buildStatement();
+    $sql = $helper->buildStatement();
 
     self::executeNone($sql);
   }

Doc Comments +3 added lines

@@ -163,6 +163,7 @@ 
   //--------------------------------------------------------------------------------------------------------------------
   /**
    * {@inheritdoc}
+   * @param string $query
    */
   public static function executeNone($query)
   {
@@ -185,6 +186,7 @@ 
   //--------------------------------------------------------------------------------------------------------------------
   /**
    * {@inheritdoc}
+   * @param string $query
    */
   public static function executeRow1($query)
   {
@@ -196,6 +198,7 @@ 
   //--------------------------------------------------------------------------------------------------------------------
   /**
    * {@inheritdoc}
+   * @param string $query
    */
   public static function executeRows($query)
   {

Indentation +15 added lines, -15 removed lines

@@ -83,14 +83,14 @@ 
                                             $additionSql)
   {
     $helper = new CreateAuditTrigger($dataSchemaName,
-                                     $auditSchemaName,
-                                     $tableName,
-                                     $triggerName,
-                                     $triggerAction,
-                                     $auditColumns,
-                                     $tableColumns,
-                                     $skipVariable,
-                                     $additionSql);
+                                      $auditSchemaName,
+                                      $tableName,
+                                      $triggerName,
+                                      $triggerAction,
+                                      $auditColumns,
+                                      $tableColumns,
+                                      $skipVariable,
+                                      $additionSql);
     $sql    = $helper->buildStatement();
 
     self::executeNone($sql);
@@ -258,8 +258,8 @@ 
 where  TABLE_SCHEMA = %s
 and    TABLE_NAME   = %s
 order by ORDINAL_POSITION',
-                   parent::quoteString($schemaName),
-                   parent::quoteString($tableName));
+                    parent::quoteString($schemaName),
+                    parent::quoteString($tableName));
 
     return self::executeRows($sql);
   }
@@ -283,8 +283,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',
-                   parent::quoteString($schemaName),
-                   parent::quoteString($tableName));
+                    parent::quoteString($schemaName),
+                    parent::quoteString($tableName));
 
     return self::executeRow1($sql);
   }
@@ -306,8 +306,8 @@ 
 where  TRIGGER_SCHEMA     = %s
 and    EVENT_OBJECT_TABLE = %s
 order by Trigger_Name',
-                   parent::quoteString($schemaName),
-                   parent::quoteString($tableName));
+                    parent::quoteString($schemaName),
+                    parent::quoteString($tableName));
 
     return self::executeRows($sql);
   }
@@ -349,7 +349,7 @@ 
 where  TRIGGER_SCHEMA     = %s
 order by EVENT_OBJECT_TABLE
 ,        TRIGGER_NAME',
-                   parent::quoteString($schemaName));
+                    parent::quoteString($schemaName));
 
     return self::executeRows($sql);
   }

src/MySql/AuditTable.php

Indentation +20 added lines, -20 removed lines

@@ -108,8 +108,8 @@ 
   public function createAuditTable()
   {
     $this->io->logInfo('Creating audit table <dbo>%s.%s<dbo>',
-                       $this->auditSchemaName,
-                       $this->configTable->getTableName());
+                        $this->auditSchemaName,
+                        $this->configTable->getTableName());
 
     // In the audit table all columns from the data table must be nullable.
     $dataTableColumnsDatabase = clone($this->dataTableColumnsDatabase);
@@ -117,9 +117,9 @@ 
 
     $columns = TableColumnsMetadata::combine($this->auditColumns, $dataTableColumnsDatabase);
     AuditDataLayer::createAuditTable($this->configTable->getSchemaName(),
-                                     $this->auditSchemaName,
-                                     $this->configTable->getTableName(),
-                                     $columns);
+                                      $this->auditSchemaName,
+                                      $this->configTable->getTableName(),
+                                      $columns);
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -242,14 +242,14 @@ 
                           $this->configTable->getTableName());
 
     AuditDataLayer::createAuditTrigger($this->configTable->getSchemaName(),
-                                       $this->auditSchemaName,
-                                       $this->configTable->getTableName(),
-                                       $triggerName,
-                                       $action,
-                                       $this->auditColumns,
-                                       $this->dataTableColumnsDatabase,
-                                       $skipVariable,
-                                       $additionSql);
+                                        $this->auditSchemaName,
+                                        $this->configTable->getTableName(),
+                                        $triggerName,
+                                        $action,
+                                        $this->auditColumns,
+                                        $this->dataTableColumnsDatabase,
+                                        $skipVariable,
+                                        $additionSql);
   }
 
   //--------------------------------------------------------------------------------------------------------------------
@@ -366,23 +366,23 @@ 
     foreach ($newColumns->getColumns() as $column)
     {
       $this->io->logInfo('New column <dbo>%s.%s</dbo>',
-                         $this->configTable->getTableName(),
-                         $column->getProperty('column_name'));
+                          $this->configTable->getTableName(),
+                          $column->getProperty('column_name'));
     }
 
     foreach ($obsoleteColumns->getColumns() as $column)
     {
       $this->io->logInfo('Obsolete column <dbo>%s.%s</dbo>',
-                         $this->configTable->getTableName(),
-                         $column->getProperty('column_name'));
+                          $this->configTable->getTableName(),
+                          $column->getProperty('column_name'));
     }
 
     foreach ($alteredColumns->getColumns() as $column)
     {
       $this->io->logInfo('Type of <dbo>%s.%s</dbo> has been altered to <dbo>%s</dbo>',
-                         $this->configTable->getTableName(),
-                         $column->getProperty('column_name'),
-                         $column->getProperty('column_type'));
+                          $this->configTable->getTableName(),
+                          $column->getProperty('column_name'),
+                          $column->getProperty('column_type'));
     }
   }
 

src/MySql/Audit.php

Indentation +16 added lines, -16 removed lines

@@ -160,8 +160,8 @@ 
       {
         $this->io->writeln(sprintf('<info>Found new table %s</info>', $table['table_name']));
         $this->config['tables'][$table['table_name']] = ['audit' => false,
-                                                         'alias' => null,
-                                                         'skip'  => null];
+                                                          'alias' => null,
+                                                          'skip'  => null];
       }
     }
   }
@@ -225,15 +225,15 @@ 
         }
 
         $configTable = new TableMetadata($table['table_name'],
-                                         $this->config['database']['data_schema'],
-                                         $tableColumns);
+                                          $this->config['database']['data_schema'],
+                                          $tableColumns);
 
         $currentTable = new AuditTable($this->io,
-                                       $configTable,
-                                       $this->config['database']['audit_schema'],
-                                       $this->auditColumnsMetadata,
-                                       $this->config['tables'][$table['table_name']]['alias'],
-                                       $this->config['tables'][$table['table_name']]['skip']);
+                                        $configTable,
+                                        $this->config['database']['audit_schema'],
+                                        $this->auditColumnsMetadata,
+                                        $this->config['tables'][$table['table_name']]['alias'],
+                                        $this->config['tables'][$table['table_name']]['skip']);
 
         // Ensure an audit table exists.
         if (StaticDataLayer::searchInRowSet('table_name', $table['table_name'], $this->auditSchemaTables)===null)
@@ -257,15 +257,15 @@ 
       else
       {
         $configTable = new TableMetadata($table['table_name'],
-                                         $this->config['database']['data_schema'],
-                                         []);
+                                          $this->config['database']['data_schema'],
+                                          []);
 
         $currentTable = new AuditTable($this->io,
-                                       $configTable,
-                                       $this->config['database']['audit_schema'],
-                                       $this->auditColumnsMetadata,
-                                       '',
-                                       '');
+                                        $configTable,
+                                        $this->config['database']['audit_schema'],
+                                        $this->auditColumnsMetadata,
+                                        '',
+                                        '');
 
         $currentTable->dropAuditTriggers($this->config['database']['data_schema'], $table['table_name']);
       }

src/MySql/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/MySql/AuditDiffTable.php

Braces +1 added lines, -2 removed lines

@@ -197,8 +197,7 @@
         && $audit_character_set_name==$config_character_set_name
         && $audit_collation_name==$config_collation_name
         && $audit_collation_name==$data_collation_name
-      )
-      {
+      ) {
         return true;
       }
     }

src/MySql/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::REQUIRED, '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::REQUIRED, '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
     );
   }