hfw / db

src/DB/SQL/ExpressionInterface.php

Spacing +1 added lines, -1 removed lines

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

src/DB/SQL/NumericTrait.php

Spacing +14 added lines, -14 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|ValueInterface $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|ValueInterface $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|ValueInterface $arg
      * @return Numeric
      */
-    public function modulo ($arg) {
+    public function modulo($arg) {
         return new Numeric($this->db, "({$this} % {$arg})");
     }
 
@@ -113,7 +113,7 @@ 
      * @param number|ValueInterface $arg
      * @return Numeric
      */
-    public function multiply ($arg) {
+    public function multiply($arg) {
         return new Numeric($this->db, "({$this} * {$arg})");
     }
 
@@ -123,7 +123,7 @@ 
      * @param number|ValueInterface $exponent
      * @return Numeric
      */
-    public function pow ($exponent) {
+    public function pow($exponent) {
         return new Numeric($this->db, "POW({$this},{$exponent})");
     }
 
@@ -133,7 +133,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})");
     }
 
@@ -143,7 +143,7 @@ 
      * @param number|ValueInterface $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/ComparisonTrait.php

Spacing +16 added lines, -16 removed lines

@@ -23,7 +23,7 @@ 
      * @param array $values
      * @return Value
      */
-    public function coalesce (array $values) {
+    public function coalesce(array $values) {
         array_unshift($values, $this);
         $values = implode(',', $this->db->quoteArray($values));
         return new Value($this->db, "COALESCE({$values})");
@@ -35,7 +35,7 @@ 
      * @param string[] $values `[when => then]`
      * @return Choice
      */
-    public function getChoice (array $values) {
+    public function getChoice(array $values) {
         return new Choice($this->db, "{$this}", $values);
     }
 
@@ -48,7 +48,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];
         }
@@ -66,7 +66,7 @@ 
      * @param number|string $max
      * @return Predicate
      */
-    public function isBetween ($min, $max) {
+    public function isBetween($min, $max) {
         return new Predicate("{$this} BETWEEN {$this->db->quote($min)} AND {$this->db->quote($max)}");
     }
 
@@ -76,7 +76,7 @@ 
      * @param string|array|Select $arg
      * @return Predicate
      */
-    public function isEqual ($arg) {
+    public function isEqual($arg) {
         return Predicate::compare($this, $this->db->quoteMixed($arg));
     }
 
@@ -86,7 +86,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isGreater ($arg) {
+    public function isGreater($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '>', 'ALL');
     }
 
@@ -96,7 +96,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isGreaterOrEqual ($arg) {
+    public function isGreaterOrEqual($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '>=', 'ALL');
     }
 
@@ -106,7 +106,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isLess ($arg) {
+    public function isLess($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '<', 'ALL');
     }
 
@@ -116,7 +116,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isLessOrEqual ($arg) {
+    public function isLessOrEqual($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '<=', 'ALL');
     }
 
@@ -126,7 +126,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');
     }
 
@@ -136,7 +136,7 @@ 
      * @param null|bool|string|Select $arg
      * @return Predicate
      */
-    public function isNot ($arg) {
+    public function isNot($arg) {
         return $this->is($arg)->invert();
     }
 
@@ -147,7 +147,7 @@ 
      * @param number|string $max
      * @return Predicate
      */
-    public function isNotBetween ($min, $max) {
+    public function isNotBetween($min, $max) {
         return new Predicate("{$this} NOT BETWEEN {$this->db->quote($min)} AND {$this->db->quote($max)}");
     }
 
@@ -157,7 +157,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');
     }
 
@@ -167,7 +167,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');
     }
 
@@ -177,7 +177,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');
     }
 
@@ -187,7 +187,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/Choice.php

Spacing +5 added lines, -5 removed lines

@@ -52,7 +52,7 @@ 
      * @param string $subject
      * @param array $values `[when => then]` for the subject.
      */
-    public function __construct (DB $db, string $subject = null, array $values = []) {
+    public function __construct(DB $db, string $subject = null, array $values = []) {
         parent::__construct($db, '');
         $this->subject = $subject;
         $this->setValues($values);
@@ -61,7 +61,7 @@ 
     /**
      * @return string
      */
-    public function __toString () {
+    public function __toString() {
         $sql = 'CASE';
         if (isset($this->subject)) {
             $sql .= " {$this->subject}";
@@ -80,7 +80,7 @@ 
      * @param string|ValueInterface $else
      * @return $this
      */
-    public function setElse ($else) {
+    public function setElse($else) {
         $this->else = isset($else) ? $this->db->quote($else) : null;
         return $this;
     }
@@ -92,7 +92,7 @@ 
      * @param string|ValueInterface $then
      * @return $this
      */
-    public function setValue ($when, $then) {
+    public function setValue($when, $then) {
         $this->values[$this->db->quote($when)] = $this->db->quote($then);
         return $this;
     }
@@ -103,7 +103,7 @@ 
      * @param array $values `[when => then]`
      * @return $this
      */
-    public function setValues (array $values) {
+    public function setValues(array $values) {
         foreach ($values as $when => $then) {
             $this->setValue($when, $then);
         }

src/DB/Junction.php

Spacing +4 added lines, -4 removed lines

@@ -29,7 +29,7 @@ 
      * @param string $interface
      * @return Junction
      */
-    public static function fromInterface (DB $db, string $interface) {
+    public static function fromInterface(DB $db, string $interface) {
         try {
             $ref = new ReflectionClass($interface);
         }
@@ -52,7 +52,7 @@ 
      * @param string $table
      * @param string[] $classes
      */
-    public function __construct (DB $db, string $table, array $classes) {
+    public function __construct(DB $db, string $table, array $classes) {
         parent::__construct($db, $table, array_keys($classes));
         $this->classes = $classes;
     }
@@ -66,7 +66,7 @@ 
      * @param array $match Keyed by junction column.
      * @return Select
      */
-    public function getCollection (string $key, array $match = []) {
+    public function getCollection(string $key, array $match = []) {
         $record = $this->db->getRecord($this->classes[$key]);
         $select = $record->select();
         $select->join($this, $this[$key]->isEqual($record['id']));
@@ -82,7 +82,7 @@ 
      * @param int[] $ids Keyed by column.
      * @return int Rows affected.
      */
-    public function link (array $ids): int {
+    public function link(array $ids): int {
         $link = $this->cache(__FUNCTION__, function() {
             $columns = implode(',', array_keys($this->columns));
             $slots = implode(',', SQL::slots(array_keys($this->columns)));