ComparisonTrait::coalesce() - Code Metrics - Inspection of "Added ComparisonTrait->coalesce()" - hfw/db - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 305c34...2bac56 )

by y

created 2019-03-12 22:40 UTC

ComparisonTrait::coalesce() A

↳ Parent: ComparisonTrait

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	3
dl	0
loc	4
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	1

<?php

namespace Helix\DB\SQL;

use Helix\DB;
use Helix\DB\Select;

/**
 * Produces comparative expressions for the instance.
 */
trait ComparisonTrait {

    use PredicateTrait;

    /**
     * @var DB
     */
    protected $db;

    /**
     * `COALESCE($this, ...$values)`
     *
     * @param array $values
     * @return Value
     */
    public function coalesce (array $values) {
        array_unshift($values, $this);
        $values = implode(',', $this->db->quoteArray($values));
        return new Value($this->db, "COALESCE({$values})");
    }

    /**
     * `CASE $this ... END`
     *
     * @param string[] $values `[when => then]`
     * @return Choice
     */
    public function getChoice (array $values) {
        return new Choice($this->db, $this, $values);
        return new Choice($this->db, /** @scrutinizer ignore-type */ $this, $values);
    }

    /**
     * Null-safe equality.
     *
     * - Mysql: `$this <=> $arg`, or `$this <=> ANY ($arg)`
     * - Sqlite: `$this IS $arg`, or `$this IS ANY ($arg)`
     *
     * @param null|bool|string|Select $arg
     * @return Predicate
     */
    public function is ($arg): Predicate {
        if ($arg === null or is_bool($arg)) {
            $arg = ['' => 'NULL', 1 => 'TRUE', 0 => 'FALSE'][$arg];
        }
        else {
            $arg = $this->db->quote($arg);
        }
        $oper = ['mysql' => '<=>', 'sqlite' => 'IS'][$this->db->getDriver()];
        return Predicate::compare($this, $arg, $oper, 'ANY');
    }

    /**
     * `$this BETWEEN $min AND $max` (inclusive)
     *
     * @param number|string $min
     * @param number|string $max
     * @return Predicate
     */
    public function isBetween ($min, $max) {
        return new Predicate("{$this} BETWEEN {$this->db->quote($min)} AND {$this->db->quote($max)}");
    }

    /**
     * `$this = $arg`, or `$this IN (...$arg)`, or `$this = ANY ($arg)`
     *
     * @param string|array|Select $arg
     * @return Predicate
     */
    public function isEqual ($arg) {
        return Predicate::compare($this, $this->db->quoteMixed($arg));
    }

    /**
     * `$this > $arg`, or `$this > ALL ($arg)`
     *
     * @param string|Select $arg
     * @return Predicate
     */
    public function isGreater ($arg) {
        return Predicate::compare($this, $this->db->quote($arg), '>', 'ALL');
    }

    /**
     * `$this >= $arg`, or `$this >= ALL ($arg)`
     *
     * @param string|Select $arg
     * @return Predicate
     */
    public function isGreaterOrEqual ($arg) {
        return Predicate::compare($this, $this->db->quote($arg), '>=', 'ALL');
    }

    /**
     * `$this < $arg`, or `$this < ALL ($arg)`
     *
     * @param string|Select $arg
     * @return Predicate
     */
    public function isLess ($arg) {
        return Predicate::compare($this, $this->db->quote($arg), '<', 'ALL');
    }

    /**
     * `$this <= $arg`, or `$this <= ALL ($arg)`
     *
     * @param string|Select $arg
     * @return Predicate
     */
    public function isLessOrEqual ($arg) {
        return Predicate::compare($this, $this->db->quote($arg), '<=', 'ALL');
    }

    /**
     * `$this LIKE $pattern`
     *
     * @param string $pattern
     * @return Predicate
     */
    public function isLike (string $pattern) {
        return Predicate::compare($this, $this->db->quote($pattern), 'LIKE');
    }

    /**
     * Null-safe inequality.
     *
     * @param null|bool|string|Select $arg
     * @return Predicate
     */
    public function isNot ($arg) {
        return $this->is($arg)->invert();
    }

    /**
     * `$this NOT BETWEEN $min AND $max` (inclusive)
     *
     * @param number|string $min
     * @param number|string $max
     * @return Predicate
     */
    public function isNotBetween ($min, $max) {
        return new Predicate("{$this} NOT BETWEEN {$this->db->quote($min)} AND {$this->db->quote($max)}");
    }

    /**
     * `$this <> $arg`, or `$this NOT IN (...$arg)`, or `$this <> ALL ($arg)`
     *
     * @param string|array|Select $arg
     * @return Predicate
     */
    public function isNotEqual ($arg) {
        return Predicate::compare($this, $this->db->quoteMixed($arg), '<>', 'ALL', 'NOT IN');
    }

    /**
     * `$this NOT LIKE $pattern`
     *
     * @param string $pattern
     * @return Predicate
     */
    public function isNotLike (string $pattern) {
        return Predicate::compare($this, $this->db->quote($pattern), 'NOT LIKE');
    }

    /**
     * `$this NOT REGEXP $pattern`
     *
     * @param string $pattern
     * @return Predicate
     */
    public function isNotRegExp (string $pattern) {
        return Predicate::compare($this, $this->db->quote($pattern), 'NOT REGEXP');
    }

    /**
     * `$this REGEXP $pattern`
     *
     * @param string $pattern
     * @return Predicate
     */
    public function isRegExp (string $pattern) {
        return Predicate::compare($this, $this->db->quote($pattern), 'REGEXP');
    }
}

hfw / db

Push — master ( 305c34...2bac56 )

ComparisonTrait::coalesce() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like