CastTrait::toText() - Code Metrics - Inspection of "reworked SQL traits" - hfw/db - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 1dcf9b...c6a312 )

by y

created 2021-06-06 08:08 UTC

CastTrait::toText() A

↳ Parent: CastTrait

Complexity

Conditions	2
Paths	2

Size

Total Lines	5
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

<?php

namespace Helix\DB\SQL;

trait CastTrait {

    use AbstractTrait;

    /**
     * `COALESCE($this, ...$values)`
     *
     * @param scalar[] $values
     * @return Value
     */
    public function coalesce (array $values) {
        array_unshift($values, $this);
        $values = $this->db->quoteList($values);
        return Value::factory($this->db, "COALESCE({$values})");
    }

    /**
     * Casts the expression to a floating point number.
     *
     * @return Num
     */
    public function toFloat () {
        if ($this->db->isSQLite()) {
            return Num::factory($this->db, "CAST({$this} AS REAL)");
        }
        return Num::factory($this->db, "({$this} + 0)");
    }

    /**
     * Casts the expression to a signed integer.
     *
     * @return Num
     */
    public function toInt () {
        if ($this->db->isSQLite()) {
            return Num::factory($this->db, "CAST({$this} AS INTEGER)");
        }
        return Num::factory($this->db, "CAST({$this} AS SIGNED)");
    }

    /**
     * Casts the expression to a character string.
     *
     * @return Text
     */
    public function toText () {
        if ($this->db->isSQLite()) {
            return Text::factory($this->db, "CAST({$this} AS TEXT)");
        }
        return Text::factory($this->db, "CAST({$this} AS CHAR)");
    }
}

1			<?php
2
3			namespace Helix\DB\SQL;
4
5			trait CastTrait {
6
7			use AbstractTrait;
8
9			/**
10			* `COALESCE($this, ...$values)`
11			*
12			* @param scalar[] $values
13			* @return Value
14			*/
15			public function coalesce (array $values) {
16			array_unshift($values, $this);
17			$values = $this->db->quoteList($values);
18			return Value::factory($this->db, "COALESCE({$values})");
19			}
20
21			/**
22			* Casts the expression to a floating point number.
23			*
24			* @return Num
25			*/
26			public function toFloat () {
27			if ($this->db->isSQLite()) {
28			return Num::factory($this->db, "CAST({$this} AS REAL)");
29			}
30			return Num::factory($this->db, "({$this} + 0)");
31			}
32
33			/**
34			* Casts the expression to a signed integer.
35			*
36			* @return Num
37			*/
38			public function toInt () {
39			if ($this->db->isSQLite()) {
40			return Num::factory($this->db, "CAST({$this} AS INTEGER)");
41			}
42			return Num::factory($this->db, "CAST({$this} AS SIGNED)");
43			}
44
45			/**
46			* Casts the expression to a character string.
47			*
48			* @return Text
49			*/
50			public function toText () {
51			if ($this->db->isSQLite()) {
52			return Text::factory($this->db, "CAST({$this} AS TEXT)");
53			}
54			return Text::factory($this->db, "CAST({$this} AS CHAR)");
55			}
56			}

hfw / db

Push — master ( 1dcf9b...c6a312 )

CastTrait::toText() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like