hfw / db

bin/helix.db.migrate.php

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

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/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/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);
     }

src/DB/Select.php

Spacing +2 added lines, -2 removed lines

@@ -144,7 +144,7 @@ 
         }
         $this->table = $table;
         $this->setColumns($columns);
-        $this->fetcher = function (Statement $statement) {
+        $this->fetcher = function(Statement $statement) {
             yield from $statement;
         };
     }
@@ -314,7 +314,7 @@ 
         if ($this->db->isMySQL()) {
             // to be standards compliant, this hack must fail if they don't have the same cols.
             assert(count($this->refs) === count($select->refs) and !array_diff_key($this->refs, $select->refs));
-            $this->join($select, ...array_map(function (string $alias, Column $ref) {
+            $this->join($select, ...array_map(function(string $alias, Column $ref) {
                 return $ref->is($this->refs[$alias]);
             }, array_keys($select->refs), $select->refs));
             return $this;

src/DB/Junction.php

Spacing +1 added lines, -1 removed lines

@@ -119,7 +119,7 @@
      */
     public function link(array $ids): int
     {
-        $statement = $this->cache(__FUNCTION__, function () {
+        $statement = $this->cache(__FUNCTION__, function() {
             $columns = implode(',', array_keys($this->columns));
             $slots = implode(',', $this->db->slots(array_keys($this->columns)));
             if ($this->db->isSQLite()) {

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
             ]);
 
-            $this->sqliteCreateFunctions([ // non-deterministic
+            $this->sqliteCreateFunctions([// non-deterministic
                 'RAND' => fn() => mt_rand() / mt_getrandmax(),
             ], false);
         }