hfw / db

src/DB/Junction.php

Braces +1 added lines, -2 removed lines

@@ -35,8 +35,7 @@
         $this->interface = $interface;
         try {
             $interface = new ReflectionClass($interface);
-        }
-        catch (ReflectionException $exception) {
+        } catch (ReflectionException $exception) {
             throw new LogicException('Unexpected ReflectionException', 0, $exception);
         }
         $doc = $interface->getDocComment();

Spacing +9 added lines, -9 removed lines

@@ -31,7 +31,7 @@ 
      * @param DB $db
      * @param string $interface
      */
-    public function __construct (DB $db, string $interface) {
+    public function __construct(DB $db, string $interface) {
         $this->interface = $interface;
         try {
             $interface = new ReflectionClass($interface);
@@ -57,7 +57,7 @@ 
      * @param EntityInterface $entity
      * @return int
      */
-    public function count (EntityInterface $entity): int {
+    public function count(EntityInterface $entity): int {
         $key = $this->getKey($entity);
         return $this->cache("count.{$key}", function() use ($key) {
             return $this->select(['COUNT(*)'])->where("{$key} = ?")->prepare();
@@ -73,7 +73,7 @@ 
      * @param string $class
      * @return Select
      */
-    public function getCollection (EntityInterface $owner, string $class): Select {
+    public function getCollection(EntityInterface $owner, string $class): Select {
         $record = $this->db->getRecord($class);
         $select = $record->select();
         $select->join($this, $this[$class]->isEqual($record['id']));
@@ -84,7 +84,7 @@ 
     /**
      * @return string
      */
-    final public function getInterface (): string {
+    final public function getInterface(): string {
         return $this->interface;
     }
 
@@ -94,7 +94,7 @@ 
      * @param EntityInterface|string $class
      * @return string
      */
-    public function getKey ($class): string {
+    public function getKey($class): string {
         if (is_object($class)) {
             $class = get_class($class);
         }
@@ -112,7 +112,7 @@ 
      * @param EntityInterface[] $entities
      * @return int Rows affected.
      */
-    public function link (array $entities): int {
+    public function link(array $entities): int {
         $ids = array_fill_keys($this->keys, null);
         foreach ($entities as $entity) {
             $ids[$this->getKey($entity)] = $entity->getId();
@@ -133,7 +133,7 @@ 
      * @param string $name
      * @return bool
      */
-    public function offsetExists ($name): bool {
+    public function offsetExists($name): bool {
         return isset($this->columns[$name]) or isset($this->keys[$name]);
     }
 
@@ -143,7 +143,7 @@ 
      * @param string $name
      * @return Column
      */
-    public function offsetGet ($name): Column {
+    public function offsetGet($name): Column {
         return $this->columns[$name] ?? $this->columns[$this->keys[$name]];
     }
 
@@ -156,7 +156,7 @@ 
      * @param EntityInterface[] $entities
      * @return int Rows affected.
      */
-    public function unlink (array $entities): int {
+    public function unlink(array $entities): int {
         $ids = array_fill_keys($this->keys, null);
         foreach ($entities as $entity) {
             $ids[$this->getKey($entity)] = $entity->getId();

src/DB/Column.php

Braces +1 added lines, -2 removed lines

@@ -70,8 +70,7 @@
     public function is ($arg): string {
         if ($arg === null or is_bool($arg)) {
             $arg = ['' => 'NULL', 1 => 'TRUE', 0 => 'FALSE'][$arg];
-        }
-        else {
+        } else {
             $arg = $this->db->quote($arg);
         }
         $operator = ['mysql' => '<=>', 'sqlite' => 'IS'][$this->db->getDriver()];

Spacing +20 added lines, -20 removed lines

@@ -34,7 +34,7 @@ 
      * @param string $name
      * @param string $qualifier
      */
-    public function __construct (DB $db, string $name, string $qualifier = '') {
+    public function __construct(DB $db, string $name, string $qualifier = '') {
         parent::__construct($db);
         $this->name = $name;
         $this->qualifier = $qualifier;
@@ -50,7 +50,7 @@ 
      * @param array $arguments
      * @return ExpressionInterface
      */
-    public function __call (string $name, array $arguments): ExpressionInterface {
+    public function __call(string $name, array $arguments): ExpressionInterface {
         array_push($arguments, $this);
         return Expression::__callStatic($name, $arguments);
     }
@@ -60,7 +60,7 @@ 
      *
      * @return string
      */
-    public function __toString (): string {
+    public function __toString(): string {
         if (strlen($this->qualifier)) {
             return "{$this->qualifier}.{$this->name}";
         }
@@ -70,14 +70,14 @@ 
     /**
      * @return string
      */
-    final public function getName (): string {
+    final public function getName(): string {
         return $this->name;
     }
 
     /**
      * @return string
      */
-    final public function getQualifier (): string {
+    final public function getQualifier(): string {
         return $this->qualifier;
     }
 
@@ -90,7 +90,7 @@ 
      * @param null|bool|string|Select $arg
      * @return string
      */
-    public function is ($arg): string {
+    public function is($arg): string {
         if ($arg === null or is_bool($arg)) {
             $arg = ['' => 'NULL', 1 => 'TRUE', 0 => 'FALSE'][$arg];
         }
@@ -107,7 +107,7 @@ 
      * @param string|array|Select $arg
      * @return string
      */
-    public function isEqual ($arg): string {
+    public function isEqual($arg): string {
         return SQL::isEqual($this, $this->db->quote($arg));
     }
 
@@ -117,7 +117,7 @@ 
      * @param string|Select $arg
      * @return string
      */
-    public function isGreater ($arg): string {
+    public function isGreater($arg): string {
         return SQL::isGreater($this, $this->db->quote($arg));
     }
 
@@ -127,7 +127,7 @@ 
      * @param string|Select $arg
      * @return string
      */
-    public function isGreaterOrEqual ($arg): string {
+    public function isGreaterOrEqual($arg): string {
         return SQL::isGreaterOrEqual($this, $this->db->quote($arg));
     }
 
@@ -137,7 +137,7 @@ 
      * @param string|Select $arg
      * @return string
      */
-    public function isLess ($arg): string {
+    public function isLess($arg): string {
         return SQL::isLess($this, $this->db->quote($arg));
     }
 
@@ -147,7 +147,7 @@ 
      * @param string|Select $arg
      * @return string
      */
-    public function isLessOrEqual ($arg): string {
+    public function isLessOrEqual($arg): string {
         return SQL::isLessOrEqual($this, $this->db->quote($arg));
     }
 
@@ -157,7 +157,7 @@ 
      * @param string $pattern
      * @return string
      */
-    public function isLike (string $pattern): string {
+    public function isLike(string $pattern): string {
         return SQL::isLike($this, $this->db->quote($pattern));
     }
 
@@ -169,7 +169,7 @@ 
      * @param null|bool|string|Select $arg
      * @return string
      */
-    public function isNot ($arg): string {
+    public function isNot($arg): string {
         return SQL::not($this->is($arg));
     }
 
@@ -179,7 +179,7 @@ 
      * @param string|array|Select $arg
      * @return string
      */
-    public function isNotEqual ($arg): string {
+    public function isNotEqual($arg): string {
         return SQL::isNotEqual($this, $this->db->quote($arg));
     }
 
@@ -189,7 +189,7 @@ 
      * @param string $pattern
      * @return string
      */
-    public function isNotLike (string $pattern): string {
+    public function isNotLike(string $pattern): string {
         return SQL::isNotLike($this, $this->db->quote($pattern));
     }
 
@@ -198,7 +198,7 @@ 
      *
      * @return string
      */
-    public function isNotNull (): string {
+    public function isNotNull(): string {
         return SQL::isNotNull($this);
     }
 
@@ -208,7 +208,7 @@ 
      * @param string $pattern
      * @return string
      */
-    public function isNotRegExp (string $pattern): string {
+    public function isNotRegExp(string $pattern): string {
         return SQL::isNotRegExp($this, $this->db->quote($pattern));
     }
 
@@ -218,7 +218,7 @@ 
      * @param string $pattern
      * @return string
      */
-    public function isRegExp (string $pattern): string {
+    public function isRegExp(string $pattern): string {
         return SQL::isRegExp($this, $this->db->quote($pattern));
     }
 
@@ -226,7 +226,7 @@ 
      * @param string $name
      * @return $this
      */
-    public function setName (string $name) {
+    public function setName(string $name) {
         $clone = clone $this;
         $clone->name = $name;
         return $clone;
@@ -236,7 +236,7 @@ 
      * @param string $qualifier
      * @return $this
      */
-    public function setQualifier (string $qualifier) {
+    public function setQualifier(string $qualifier) {
         $clone = clone $this;
         $clone->qualifier = $qualifier;
         return $clone;

src/DB/AttributesTrait.php

Spacing +6 added lines, -6 removed lines

@@ -22,7 +22,7 @@ 
     /**
      * @return array
      */
-    public function getAttributes (): array {
+    public function getAttributes(): array {
         return $this->attributes ?: [];
     }
 
@@ -30,7 +30,7 @@ 
      * @param mixed $offset
      * @return bool
      */
-    public function offsetExists ($offset): bool {
+    public function offsetExists($offset): bool {
         return $this->attributes and array_key_exists($offset, $this->attributes);
     }
 
@@ -38,7 +38,7 @@ 
      * @param mixed $offset
      * @return mixed Returns `NULL` for nonexistent attributes.
      */
-    public function offsetGet ($offset) {
+    public function offsetGet($offset) {
         return $this->attributes[$offset] ?? null;
     }
 
@@ -46,14 +46,14 @@ 
      * @param mixed $offset
      * @param mixed $value
      */
-    public function offsetSet ($offset, $value): void {
+    public function offsetSet($offset, $value): void {
         $this->attributes[$offset] = $value;
     }
 
     /**
      * @param mixed $offset
      */
-    public function offsetUnset ($offset): void {
+    public function offsetUnset($offset): void {
         unset($this->attributes[$offset]);
     }
 
@@ -61,7 +61,7 @@ 
      * @param array $attributes
      * @return $this
      */
-    public function setAttributes (array $attributes) {
+    public function setAttributes(array $attributes) {
         $this->attributes = $attributes;
         return $this;
     }

src/DB/EntityInterface.php

Spacing +1 added lines, -1 removed lines

@@ -10,5 +10,5 @@
     /**
      * @return int
      */
-    public function getId ();
+    public function getId();
 }
\ No newline at end of file

src/DB/AbstractAccess.php

Spacing +2 added lines, -2 removed lines

@@ -25,7 +25,7 @@ 
     /**
      * @param DB $db
      */
-    public function __construct (DB $db) {
+    public function __construct(DB $db) {
         $this->db = $db;
     }
 
@@ -36,7 +36,7 @@ 
      * @param Closure $prepare `():Statement`
      * @return Statement
      */
-    protected function cache (string $key, Closure $prepare): Statement {
+    protected function cache(string $key, Closure $prepare): Statement {
         return $this->_cache[$key] ?? $this->_cache[$key] = $prepare->__invoke();
     }
 

src/DB/Table.php

Spacing +11 added lines, -11 removed lines

@@ -30,7 +30,7 @@ 
      * @param string $name
      * @param string[] $columns
      */
-    public function __construct (DB $db, $name, array $columns) {
+    public function __construct(DB $db, $name, array $columns) {
         parent::__construct($db);
         $this->name = $name;
         foreach ($columns as $column) {
@@ -43,7 +43,7 @@ 
      *
      * @return string
      */
-    final public function __toString (): string {
+    final public function __toString(): string {
         return $this->name;
     }
 
@@ -55,7 +55,7 @@ 
      * @param array $match
      * @return int Rows affected.
      */
-    public function delete (array $match): int {
+    public function delete(array $match): int {
         $match = SQL::all($this->db->match($match));
         return $this->db->exec("DELETE FROM {$this} WHERE {$match}");
     }
@@ -63,14 +63,14 @@ 
     /**
      * @return Column[]
      */
-    final public function getColumns (): array {
+    final public function getColumns(): array {
         return $this->columns;
     }
 
     /**
      * @return string
      */
-    final public function getName (): string {
+    final public function getName(): string {
         return $this->name;
     }
 
@@ -80,7 +80,7 @@ 
      * @param array $values
      * @return int Insertion ID.
      */
-    public function insert (array $values): int {
+    public function insert(array $values): int {
         $columns = implode(',', array_keys($values));
         $values = implode(',', $this->db->quote($values));
         $this->db->exec("INSERT INTO {$this} ($columns) VALUES ($values)");
@@ -91,7 +91,7 @@ 
      * @param string $name
      * @return bool
      */
-    public function offsetExists ($name): bool {
+    public function offsetExists($name): bool {
         return isset($this->columns[$name]);
     }
 
@@ -99,7 +99,7 @@ 
      * @param string $name
      * @return Column
      */
-    public function offsetGet ($name): Column {
+    public function offsetGet($name): Column {
         return $this->columns[$name];
     }
 
@@ -109,7 +109,7 @@ 
      * @param string[] $columns Defaults to all columns.
      * @return Select
      */
-    public function select (array $columns = []): Select {
+    public function select(array $columns = []): Select {
         if (!$columns) {
             $columns = $this->columns;
         }
@@ -122,7 +122,7 @@ 
      * @param string $name
      * @return Table
      */
-    public function setName (string $name) {
+    public function setName(string $name) {
         $clone = clone $this;
         $clone->name = $name;
         foreach ($this->columns as $name => $column) {
@@ -140,7 +140,7 @@ 
      * @param array $match
      * @return int Rows affected.
      */
-    public function update (array $values, array $match): int {
+    public function update(array $values, array $match): int {
         $values = implode(', ', SQL::isEqual($this->db->quote($values)));
         $match = SQL::all($this->db->match($match));
         return $this->db->exec("UPDATE {$this} SET {$values} WHERE {$match}");

src/DB/EAV.php

Spacing +7 added lines, -7 removed lines

@@ -18,7 +18,7 @@ 
      * @param Record $record The entity's storage access.
      * @param $name
      */
-    public function __construct (Record $record, $name) {
+    public function __construct(Record $record, $name) {
         $this->record = $record;
         parent::__construct($record->db, $name, ['entity', 'attribute', 'value']);
     }
@@ -29,7 +29,7 @@ 
      * @param int $id
      * @return int
      */
-    public function count (int $id): int {
+    public function count(int $id): int {
         return $this->cache(__FUNCTION__, function() {
             return $this->select(['COUNT(*)'])->where('entity=?')->prepare();
         })->execute([$id])->fetchColumn();
@@ -42,7 +42,7 @@ 
      * @param string $attribute
      * @return bool
      */
-    public function exists (int $id, string $attribute): bool {
+    public function exists(int $id, string $attribute): bool {
         return $this->cache(__FUNCTION__, function() {
             return $this->select(['COUNT(*) > 0'])->where('entity = ? AND attribute = ?')->prepare();
         })->execute([$id, $attribute])->fetchColumn();
@@ -57,7 +57,7 @@ 
      * @param array $match `[attribute => value]`. If empty, selects all IDs for entities having at least one attribute.
      * @return Select
      */
-    public function find (array $match): Select {
+    public function find(array $match): Select {
         $select = $this->select([$this['entity']]);
         $prior = $this;
         foreach ($match as $attribute => $value) {
@@ -79,7 +79,7 @@ 
      * @param int $id
      * @return array `[attribute => value]`
      */
-    public function load (int $id): array {
+    public function load(int $id): array {
         return $this->cache(__FUNCTION__, function() {
             return $this->select(['attribute', 'value'])->where('entity = ?')->prepare();
         })->execute([$id])->fetchAll(DB::FETCH_KEY_PAIR);
@@ -91,7 +91,7 @@ 
      * @param int[] $ids
      * @return array[] `[id => attribute => value]
      */
-    public function loadAll (array $ids): array {
+    public function loadAll(array $ids): array {
         if (count($ids) === 1) {
             return [current($ids) => $this->load(current($ids))];
         }
@@ -111,7 +111,7 @@ 
      * @param array $values `[attribute => value]`
      * @return $this
      */
-    public function save (int $id, array $values) {
+    public function save(int $id, array $values) {
         $this->delete([
             $this['entity']->isEqual($id),
             $this['attribute']->isNotEqual(array_keys($values))

src/DB/Statement.php

Spacing +4 added lines, -4 removed lines

@@ -21,7 +21,7 @@ 
      *
      * @param DB $db
      */
-    protected function __construct (DB $db) {
+    protected function __construct(DB $db) {
         $this->db = $db;
     }
 
@@ -30,7 +30,7 @@ 
      *
      * @return string
      */
-    public function __toString () {
+    public function __toString() {
         return $this->queryString;
     }
 
@@ -44,7 +44,7 @@ 
      * @return $this
      * @throws ArgumentCountError
      */
-    public function execute ($args = null) {
+    public function execute($args = null) {
         $this->db->getLogger()->__invoke($this->queryString);
         if (!parent::execute($args)) {
             $info = $this->errorInfo();
@@ -61,7 +61,7 @@ 
      *
      * @return int
      */
-    public function getId (): int {
+    public function getId(): int {
         return $this->db->lastInsertId();
     }
 }

src/DB/AbstractTable.php

Spacing +5 added lines, -5 removed lines

@@ -15,19 +15,19 @@ 
      *
      * @return string
      */
-    abstract public function __toString (): string;
+    abstract public function __toString(): string;
 
     /**
      * @param string $name
      * @return bool
      */
-    abstract public function offsetExists ($name): bool;
+    abstract public function offsetExists($name): bool;
 
     /**
      * @param string $name
      * @return Column
      */
-    abstract public function offsetGet ($name): Column;
+    abstract public function offsetGet($name): Column;
 
     /**
      * Throws.
@@ -36,7 +36,7 @@ 
      * @param void $value
      * @throws Exception
      */
-    final public function offsetSet ($name, $value): void {
+    final public function offsetSet($name, $value): void {
         throw new Exception('Tables are immutable.');
     }
 
@@ -46,7 +46,7 @@ 
      * @param void $name
      * @throws Exception
      */
-    final public function offsetUnset ($name): void {
+    final public function offsetUnset($name): void {
         $this->offsetSet($name, null);
     }