hfw / db

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->getDriver() === 'sqlite') {
             return new Text($this->db, "CAST({$this} AS TEXT)");
         }

src/DB.php

Spacing +21 added lines, -21 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);
@@ -74,7 +74,7 @@ 
      * @param string $sql
      * @return int
      */
-    public function exec ($sql): int {
+    public function exec($sql): int {
         $this->logger->__invoke($sql);
         return parent::exec($sql);
     }
@@ -82,7 +82,7 @@ 
     /**
      * @return string
      */
-    final public function getDriver (): string {
+    final public function getDriver(): string {
         return $this->driver;
     }
 
@@ -92,7 +92,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);
         }
@@ -102,7 +102,7 @@ 
     /**
      * @return Closure
      */
-    public function getLogger () {
+    public function getLogger() {
         return $this->logger;
     }
 
@@ -112,7 +112,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);
@@ -137,7 +137,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);
@@ -163,7 +163,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);
     }
 
@@ -171,7 +171,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);
     }
 
@@ -179,7 +179,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);
         }
@@ -193,7 +193,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);
         }
@@ -205,7 +205,7 @@ 
     /**
      * @param string $class Class or interface name.
      */
-    public function offsetUnset ($class) {
+    public function offsetUnset($class) {
         unset($this->records[$class]);
         unset($this->junctions[$class]);
     }
@@ -217,7 +217,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);
@@ -233,7 +233,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());
@@ -252,7 +252,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;
         }
@@ -272,7 +272,7 @@ 
      * @param array $values
      * @return string[]
      */
-    public function quoteArray (array $values): array {
+    public function quoteArray(array $values): array {
         return array_map([$this, 'quote'], $values);
     }
 
@@ -282,7 +282,7 @@ 
      * @param mixed $value
      * @return string|string[]
      */
-    public function quoteMixed ($value) {
+    public function quoteMixed($value) {
         if (is_array($value)) {
             return $this->quoteArray($value);
         }
@@ -295,7 +295,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);
     }
 
@@ -304,7 +304,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;
     }
@@ -313,7 +313,7 @@ 
      * @param Closure $logger
      * @return $this
      */
-    public function setLogger (Closure $logger) {
+    public function setLogger(Closure $logger) {
         $this->logger = $logger;
         return $this;
     }
@@ -323,7 +323,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/ComparisonTrait.php

Spacing +14 added lines, -14 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];
         }
@@ -44,7 +44,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)}");
     }
 
@@ -54,7 +54,7 @@ 
      * @param string|array|Select $arg
      * @return Predicate
      */
-    public function isEqual ($arg) {
+    public function isEqual($arg) {
         return Predicate::compare($this, $this->db->quoteMixed($arg));
     }
 
@@ -64,7 +64,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isGreater ($arg) {
+    public function isGreater($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '>', 'ALL');
     }
 
@@ -74,7 +74,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isGreaterOrEqual ($arg) {
+    public function isGreaterOrEqual($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '>=', 'ALL');
     }
 
@@ -84,7 +84,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isLess ($arg) {
+    public function isLess($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '<', 'ALL');
     }
 
@@ -94,7 +94,7 @@ 
      * @param string|Select $arg
      * @return Predicate
      */
-    public function isLessOrEqual ($arg) {
+    public function isLessOrEqual($arg) {
         return Predicate::compare($this, $this->db->quote($arg), '<=', 'ALL');
     }
 
@@ -104,7 +104,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');
     }
 
@@ -114,7 +114,7 @@ 
      * @param null|bool|string|Select $arg
      * @return Predicate
      */
-    public function isNot ($arg) {
+    public function isNot($arg) {
         return $this->is($arg)->invert();
     }
 
@@ -125,7 +125,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)}");
     }
 
@@ -135,7 +135,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');
     }
 
@@ -145,7 +145,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');
     }
 
@@ -155,7 +155,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');
     }
 
@@ -165,7 +165,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/Select.php

Spacing +23 added lines, -23 removed lines

@@ -74,7 +74,7 @@ 
      * @param string|Select $table
      * @param string[] $columns
      */
-    public function __construct (DB $db, $table, array $columns) {
+    public function __construct(DB $db, $table, array $columns) {
         parent::__construct($db);
         if ($table instanceof Select) {
             $table = $table->toSubquery();
@@ -96,7 +96,7 @@ 
     /**
      * Gives the clone a new alias.
      */
-    public function __clone () {
+    public function __clone() {
         $this->alias = uniqid('_') . "__{$this->table}";
     }
 
@@ -104,7 +104,7 @@ 
      * @param array $args
      * @return Statement
      */
-    public function __invoke (array $args = []) {
+    public function __invoke(array $args = []) {
         return $this->execute($args);
     }
 
@@ -113,7 +113,7 @@ 
      *
      * @return string
      */
-    final public function __toString () {
+    final public function __toString() {
         return $this->alias;
     }
 
@@ -123,7 +123,7 @@ 
      * @param array $args Execution arguments.
      * @return int
      */
-    public function count (array $args = []): int {
+    public function count(array $args = []): int {
         $clone = clone $this;
         $clone->_columns = 'COUNT(*)';
         return (int)$clone->execute($args)->fetchColumn();
@@ -135,7 +135,7 @@ 
      * @param array $args
      * @return Statement
      */
-    public function execute (array $args = []) {
+    public function execute(array $args = []) {
         if (empty($args)) {
             return $this->db->query($this->toSql());
         }
@@ -150,7 +150,7 @@ 
      * @param array $args Execution arguments.
      * @return array
      */
-    public function fetchAll (array $args = []): array {
+    public function fetchAll(array $args = []): array {
         return iterator_to_array($this->fetcher->__invoke($this->execute($args)));
     }
 
@@ -163,7 +163,7 @@ 
      * @param array $args Execution arguments.
      * @return Generator
      */
-    public function fetchEach (array $args = []) {
+    public function fetchEach(array $args = []) {
         yield from $this->fetcher->__invoke($this->execute($args));
     }
 
@@ -174,7 +174,7 @@ 
      *
      * @return Generator
      */
-    public function getIterator () {
+    public function getIterator() {
         yield from $this->fetchEach();
     }
 
@@ -184,7 +184,7 @@ 
      * @param string $column
      * @return $this
      */
-    public function group (string $column) {
+    public function group(string $column) {
         if (!strlen($this->_group)) {
             $this->_group = " GROUP BY {$column}";
         }
@@ -200,7 +200,7 @@ 
      * @param string $condition
      * @return $this
      */
-    public function having (string $condition) {
+    public function having(string $condition) {
         if (!strlen($this->_having)) {
             $this->_having = " HAVING {$condition}";
         }
@@ -215,7 +215,7 @@ 
      *
      * @return Predicate
      */
-    public function isEmpty () {
+    public function isEmpty() {
         return new Predicate("NOT EXISTS ({$this->toSql()}");
     }
 
@@ -224,7 +224,7 @@ 
      *
      * @return Predicate
      */
-    public function isNotEmpty () {
+    public function isNotEmpty() {
         return new Predicate("EXISTS ({$this->toSql()})");
     }
 
@@ -236,7 +236,7 @@ 
      * @param string $type
      * @return $this
      */
-    public function join ($table, string $condition, string $type = 'INNER') {
+    public function join($table, string $condition, string $type = 'INNER') {
         if ($table instanceof Select) {
             $table = $table->toSubquery();
         }
@@ -251,7 +251,7 @@ 
      * @param int $offset
      * @return $this
      */
-    public function limit (int $limit, int $offset = 0) {
+    public function limit(int $limit, int $offset = 0) {
         if ($limit == 0) {
             $this->_limit = '';
         }
@@ -270,7 +270,7 @@ 
      * @param string $name Name or alias if used.
      * @return bool
      */
-    public function offsetExists ($name): bool {
+    public function offsetExists($name): bool {
         return true;
     }
 
@@ -280,7 +280,7 @@ 
      * @param string $name Name, or alias if used.
      * @return Column
      */
-    public function offsetGet ($name) {
+    public function offsetGet($name) {
         return new Column($this->db, $name, $this->alias);
     }
 
@@ -290,7 +290,7 @@ 
      * @param string $order
      * @return $this
      */
-    public function order (string $order) {
+    public function order(string $order) {
         if (strlen($order)) {
             $order = " ORDER BY {$order}";
         }
@@ -301,7 +301,7 @@ 
     /**
      * @return Statement
      */
-    public function prepare () {
+    public function prepare() {
         return $this->db->prepare($this->toSql());
     }
 
@@ -309,7 +309,7 @@ 
      * @param Closure $fetcher
      * @return $this
      */
-    public function setFetcher (Closure $fetcher) {
+    public function setFetcher(Closure $fetcher) {
         $this->fetcher = $fetcher;
         return $this;
     }
@@ -317,7 +317,7 @@ 
     /**
      * @return string
      */
-    public function toSql (): string {
+    public function toSql(): string {
         $sql = "SELECT {$this->_columns} FROM {$this->table}";
         $sql .= $this->_join;
         $sql .= $this->_where;
@@ -333,7 +333,7 @@ 
      *
      * @return string
      */
-    public function toSubquery (): string {
+    public function toSubquery(): string {
         return "({$this->toSql()}) AS {$this->alias}";
     }
 
@@ -343,7 +343,7 @@ 
      * @param string $condition
      * @return $this
      */
-    public function where (string $condition) {
+    public function where(string $condition) {
         if (!strlen($this->_where)) {
             $this->_where = " WHERE {$condition}";
         }