SetBased / php-audit

src/MySql/Command/AuditCommand.php

Indentation +106 added lines, -106 removed lines

@@ -17,116 +17,116 @@ 
  */
 class AuditCommand extends MySqlCommand
 {
-  //--------------------------------------------------------------------------------------------------------------------
-  /**
-   * All tables in the in the audit schema.
-   *
-   * @var array
-   */
-  protected $auditSchemaTables;
-
-  /**
-   * Array of tables from data schema.
-   *
-   * @var array
-   */
-  protected $dataSchemaTables;
-
-  /**
-   * If true remove all column information from config file.
-   *
-   * @var boolean
-   */
-  private $pruneOption;
-
-  //--------------------------------------------------------------------------------------------------------------------
-  /**
-   * Compares the tables listed in the config file and the tables found in the audit schema
-   *
-   * @param string  $tableName Name of table
-   * @param Columns $columns   The table columns.
-   */
-  public function getColumns($tableName, $columns)
-  {
+    //--------------------------------------------------------------------------------------------------------------------
+    /**
+     * All tables in the in the audit schema.
+     *
+     * @var array
+     */
+    protected $auditSchemaTables;
+
+    /**
+     * Array of tables from data schema.
+     *
+     * @var array
+     */
+    protected $dataSchemaTables;
+
+    /**
+     * If true remove all column information from config file.
+     *
+     * @var boolean
+     */
+    private $pruneOption;
+
+    //--------------------------------------------------------------------------------------------------------------------
+    /**
+     * Compares the tables listed in the config file and the tables found in the audit schema
+     *
+     * @param string  $tableName Name of table
+     * @param Columns $columns   The table columns.
+     */
+    public function getColumns($tableName, $columns)
+    {
     $newColumns = [];
     foreach ($columns->getColumns() as $column)
     {
-      $newColumns[] = ['column_name' => $column['column_name'],
-                       'column_type' => $column['column_type']];
+        $newColumns[] = ['column_name' => $column['column_name'],
+                        'column_type' => $column['column_type']];
     }
     $this->config['table_columns'][$tableName] = $newColumns;
 
     if ($this->pruneOption)
     {
-      $this->config['table_columns'] = [];
+        $this->config['table_columns'] = [];
+    }
     }
-  }
-
-  //--------------------------------------------------------------------------------------------------------------------
-  /**
-   * Getting list of all tables from information_schema of database from config file.
-   */
-  public function listOfTables()
-  {
+
+    //--------------------------------------------------------------------------------------------------------------------
+    /**
+     * Getting list of all tables from information_schema of database from config file.
+     */
+    public function listOfTables()
+    {
     $this->dataSchemaTables = DataLayer::getTablesNames($this->config['database']['data_schema']);
 
     $this->auditSchemaTables = DataLayer::getTablesNames($this->config['database']['audit_schema']);
-  }
-
-  //--------------------------------------------------------------------------------------------------------------------
-  /**
-   * Found tables in config file
-   *
-   * Compares the tables listed in the config file and the tables found in the data schema
-   */
-  public function unknownTables()
-  {
+    }
+
+    //--------------------------------------------------------------------------------------------------------------------
+    /**
+     * Found tables in config file
+     *
+     * Compares the tables listed in the config file and the tables found in the data schema
+     */
+    public function unknownTables()
+    {
     foreach ($this->dataSchemaTables as $table)
     {
-      if (isset($this->config['tables'][$table['table_name']]))
-      {
+        if (isset($this->config['tables'][$table['table_name']]))
+        {
         if (!isset($this->config['tables'][$table['table_name']]['audit']))
         {
-          $this->io->writeln(sprintf('<info>AuditApplication flag is not set in table %s</info>', $table['table_name']));
+            $this->io->writeln(sprintf('<info>AuditApplication flag is not set in table %s</info>', $table['table_name']));
         }
         else
         {
-          if ($this->config['tables'][$table['table_name']]['audit'])
-          {
+            if ($this->config['tables'][$table['table_name']]['audit'])
+            {
             if(!isset($this->config['tables'][$table['table_name']]['alias']))
             {
-              $this->config['tables'][$table['table_name']]['alias'] = Table::getRandomAlias();
+                $this->config['tables'][$table['table_name']]['alias'] = Table::getRandomAlias();
+            }
             }
-          }
         }
-      }
-      else
-      {
+        }
+        else
+        {
         $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];
+        }
+    }
     }
-  }
-
-  //--------------------------------------------------------------------------------------------------------------------
-  /**
-   * {@inheritdoc}
-   */
-  protected function configure()
-  {
+
+    //--------------------------------------------------------------------------------------------------------------------
+    /**
+     * {@inheritdoc}
+     */
+    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', 'etc/audit.json');
-  }
-
-  //--------------------------------------------------------------------------------------------------------------------
-  /**
-   * {@inheritdoc}
-   */
-  protected function execute(InputInterface $input, OutputInterface $output)
-  {
+            ->setDescription('Create (missing) audit table and (re)creates audit triggers')
+            ->addArgument('config file', InputArgument::OPTIONAL, 'The audit configuration file', 'etc/audit.json');
+    }
+
+    //--------------------------------------------------------------------------------------------------------------------
+    /**
+     * {@inheritdoc}
+     */
+    protected function execute(InputInterface $input, OutputInterface $output)
+    {
     $this->io = new StratumStyle($input, $output);
 
     $this->configFileName = $input->getArgument('config file');
@@ -141,52 +141,52 @@ 
 
     foreach ($this->dataSchemaTables as $table)
     {
-      if ($this->config['tables'][$table['table_name']]['audit'])
-      {
+        if ($this->config['tables'][$table['table_name']]['audit'])
+        {
         $tableColumns = [];
         if (isset($this->config['table_columns'][$table['table_name']]))
         {
-          $tableColumns = $this->config['table_columns'][$table['table_name']];
+            $tableColumns = $this->config['table_columns'][$table['table_name']];
         }
         $currentTable = new Table($this->io,
-                                  $table['table_name'],
-                                  $this->config['database']['data_schema'],
-                                  $this->config['database']['audit_schema'],
-                                  $tableColumns,
-                                  $this->config['audit_columns'],
-                                  $this->config['tables'][$table['table_name']]['alias'],
-                                  $this->config['tables'][$table['table_name']]['skip']);
+                                    $table['table_name'],
+                                    $this->config['database']['data_schema'],
+                                    $this->config['database']['audit_schema'],
+                                    $tableColumns,
+                                    $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);
         if (!isset($res))
         {
-          $currentTable->createMissingAuditTable();
+            $currentTable->createMissingAuditTable();
         }
 
         $columns        = $currentTable->main($this->config['additional_sql']);
         $alteredColumns = $columns['altered_columns']->getColumns();
         if (empty($alteredColumns))
         {
-          $this->getColumns($currentTable->getTableName(), $columns['full_columns']);
+            $this->getColumns($currentTable->getTableName(), $columns['full_columns']);
+        }
         }
-      }
     }
 
     // Drop database connection
     DataLayer::disconnect();
 
     $this->rewriteConfig();
-  }
-
-  //--------------------------------------------------------------------------------------------------------------------
-  /**
-   * Write new data to config file.
-   */
-  private function rewriteConfig()
-  {
+    }
+
+    //--------------------------------------------------------------------------------------------------------------------
+    /**
+     * Write new data to config file.
+     */
+    private function rewriteConfig()
+    {
     $this->writeTwoPhases($this->configFileName, json_encode($this->config, JSON_PRETTY_PRINT));
-  }
+    }
 
-  //--------------------------------------------------------------------------------------------------------------------
+    //--------------------------------------------------------------------------------------------------------------------
 }
 
 //----------------------------------------------------------------------------------------------------------------------

Spacing +2 added lines, -2 removed lines

@@ -93,7 +93,7 @@ 
         {
           if ($this->config['tables'][$table['table_name']]['audit'])
           {
-            if(!isset($this->config['tables'][$table['table_name']]['alias']))
+            if (!isset($this->config['tables'][$table['table_name']]['alias']))
             {
               $this->config['tables'][$table['table_name']]['alias'] = Table::getRandomAlias();
             }
@@ -156,7 +156,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();