ondrej-bouda / ivory

src/Ivory/Value/NetAddress.php

Doc Comments +2 added lines, -2 removed lines

@@ -114,7 +114,7 @@ 
     }
 
     /**
-     * @return bool whether the PHP was built with IPv6 support enabled
+     * @return boolean|null whether the PHP was built with IPv6 support enabled
      */
     private static function ipv6Support()
     {
@@ -348,7 +348,7 @@ 
      *
      * @param NetAddress|string $address a {@link NetAddress} or anything {@link NetAddress::fromString()} accepts as
      *                                     its first argument
-     * @return bool
+     * @return null|boolean
      */
     public function equals($address)
     {

Spacing +1 added lines, -1 removed lines

@@ -287,7 +287,7 @@
                 $i += $lzsLen - 1;
                 continue;
             }
-            $result .= (ltrim($fields[$i], '0') ? : '0');
+            $result .= (ltrim($fields[$i], '0') ?: '0');
         }
         if ($lzsStart + $lzsLen == 8) {
             $result .= ':';

Braces +11 added lines, -22 removed lines

@@ -136,8 +136,7 @@ 
 
         if ($netmaskLengthOrNetmask === null) {
             $this->netmaskLength = ($this->ipVersion == 6 ? 128 : 32);
-        }
-        else {
+        } else {
             if (filter_var($netmaskLengthOrNetmask, FILTER_VALIDATE_IP, FILTER_FLAG_IPV4) !== false) {
                 if ($this->ipVersion == 4) {
                     // taken from http://php.net/manual/en/function.ip2long.php#94787
@@ -148,12 +147,10 @@ 
                         throw new \InvalidArgumentException('Invalid netmask');
                     }
                     $this->netmaskLength = 32 - (int)$bits;
-                }
-                else {
+                } else {
                     throw new \InvalidArgumentException('Netmask may only be used for an IPv4 address.');
                 }
-            }
-            else {
+            } else {
                 $this->netmaskLength = filter_var($netmaskLengthOrNetmask, FILTER_VALIDATE_INT);
                 if ($this->netmaskLength === false) {
                     throw new \InvalidArgumentException('$netmaskLengthOrNetmask');
@@ -212,8 +209,7 @@ 
     {
         if ($this->ipVersion == 4) {
             return $this->addrStr;
-        }
-        else {
+        } else {
             if (!self::ipv6Support()) {
                 throw new NotImplementedException('PHP must be compiled with IPv6 support');
             }
@@ -259,12 +255,10 @@ 
                 if ($czsStart === null) {
                     $czsStart = $i;
                     $czsLen = 1;
-                }
-                else {
+                } else {
                     $czsLen++;
                 }
-            }
-            else {
+            } else {
                 if ($czsStart !== null) {
                     if ($czsLen > $lzsLen) {
                         $lzsStart = $czsStart;
@@ -302,8 +296,7 @@ 
     {
         if ($this->ipVersion == 6) {
             return ($this->netmaskLength == 128);
-        }
-        else {
+        } else {
             return ($this->netmaskLength == 32);
         }
     }
@@ -318,8 +311,7 @@ 
             $hostPartLen = 32 - $this->netmaskLength;
             $mask = (1 << $hostPartLen) - 1;
             return ((ip2long($this->addrStr) & $mask) == 0);
-        }
-        else {
+        } else {
             $hostPartLen = 128 - $this->netmaskLength;
             $hostPartOctets = (int)floor($hostPartLen / 8);
             $hostPartLeadBits = $hostPartLen % 8;
@@ -436,8 +428,7 @@ 
     {
         if ($this->isSingleHost()) {
             return $this->addrStr;
-        }
-        else {
+        } else {
             return $this->toCidrString();
         }
     }
@@ -461,8 +452,7 @@ 
     {
         if ($this->ipVersion == 4 || self::ipv6Support()) {
             return inet_pton($this->addrStr);
-        }
-        else {
+        } else {
             throw new NotImplementedException('PHP must be compiled with IPv6 support');
         }
     }
@@ -480,8 +470,7 @@ 
     {
         if ($this->ipVersion == 4) {
             return ip2long($this->addrStr);
-        }
-        else {
+        } else {
             throw new \LogicException('IPv6 address cannot be converted to long');
         }
     }

src/Ivory/Value/Range.php

Doc Comments +15 added lines, -8 removed lines

@@ -166,6 +166,9 @@ 
         return new Range($subtype, null, true, null, null, null, null);
     }
 
+    /**
+     * @param boolean $upperInc
+     */
     private static function processBoundSpec($boundsOrLowerInc = '[)', $upperInc = null)
     {
         if (is_string($boundsOrLowerInc)) {
@@ -193,6 +196,10 @@ 
     }
 
 
+    /**
+     * @param IRangeCanonicalFunc|null $canonicalFunc
+     * @param boolean $empty
+     */
     private function __construct(ITotallyOrderedType $subtype, $canonicalFunc, $empty, $lower, $upper, $lowerInc, $upperInc)
     {
         $this->subtype = $subtype;
@@ -372,7 +379,7 @@ 
 
     /**
      * @param mixed $element a value of the range subtype
-     * @return bool whether this range contains the given element;
+     * @return null|boolean whether this range contains the given element;
      *              <tt>null</tt> on <tt>null</tt> input
      */
     public function containsElement($element)
@@ -403,7 +410,7 @@ 
 
     /**
      * @param mixed $element value of the range subtype
-     * @return bool <tt>true</tt> iff this range is left of the given element - value of the range subtype;
+     * @return null|boolean <tt>true</tt> iff this range is left of the given element - value of the range subtype;
      *              <tt>false</tt> otherwise, especially if this range is empty;
      *              <tt>null</tt> on <tt>null</tt> input
      */
@@ -425,7 +432,7 @@ 
 
     /**
      * @param mixed $element value of the range subtype
-     * @return bool <tt>true</tt> iff this range is right of the given element - value of the range subtype;
+     * @return null|boolean <tt>true</tt> iff this range is right of the given element - value of the range subtype;
      *              <tt>false</tt> otherwise, especially if this range is empty;
      *              <tt>null</tt> on <tt>null</tt> input
      */
@@ -447,7 +454,7 @@ 
 
     /**
      * @param Range $other a range of the same subtype as this range
-     * @return bool whether this range entirely contains the other range;
+     * @return null|boolean whether this range entirely contains the other range;
      *              an empty range is considered to be contained in any range, even an empty one;
      *              <tt>null</tt> on <tt>null</tt> input
      */
@@ -495,7 +502,7 @@ 
 
     /**
      * @param Range $other a range of the same subtype as this range
-     * @return bool whether this range is entirely contained in the other range;
+     * @return null|boolean whether this range is entirely contained in the other range;
      *              an empty range is considered to be contained in any range, even an empty one;
      *              <tt>null</tt> on <tt>null</tt> input
      */
@@ -512,7 +519,7 @@ 
 
     /**
      * @param Range $other a range of the same subtype as this range
-     * @return bool whether this and the other range overlap, i.e., have a non-empty intersection;
+     * @return null|boolean whether this and the other range overlap, i.e., have a non-empty intersection;
      *              <tt>null</tt> on <tt>null</tt> input
      */
     public function overlaps($other)
@@ -626,7 +633,7 @@ 
 
     /**
      * @param Range|null $other a range of the same subtype as this range
-     * @return bool <tt>true</tt> iff this range is strictly left of the other range, i.e., it ends before the other
+     * @return null|boolean <tt>true</tt> iff this range is strictly left of the other range, i.e., it ends before the other
      *                starts;
      *              <tt>false</tt> otherwise, especially if either range is empty;
      *              <tt>null</tt> on <tt>null</tt> input
@@ -652,7 +659,7 @@ 
 
     /**
      * @param Range|null $other a range of the same subtype as this range
-     * @return bool <tt>true</tt> iff this range is strictly left of the other range, i.e., it ends before the other
+     * @return null|boolean <tt>true</tt> iff this range is strictly left of the other range, i.e., it ends before the other
      *                starts;
      *              <tt>false</tt> otherwise, especially if either range is empty;;
      *              <tt>null</tt> on <tt>null</tt> input

Braces +25 added lines, -50 removed lines

@@ -108,14 +108,12 @@ 
             $comp = $subtype->compareValues($lower, $upper);
             if ($comp > 0) {
                 return self::createEmpty($subtype);
-            }
-            elseif ($comp == 0) {
+            } elseif ($comp == 0) {
                 if (!$loInc || !$upInc) {
                     return self::createEmpty($subtype);
                 }
             }
-        }
-        else {
+        } else {
             if ($lower === null) {
                 $loInc = false;
             }
@@ -135,14 +133,12 @@ 
                 $comp = $subtype->compareValues($lower, $upper);
                 if ($comp > 0) {
                     return self::createEmpty($subtype);
-                }
-                elseif ($comp == 0) {
+                } elseif ($comp == 0) {
                     if (!$loInc || !$upInc) {
                         return self::createEmpty($subtype);
                     }
                 }
-            }
-            else {
+            } else {
                 if ($lower === null) {
                     $loInc = false;
                 }
@@ -183,8 +179,7 @@ 
 
             $loInc = ($boundsOrLowerInc[0] == '[');
             $upInc = ($boundsOrLowerInc[1] == ']');
-        }
-        else {
+        } else {
             $loInc = (bool)$boundsOrLowerInc;
             $upInc = (bool)$upperInc;
         }
@@ -263,8 +258,7 @@ 
     {
         if ($this->empty) {
             return null;
-        }
-        else {
+        } else {
             return ($this->lowerInc ? '[' : '(') . ($this->upperInc ? ']' : ')');
         }
     }
@@ -289,8 +283,7 @@ 
             $lo = ($this->lowerInc ? $this->lower : $this->subtype->step(1, $this->lower));
             $up = ($this->upperInc ? $this->upper : $this->subtype->step(-1, $this->upper));
             return ($this->subtype->compareValues($lo, $up) == 0);
-        }
-        else {
+        } else {
             return false;
         }
     }
@@ -328,8 +321,7 @@ 
 
         if ($this->lower === null) {
             $lo = null;
-        }
-        else {
+        } else {
             $lo = $this->lower;
             $step = $loInc - $this->lowerInc;
             if ($step) {
@@ -339,8 +331,7 @@ 
 
         if ($this->upper === null) {
             $up = null;
-        }
-        else {
+        } else {
             $up = $this->upper;
             $step = $this->upperInc - $upInc;
             if ($step) {
@@ -469,8 +460,7 @@ 
         if ($this->lower !== null) {
             if ($other->lower === null) {
                 return false;
-            }
-            else {
+            } else {
                 $cmp = $this->subtype->compareValues($this->lower, $other->lower);
                 if ($cmp > 0 || ($cmp == 0 && !$this->lowerInc && $other->lowerInc)) {
                     return false;
@@ -481,8 +471,7 @@ 
         if ($this->upper !== null) {
             if ($other->upper === null) {
                 return false;
-            }
-            else {
+            } else {
                 $cmp = $this->subtype->compareValues($this->upper, $other->upper);
                 if ($cmp < 0 || ($cmp == 0 && !$this->upperInc && $other->upperInc)) {
                     return false;
@@ -567,22 +556,18 @@ 
         if ($this->lower === null) {
             $lo = $other->lower;
             $loInc = $other->lowerInc;
-        }
-        elseif ($other->lower === null) {
+        } elseif ($other->lower === null) {
             $lo = $this->lower;
             $loInc = $this->lowerInc;
-        }
-        else {
+        } else {
             $cmp = $this->subtype->compareValues($this->lower, $other->lower);
             if ($cmp < 0) {
                 $lo = $other->lower;
                 $loInc = $other->lowerInc;
-            }
-            elseif ($cmp > 0) {
+            } elseif ($cmp > 0) {
                 $lo = $this->lower;
                 $loInc = $this->lowerInc;
-            }
-            else {
+            } else {
                 $lo = $this->lower;
                 $loInc = ($this->lowerInc && $other->lowerInc);
             }
@@ -591,22 +576,18 @@ 
         if ($this->upper === null) {
             $up = $other->upper;
             $upInc = $other->upperInc;
-        }
-        elseif ($other->upper === null) {
+        } elseif ($other->upper === null) {
             $up = $this->upper;
             $upInc = $this->upperInc;
-        }
-        else {
+        } else {
             $cmp = $this->subtype->compareValues($this->upper, $other->upper);
             if ($cmp < 0) {
                 $up = $this->upper;
                 $upInc = $this->upperInc;
-            }
-            elseif ($cmp > 0) {
+            } elseif ($cmp > 0) {
                 $up = $other->upper;
                 $upInc = $other->upperInc;
-            }
-            else {
+            } else {
                 $up = $this->upper;
                 $upInc = ($this->upperInc && $other->upperInc);
             }
@@ -710,13 +691,11 @@ 
             if ($object->lower !== null) {
                 return false;
             }
-        }
-        elseif ($this->lower instanceof IComparable) {
+        } elseif ($this->lower instanceof IComparable) {
             if (!$this->lower->equals($object->lower)) {
                 return false;
             }
-        }
-        else {
+        } else {
             if ($this->lower != $object->lower) {
                 return false;
             }
@@ -726,13 +705,11 @@ 
             if ($object->upper !== null) {
                 return false;
             }
-        }
-        elseif ($this->upper instanceof IComparable) {
+        } elseif ($this->upper instanceof IComparable) {
             if (!$this->upper->equals($object->upper)) {
                 return false;
             }
-        }
-        else {
+        } else {
             if ($this->upper != $object->upper) {
                 return false;
             }
@@ -754,11 +731,9 @@ 
     {
         if ($offset == 0) {
             return ($this->empty ? null : $this->lower);
-        }
-        elseif ($offset == 1) {
+        } elseif ($offset == 1) {
             return ($this->empty ? null : $this->upper);
-        }
-        else {
+        } else {
             trigger_error("Undefined range offset: $offset", E_USER_WARNING);
             return null;
         }

src/Ivory/Value/TextSearchQuery.php

Doc Comments +6 added lines

@@ -38,11 +38,17 @@
         return new TextSearchQuery($queryString);
     }
 
+    /**
+     * @param string $queryString
+     */
     private function __construct($queryString)
     {
         $this->queryString = $queryString;
     }
 
+    /**
+     * @return string
+     */
     public function toString()
     {
         return $this->queryString;

src/Ivory/Value/TimeInterval.php

Doc Comments +10 added lines, -1 removed lines

@@ -231,6 +231,9 @@ 
         return self::fromParts($parts);
     }
 
+    /**
+     * @param string $str
+     */
     private static function parseIsoDateStr($str)
     {
         if (preg_match('~^(-?\d+)-(-?\d+)-(-?\d+)$~', $str, $m)) {
@@ -284,6 +287,9 @@ 
         }
     }
 
+    /**
+     * @param string $str
+     */
     private static function parsePostgresqlStr($str, $offset = 0)
     {
         static $pgUnits = [
@@ -341,6 +347,9 @@ 
         return $parts;
     }
 
+    /**
+     * @param integer $offset
+     */
     private static function parseQuantityUnitPairs($str, $offset, $units)
     {
         $result = [];
@@ -450,7 +459,7 @@ 
     /**
      * Multiplies this time interval with a scalar and returns the result as a new time interval object.
      *
-     * @param number $multiplier
+     * @param integer $multiplier
      * @return TimeInterval
      */
     public function multiply($multiplier)

Spacing +2 added lines, -2 removed lines

@@ -245,7 +245,7 @@ 
             preg_match_all('~(-?\d+(?:\.\d+)?)([YMDW])~', $str, $matches, PREG_SET_ORDER);
             static $units = ['Y' => self::YEAR, 'M' => self::MONTH, 'D' => self::DAY, 'W' => self::WEEK];
             foreach ($matches as $m) {
-                $parts[ $units[$m[2]] ] = (float)$m[1];
+                $parts[$units[$m[2]]] = (float)$m[1];
             }
             return $parts;
         }
@@ -278,7 +278,7 @@ 
             preg_match_all('~(-?\d+(?:\.\d+)?)([HMS])~', $str, $matches, PREG_SET_ORDER, $offset);
             static $units = ['H' => self::HOUR, 'M' => self::MINUTE, 'S' => self::SECOND];
             foreach ($matches as $m) {
-                $parts[ $units[$m[2]] ] = (float)$m[1];
+                $parts[$units[$m[2]]] = (float)$m[1];
             }
             return $parts;
         }

Braces +8 added lines, -16 removed lines

@@ -198,20 +198,16 @@ 
             $timeDelimPos = strpos($str, 'T');
             if (!$timeDelimPos) {
                 $parts = self::parseIsoDateStr(substr($str, 1));
-            }
-            elseif ($timeDelimPos == 1) {
+            } elseif ($timeDelimPos == 1) {
                 $parts = self::parseTimeStr($str, 2);
-            }
-            else {
+            } else {
                 $parts = self::parseIsoDateStr(substr($str, 1, $timeDelimPos - 1)) +
                     self::parseTimeStr($str, $timeDelimPos + 1);
             }
-        }
-        elseif ($str[0] == '@') {
+        } elseif ($str[0] == '@') {
             // verbose PostgreSQL format
             $parts = self::parsePostgresqlStr($str, 1);
-        }
-        elseif (preg_match('~^(?:(-)?(\d+)-(\d+))?\s*(-?\d+)??\s*(-?\d+(?::\d+(?::\d+(?:\.\d+)?)?)?)?$~', $str, $m)) {
+        } elseif (preg_match('~^(?:(-)?(\d+)-(\d+))?\s*(-?\d+)??\s*(-?\d+(?::\d+(?::\d+(?:\.\d+)?)?)?)?$~', $str, $m)) {
             // sql format
             $parts = (isset($m[5]) ? self::parseTimeStr($m[5], 0, false) : []);
             if (!empty($m[2]) || !empty($m[3])) {
@@ -222,8 +218,7 @@ 
             if (!empty($m[4])) {
                 $parts[self::DAY] = (int)$m[4];
             }
-        }
-        else {
+        } else {
             // PostgreSQL format
             $parts = self::parsePostgresqlStr($str);
         }
@@ -239,8 +234,7 @@ 
                 self::MONTH => (int)$m[2],
                 self::DAY => (int)$m[3],
             ];
-        }
-        else {
+        } else {
             $parts = [];
             preg_match_all('~(-?\d+(?:\.\d+)?)([YMDW])~', $str, $matches, PREG_SET_ORDER);
             static $units = ['Y' => self::YEAR, 'M' => self::MONTH, 'D' => self::DAY, 'W' => self::WEEK];
@@ -266,14 +260,12 @@ 
                     self::MINUTE => $sgn * $m[2],
                     self::SECOND => $sgn * (isset($m[3]) ? (float)$m[3] : 0),
                 ];
-            }
-            else {
+            } else {
                 return [
                     self::SECOND => (float)$m[1],
                 ];
             }
-        }
-        else {
+        } else {
             $parts = [];
             preg_match_all('~(-?\d+(?:\.\d+)?)([HMS])~', $str, $matches, PREG_SET_ORDER, $offset);
             static $units = ['H' => self::HOUR, 'M' => self::MINUTE, 'S' => self::SECOND];

src/Ivory/Value/TxIdSnapshot.php

Doc Comments +4 added lines

@@ -56,6 +56,10 @@
         return self::fromParts($parts[0], $parts[1], $xipList);
     }
 
+    /**
+     * @param integer $xmin
+     * @param integer $xmax
+     */
     private function __construct($xmin, $xmax, $xipList)
     {
         $this->xmin = $xmin;

showcase/issues/mutability.php

Indentation +2 added lines, -2 removed lines

@@ -14,14 +14,14 @@
 // VERSION 1: mutable relations
 
 foreach ($personRel as $row) {
-	print_r($row); // prints just the 'id', 'firstname', and 'lastname' attributes
+    print_r($row); // prints just the 'id', 'firstname', and 'lastname' attributes
 }
 
 
 // VERSION 2: immutable relations
 
 foreach ($personRel as $row) {
-	print_r($row); // prints the whole person row, not just the three attributes
+    print_r($row); // prints the whole person row, not just the three attributes
 }
 
 // VERSION 2a: the project() and similar methods copy the entire object into a new one

showcase/issues/aliasing.php

Indentation +8 added lines, -8 removed lines

@@ -15,12 +15,12 @@ 
 $availPersonRel = new DbViewRelation('vw_avail_person', 'datatemplate');
 
 $sql = new StatementRelation(
-	"SELECT avail.room_id, %ln@p, 'the % sign is not expanded inside string literals'
+    "SELECT avail.room_id, %ln@p, 'the % sign is not expanded inside string literals'
 	 FROM % avail
 	      JOIN % p ON p.id = avail.person_id",
-	$personRel->project('id', 'firstname', 'lastname'),
-	$availPersonRel,
-	$personRel
+    $personRel->project('id', 'firstname', 'lastname'),
+    $availPersonRel,
+    $personRel
 );
 // "%ln" denotes a list of identifiers; in this case, it is fed with a relation, which causes to take all its attributes
 // the "@" sign denotes aliasing the relation of attributes
@@ -33,11 +33,11 @@ 
 $availPersonRel = new DbViewRelation('vw_avail_person', 'datatemplate');
 
 $sql = new StatementRelation(
-	"SELECT avail.room_id, %ln, 'the % sign is not expanded inside string literals'
+    "SELECT avail.room_id, %ln, 'the % sign is not expanded inside string literals'
 	 FROM %
 	      JOIN % ON p.id = avail.person_id",
-	$personRel->project('id', 'firstname', 'lastname'),
-	$availPersonRel->aliased('avail'),
-	$personRel
+    $personRel->project('id', 'firstname', 'lastname'),
+    $availPersonRel->aliased('avail'),
+    $personRel
 );
 // "%ln" denotes a list of identifiers; in this case, it is fed with a relation, which causes to take all its attributes

showcase/basic.php

Indentation +12 added lines, -12 removed lines

@@ -9,32 +9,32 @@
 $joesRel = $personRel->findWhere('firstname = %', 'Joe'); // the percent sign for no conversion - take "string"
 
 foreach ($joesRel as $row) {
-	printf("%s %s\n", $row['firstname'], $row['lastname']);
+    printf("%s %s\n", $row['firstname'], $row['lastname']);
 }
 
 $joesName = $joesRel->project(['firstname', 'lastname', 'dateofbirth']); // project() limits the attributes to be fetched only to the listed ones
 foreach ($joesName as $i => $row) {
-	printf("%d: %s %s, born on %s\n",
-		$i, $row['firstname'], $row['lastname'], $row['dateofbirth']->format('Y-m-d')
-	);
+    printf("%d: %s %s, born on %s\n",
+        $i, $row['firstname'], $row['lastname'], $row['dateofbirth']->format('Y-m-d')
+    );
 }
 
 $joeRows = $joesRel->map('id'); // fetch all columns, map by id
 foreach ($joeRows as $id => $row) {
-	printf("person #%d:\n", $id);
-	foreach ($row as $field => $value) {
-		printf("  %s => %s\n", $field, $value);
-	}
+    printf("person #%d:\n", $id);
+    foreach ($row as $field => $value) {
+        printf("  %s => %s\n", $field, $value);
+    }
 }
 
 $joesLastnameMap = $joesRel->map('id', 'lastname'); // fetch a map of person ids to lastnames
 foreach ($joesLastnameMap as $id => $lastname) {
-	printf("%d: %s\n", $id, $lastname);
+    printf("%d: %s\n", $id, $lastname);
 }
 
 $joesRowMap = $joesRel->map('id', ['firstname', 'lastname', 'dateofbirth']); // fetch a map of person ids to rows containing the person firstname, lastname, and date of birth
 foreach ($joesRowMap as $id => $row) {
-	printf("%d: %s %s, born on %s\n",
-		$id, $row['firstname'], $row['lastname'], $row['dateofbirth']->format('Y-m-d')
-	);
+    printf("%d: %s %s, born on %s\n",
+        $id, $row['firstname'], $row['lastname'], $row['dateofbirth']->format('Y-m-d')
+    );
 }

showcase/sql.php

Indentation +24 added lines, -24 removed lines

@@ -12,53 +12,53 @@
 $roomIds = [3, 4, 5];
 
 $sql = new StatementRelation(
-	"SELECT avail.room_id, %ln@p, 'the % sign is not expanded inside string literals'
+    "SELECT avail.room_id, %ln@p, 'the % sign is not expanded inside string literals'
 	 FROM % avail
 	      JOIN % p ON p.id = avail.person_id
 	 WHERE avail.room_id IN (%l) AND p.id IN (%l)
 	 ORDER BY avail.room_id, p.lastname, p.firstname",
-	$personRel->project('id', 'firstname', 'lastname'), // limit the person relation only to these attributes
-	$availPersonRel, // the real power comes in: any relation shall be applicable in the query
-	$personRel,
-	$roomIds, $employeeIds
+    $personRel->project('id', 'firstname', 'lastname'), // limit the person relation only to these attributes
+    $availPersonRel, // the real power comes in: any relation shall be applicable in the query
+    $personRel,
+    $roomIds, $employeeIds
 );
 // "%l" generally means a list of something; another formatting token may follow, specifying the list subtype
 // the list subtype may be omitted to use the identity conversion, just like for any argument
 // here, "%ln" denotes a list of identifiers; in this case, it is fed with a relation, which causes to take all its (three) attributes
 // the "@" sign denotes aliasing the relation of attributes
 foreach ($sql as $row) {
-	printf("%s %s available for room #%d\n", $row['firstname'], $row['lastname'], $row['room_id']);
+    printf("%s %s available for room #%d\n", $row['firstname'], $row['lastname'], $row['room_id']);
 }
 
 
 class PersonRole extends DbTableRelation
 {
-	public function __construct()
-	{
-		parent::__construct('person_role');
-	}
+    public function __construct()
+    {
+        parent::__construct('person_role');
+    }
 }
 
 class Role extends DbTableRelation
 {
-	const ADMIN = 1;
+    const ADMIN = 1;
 
-	public function __construct()
-	{
-		parent::__construct('role');
-	}
+    public function __construct()
+    {
+        parent::__construct('role');
+    }
 }
 
 $adminInfo = $personRel->project([
-	'id',
-	'fname' => 'firstname',
-	'lastname' => 'UPPER(lastname)',
-	'is_admin' => new Statement("EXISTS(SELECT 1 FROM %n WHERE role = %)", PersonRole::class, Role::ADMIN), // unfortunately, PHP implements ::class as mere string, not an object of a special class, thus, the explicit %n must be used
+    'id',
+    'fname' => 'firstname',
+    'lastname' => 'UPPER(lastname)',
+    'is_admin' => new Statement("EXISTS(SELECT 1 FROM %n WHERE role = %)", PersonRole::class, Role::ADMIN), // unfortunately, PHP implements ::class as mere string, not an object of a special class, thus, the explicit %n must be used
 ]);
 foreach ($adminInfo as $row) {
-	echo $row['fname'] . ' ' . $row['lastname'];
-	if ($row['is_admin']) {
-		echo ' is admin';
-	}
-	echo "\n";
+    echo $row['fname'] . ' ' . $row['lastname'];
+    if ($row['is_admin']) {
+        echo ' is admin';
+    }
+    echo "\n";
 }