hfw / db

bin/helix.db.migrate.php

Indentation +1 added lines, -10 removed lines

@@ -347,13 +347,4 @@
              */
             public function down(\$schema)
             {
-        {$down}
-            }
-
-        };
-
-        MIGRATION
-        );
-    }
-
-})->_exec();
+        {$down}
\ No newline at end of file

Switch Indentation +1 added lines, -10 removed lines

@@ -347,13 +347,4 @@
              */
             public function down(\$schema)
             {
-        {$down}
-            }
-
-        };
-
-        MIGRATION
-        );
-    }
-
-})->_exec();
+        {$down}
\ No newline at end of file

Spacing +1 added lines, -10 removed lines

@@ -347,13 +347,4 @@
              */
             public function down(\$schema)
             {
-        {$down}
-            }
-
-        };
-
-        MIGRATION
-        );
-    }
-
-})->_exec();
+        {$down}
\ No newline at end of file

Braces +1 added lines, -10 removed lines

@@ -347,13 +347,4 @@
              */
             public function down(\$schema)
             {
-        {$down}
-            }
-
-        };
-
-        MIGRATION
-        );
-    }
-
-})->_exec();
+        {$down}
\ No newline at end of file

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

@@ -347,13 +347,4 @@
              */
             public function down(\$schema)
             {
-        {$down}
-            }
-
-        };
-
-        MIGRATION
-        );
-    }
-
-})->_exec();
+        {$down}
\ No newline at end of file

src/DB.php

Spacing +3 added lines, -3 removed lines

@@ -131,7 +131,7 @@ 
      */
     public static function slots(array $columns): array
     {
-        return array_combine($columns, array_map(function (string $column) {
+        return array_combine($columns, array_map(function(string $column) {
             return ':' . str_replace('.', '__', $column);
         }, $columns));
     }
@@ -175,7 +175,7 @@ 
             $this->exec("SET time_zone = 'UTC'");
         } elseif ($this->isSQLite()) {
             // polyfill sqlite functions
-            $this->sqliteCreateFunctions([ // deterministic functions
+            $this->sqliteCreateFunctions([// deterministic functions
                 // https://www.sqlite.org/lang_mathfunc.html
                 'ACOS' => 'acos',
                 'ASIN' => 'asin',
@@ -201,7 +201,7 @@ 
                 'SIGN' => fn($x) => ($x > 0) - ($x < 0),
             ]);
 
-            $this->sqliteCreateFunctions([ // non-deterministic
+            $this->sqliteCreateFunctions([// non-deterministic
                 'RAND' => fn() => mt_rand() / mt_getrandmax(),
             ], false);
         }

src/DB/Migrator.php

Spacing +2 added lines, -2 removed lines

@@ -49,7 +49,7 @@ 
      */
     public function down(string $to = null): ?string
     {
-        return $this->db->transact(function () use ($to) {
+        return $this->db->transact(function() use ($to) {
             $current = $this->getCurrent();
             // walk newest to oldest
             foreach (array_reverse($this->glob(), true) as $sequence => $file) {
@@ -135,7 +135,7 @@ 
      */
     public function up(string $to = null): ?string
     {
-        return $this->db->transact(function () use ($to) {
+        return $this->db->transact(function() use ($to) {
             $current = $this->getCurrent();
             // walk oldest to newest
             foreach ($this->glob() as $sequence => $file) {

src/DB/EAV.php

Spacing +3 added lines, -3 removed lines

@@ -39,7 +39,7 @@ 
      */
     public function exists(int $id, string $attribute): bool
     {
-        $statement = $this->cache(__FUNCTION__, function () {
+        $statement = $this->cache(__FUNCTION__, function() {
             return $this->select(['COUNT(*) > 0'])->where('entity = ? AND attribute = ?')->prepare();
         });
         $exists = (bool)$statement([$id, $attribute])->fetchColumn();
@@ -89,7 +89,7 @@ 
      */
     public function load(int $id): array
     {
-        $statement = $this->cache(__FUNCTION__, function () {
+        $statement = $this->cache(__FUNCTION__, function() {
             $select = $this->select(['attribute', 'value']);
             $select->where('entity = ?');
             $select->order('attribute');
@@ -151,7 +151,7 @@ 
         }
 
         // upsert each
-        $statement = $this->cache(__FUNCTION__, function () {
+        $statement = $this->cache(__FUNCTION__, function() {
             if ($this->db->isSQLite()) {
                 return $this->db->prepare(
                     "INSERT INTO {$this} (entity,attribute,value) VALUES (?,?,?)"

src/DB/Column.php

Spacing +1 added lines, -1 removed lines

@@ -136,7 +136,7 @@
     public function select()
     {
         return Select::factory($this->db, $this->qualifier, [$this->name])
-            ->setFetcher(function (Statement $statement) {
+            ->setFetcher(function(Statement $statement) {
                 while (false !== $value = $statement->fetchColumn()) {
                     yield $value;
                 }

src/DB/Record.php

Spacing +4 added lines, -4 removed lines

@@ -488,7 +488,7 @@ 
      */
     public function load(int $id)
     {
-        $statement = $this->cache(__FUNCTION__, function () {
+        $statement = $this->cache(__FUNCTION__, function() {
             return $this->select()->where('id = ?')->prepare();
         });
         $values = $statement([$id])->fetch();
@@ -509,7 +509,7 @@ 
      */
     public function loadAll()
     {
-        return $this->select()->setFetcher(function (Statement $statement) {
+        return $this->select()->setFetcher(function(Statement $statement) {
             yield from $this->fetchEach($statement);
         });
     }
@@ -568,7 +568,7 @@ 
      */
     protected function saveInsert(EntityInterface $entity): void
     {
-        $statement = $this->cache(__FUNCTION__, function () {
+        $statement = $this->cache(__FUNCTION__, function() {
             $slots = $this->db->slots(array_keys($this->columns));
             unset($slots['id']);
             $columns = implode(',', array_keys($slots));
@@ -588,7 +588,7 @@ 
      */
     protected function saveUpdate(EntityInterface $entity): void
     {
-        $statement = $this->cache(__FUNCTION__, function () {
+        $statement = $this->cache(__FUNCTION__, function() {
             $slots = $this->db->slotsEqual(array_keys($this->columns));
             unset($slots['id']);
             $slots = implode(', ', $slots);

src/DB/Schema.php

Spacing +4 added lines, -4 removed lines

@@ -144,16 +144,16 @@ 
         // bool
         'BOOLEAN' => 'bool',
         // int
-        'BIGINT' => 'int',  // mysql
+        'BIGINT' => 'int', // mysql
         'INTEGER' => 'int', // sqlite (must be this type to allow AUTOINCREMENT)
         // float
         'DOUBLE PRECISION' => 'float',
         // string <= 255
         'VARCHAR(255)' => 'string',
         // string <= 64k
-        'TEXT' => 'String',     // @var String
+        'TEXT' => 'String', // @var String
         // string > 64k
-        'BLOB' => 'STRING',     // @var STRING (sqlite)
+        'BLOB' => 'STRING', // @var STRING (sqlite)
         'LONGBLOB' => 'STRING', // @var STRING (mysql)
         // DateTime
         'DATETIME' => 'DateTime',
@@ -456,7 +456,7 @@ 
      */
     protected function sortColumns(array $types): array
     {
-        uksort($types, function (string $a, string $b) use ($types) {
+        uksort($types, function(string $a, string $b) use ($types) {
             // descending type constant, ascending name
             return $types[$b] <=> $types[$a] ?: $a <=> $b;
         });

src/DB/Fluent/Choice.php

Braces +3 added lines, -1 removed lines

@@ -90,9 +90,11 @@
      * @param string|ValueInterface $else
      * @return $this
      */
-    public function else($else)
+    public function else {
+        ($else)
     {
         $this->else = isset($else) ? $this->db->quote($else) : null;
+    }
         return $this;
     }
 

src/DB/Fluent/Value/ComparisonTrait.php

Spacing +1 added lines, -1 removed lines

@@ -322,7 +322,7 @@
      * @param array $values `[when => then]`
      * @return Choice
      */
-    public function switch(array $values = [])
+    public function switch (array $values = [])
     {
         return Choice::factory($this->db, "{$this}", $values);
     }