hfw / db

src/DB/Record.php

Braces +4 added lines, -8 removed lines

@@ -62,8 +62,7 @@ 
     public static function fromClass (DB $db, $class) {
         try {
             $rClass = new ReflectionClass($class);
-        }
-        catch (ReflectionException $exception) {
+        } catch (ReflectionException $exception) {
             throw new LogicException('Unexpected ReflectionException', 0, $exception);
         }
         $columns = [];
@@ -74,8 +73,7 @@ 
             $name = $rProp->getName();
             if (preg_match('/@col(umn)?[\s$]/', $doc)) {
                 $columns[] = $name;
-            }
-            elseif (preg_match('/@eav\s+(?<table>\S+)/', $doc, $attr)) {
+            } elseif (preg_match('/@eav\s+(?<table>\S+)/', $doc, $attr)) {
                 $eav[$name] = $db->factory(EAV::class, $db, $attr['table']);
             }
         }
@@ -114,8 +112,7 @@ 
                 $rProp->setAccessible(true);
                 $this->properties[$name] = $rProp;
             }
-        }
-        catch (ReflectionException $exception) {
+        } catch (ReflectionException $exception) {
             throw new LogicException('Unexpected ReflectionException', 0, $exception);
         }
     }
@@ -242,8 +239,7 @@ 
     public function save (EntityInterface $entity): int {
         if (!$entity->getId()) {
             $this->saveInsert($entity);
-        }
-        else {
+        } else {
             $this->saveUpdate($entity);
         }
         $this->saveEav($entity);

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 $this->db->factory(Predicate::class, "{$this} IS FALSE");
     }
 
@@ -21,7 +21,7 @@ 
      *
      * @return Predicate
      */
-    public function isNotNull () {
+    public function isNotNull() {
         return $this->db->factory(Predicate::class, "{$this} IS NOT NULL");
     }
 
@@ -30,7 +30,7 @@ 
      *
      * @return Predicate
      */
-    public function isNull () {
+    public function isNull() {
         return $this->db->factory(Predicate::class, "{$this} IS NULL");
     }
 }
\ No newline at end of file

src/DB/SQL/Text.php

Spacing +2 added lines, -2 removed lines

@@ -14,7 +14,7 @@ 
      *
      * @return Numeric
      */
-    public function toFloat () {
+    public function toFloat() {
         switch ($this->db) {
             case 'sqlite':
                 return $this->db->factory(Numeric::class, $this->db, "CAST({$this} AS REAL)");
@@ -28,7 +28,7 @@ 
      *
      * @return Numeric
      */
-    public function toInt () {
+    public function toInt() {
         switch ($this->db) {
             case 'sqlite':
                 return $this->db->factory(Numeric::class, $this->db, "CAST({$this} AS INTEGER)");

src/DB/SQL/AggregateTrait.php

Spacing +6 added lines, -6 removed lines

@@ -20,7 +20,7 @@ 
      * @param string $aggregate `ALL|DISTINCT`
      * @return Numeric
      */
-    public function getAvg ($aggregate = 'ALL') {
+    public function getAvg($aggregate = 'ALL') {
         return $this->db->factory(Numeric::class, $this->db, "AVG({$aggregate} {$this})");
     }
 
@@ -30,7 +30,7 @@ 
      * @param string $delimiter
      * @return Text
      */
-    public function getConcat (string $delimiter = ',') {
+    public function getConcat(string $delimiter = ',') {
         $delimiter = $this->db->quote($delimiter);
         switch ($this->db) {
             case 'sqlite':
@@ -46,7 +46,7 @@ 
      * @param string $aggregate `ALL|DISTINCT`
      * @return Numeric
      */
-    public function getCount (string $aggregate = 'ALL') {
+    public function getCount(string $aggregate = 'ALL') {
         return $this->db->factory(Numeric::class, $this->db, "COUNT({$aggregate} {$this})");
     }
 
@@ -55,7 +55,7 @@ 
      *
      * @return Numeric
      */
-    public function getMax () {
+    public function getMax() {
         return $this->db->factory(Numeric::class, $this->db, "MAX({$this})");
     }
 
@@ -64,7 +64,7 @@ 
      *
      * @return Numeric
      */
-    public function getMin () {
+    public function getMin() {
         return $this->db->factory(Numeric::class, $this->db, "MIN({$this})");
     }
 
@@ -74,7 +74,7 @@ 
      * @param string $aggregate `ALL|DISTINCT`
      * @return Numeric
      */
-    public function getSum (string $aggregate = 'ALL') {
+    public function getSum(string $aggregate = 'ALL') {
         return $this->db->factory(Numeric::class, $this->db, "SUM({$aggregate} {$this})");
     }
 }
\ 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 $this->db->factory(Text::class, $this->db, "HEX({$this})");
     }
 
@@ -28,7 +28,7 @@ 
      *
      * @return Numeric
      */
-    public function getLength () {
+    public function getLength() {
         switch ($this->db) {
             case 'sqlite':
                 return $this->db->factory(Numeric::class, $this->db, "LENGTH(CAST({$this} AS TEXT))");
@@ -42,7 +42,7 @@ 
      *
      * @return Text
      */
-    public function getLower () {
+    public function getLower() {
         return $this->db->factory(Text::class, $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) {
             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 $this->db->factory(Text::class, $this->db, "REPLACE({$this},{$search},{$replace})");
@@ -82,7 +82,7 @@ 
      *
      * @return Numeric
      */
-    public function getSize () {
+    public function getSize() {
         switch ($this->db) {
             case 'sqlite':
                 return $this->db->factory(Numeric::class, $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 $this->db->factory(Text::class, $this->db, "SUBSTR({$this},{$start},{$length})");
         }
@@ -110,7 +110,7 @@ 
      *
      * @return Text
      */
-    public function getUpper () {
+    public function getUpper() {
         return $this->db->factory(Text::class, $this->db, "UPPER({$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 $this->db->factory(Text::class, $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) {
         $driver = $this->db->getDriver();
         if (is_array($format)) {
             $format = $format[$driver];
@@ -48,7 +48,7 @@ 
      *
      * @return Numeric
      */
-    public function getDay () {
+    public function getDay() {
         return $this->db->factory(Numeric::class, $this->db, $this->getDateTimeFormat('%d'));
     }
 
@@ -57,7 +57,7 @@ 
      *
      * @return Numeric
      */
-    public function getDayOfWeek () {
+    public function getDayOfWeek() {
         return $this->db->factory(Numeric::class, $this->db, $this->getDateTimeFormat('%w'));
     }
 
@@ -66,7 +66,7 @@ 
      *
      * @return Numeric
      */
-    public function getDayOfYear () {
+    public function getDayOfYear() {
         return $this->db->factory(Numeric::class, $this->db, $this->getDateTimeFormat('%j'));
     }
 
@@ -75,7 +75,7 @@ 
      *
      * @return Numeric
      */
-    public function getHours () {
+    public function getHours() {
         return $this->db->factory(Numeric::class, $this->db, $this->getDateTimeFormat('%H'));
     }
 
@@ -84,7 +84,7 @@ 
      *
      * @return Numeric
      */
-    public function getMinutes () {
+    public function getMinutes() {
         return $this->db->factory(Numeric::class, $this->db, $this->getDateTimeFormat([
             'mysql' => '%i',
             'sqlite' => '%M'
@@ -96,7 +96,7 @@ 
      *
      * @return Numeric
      */
-    public function getMonth () {
+    public function getMonth() {
         return $this->db->factory(Numeric::class, $this->db, $this->getDateTimeFormat('%m'));
     }
 
@@ -105,7 +105,7 @@ 
      *
      * @return Numeric
      */
-    public function getSeconds () {
+    public function getSeconds() {
         return $this->db->factory(Numeric::class, $this->db, $this->getDateTimeFormat('%S'));
     }
 
@@ -114,7 +114,7 @@ 
      *
      * @return Text
      */
-    public function getTime () {
+    public function getTime() {
         return $this->db->factory(Text::class, $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) {
             case 'sqlite':
                 return $this->db->factory(Numeric::class, $this->db, "STRFTIME('%s',{$this})");
@@ -140,7 +140,7 @@ 
      *
      * @return Numeric
      */
-    public function getWeekOfYear () {
+    public function getWeekOfYear() {
         return $this->db->factory(Numeric::class, $this->db, $this->getDateTimeFormat([
             'mysql' => '%U',
             'sqlite' => '%W'
@@ -152,7 +152,7 @@ 
      *
      * @return Numeric
      */
-    public function getYear () {
+    public function getYear() {
         return $this->db->factory(Numeric::class, $this->db, $this->getDateTimeFormat('%Y'));
     }
 }
\ 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 $this->db->factory(Numeric::class, $this->db, "ABS({$this})");
     }
 
@@ -29,7 +29,7 @@ 
      * @param number|ValueInterface $arg
      * @return Numeric
      */
-    public function add ($arg) {
+    public function add($arg) {
         return $this->db->factory(Numeric::class, $this->db, "({$this} + {$arg})");
     }
 
@@ -38,7 +38,7 @@ 
      *
      * @return Numeric
      */
-    public function ceil () {
+    public function ceil() {
         return $this->db->factory(Numeric::class, $this->db, "CEIL({$this})");
     }
 
@@ -48,7 +48,7 @@ 
      * @param number|ValueInterface $arg
      * @return Numeric
      */
-    public function divide ($arg) {
+    public function divide($arg) {
         return $this->db->factory(Numeric::class, $this->db, "({$this} / {$arg})");
     }
 
@@ -57,7 +57,7 @@ 
      *
      * @return Numeric
      */
-    public function floor () {
+    public function floor() {
         return $this->db->factory(Numeric::class, $this->db, "FLOOR({$this})");
     }
 
@@ -66,7 +66,7 @@ 
      *
      * @return Predicate
      */
-    public function isEven () {
+    public function isEven() {
         return $this->db->factory(Predicate::class, "({$this} % 2) = 0");
     }
 
@@ -75,7 +75,7 @@ 
      *
      * @return Predicate
      */
-    public function isNegative () {
+    public function isNegative() {
         return $this->db->factory(Predicate::class, "{$this} < 0");
     }
 
@@ -84,7 +84,7 @@ 
      *
      * @return Predicate
      */
-    public function isOdd () {
+    public function isOdd() {
         return $this->db->factory(Predicate::class, "({$this} % 2) <> 0");
     }
 
@@ -93,7 +93,7 @@ 
      *
      * @return Predicate
      */
-    public function isPositive () {
+    public function isPositive() {
         return $this->db->factory(Predicate::class, "{$this} > 0");
     }
 
@@ -103,7 +103,7 @@ 
      * @param number|ValueInterface $arg
      * @return Numeric
      */
-    public function modulo ($arg) {
+    public function modulo($arg) {
         return $this->db->factory(Numeric::class, $this->db, "({$this} % {$arg})");
     }
 
@@ -113,7 +113,7 @@ 
      * @param number|ValueInterface $arg
      * @return Numeric
      */
-    public function multiply ($arg) {
+    public function multiply($arg) {
         return $this->db->factory(Numeric::class, $this->db, "({$this} * {$arg})");
     }
 
@@ -123,7 +123,7 @@ 
      * @param number|ValueInterface $exponent
      * @return Numeric
      */
-    public function pow ($exponent) {
+    public function pow($exponent) {
         return $this->db->factory(Numeric::class, $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 $this->db->factory(Numeric::class, $this->db, "ROUND({$this},{$decimals})");
     }
 
@@ -143,7 +143,7 @@ 
      * @param number|ValueInterface $arg
      * @return Numeric
      */
-    public function subtract ($arg) {
+    public function subtract($arg) {
         return $this->db->factory(Numeric::class, $this->db, "({$this} - {$arg})");
     }
 }
\ No newline at end of file

src/DB/SQL/ComparisonTrait.php

Spacing +16 added lines, -16 removed lines

@@ -28,7 +28,7 @@ 
      * @param array $values
      * @return Value
      */
-    public function coalesce (array $values) {
+    public function coalesce(array $values) {
         array_unshift($values, $this);
         $values = $this->db->quoteList($values);
         return $this->db->factory(Value::class, $this->db, "COALESCE({$values})");
@@ -40,7 +40,7 @@ 
      * @param array $values `[when => then]`
      * @return Choice
      */
-    public function getChoice (array $values) {
+    public function getChoice(array $values) {
         return $this->db->factory(Choice::class, $this->db, "{$this}", $values);
     }
 
@@ -53,7 +53,7 @@ 
      * @param null|bool|number|string|Select $arg
      * @return Predicate
      */
-    public function is ($arg): Predicate {
+    public function is($arg): Predicate {
         $driver = $this->db->getDriver();
         if ($arg instanceof Select) {
             switch ($driver) {
@@ -82,7 +82,7 @@ 
      * @param number $max
      * @return Predicate
      */
-    public function isBetween ($min, $max) {
+    public function isBetween($min, $max) {
         $min = $this->db->quote($min);
         $max = $this->db->quote($max);
         return $this->db->factory(Predicate::class, "{$this} BETWEEN {$min} AND {$max}");
@@ -94,7 +94,7 @@ 
      * @param bool|number|string|array|Select $arg
      * @return Predicate
      */
-    public function isEqual ($arg) {
+    public function isEqual($arg) {
         return $this->db->match($this, $arg);
     }
 
@@ -110,7 +110,7 @@ 
      * @param string $multi `ALL|ANY`
      * @return Predicate
      */
-    public function isGreater ($arg, string $multi = 'ALL') {
+    public function isGreater($arg, string $multi = 'ALL') {
         if ($arg instanceof Select) {
             switch ($this->db) {
                 case 'sqlite':
@@ -141,7 +141,7 @@ 
      * @param string $multi `ALL|ANY`
      * @return Predicate
      */
-    public function isGreaterOrEqual ($arg, string $multi = 'ALL') {
+    public function isGreaterOrEqual($arg, string $multi = 'ALL') {
         if ($arg instanceof Select) {
             switch ($this->db) {
                 case 'sqlite':
@@ -172,7 +172,7 @@ 
      * @param string $multi `ALL|ANY`
      * @return Predicate
      */
-    public function isLess ($arg, string $multi = 'ALL') {
+    public function isLess($arg, string $multi = 'ALL') {
         if ($arg instanceof Select) {
             switch ($this->db) {
                 case 'sqlite':
@@ -203,7 +203,7 @@ 
      * @param string $multi `ALL|ANY`
      * @return Predicate
      */
-    public function isLessOrEqual ($arg, string $multi = 'ALL') {
+    public function isLessOrEqual($arg, string $multi = 'ALL') {
         if ($arg instanceof Select) {
             switch ($this->db) {
                 case 'sqlite':
@@ -228,7 +228,7 @@ 
      * @param string $pattern
      * @return Predicate
      */
-    public function isLike (string $pattern) {
+    public function isLike(string $pattern) {
         $pattern = $this->db->quote($pattern);
         return $this->db->factory(Predicate::class, "{$this} LIKE {$pattern}");
     }
@@ -239,7 +239,7 @@ 
      * @param null|bool|number|string|Select $arg
      * @return Predicate
      */
-    public function isNot ($arg) {
+    public function isNot($arg) {
         return $this->is($arg)->invert();
     }
 
@@ -250,7 +250,7 @@ 
      * @param number $max
      * @return Predicate
      */
-    public function isNotBetween ($min, $max) {
+    public function isNotBetween($min, $max) {
         $min = $this->db->quote($min);
         $max = $this->db->quote($max);
         return $this->db->factory(Predicate::class, "{$this} NOT BETWEEN {$min} AND {$max}");
@@ -262,7 +262,7 @@ 
      * @param bool|number|string|array|Select $arg
      * @return Predicate
      */
-    public function isNotEqual ($arg) {
+    public function isNotEqual($arg) {
         if ($arg instanceof Select) {
             return $this->db->factory(Predicate::class, "{$this} NOT IN ({$arg->toSql()})");
         }
@@ -278,7 +278,7 @@ 
      * @param string $pattern
      * @return Predicate
      */
-    public function isNotLike (string $pattern) {
+    public function isNotLike(string $pattern) {
         $pattern = $this->db->quote($pattern);
         return $this->db->factory(Predicate::class, "{$this} NOT LIKE {$pattern}");
     }
@@ -289,7 +289,7 @@ 
      * @param string $pattern
      * @return Predicate
      */
-    public function isNotRegExp (string $pattern) {
+    public function isNotRegExp(string $pattern) {
         $pattern = $this->db->quote($pattern);
         return $this->db->factory(Predicate::class, "{$this} NOT REGEXP {$pattern}");
     }
@@ -300,7 +300,7 @@ 
      * @param string $pattern
      * @return Predicate
      */
-    public function isRegExp (string $pattern) {
+    public function isRegExp(string $pattern) {
         $pattern = $this->db->quote($pattern);
         return $this->db->factory(Predicate::class, "{$this} REGEXP {$pattern}");
     }

src/DB/SQL/Numeric.php

Spacing +1 added lines, -1 removed lines

@@ -14,7 +14,7 @@
      *
      * @return Text
      */
-    public function toText () {
+    public function toText() {
         if ($this->db == 'sqlite') {
             return $this->db->factory(Text::class, $this->db, "CAST({$this} AS TEXT)");
         }