aAV5=aAV`5<saAVP`5֒aAV0@~8G aAVP09paAV0P9taAV9<}aAV9H⒔aAV:H⒔aAV;H⒔aAV<H⒔aAV=H⒔aAV>H aAVP?paAVP?taAV?<}aAV?H aAVP(@paAVP@taAV@<}aAV@H aAVPp8ApaAVpPAtaAVA<}aAV@AH⒔aAV0@BH⒔aAV0@CH⒔aAV0@DH⒔aAV0@EH⒔aAV0@FH⒔aAV0@GH⒔aAV0@HHaAV0HI=嗔aAV PIAaAVI<}aAVIH⒔aAVJH⒔aAVKH aAVPPLpaAVPLtaAVL<}aAVLH aAVP`MpaAVPMtaAVM<}aAVpMH aAVP`pNpaAV`PNtaAVN<}aAV0NH⒔aAV 0OH⒔aAV 0PH⒔aAV 0QH⒔aAV 0RH⒔aAV 0SH⒔aAV 0TH⒔aAV 0UH⒔aAV 0VH1aAVV>~aAVX>RP8VRPp*Vp*V@RPpRPȢ(VPPȢ(V(PȢ(VPȢ(VPȢ(V`(Vp*Vp*VPPXc7Vp*Vp*VQPRPp*Vp*VQPXPȢ(V;VȢ(VBPȢ(V0PȢ(V9fVȢ(V9fVȢ(V8VȢ(V9fV@VP (VȚPȢ(VPȢ(V,Vp*Vp*VhPxPp*Vp*VxPPp*Vp*VoP(PȢ(VQPȢ(V8wPȢ(VPQPȢ(VPȢ(V+pVȢ(V+pVȢ(VJPȢ(V`PE,*]9)G=Q3Q$ G=Q3Qzšɲ(`F=Qx3QTgX0F=Q3QC>G(E=Q3QD6U=Q`3Q6P?U=Q7Q5Rp(POQ7QꄰzQOQ7Q"ڒK&FQ7QuUOQ8 ;QL9&;Q:Q S6f &;Qx:QQ@,QP:Q6]kbs蠨,QH*QDK?٬:`$;Q*Q@8V=Ԁ#;Q*Q@\%,Q*Qȉ\%߀,Qx*Q@Ƹo0";Q*Q9_{I.Ӟk=Q@*Q*^pn=Q*QMVV/QP*Q07h0W/Q*Q d[닮W/Q*QZnY{pQX*QCڌe! ;Qcomparison($x, self::NEQ, $y); } /** * Creates a lower-than comparison expression with the given arguments. * First argument is considered the left expression and the second is the right expression. * When converted to string, it will generated a < . Example: * * [php] * // u.id < ? * $q->where($q->expr()->lt('u.id', '?')); * * @param mixed $x The left expression. * @param mixed $y The right expression. * * @return string */ public function lt($x, $y) { return $this->comparison($x, self::LT, $y); } /** * Creates a lower-than-equal comparison expression with the given arguments. * First argument is considered the left expression and the second is the right expression. * When converted to string, it will generated a <= . Example: * * [php] * // u.id <= ? * $q->where($q->expr()->lte('u.id', '?')); * * @param mixed $x The left expression. * @param mixed $y The right expression. * * @return string */ public function lte($x, $y) { return $this->comparison($x, self::LTE, $y); } /** * Creates a greater-than comparison expression with the given arguments. * First argument is considered the left expression and the second is the right expression. * When converted to string, it will generated a > . Example: * * [php] * // u.id > ? * $q->where($q->expr()->gt('u.id', '?')); * * @param mixed $x The left expression. * @param mixed $y The right expression. * * @return string */ public function gt($x, $y) { return $this->comparison($x, self::GT, $y); } /** * Creates a greater-than-equal comparison expression with the given arguments. * First argument is considered the left expression and the second is the right expression. * When converted to string, it will generated a >= . Example: * * [php] * // u.id >= ? * $q->where($q->expr()->gte('u.id', '?')); * * @param mixed $x The left expression. * @param mixed $y The right expression. * * @return string */ public function gte($x, $y) { return $this->comparison($x, self::GTE, $y); } /** * Creates an IS NULL expression with the given arguments. * * @param string $x The expression to be restricted by IS NULL. * * @return string */ public function isNull($x) { return $x . ' IS NULL'; } /** * Creates an IS NOT NULL expression with the given arguments. * * @param string $x The expression to be restricted by IS NOT NULL. * * @return string */ public function isNotNull($x) { return $x . ' IS NOT NULL'; } /** * Creates a LIKE() comparison expression with the given arguments. * * @param string $x The expression to be inspected by the LIKE comparison * @param mixed $y The pattern to compare against * * @return string */ public function like($x, $y/*, ?string $escapeChar = null */) { return $this->comparison($x, 'LIKE', $y) . (func_num_args() >= 3 ? sprintf(' ESCAPE %s', func_get_arg(2)) : ''); } /** * Creates a NOT LIKE() comparison expression with the given arguments. * * @param string $x The expression to be inspected by the NOT LIKE comparison * @param mixed $y The pattern to compare against * * @return string */ public function notLike($x, $y/*, ?string $escapeChar = null */) { return $this->comparison($x, 'NOT LIKE', $y) . (func_num_args() >= 3 ? sprintf(' ESCAPE %s', func_get_arg(2)) : ''); } /** * Creates an IN () comparison expression with the given arguments. * * @param string $x The SQL expression to be matched against the set. * @param string|string[] $y The SQL expression or an array of SQL expressions representing the set. * * @return string */ public function in($x, $y) { return $this->comparison($x, 'IN', '(' . implode(', ', (array) $y) . ')'); } /** * Creates a NOT IN () comparison expression with the given arguments. * * @param string $x The SQL expression to be matched against the set. * @param string|string[] $y The SQL expression or an array of SQL expressions representing the set. * * @return string */ public function notIn($x, $y) { return $this->comparison($x, 'NOT IN', '(' . implode(', ', (array) $y) . ')'); } /** * Builds an SQL literal from a given input parameter. * * The usage of this method is discouraged. Use prepared statements * or {@see AbstractPlatform::quoteStringLiteral()} instead. * * @param mixed $input The parameter to be quoted. * @param int|null $type The type of the parameter. * * @return string */ public function literal($input, $type = null) { return $this->connection->quote($input, $type); } }