SetBased / php-audit

src/MySql/DataLayer.php

Indentation +14 added lines, -14 removed lines

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

Spacing +1 added lines, -1 removed lines

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

src/MySql/Command/AuditCommand.php

Spacing +1 added lines, -1 removed lines

@@ -153,7 +153,7 @@
                                   $this->config['audit_columns'],
                                   $this->config['tables'][$table['table_name']]['alias'],
                                   $this->config['tables'][$table['table_name']]['skip']);
-        $res          = StaticDataLayer::searchInRowSet('table_name', $currentTable->getTableName(), $this->auditSchemaTables);
+        $res = StaticDataLayer::searchInRowSet('table_name', $currentTable->getTableName(), $this->auditSchemaTables);
         if (!isset($res))
         {
           $currentTable->createMissingAuditTable();

Indentation +4 added lines, -4 removed lines

@@ -105,8 +105,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];
       }
     }
   }
@@ -143,8 +143,8 @@ 
   protected function configure()
   {
     $this->setName('audit')
-         ->setDescription('Create (missing) audit table and (re)creates audit triggers')
-         ->addArgument('config file', InputArgument::OPTIONAL, 'The audit configuration file');
+          ->setDescription('Create (missing) audit table and (re)creates audit triggers')
+          ->addArgument('config file', InputArgument::OPTIONAL, 'The audit configuration file');
   }
 
   //--------------------------------------------------------------------------------------------------------------------

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/DiffCommand.php

Indentation +3 added lines, -3 removed lines

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

Doc Comments +3 added lines, -3 removed lines

@@ -53,7 +53,7 @@ 
    *
    * @param array[] $columns The metadata of the columns of a table.
    *
-   * @return array[]
+   * @return \array[]
    */
   private static function removeMatchingColumns($columns)
   {
@@ -142,7 +142,7 @@ 
   /**
    * Add not null to audit columns if it not nullable.
    *
-   * @param array $theColumns Audit columns.
+   * @param \array[] $theColumns Audit columns.
    *
    * @return array
    */
@@ -173,7 +173,7 @@ 
    * @param Columns $dataColumns  The table columns from data schema.
    * @param Columns $auditColumns The table columns from audit schema.
    *
-   * @return \array[]
+   * @return ColumnTypesExtended
    */
   private function createDiffArray($dataColumns, $auditColumns)
   {

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

Doc Comments +1 added lines, -1 removed lines

@@ -268,7 +268,7 @@
   /**
    * Selects and returns the metadata of the columns of this table from information_schema.
    *
-   * @return array[]
+   * @return \array[]
    */
   private function getColumnsFromInformationSchema()
   {

Indentation +4 added lines, -4 removed lines

@@ -259,7 +259,7 @@ 
   private function getAlteredColumns()
   {
     $alteredColumnsTypes = Columns::differentColumnTypes($this->dataTableColumnsDatabase,
-                                                         $this->dataTableColumnsConfig);
+                                                          $this->dataTableColumnsConfig);
 
     return $alteredColumnsTypes;
   }
@@ -382,9 +382,9 @@ 
     foreach ($alteredColumns as $column)
     {
       $this->io->logInfo('Type of <dbo>%s.%s</dbo> has been altered to <dbo>%s</dbo>',
-                         $this->tableName,
-                         $column['column_name'],
-                         $column['column_type']);
+                          $this->tableName,
+                          $column['column_name'],
+                          $column['column_type']);
     }
   }
 

src/MySql/Helper/ColumnTypesExtended.php

Unused Use Statements +1 added lines, -1 removed lines

@@ -3,8 +3,8 @@
 namespace SetBased\Audit\MySql\Helper;
 
 //----------------------------------------------------------------------------------------------------------------------
-use SetBased\Audit\MySql\Table\Columns;
 use SetBased\Audit\MySQl\Table\ColumnType;
+use SetBased\Audit\MySql\Table\Columns;
 
 /**
  * A helper class for column types.

src/MySql/Helper/TableHelper.php

Indentation +3 added lines, -3 removed lines

@@ -94,9 +94,9 @@
         $theName = $theOption;
       }
       $tableRow               = ['column_name'        => $theName,
-                                 'data_column_type'   => $this->dataTableOptions[$theOption],
-                                 'audit_column_type'  => $this->auditTableOptions[$theOption],
-                                 'config_column_type' => null];
+                                  'data_column_type'   => $this->dataTableOptions[$theOption],
+                                  'audit_column_type'  => $this->auditTableOptions[$theOption],
+                                  'config_column_type' => null];
       $this->rows[$theOption] = RowHelper::createTableRow($tableRow);
     }
   }

Spacing +1 added lines, -1 removed lines

@@ -93,7 +93,7 @@
       {
         $theName = $theOption;
       }
-      $tableRow               = ['column_name'        => $theName,
+      $tableRow = ['column_name'        => $theName,
                                  'data_column_type'   => $this->dataTableOptions[$theOption],
                                  'audit_column_type'  => $this->auditTableOptions[$theOption],
                                  'config_column_type' => null];

src/MySql/Helper/RowHelper.php

Indentation +6 added lines, -6 removed lines

@@ -25,9 +25,9 @@ 
     $auditCollationName = isset($theRow['audit_collation_name']) ? $theRow['audit_collation_name'] : null;
 
     $tableRow = ['column_name'      => null,
-                 'data_table_type'  => self::styledOptionsRow($dataCharsetName, $dataCollationName),
-                 'audit_table_type' => self::styledOptionsRow($auditCharsetName, $auditCollationName),
-                 'config_type'      => null];
+                  'data_table_type'  => self::styledOptionsRow($dataCharsetName, $dataCollationName),
+                  'audit_table_type' => self::styledOptionsRow($auditCharsetName, $auditCollationName),
+                  'config_type'      => null];
 
     return $tableRow;
   }
@@ -60,9 +60,9 @@ 
   public static function createTableRow($theRow)
   {
     $tableRow = ['column_name'      => isset($theRow['column_name']) ? $theRow['column_name'] : null,
-                 'data_table_type'  => isset($theRow['data_column_type']) ? $theRow['data_column_type'] : null,
-                 'audit_table_type' => isset($theRow['audit_column_type']) ? $theRow['audit_column_type'] : null,
-                 'config_type'      => isset($theRow['config_column_type']) ? $theRow['config_column_type'] : null];
+                  'data_table_type'  => isset($theRow['data_column_type']) ? $theRow['data_column_type'] : null,
+                  'audit_table_type' => isset($theRow['audit_column_type']) ? $theRow['audit_column_type'] : null,
+                  'config_type'      => isset($theRow['config_column_type']) ? $theRow['config_column_type'] : null];
 
     return $tableRow;
   }