projectmentor / laravel-quota

src/Console/Commands/ResetQuotaLog.php

Switch Indentation +56 added lines, -56 removed lines

@@ -50,66 +50,66 @@
     {
         switch(DB::connection()->getPDO()->getAttribute(\PDO::ATTR_DRIVER_NAME))
         {
-        case 'mysql':
-
-            $sql = 'INSERT INTO quotalog' .
-                ' (date, connection, hits, misses, created_at, updated_at)' .
-                ' VALUES' .
-                ' ( :date, :connection, :hits, :misses, :created_at, :updated_at)' .
-                ' ON DUPLICATE KEY UPDATE' .
-                ' hits = VALUES(hits),' .
-                ' misses = VALUES(misses),' .
-                ' updated_at = VALUES(updated_at)';
-
-            $this->doUpsertStatement($sql);
-
-            break;
-        case 'sqlite':
-
-            $date = $this->argument('date');
-            $connection = $this->argument('connection');
-
-            $sql = 'UPDATE quotalog' .
-                ' SET `date` = :date' .
-                ', `connection` = :connection' .
-                ', `hits` = :hits' . 
-                ', `misses` = :misses' .
-                ', `updated_at` = :updated_at' .
-                ' WHERE `date` = ' . '\''. $date . '\'' .
-                ' AND `connection` = ' . '\'' . $connection . '\'';
-
-            $this->doUpdateStatement($sql);
-
-            $changes = DB::select('SELECT changes()');
-            if(! $this->sqliteUpdateDidChange($changes))
-            {
+            case 'mysql':
+
                 $sql = 'INSERT INTO quotalog' .
-                  ' (' .
-                  ' `date`' .
-                  ', `connection`' .
-                  ', `hits`' .
-                  ', `misses`' .
-                  ', `created_at`' .
-                  ', `updated_at`' .
-                  ')' . 
-                  ' VALUES' .
-                  ' (' . 
-                  ' :date' .
-                  ', :connection' .
-                  ', :hits' .
-                  ', :misses' .
-                  ', :created_at' .  
-                  ', :updated_at' .
-                  ')';
+                    ' (date, connection, hits, misses, created_at, updated_at)' .
+                    ' VALUES' .
+                    ' ( :date, :connection, :hits, :misses, :created_at, :updated_at)' .
+                    ' ON DUPLICATE KEY UPDATE' .
+                    ' hits = VALUES(hits),' .
+                    ' misses = VALUES(misses),' .
+                    ' updated_at = VALUES(updated_at)';
 
                 $this->doUpsertStatement($sql);
-            }
-            break;
 
-        default:
-            throw new \ErrorException(
-                __CLASS__.'::'.__FUNCTION__.
-                ' Driver: ' . $driver . ' not supported.');
+                break;
+            case 'sqlite':
+
+                $date = $this->argument('date');
+                $connection = $this->argument('connection');
+
+                $sql = 'UPDATE quotalog' .
+                    ' SET `date` = :date' .
+                    ', `connection` = :connection' .
+                    ', `hits` = :hits' . 
+                    ', `misses` = :misses' .
+                    ', `updated_at` = :updated_at' .
+                    ' WHERE `date` = ' . '\''. $date . '\'' .
+                    ' AND `connection` = ' . '\'' . $connection . '\'';
+
+                $this->doUpdateStatement($sql);
+
+                $changes = DB::select('SELECT changes()');
+                if(! $this->sqliteUpdateDidChange($changes))
+                {
+                    $sql = 'INSERT INTO quotalog' .
+                      ' (' .
+                      ' `date`' .
+                      ', `connection`' .
+                      ', `hits`' .
+                      ', `misses`' .
+                      ', `created_at`' .
+                      ', `updated_at`' .
+                      ')' . 
+                      ' VALUES' .
+                      ' (' . 
+                      ' :date' .
+                      ', :connection' .
+                      ', :hits' .
+                      ', :misses' .
+                      ', :created_at' .  
+                      ', :updated_at' .
+                      ')';
+
+                    $this->doUpsertStatement($sql);
+                }
+                break;
+
+            default:
+                throw new \ErrorException(
+                    __CLASS__.'::'.__FUNCTION__.
+                    ' Driver: ' . $driver . ' not supported.');
         }
     }