hfw / db

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

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

src/DB/Record.php

Spacing +16 added lines, -16 removed lines

@@ -62,7 +62,7 @@ 
      * @param DB $db
      * @param string $class
      */
-    public function __construct (DB $db, string $class) {
+    public function __construct(DB $db, string $class) {
         $this->class = $class;
         try {
             $class = new ReflectionClass($class);
@@ -105,7 +105,7 @@ 
      * @param Statement $statement
      * @return EntityInterface[] Enumerated
      */
-    public function fetchAll (Statement $statement): array {
+    public function fetchAll(Statement $statement): array {
         $entities = [];
         foreach ($statement->fetchAll() as $row) {
             $clone = clone $this->proto;
@@ -125,7 +125,7 @@ 
      * @param array[] $eavMatch Additional `[eav property => attribute => mixed]`
      * @return Select
      */
-    public function find (array $match, array $eavMatch = []): Select {
+    public function find(array $match, array $eavMatch = []): Select {
         $select = $this->select();
         foreach ($match as $column => $value) {
             $select->where($this->db->match($column, $value));
@@ -140,7 +140,7 @@ 
     /**
      * @return string
      */
-    final public function getClass (): string {
+    final public function getClass(): string {
         return $this->class;
     }
 
@@ -148,14 +148,14 @@ 
      * @param string $property
      * @return EAV
      */
-    final public function getEav (string $property): EAV {
+    final public function getEav(string $property): EAV {
         return $this->eav[$property];
     }
 
     /**
      * @return EntityInterface
      */
-    public function getProto (): EntityInterface {
+    public function getProto(): EntityInterface {
         return $this->proto;
     }
 
@@ -163,7 +163,7 @@ 
      * @param EntityInterface $entity
      * @return array
      */
-    protected function getValues (EntityInterface $entity): array {
+    protected function getValues(EntityInterface $entity): array {
         $values = [];
         foreach (array_keys($this->columns) as $name) {
             $values[$name] = $this->properties[$name]->getValue($entity);
@@ -177,7 +177,7 @@ 
      * @param int $id
      * @return null|EntityInterface
      */
-    public function load (int $id): ?EntityInterface {
+    public function load(int $id): ?EntityInterface {
         $load = $this->cache(__FUNCTION__, function() {
             return $this->select()->where('id = ?')->prepare();
         })->execute([$id]);
@@ -195,7 +195,7 @@ 
      *
      * @param EntityInterface[] $entities
      */
-    protected function loadEav (array $entities): void {
+    protected function loadEav(array $entities): void {
         $ids = array_keys($entities);
         foreach ($this->eav as $name => $eav) {
             foreach ($eav->loadAll($ids) as $id => $values) {
@@ -210,7 +210,7 @@ 
      * @param EntityInterface $entity
      * @return int ID
      */
-    public function save (EntityInterface $entity): int {
+    public function save(EntityInterface $entity): int {
         if (!$entity->getId()) {
             $this->saveInsert($entity);
         }
@@ -224,7 +224,7 @@ 
     /**
      * @param EntityInterface $entity
      */
-    protected function saveEav (EntityInterface $entity): void {
+    protected function saveEav(EntityInterface $entity): void {
         $id = $entity->getId();
         foreach ($this->eav as $name => $eav) {
             $values = $this->properties[$name]->getValue($entity);
@@ -239,7 +239,7 @@ 
      *
      * @param EntityInterface $entity
      */
-    protected function saveInsert (EntityInterface $entity): void {
+    protected function saveInsert(EntityInterface $entity): void {
         $values = $this->getValues($entity);
         unset($values['id']);
         $insert = $this->cache(__FUNCTION__, function() {
@@ -257,7 +257,7 @@ 
      *
      * @param EntityInterface $entity
      */
-    protected function saveUpdate (EntityInterface $entity): void {
+    protected function saveUpdate(EntityInterface $entity): void {
         $this->cache(__FUNCTION__, function() {
             $slots = SQL::slots(array_keys($this->columns));
             unset($slots['id']);
@@ -272,7 +272,7 @@ 
      * @param array $columns Defaults to all columns.
      * @return Select
      */
-    public function select (array $columns = []): Select {
+    public function select(array $columns = []): Select {
         return parent::select($columns)->setFetcher(function(Statement $statement) {
             return $this->fetchAll($statement);
         });
@@ -282,7 +282,7 @@ 
      * @param EntityInterface $proto
      * @return $this
      */
-    public function setProto (EntityInterface $proto) {
+    public function setProto(EntityInterface $proto) {
         $this->proto = $proto;
         return $this;
     }
@@ -291,7 +291,7 @@ 
      * @param EntityInterface $entity
      * @param array $values
      */
-    protected function setValues (EntityInterface $entity, array $values): void {
+    protected function setValues(EntityInterface $entity, array $values): void {
         foreach ($values as $name => $value) {
             settype($value, $this->types[$name]);
             $this->properties[$name]->setValue($entity, $value);

src/DB/ExpressionInterface.php

Spacing +1 added lines, -1 removed lines

@@ -7,6 +7,6 @@
  */
 interface ExpressionInterface {
 
-    public function __toString ();
+    public function __toString();
 
 }
\ No newline at end of file

src/DB/Select.php

Spacing +20 added lines, -20 removed lines

@@ -79,7 +79,7 @@ 
      * @param string|Select $table
      * @param string[] $columns
      */
-    public function __construct (DB $db, $table, array $columns) {
+    public function __construct(DB $db, $table, array $columns) {
         parent::__construct($db);
         if ($table instanceof Select) {
             $table = $table->toSubquery();
@@ -95,7 +95,7 @@ 
     /**
      * Gives the clone a new alias.
      */
-    public function __clone () {
+    public function __clone() {
         $this->alias = uniqid('_') . "__{$this->table}";
     }
 
@@ -103,7 +103,7 @@ 
      * @param array $args
      * @return Statement
      */
-    public function __invoke (array $args = []): Statement {
+    public function __invoke(array $args = []): Statement {
         return $this->execute($args);
     }
 
@@ -112,7 +112,7 @@ 
      *
      * @return string
      */
-    public function __toString (): string {
+    public function __toString(): string {
         return $this->alias;
     }
 
@@ -122,7 +122,7 @@ 
      * @param array $args Execution arguments.
      * @return int
      */
-    public function count (array $args = []): int {
+    public function count(array $args = []): int {
         $clone = clone $this;
         $clone->columns = ['COUNT(*)'];
         return (int)$clone->execute($args)->fetchColumn();
@@ -134,7 +134,7 @@ 
      * @param array $args
      * @return Statement
      */
-    public function execute (array $args = []): Statement {
+    public function execute(array $args = []): Statement {
         if (!empty($args)) {
             return $this->prepare()->execute($args);
         }
@@ -149,7 +149,7 @@ 
      * @param array $args Execution arguments.
      * @return array
      */
-    public function fetchAll (array $args = []): array {
+    public function fetchAll(array $args = []): array {
         return $this->fetcher->__invoke($this->execute($args));
     }
 
@@ -160,7 +160,7 @@ 
      *
      * @return ArrayIterator
      */
-    public function getIterator () {
+    public function getIterator() {
         return new ArrayIterator($this->fetchAll());
     }
 
@@ -170,7 +170,7 @@ 
      * @param string $column
      * @return $this
      */
-    public function group (string $column) {
+    public function group(string $column) {
         $this->_group[] = $column;
         return $this;
     }
@@ -181,7 +181,7 @@ 
      * @param string $condition
      * @return $this
      */
-    public function having (string $condition) {
+    public function having(string $condition) {
         $this->_having[] = $condition;
         return $this;
     }
@@ -194,7 +194,7 @@ 
      * @param string $type
      * @return $this
      */
-    public function join ($table, string $condition, string $type = 'INNER') {
+    public function join($table, string $condition, string $type = 'INNER') {
         if ($table instanceof Select) {
             $table = $table->toSubquery();
         }
@@ -209,7 +209,7 @@ 
      * @param int $offset
      * @return $this
      */
-    public function limit (int $limit, int $offset = 0) {
+    public function limit(int $limit, int $offset = 0) {
         $this->_limit = $limit;
         $this->_offset = $offset;
         return $this;
@@ -221,7 +221,7 @@ 
      * @param string $name Name or alias if used.
      * @return bool
      */
-    public function offsetExists ($name): bool {
+    public function offsetExists($name): bool {
         return true;
     }
 
@@ -231,7 +231,7 @@ 
      * @param string $name Name, or alias if used.
      * @return Column
      */
-    public function offsetGet ($name): Column {
+    public function offsetGet($name): Column {
         return new Column($this->db, $name, $this->alias);
     }
 
@@ -241,7 +241,7 @@ 
      * @param string $order
      * @return $this
      */
-    public function order (string $order) {
+    public function order(string $order) {
         $this->_order = $order;
         return $this;
     }
@@ -249,7 +249,7 @@ 
     /**
      * @return Statement
      */
-    public function prepare (): Statement {
+    public function prepare(): Statement {
         return $this->db->prepare($this->toSql());
     }
 
@@ -257,7 +257,7 @@ 
      * @param Closure $fetcher
      * @return $this
      */
-    public function setFetcher (Closure $fetcher) {
+    public function setFetcher(Closure $fetcher) {
         $this->fetcher = $fetcher;
         return $this;
     }
@@ -265,7 +265,7 @@ 
     /**
      * @return string
      */
-    public function toSql (): string {
+    public function toSql(): string {
         $sql = SQL::select($this->table, $this->columns);
         foreach ($this->_join as $join) {
             $sql .= " {$join}";
@@ -283,7 +283,7 @@ 
      *
      * @return string
      */
-    public function toSubquery (): string {
+    public function toSubquery(): string {
         return "({$this->toSql()}) AS {$this->alias}";
     }
 
@@ -293,7 +293,7 @@ 
      * @param string $condition
      * @return $this
      */
-    public function where (string $condition) {
+    public function where(string $condition) {
         $this->_where[] = $condition;
         return $this;
     }