hfw / db

src/DB/AbstractTable.php

Spacing +7 added lines, -7 removed lines

@@ -27,7 +27,7 @@ 
     /**
      * @param DB $db
      */
-    public function __construct (DB $db) {
+    public function __construct(DB $db) {
         $this->db = $db;
     }
 
@@ -36,7 +36,7 @@ 
      *
      * @return string
      */
-    abstract public function __toString ();
+    abstract public function __toString();
 
     /**
      * Caches a prepared query.
@@ -45,7 +45,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();
     }
 
@@ -53,13 +53,13 @@ 
      * @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.
@@ -68,7 +68,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.');
     }
 
@@ -78,7 +78,7 @@ 
      * @param void $name
      * @throws Exception
      */
-    final public function offsetUnset ($name): void {
+    final public function offsetUnset($name): void {
         $this->offsetSet($name, null);
     }
 }
\ No newline at end of file

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(array_keys($this->columns))->where('id = ?')->prepare();
         });
@@ -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 {
         $insert = $this->cache(__FUNCTION__, function() {
             $slots = SQL::slots(array_keys($this->columns));
             unset($slots['id']);
@@ -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::slotsEqual(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/SQL/Predicate.php

Spacing +5 added lines, -5 removed lines

@@ -17,7 +17,7 @@ 
      * @param string[] $conditions
      * @return Predicate
      */
-    public static function all (array $conditions) {
+    public static function all(array $conditions) {
         if (count($conditions) === 1) {
             return reset($conditions);
         }
@@ -30,7 +30,7 @@ 
      * @param string[] $conditions
      * @return Predicate
      */
-    public static function any (array $conditions) {
+    public static function any(array $conditions) {
         if (count($conditions) === 1) {
             return reset($conditions);
         }
@@ -57,7 +57,7 @@ 
      * @param string $listOper
      * @return Predicate
      */
-    public static function compare ($a, $b = null, $oper = '=', $subOper = 'ANY', $listOper = 'IN') {
+    public static function compare($a, $b = null, $oper = '=', $subOper = 'ANY', $listOper = 'IN') {
         if (is_array($b)) {
             return new static("{$a} {$listOper} (" . implode(',', $b) . ")");
         }
@@ -79,7 +79,7 @@ 
      * @param string $listOper
      * @return Predicate[]
      */
-    public static function compareArray (array $values, $oper = '=', $subOper = 'ANY', $listOper = 'IN') {
+    public static function compareArray(array $values, $oper = '=', $subOper = 'ANY', $listOper = 'IN') {
         foreach ($values as $a => $b) {
             $values[$a] = static::compare($a, $b, $oper, $subOper, $listOper);
         }
@@ -91,7 +91,7 @@ 
      *
      * @return Predicate
      */
-    public function invert () {
+    public function invert() {
         return new static("NOT({$this})");
     }
 }
\ No newline at end of file

src/DB/SQL/DateTimeTrait.php

Spacing +13 added lines, -13 removed lines

@@ -19,7 +19,7 @@ 
      *
      * @return Text
      */
-    public function getDate () {
+    public function getDate() {
         return new Text($this->db, $this->getDateTimeFormat('%Y-%m-%d'));
     }
 
@@ -29,7 +29,7 @@ 
      * @param string|array $format Format, or formats keyed by driver name.
      * @return Text
      */
-    public function getDateTimeFormat ($format) {
+    public function getDateTimeFormat($format) {
         if (is_array($format)) {
             $format = $format[$this->db->getDriver()];
         }
@@ -48,7 +48,7 @@ 
      *
      * @return Numeric
      */
-    public function getDay () {
+    public function getDay() {
         return new Numeric($this->db, $this->getDateTimeFormat('%d'));
     }
 
@@ -57,7 +57,7 @@ 
      *
      * @return Numeric
      */
-    public function getDayOfWeek () {
+    public function getDayOfWeek() {
         return new Numeric($this->db, $this->getDateTimeFormat('%w'));
     }
 
@@ -66,7 +66,7 @@ 
      *
      * @return Numeric
      */
-    public function getDayOfYear () {
+    public function getDayOfYear() {
         return new Numeric($this->db, $this->getDateTimeFormat('%j'));
     }
 
@@ -75,7 +75,7 @@ 
      *
      * @return Numeric
      */
-    public function getHours () {
+    public function getHours() {
         return new Numeric($this->db, $this->getDateTimeFormat('%H'));
     }
 
@@ -84,7 +84,7 @@ 
      *
      * @return Numeric
      */
-    public function getMinutes () {
+    public function getMinutes() {
         return new Numeric($this->db, $this->getDateTimeFormat([
             'mysql' => '%i',
             'sqlite' => '%M'
@@ -96,7 +96,7 @@ 
      *
      * @return Numeric
      */
-    public function getMonth () {
+    public function getMonth() {
         return new Numeric($this->db, $this->getDateTimeFormat('%m'));
     }
 
@@ -105,7 +105,7 @@ 
      *
      * @return Numeric
      */
-    public function getSeconds () {
+    public function getSeconds() {
         return new Numeric($this->db, $this->getDateTimeFormat('%S'));
     }
 
@@ -114,7 +114,7 @@ 
      *
      * @return Text
      */
-    public function getTime () {
+    public function getTime() {
         return new Text($this->db, $this->getDateTimeFormat([
             'mysql' => '%H:%i:%S',
             'sqlite' => '%H:%M:%S'
@@ -126,7 +126,7 @@ 
      *
      * @return Numeric
      */
-    public function getTimestamp () {
+    public function getTimestamp() {
         switch ($this->db->getDriver()) {
             case 'sqlite':
                 return new Numeric($this->db, "STRFTIME('%s',{$this})");
@@ -140,7 +140,7 @@ 
      *
      * @return Numeric
      */
-    public function getWeekOfYear () {
+    public function getWeekOfYear() {
         return new Numeric($this->db, $this->getDateTimeFormat([
             'mysql' => '%U',
             'sqlite' => '%W'
@@ -152,7 +152,7 @@ 
      *
      * @return Numeric
      */
-    public function getYear () {
+    public function getYear() {
         return new Numeric($this->db, $this->getDateTimeFormat('%Y'));
     }
 }
\ No newline at end of file

src/DB/SQL/NumericTrait.php

Spacing +13 added lines, -13 removed lines

@@ -19,7 +19,7 @@ 
      *
      * @return Numeric
      */
-    public function abs () {
+    public function abs() {
         return new Numeric($this->db, "ABS({$this})");
     }
 
@@ -29,7 +29,7 @@ 
      * @param number|ExpressionInterface $arg
      * @return Numeric
      */
-    public function add ($arg) {
+    public function add($arg) {
         return new Numeric($this->db, "({$this} + {$arg})");
     }
 
@@ -38,7 +38,7 @@ 
      *
      * @return Numeric
      */
-    public function ceil () {
+    public function ceil() {
         return new Numeric($this->db, "CEIL({$this})");
     }
 
@@ -48,7 +48,7 @@ 
      * @param number|ExpressionInterface $arg
      * @return Numeric
      */
-    public function divide ($arg) {
+    public function divide($arg) {
         return new Numeric($this->db, "({$this} / {$arg})");
     }
 
@@ -57,7 +57,7 @@ 
      *
      * @return Numeric
      */
-    public function floor () {
+    public function floor() {
         return new Numeric($this->db, "FLOOR({$this})");
     }
 
@@ -66,7 +66,7 @@ 
      *
      * @return Predicate
      */
-    public function isEven () {
+    public function isEven() {
         return new Predicate("({$this} % 2) = 0");
     }
 
@@ -75,7 +75,7 @@ 
      *
      * @return Predicate
      */
-    public function isNegative () {
+    public function isNegative() {
         return new Predicate("{$this} < 0");
     }
 
@@ -84,7 +84,7 @@ 
      *
      * @return Predicate
      */
-    public function isOdd () {
+    public function isOdd() {
         return new Predicate("({$this} % 2) <> 0");
     }
 
@@ -93,7 +93,7 @@ 
      *
      * @return Predicate
      */
-    public function isPositive () {
+    public function isPositive() {
         return new Predicate("{$this} > 0");
     }
 
@@ -103,7 +103,7 @@ 
      * @param number|ExpressionInterface $arg
      * @return Numeric
      */
-    public function modulo ($arg) {
+    public function modulo($arg) {
         return new Numeric($this->db, "({$this} % {$arg})");
     }
 
@@ -113,7 +113,7 @@ 
      * @param number|ExpressionInterface $arg
      * @return Numeric
      */
-    public function multiply ($arg) {
+    public function multiply($arg) {
         return new Numeric($this->db, "({$this} * {$arg})");
     }
 
@@ -123,7 +123,7 @@ 
      * @param int $decimals
      * @return Numeric
      */
-    public function round (int $decimals = 0) {
+    public function round(int $decimals = 0) {
         return new Numeric($this->db, "ROUND({$this},{$decimals})");
     }
 
@@ -133,7 +133,7 @@ 
      * @param number|ExpressionInterface $arg
      * @return Numeric
      */
-    public function subtract ($arg) {
+    public function subtract($arg) {
         return new Numeric($this->db, "({$this} - {$arg})");
     }
 }
\ No newline at end of file

src/DB/SQL/PredicateTrait.php

Spacing +3 added lines, -3 removed lines

@@ -12,7 +12,7 @@ 
      *
      * @return Predicate
      */
-    public function isFalse () {
+    public function isFalse() {
         return new Predicate("{$this} IS FALSE");
     }
 
@@ -21,7 +21,7 @@ 
      *
      * @return Predicate
      */
-    public function isNotNull () {
+    public function isNotNull() {
         return new Predicate("{$this} IS NOT NULL");
     }
 
@@ -30,7 +30,7 @@ 
      *
      * @return Predicate
      */
-    public function isNull () {
+    public function isNull() {
         return new Predicate("{$this} IS NULL");
     }
 }
\ No newline at end of file

src/DB/SQL/Expression.php

Spacing +2 added lines, -2 removed lines

@@ -15,14 +15,14 @@
     /**
      * @param string $expression
      */
-    public function __construct (string $expression) {
+    public function __construct(string $expression) {
         $this->expression = $expression;
     }
 
     /**
      * @return string
      */
-    public function __toString () {
+    public function __toString() {
         return $this->expression;
     }
 }
\ No newline at end of file

src/DB/SQL/ComparisonTrait.php

Spacing +12 added lines, -12 removed lines

@@ -26,7 +26,7 @@ 
      * @param null|bool|string|Select $arg
      * @return Predicate
      */
-    public function is ($arg): Predicate {
+    public function is($arg): Predicate {
         if ($arg === null or is_bool($arg)) {
             $arg = ['' => 'NULL', 1 => 'TRUE', 0 => 'FALSE'][$arg];
         }
@@ -43,7 +43,7 @@ 
      * @param string|array|Select $arg
      * @return Predicate
      */
-    public function isEqual ($arg) {
+    public function isEqual($arg) {
         return Predicate::compare($this, $this->db->quoteMixed($arg));
     }
 
@@ -53,7 +53,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isGreater ($arg) {
+    public function isGreater($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '>', 'ALL');
     }
 
@@ -63,7 +63,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isGreaterOrEqual ($arg) {
+    public function isGreaterOrEqual($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '>=', 'ALL');
     }
 
@@ -73,7 +73,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isLess ($arg) {
+    public function isLess($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '<', 'ALL');
     }
 
@@ -83,7 +83,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isLessOrEqual ($arg) {
+    public function isLessOrEqual($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '<=', 'ALL');
     }
 
@@ -93,7 +93,7 @@ 
      * @param string $pattern
      * @return Predicate
      */
-    public function isLike (string $pattern) {
+    public function isLike(string $pattern) {
         return Predicate::compare($this, $this->db->quote($pattern), 'LIKE');
     }
 
@@ -103,7 +103,7 @@ 
      * @param null|bool|string|Select $arg
      * @return Predicate
      */
-    public function isNot ($arg) {
+    public function isNot($arg) {
         return $this->is($arg)->invert();
     }
 
@@ -113,7 +113,7 @@ 
      * @param string|array|Select $arg
      * @return Predicate
      */
-    public function isNotEqual ($arg) {
+    public function isNotEqual($arg) {
         return Predicate::compare($this, $this->db->quoteMixed($arg), '<>', 'ALL', 'NOT IN');
     }
 
@@ -123,7 +123,7 @@ 
      * @param string $pattern
      * @return Predicate
      */
-    public function isNotLike (string $pattern) {
+    public function isNotLike(string $pattern) {
         return Predicate::compare($this, $this->db->quote($pattern), 'NOT LIKE');
     }
 
@@ -133,7 +133,7 @@ 
      * @param string $pattern
      * @return Predicate
      */
-    public function isNotRegExp (string $pattern) {
+    public function isNotRegExp(string $pattern) {
         return Predicate::compare($this, $this->db->quote($pattern), 'NOT REGEXP');
     }
 
@@ -143,7 +143,7 @@ 
      * @param string $pattern
      * @return Predicate
      */
-    public function isRegExp (string $pattern) {
+    public function isRegExp(string $pattern) {
         return Predicate::compare($this, $this->db->quote($pattern), 'REGEXP');
     }
 }
\ No newline at end of file

src/DB/SQL/TextTrait.php

Spacing +8 added lines, -8 removed lines

@@ -17,7 +17,7 @@ 
     /**
      * @return Text
      */
-    public function getHex () {
+    public function getHex() {
         return new Text($this->db, "HEX({$this})");
     }
 
@@ -28,7 +28,7 @@ 
      *
      * @return Numeric
      */
-    public function getLength () {
+    public function getLength() {
         switch ($this->db->getDriver()) {
             case 'sqlite':
                 return new Numeric($this->db, "LENGTH(CAST({$this} AS TEXT))");
@@ -42,7 +42,7 @@ 
      *
      * @return Text
      */
-    public function getLower () {
+    public function getLower() {
         return new Text($this->db, "LOWER({$this})");
     }
 
@@ -54,7 +54,7 @@ 
      * @param string $substring
      * @return Numeric
      */
-    public function getPosition (string $substring) {
+    public function getPosition(string $substring) {
         $substring = $this->db->quote($substring);
         switch ($this->db->getDriver()) {
             case 'sqlite':
@@ -71,7 +71,7 @@ 
      * @param string $replace
      * @return Text
      */
-    public function getReplacement (string $search, string $replace) {
+    public function getReplacement(string $search, string $replace) {
         $search = $this->db->quote($search);
         $replace = $this->db->quote($replace);
         return new Text($this->db, "REPLACE({$this},{$search},{$replace})");
@@ -82,7 +82,7 @@ 
      *
      * @return Numeric
      */
-    public function getSize () {
+    public function getSize() {
         switch ($this->db->getDriver()) {
             case 'sqlite':
                 return new Numeric($this->db, "LENGTH(CAST({$this} AS BLOB))");
@@ -98,7 +98,7 @@ 
      * @param int $length
      * @return Text
      */
-    public function getSubstring (int $start, int $length = null) {
+    public function getSubstring(int $start, int $length = null) {
         if (isset($length)) {
             return new Text($this->db, "SUBSTR({$this},{$start},{$length})");
         }
@@ -110,7 +110,7 @@ 
      *
      * @return Text
      */
-    public function getUpper () {
+    public function getUpper() {
         return new Text($this->db, "UPPER({$this})");
     }
 }
\ No newline at end of file