hfw / db

src/DB/AbstractTable.php

Spacing +6 added lines, -6 removed lines

@@ -19,7 +19,7 @@ 
     /**
      * @param DB $db
      */
-    public function __construct (DB $db) {
+    public function __construct(DB $db) {
         $this->db = $db;
     }
 
@@ -28,19 +28,19 @@ 
      *
      * @return string
      */
-    abstract public function __toString ();
+    abstract public function __toString();
 
     /**
      * @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);
+    abstract public function offsetGet($name);
 
     /**
      * Throws.
@@ -49,7 +49,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.');
     }
 
@@ -59,7 +59,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.php

Braces +1 added lines, -2 removed lines

@@ -196,8 +196,7 @@
     public function offsetSet ($class, $access) {
         if ($access instanceof Record) {
             $this->setRecord($class, $access);
-        }
-        else {
+        } else {
             $this->setJunction($class, $access);
         }
     }

Spacing +23 added lines, -23 removed lines

@@ -52,7 +52,7 @@ 
      * @param string $passwd
      * @param array $options
      */
-    public function __construct ($dsn, $username = null, $passwd = null, $options = null) {
+    public function __construct($dsn, $username = null, $passwd = null, $options = null) {
         parent::__construct($dsn, $username, $passwd, $options);
         $this->driver = $this->getAttribute(self::ATTR_DRIVER_NAME);
         $this->setAttribute(self::ATTR_DEFAULT_FETCH_MODE, self::FETCH_ASSOC);
@@ -73,7 +73,7 @@ 
      *
      * @return string
      */
-    final public function __toString () {
+    final public function __toString() {
         return $this->driver;
     }
 
@@ -83,7 +83,7 @@ 
      * @param string $sql
      * @return int
      */
-    public function exec ($sql): int {
+    public function exec($sql): int {
         $this->logger->__invoke($sql);
         return parent::exec($sql);
     }
@@ -91,7 +91,7 @@ 
     /**
      * @return string
      */
-    final public function getDriver (): string {
+    final public function getDriver(): string {
         return $this->driver;
     }
 
@@ -101,7 +101,7 @@ 
      * @param string $interface
      * @return Junction
      */
-    public function getJunction ($interface) {
+    public function getJunction($interface) {
         if (!isset($this->junctions[$interface])) {
             $this->junctions[$interface] = Junction::fromInterface($this, $interface);
         }
@@ -111,7 +111,7 @@ 
     /**
      * @return Closure
      */
-    public function getLogger () {
+    public function getLogger() {
         return $this->logger;
     }
 
@@ -121,7 +121,7 @@ 
      * @param string|EntityInterface $class
      * @return Record
      */
-    public function getRecord ($class) {
+    public function getRecord($class) {
         $name = $class;
         if (is_object($name)) {
             $name = get_class($name);
@@ -148,7 +148,7 @@ 
      * @param mixed $b
      * @return string
      */
-    public function match ($a, $b) {
+    public function match($a, $b) {
         if ($b instanceof Closure) {
             if (!$a instanceof Column) {
                 $a = new Column($this, $a);
@@ -174,7 +174,7 @@ 
      * @param array $match
      * @return string[]
      */
-    public function matchArray (array $match) {
+    public function matchArray(array $match) {
         return array_map([$this, 'match'], array_keys($match), $match);
     }
 
@@ -182,7 +182,7 @@ 
      * @param string $class Class or interface name.
      * @return bool
      */
-    public function offsetExists ($class): bool {
+    public function offsetExists($class): bool {
         return (bool)$this->offsetGet($class);
     }
 
@@ -190,7 +190,7 @@ 
      * @param string $class Class or interface name.
      * @return null|Record|Junction
      */
-    public function offsetGet ($class) {
+    public function offsetGet($class) {
         if (class_exists($class)) {
             return $this->getRecord($class);
         }
@@ -204,7 +204,7 @@ 
      * @param string $class Class or interface name.
      * @param Record|Junction $access
      */
-    public function offsetSet ($class, $access) {
+    public function offsetSet($class, $access) {
         if ($access instanceof Record) {
             $this->setRecord($class, $access);
         }
@@ -216,7 +216,7 @@ 
     /**
      * @param string $class Class or interface name.
      */
-    public function offsetUnset ($class) {
+    public function offsetUnset($class) {
         unset($this->records[$class]);
         unset($this->junctions[$class]);
     }
@@ -228,7 +228,7 @@ 
      * @param array $options
      * @return Statement
      */
-    public function prepare ($sql, $options = []) {
+    public function prepare($sql, $options = []) {
         $this->logger->__invoke($sql);
         /** @var Statement $statement */
         $statement = parent::prepare($sql, $options);
@@ -244,7 +244,7 @@ 
      * @param array $ctorargs
      * @return Statement
      */
-    public function query ($sql, $mode = PDO::ATTR_DEFAULT_FETCH_MODE, $arg3 = null, array $ctorargs = []) {
+    public function query($sql, $mode = PDO::ATTR_DEFAULT_FETCH_MODE, $arg3 = null, array $ctorargs = []) {
         $this->logger->__invoke($sql);
         /** @var Statement $statement */
         $statement = parent::query(...func_get_args());
@@ -263,7 +263,7 @@ 
      * @param int $type Ignored.
      * @return string
      */
-    public function quote ($value, $type = null) {
+    public function quote($value, $type = null) {
         if ($value instanceof ExpressionInterface) {
             return $value;
         }
@@ -283,7 +283,7 @@ 
      * @param array $values
      * @return string[]
      */
-    public function quoteArray (array $values): array {
+    public function quoteArray(array $values): array {
         return array_map([$this, 'quote'], $values);
     }
 
@@ -293,7 +293,7 @@ 
      * @param array $values
      * @return string
      */
-    public function quoteList (array $values): string {
+    public function quoteList(array $values): string {
         return implode(',', $this->quoteArray($values));
     }
 
@@ -303,7 +303,7 @@ 
      * @param mixed $value
      * @return string|string[]
      */
-    public function quoteMixed ($value) {
+    public function quoteMixed($value) {
         if (is_array($value)) {
             return $this->quoteArray($value);
         }
@@ -316,7 +316,7 @@ 
      * @param EntityInterface $entity
      * @return int ID
      */
-    public function save (EntityInterface $entity): int {
+    public function save(EntityInterface $entity): int {
         return $this->getRecord($entity)->save($entity);
     }
 
@@ -325,7 +325,7 @@ 
      * @param Junction $junction
      * @return $this
      */
-    public function setJunction (string $interface, Junction $junction) {
+    public function setJunction(string $interface, Junction $junction) {
         $this->junctions[$interface] = $junction;
         return $this;
     }
@@ -334,7 +334,7 @@ 
      * @param Closure $logger
      * @return $this
      */
-    public function setLogger (Closure $logger) {
+    public function setLogger(Closure $logger) {
         $this->logger = $logger;
         return $this;
     }
@@ -344,7 +344,7 @@ 
      * @param Record $record
      * @return $this
      */
-    public function setRecord (string $class, Record $record) {
+    public function setRecord(string $class, Record $record) {
         $this->records[$class] = $record;
         return $this;
     }

src/DB/SQL/Value.php

Spacing +1 added lines, -1 removed lines

@@ -12,7 +12,7 @@
     use ComparisonTrait;
     use AggregateTrait;
 
-    public function __construct (DB $db, string $expression) {
+    public function __construct(DB $db, string $expression) {
         $this->db = $db;
         parent::__construct($expression);
     }

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

Spacing +14 added lines, -14 removed lines

@@ -39,7 +39,7 @@ 
      * @param string $name
      * @param string[] $columns
      */
-    public function __construct (DB $db, $name, array $columns) {
+    public function __construct(DB $db, $name, array $columns) {
         parent::__construct($db);
         $this->name = $name;
         foreach ($columns as $column) {
@@ -52,7 +52,7 @@ 
      *
      * @return string
      */
-    final public function __toString () {
+    final public function __toString() {
         return $this->name;
     }
 
@@ -62,7 +62,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 = implode(', ', $this->db->quoteArray($values));
         switch ($this->db) {
@@ -84,7 +84,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] ?? $this->_cache[$key] = $prepare->__invoke();
     }
 
@@ -92,7 +92,7 @@ 
      * @param array $match
      * @return int
      */
-    public function count (array $match = []) {
+    public function count(array $match = []) {
         $select = $this->select(['COUNT(*)']);
         foreach ($this->db->matchArray($match) as $condition) {
             $select->where($condition);
@@ -108,7 +108,7 @@ 
      * @param array $match
      * @return int Rows affected.
      */
-    public function delete (array $match): int {
+    public function delete(array $match): int {
         $match = Predicate::all($this->db->matchArray($match));
         return $this->db->exec("DELETE FROM {$this} WHERE {$match}");
     }
@@ -116,14 +116,14 @@ 
     /**
      * @return Column[]
      */
-    final public function getColumns (): array {
+    final public function getColumns(): array {
         return $this->columns;
     }
 
     /**
      * @return string
      */
-    final public function getName (): string {
+    final public function getName(): string {
         return $this->name;
     }
 
@@ -133,7 +133,7 @@ 
      * @param array $values
      * @return Statement
      */
-    public function insert (array $values) {
+    public function insert(array $values) {
         $columns = implode(',', array_keys($values));
         $values = implode(', ', $this->db->quoteArray($values));
         return $this->db->query("INSERT INTO {$this} ($columns) VALUES ($values)");
@@ -143,7 +143,7 @@ 
      * @param string $name
      * @return bool
      */
-    public function offsetExists ($name): bool {
+    public function offsetExists($name): bool {
         return isset($this->columns[$name]);
     }
 
@@ -151,7 +151,7 @@ 
      * @param string $name
      * @return Column
      */
-    public function offsetGet ($name) {
+    public function offsetGet($name) {
         return $this->columns[$name];
     }
 
@@ -161,7 +161,7 @@ 
      * @param string[] $columns Defaults to all columns.
      * @return Select
      */
-    public function select (array $columns = []) {
+    public function select(array $columns = []) {
         if (empty($columns)) {
             $columns = $this->columns;
         }
@@ -174,7 +174,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) {
@@ -192,7 +192,7 @@ 
      * @param array $match
      * @return int Rows affected.
      */
-    public function update (array $values, array $match): int {
+    public function update(array $values, array $match): int {
         $values = implode(', ', $this->db->matchArray($values));
         $match = Predicate::all($this->db->matchArray($match));
         return $this->db->exec("UPDATE {$this} SET {$values} WHERE {$match}");

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) {
         $driver = $this->db->getDriver();
         if (is_array($format)) {
             $format = $format[$driver];
@@ -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) {
             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/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 new Numeric($this->db, "CAST({$this} AS REAL)");
@@ -28,7 +28,7 @@ 
      *
      * @return Numeric
      */
-    public function toInt () {
+    public function toInt() {
         switch ($this->db) {
             case 'sqlite':
                 return new Numeric($this->db, "CAST({$this} AS INTEGER)");