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

Spacing +14 added lines, -14 removed lines

@@ -70,19 +70,19 @@ 
      */
     protected const SCALARS = [
         'bool' => 'bool',
-        'boolean' => 'bool',    // gettype()
-        'double' => 'float',    // gettype()
-        'false' => 'bool',      // @var
+        'boolean' => 'bool', // gettype()
+        'double' => 'float', // gettype()
+        'false' => 'bool', // @var
         'float' => 'float',
         'int' => 'int',
-        'integer' => 'int',     // gettype()
-        'NULL' => 'string',     // gettype()
-        'number' => 'string',   // @var
-        'scalar' => 'string',   // @var
+        'integer' => 'int', // gettype()
+        'NULL' => 'string', // gettype()
+        'number' => 'string', // @var
+        'scalar' => 'string', // @var
         'string' => 'string',
-        'String' => 'String',   // @var
-        'STRING' => 'STRING',   // @var
-        'true' => 'bool',       // @var
+        'String' => 'String', // @var
+        'STRING' => 'STRING', // @var
+        'true' => 'bool', // @var
     ];
 
     /**
@@ -493,7 +493,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();
@@ -514,7 +514,7 @@ 
      */
     public function loadAll()
     {
-        return $this->select()->setFetcher(function (Statement $statement) {
+        return $this->select()->setFetcher(function(Statement $statement) {
             yield from $this->fetchEach($statement);
         });
     }
@@ -573,7 +573,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));
@@ -593,7 +593,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);