hfw / db

src/DB/SQL/AbstractTrait.php

Spacing +1 added lines, -1 removed lines

@@ -14,7 +14,7 @@
     /**
      * @return string
      */
-    abstract public function __toString ();
+    abstract public function __toString();
 
     /**
      * @var DB

src/DB/SQL/DateTimeTrait.php

Spacing +14 added lines, -14 removed lines

@@ -19,7 +19,7 @@ 
      *
      * @return Text
      */
-    public function date () {
+    public function date() {
         return Text::factory($this->db, $this->dateFormat('%Y-%m-%d'));
     }
 
@@ -29,7 +29,7 @@ 
      * @param string|string[] $format Format, or formats keyed by driver name.
      * @return Text
      */
-    public function dateFormat ($format) {
+    public function dateFormat($format) {
         if (is_array($format)) {
             $format = $format[$this->db->getDriver()];
         }
@@ -45,7 +45,7 @@ 
      *
      * @return Text
      */
-    public function datetime () {
+    public function datetime() {
         return Text::factory($this->db, $this->dateFormat([
             'mysql' => '%Y-%m-%d %H:%i:%S',
             'sqlite' => '%Y-%m-%d %H:%M:%S'
@@ -57,7 +57,7 @@ 
      *
      * @return Num
      */
-    public function day () {
+    public function day() {
         return Num::factory($this->db, $this->dateFormat('%d'));
     }
 
@@ -66,7 +66,7 @@ 
      *
      * @return Num
      */
-    public function dayOfWeek () {
+    public function dayOfWeek() {
         return Num::factory($this->db, $this->dateFormat('%w'));
     }
 
@@ -75,7 +75,7 @@ 
      *
      * @return Num
      */
-    public function dayOfYear () {
+    public function dayOfYear() {
         return Num::factory($this->db, $this->dateFormat('%j'));
     }
 
@@ -84,7 +84,7 @@ 
      *
      * @return Num
      */
-    public function hours () {
+    public function hours() {
         return Num::factory($this->db, $this->dateFormat('%H'));
     }
 
@@ -93,7 +93,7 @@ 
      *
      * @return Num
      */
-    public function minutes () {
+    public function minutes() {
         return Num::factory($this->db, $this->dateFormat([
             'mysql' => '%i',
             'sqlite' => '%M'
@@ -105,7 +105,7 @@ 
      *
      * @return Num
      */
-    public function month () {
+    public function month() {
         return Num::factory($this->db, $this->dateFormat('%m'));
     }
 
@@ -114,7 +114,7 @@ 
      *
      * @return Num
      */
-    public function seconds () {
+    public function seconds() {
         return Num::factory($this->db, $this->dateFormat('%S'));
     }
 
@@ -123,7 +123,7 @@ 
      *
      * @return Text
      */
-    public function time () {
+    public function time() {
         return Text::factory($this->db, $this->dateFormat([
             'mysql' => '%H:%i:%S',
             'sqlite' => '%H:%M:%S'
@@ -135,7 +135,7 @@ 
      *
      * @return Num
      */
-    public function timestamp () {
+    public function timestamp() {
         if ($this->db->isSQLite()) {
             return Num::factory($this->db, "STRFTIME('%s',{$this})");
         }
@@ -147,7 +147,7 @@ 
      *
      * @return Num
      */
-    public function weekOfYear () {
+    public function weekOfYear() {
         return Num::factory($this->db, $this->dateFormat([
             'mysql' => '%U',
             'sqlite' => '%W'
@@ -159,7 +159,7 @@ 
      *
      * @return Num
      */
-    public function year () {
+    public function year() {
         return Num::factory($this->db, $this->dateFormat('%Y'));
     }
 }
\ No newline at end of file

src/DB/SQL/AggregateTrait.php

Spacing +9 added lines, -9 removed lines

@@ -14,7 +14,7 @@ 
      *
      * @return Num
      */
-    public function avg () {
+    public function avg() {
         return Num::factory($this->db, "AVG({$this})");
     }
 
@@ -23,7 +23,7 @@ 
      *
      * @return Num
      */
-    public function avgDistinct () {
+    public function avgDistinct() {
         return Num::factory($this->db, "AVG(DISTINCT {$this})");
     }
 
@@ -32,7 +32,7 @@ 
      *
      * @return Num
      */
-    public function count () {
+    public function count() {
         return Num::factory($this->db, "COUNT({$this})");
     }
 
@@ -41,7 +41,7 @@ 
      *
      * @return Num
      */
-    public function countDistinct () {
+    public function countDistinct() {
         return Num::factory($this->db, "COUNT(DISTINCT {$this})");
     }
 
@@ -51,7 +51,7 @@ 
      * @param string $delimiter
      * @return Text
      */
-    public function groupConcat (string $delimiter = ',') {
+    public function groupConcat(string $delimiter = ',') {
         $delimiter = $this->db->quote($delimiter);
         if ($this->db->isSQLite()) {
             return Text::factory($this->db, "GROUP_CONCAT({$this},{$delimiter})");
@@ -64,7 +64,7 @@ 
      *
      * @return Num
      */
-    public function max () {
+    public function max() {
         return Num::factory($this->db, "MAX({$this})");
     }
 
@@ -73,7 +73,7 @@ 
      *
      * @return Num
      */
-    public function min () {
+    public function min() {
         return Num::factory($this->db, "MIN({$this})");
     }
 
@@ -82,7 +82,7 @@ 
      *
      * @return Num
      */
-    public function sum () {
+    public function sum() {
         return Num::factory($this->db, "SUM({$this})");
     }
 
@@ -91,7 +91,7 @@ 
      *
      * @return Num
      */
-    public function sumDistinct () {
+    public function sumDistinct() {
         return Num::factory($this->db, "SUM(DISTINCT {$this})");
     }
 }
\ No newline at end of file

src/DB/SQL/TextTrait.php

Spacing +8 added lines, -8 removed lines

@@ -16,7 +16,7 @@ 
      *
      * @return Text
      */
-    public function hex () {
+    public function hex() {
         return Text::factory($this->db, "HEX({$this})");
     }
 
@@ -27,7 +27,7 @@ 
      *
      * @return Num
      */
-    public function length () {
+    public function length() {
         if ($this->db->isSQLite()) {
             return Num::factory($this->db, "LENGTH(CAST({$this} AS TEXT))");
         }
@@ -41,7 +41,7 @@ 
      *
      * @return Text
      */
-    public function lower () {
+    public function lower() {
         return Text::factory($this->db, "LOWER({$this})");
     }
 
@@ -53,7 +53,7 @@ 
      * @param string $substring
      * @return Num
      */
-    public function position (string $substring) {
+    public function position(string $substring) {
         $substring = $this->db->quote($substring);
         if ($this->db->isSQLite()) {
             return Num::factory($this->db, "INSTR({$this},{$substring})");
@@ -70,7 +70,7 @@ 
      * @param string $replace
      * @return Text
      */
-    public function replace (string $search, string $replace) {
+    public function replace(string $search, string $replace) {
         $search = $this->db->quote($search);
         $replace = $this->db->quote($replace);
         return Text::factory($this->db, "REPLACE({$this},{$search},{$replace})");
@@ -81,7 +81,7 @@ 
      *
      * @return Num
      */
-    public function size () {
+    public function size() {
         if ($this->db->isSQLite()) {
             return Num::factory($this->db, "LENGTH(CAST({$this} AS BLOB))");
         }
@@ -97,7 +97,7 @@ 
      * @param null|int $length
      * @return Text
      */
-    public function substr (int $start, int $length = null) {
+    public function substr(int $start, int $length = null) {
         if (isset($length)) {
             return Text::factory($this->db, "SUBSTR({$this},{$start},{$length})");
         }
@@ -111,7 +111,7 @@ 
      *
      * @return Text
      */
-    public function upper () {
+    public function upper() {
         return Text::factory($this->db, "UPPER({$this})");
     }
 }
\ No newline at end of file

src/DB/SQL/NumTrait.php

Spacing +29 added lines, -29 removed lines

@@ -14,7 +14,7 @@ 
      *
      * @return Num
      */
-    public function abs () {
+    public function abs() {
         return Num::factory($this->db, "ABS({$this})");
     }
 
@@ -23,7 +23,7 @@ 
      *
      * @return Num
      */
-    public function acos () {
+    public function acos() {
         return Num::factory($this->db, "ACOS({$this})");
     }
 
@@ -33,7 +33,7 @@ 
      * @param number|ValueInterface $arg
      * @return Num
      */
-    public function add ($arg) {
+    public function add($arg) {
         $arg = $this->db->quote($arg);
         return Num::factory($this->db, "({$this} + {$arg})");
     }
@@ -43,7 +43,7 @@ 
      *
      * @return Num
      */
-    public function asin () {
+    public function asin() {
         return Num::factory($this->db, "ASIN({$this})");
     }
 
@@ -52,7 +52,7 @@ 
      *
      * @return Num
      */
-    public function atan () {
+    public function atan() {
         return Num::factory($this->db, "ATAN({$this})");
     }
 
@@ -61,7 +61,7 @@ 
      *
      * @return Num
      */
-    public function ceil () {
+    public function ceil() {
         return Num::factory($this->db, "CEIL({$this})");
     }
 
@@ -70,7 +70,7 @@ 
      *
      * @return Num
      */
-    public function cos () {
+    public function cos() {
         return Num::factory($this->db, "COS({$this})");
     }
 
@@ -81,7 +81,7 @@ 
      *
      * @return Num
      */
-    public function degrees () {
+    public function degrees() {
         return Num::factory($this->db, "DEGREES({$this})");
     }
 
@@ -91,7 +91,7 @@ 
      * @param number|ValueInterface $arg
      * @return Num
      */
-    public function div ($arg) {
+    public function div($arg) {
         $arg = $this->db->quote($arg);
         return Num::factory($this->db, "({$this} / {$arg})");
     }
@@ -103,7 +103,7 @@ 
      *
      * @return Num
      */
-    public function exp () {
+    public function exp() {
         return Num::factory($this->db, "EXP({$this})");
     }
 
@@ -112,7 +112,7 @@ 
      *
      * @return Num
      */
-    public function floor () {
+    public function floor() {
         return Num::factory($this->db, "FLOOR({$this})");
     }
 
@@ -121,7 +121,7 @@ 
      *
      * @return Predicate
      */
-    public function isEven () {
+    public function isEven() {
         return Predicate::factory($this->db, "({$this} % 2) = 0");
     }
 
@@ -130,7 +130,7 @@ 
      *
      * @return Predicate
      */
-    public function isNegative () {
+    public function isNegative() {
         return Predicate::factory($this->db, "{$this} < 0");
     }
 
@@ -139,7 +139,7 @@ 
      *
      * @return Predicate
      */
-    public function isOdd () {
+    public function isOdd() {
         return Predicate::factory($this->db, "({$this} % 2) <> 0");
     }
 
@@ -148,7 +148,7 @@ 
      *
      * @return Predicate
      */
-    public function isPositive () {
+    public function isPositive() {
         return Predicate::factory($this->db, "{$this} > 0");
     }
 
@@ -157,7 +157,7 @@ 
      *
      * @return Num
      */
-    public function ln () {
+    public function ln() {
         return Num::factory($this->db, "LN({$this})");
     }
 
@@ -169,7 +169,7 @@ 
      * @param float $base
      * @return Num
      */
-    public function log (float $base) {
+    public function log(float $base) {
         return Num::factory($this->db, "LOG({$base},{$this})");
     }
 
@@ -178,7 +178,7 @@ 
      *
      * @return Num
      */
-    public function log10 () {
+    public function log10() {
         return Num::factory($this->db, "LOG10({$this})");
     }
 
@@ -187,7 +187,7 @@ 
      *
      * @return Num
      */
-    public function log2 () {
+    public function log2() {
         return Num::factory($this->db, "LOG2({$this})");
     }
 
@@ -197,7 +197,7 @@ 
      * @param float $divisor
      * @return Num
      */
-    public function mod (float $divisor) {
+    public function mod(float $divisor) {
         return Num::factory($this->db, "({$this} % {$divisor})");
     }
 
@@ -207,7 +207,7 @@ 
      * @param number|ValueInterface $arg
      * @return Num
      */
-    public function mul ($arg) {
+    public function mul($arg) {
         $arg = $this->db->quote($arg);
         return Num::factory($this->db, "({$this} * {$arg})");
     }
@@ -218,7 +218,7 @@ 
      * @param float $exponent
      * @return Num
      */
-    public function pow (float $exponent) {
+    public function pow(float $exponent) {
         return Num::factory($this->db, "POW({$this},{$exponent})");
     }
 
@@ -229,7 +229,7 @@ 
      *
      * @return Num
      */
-    public function radians () {
+    public function radians() {
         return Num::factory($this->db, "RADIANS({$this})");
     }
 
@@ -239,7 +239,7 @@ 
      * @param int $decimals
      * @return Num
      */
-    public function round (int $decimals = 0) {
+    public function round(int $decimals = 0) {
         return Num::factory($this->db, "ROUND({$this},{$decimals})");
     }
 
@@ -248,7 +248,7 @@ 
      *
      * @return Num `-1`, `0`, `1`
      */
-    public function sign () {
+    public function sign() {
         return Num::factory($this->db, "SIGN({$this})");
     }
 
@@ -257,7 +257,7 @@ 
      *
      * @return Num
      */
-    public function sin () {
+    public function sin() {
         return Num::factory($this->db, "SIN({$this})");
     }
 
@@ -266,7 +266,7 @@ 
      *
      * @return Num
      */
-    public function sqrt () {
+    public function sqrt() {
         return Num::factory($this->db, "SQRT({$this})");
     }
 
@@ -276,7 +276,7 @@ 
      * @param number|ValueInterface $arg
      * @return Num
      */
-    public function sub ($arg) {
+    public function sub($arg) {
         $arg = $this->db->quote($arg);
         return Num::factory($this->db, "({$this} - {$arg})");
     }
@@ -286,7 +286,7 @@ 
      *
      * @return Num
      */
-    public function tan () {
+    public function tan() {
         return Num::factory($this->db, "TAN({$this})");
     }
 }
\ No newline at end of file

src/DB/SQL/CastTrait.php

Spacing +9 added lines, -9 removed lines

@@ -12,7 +12,7 @@ 
      * @param scalar[] $values
      * @return Value
      */
-    public function coalesce (array $values) {
+    public function coalesce(array $values) {
         array_unshift($values, $this);
         $values = $this->db->quoteList($values);
         return Value::factory($this->db, "COALESCE({$values})");
@@ -25,7 +25,7 @@ 
      * @param int $to
      * @return Text
      */
-    public function toBase (int $from, int $to) {
+    public function toBase(int $from, int $to) {
         return Text::factory($this->db, "CONV({$this},{$from},{$to})");
     }
 
@@ -35,7 +35,7 @@ 
      * @param int $from
      * @return Num
      */
-    public function toBase10 (int $from) {
+    public function toBase10(int $from) {
         return Num::factory($this->db, "CONV({$this},{$from},10)");
     }
 
@@ -47,7 +47,7 @@ 
      * @param int $from
      * @return Text
      */
-    public function toBase16 (int $from) {
+    public function toBase16(int $from) {
         return $this->toBase($from, 16);
     }
 
@@ -57,7 +57,7 @@ 
      * @param int $from
      * @return Text
      */
-    public function toBase2 (int $from) {
+    public function toBase2(int $from) {
         return $this->toBase($from, 2);
     }
 
@@ -67,7 +67,7 @@ 
      * @param int $from
      * @return Text
      */
-    public function toBase8 (int $from) {
+    public function toBase8(int $from) {
         return $this->toBase($from, 8);
     }
 
@@ -76,7 +76,7 @@ 
      *
      * @return Num
      */
-    public function toFloat () {
+    public function toFloat() {
         if ($this->db->isSQLite()) {
             return Num::factory($this->db, "CAST({$this} AS REAL)");
         }
@@ -88,7 +88,7 @@ 
      *
      * @return Num
      */
-    public function toInt () {
+    public function toInt() {
         if ($this->db->isSQLite()) {
             return Num::factory($this->db, "CAST({$this} AS INTEGER)");
         }
@@ -100,7 +100,7 @@ 
      *
      * @return Text
      */
-    public function toText () {
+    public function toText() {
         if ($this->db->isSQLite()) {
             return Text::factory($this->db, "CAST({$this} AS TEXT)");
         }

src/DB/Transaction.php

Spacing +4 added lines, -4 removed lines

@@ -33,7 +33,7 @@ 
      *
      * @param DB $db
      */
-    public function __construct (DB $db) {
+    public function __construct(DB $db) {
         $this->db = $db;
         $db->beginTransaction();
     }
@@ -41,7 +41,7 @@ 
     /**
      * Rolls back if the instance wasn't committed.
      */
-    public function __destruct () {
+    public function __destruct() {
         if (!$this->committed) {
             $this->db->rollBack();
         }
@@ -54,14 +54,14 @@ 
      *
      * @return true
      */
-    public function commit (): bool {
+    public function commit(): bool {
         return $this->committed or $this->committed = $this->db->commit();
     }
 
     /**
      * @return bool
      */
-    final public function wasCommitted (): bool {
+    final public function wasCommitted(): bool {
         return $this->committed;
     }
 }
\ No newline at end of file

src/DB/Table.php

Spacing +13 added lines, -13 removed lines

@@ -42,7 +42,7 @@ 
      * @param string $name
      * @param string[] $columns
      */
-    public function __construct (DB $db, string $name, array $columns) {
+    public function __construct(DB $db, string $name, array $columns) {
         parent::__construct($db);
         $this->name = $name;
         foreach ($columns as $column) {
@@ -55,7 +55,7 @@ 
      *
      * @return string
      */
-    final public function __toString () {
+    final public function __toString() {
         return $this->name;
     }
 
@@ -65,7 +65,7 @@ 
      * @param array $values
      * @return int Rows affected.
      */
-    public function apply (array $values): int {
+    public function apply(array $values): int {
         $columns = implode(',', array_keys($values));
         $values = $this->db->quoteList($values);
         if ($this->db->isSQLite()) {
@@ -85,7 +85,7 @@ 
      * @param Closure $prepare `():Statement`
      * @return Statement
      */
-    protected function cache (string $key, Closure $prepare) {
+    protected function cache(string $key, Closure $prepare) {
         return $this->_cache[$key] ??= $prepare->__invoke();
     }
 
@@ -93,7 +93,7 @@ 
      * @param array $match `[a => b]`
      * @return int
      */
-    public function count (array $match = []) {
+    public function count(array $match = []) {
         $select = $this->select(['COUNT(*)']);
         foreach ($match as $a => $b) {
             $select->where($this->db->match($this[$a] ?? $a, $b));
@@ -109,7 +109,7 @@ 
      * @param array $match
      * @return int Rows affected.
      */
-    public function delete (array $match): int {
+    public function delete(array $match): int {
         foreach ($match as $a => $b) {
             $match[$a] = $this->db->match($this[$a] ?? $a, $b);
         }
@@ -120,14 +120,14 @@ 
     /**
      * @return Column[]
      */
-    public function getColumns () {
+    public function getColumns() {
         return $this->columns;
     }
 
     /**
      * @return string
      */
-    final public function getName (): string {
+    final public function getName(): string {
         return $this->name;
     }
 
@@ -137,7 +137,7 @@ 
      * @param array $values
      * @return Statement
      */
-    public function insert (array $values) {
+    public function insert(array $values) {
         $columns = implode(',', array_keys($values));
         $values = $this->db->quoteList($values);
         return $this->db->query("INSERT INTO {$this} ($columns) VALUES ($values)");
@@ -147,7 +147,7 @@ 
      * @param int|string $column
      * @return Column
      */
-    public function offsetGet ($column) {
+    public function offsetGet($column) {
         if (is_int($column)) {
             return current(array_slice($this->columns, $column, 1)) ?: null;
         }
@@ -160,7 +160,7 @@ 
      * @param string[] $columns
      * @return Select|array[]
      */
-    public function select (array $columns = ['*']) {
+    public function select(array $columns = ['*']) {
         return Select::factory($this->db, $this, $columns);
     }
 
@@ -170,7 +170,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) {
@@ -188,7 +188,7 @@ 
      * @param array $match
      * @return int Rows affected.
      */
-    public function update (array $values, array $match): int {
+    public function update(array $values, array $match): int {
         foreach ($this->db->quoteArray($values) as $key => $value) {
             $values[$key] = "{$key} = {$value}";
         }

src/DB/AbstractTable.php

Spacing +7 added lines, -7 removed lines

@@ -16,20 +16,20 @@ 
      *
      * @return string
      */
-    abstract public function __toString ();
+    abstract public function __toString();
 
     /**
      * Columns keyed by name/alias.
      *
      * @return Column[]
      */
-    abstract public function getColumns ();
+    abstract public function getColumns();
 
     /**
      * @param int|string $column
      * @return null|Column
      */
-    abstract public function offsetGet ($column);
+    abstract public function offsetGet($column);
 
     /**
      * @var DB
@@ -39,7 +39,7 @@ 
     /**
      * @param DB $db
      */
-    public function __construct (DB $db) {
+    public function __construct(DB $db) {
         $this->db = $db;
     }
 
@@ -47,7 +47,7 @@ 
      * @param int|string $column
      * @return bool
      */
-    public function offsetExists ($column): bool {
+    public function offsetExists($column): bool {
         return $this->offsetGet($column) !== null;
     }
 
@@ -58,7 +58,7 @@ 
      * @param void $value
      * @throws Exception
      */
-    final public function offsetSet ($offset, $value): void {
+    final public function offsetSet($offset, $value): void {
         throw new Exception('Tables are immutable.');
     }
 
@@ -68,7 +68,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