GLPDO2::__construct() - Code Metrics - ellisgl/GeekLab-GLPDO2 - Measure and Improve Code Quality continuously with Scrutinizer

GLPDO2::__construct() A
last analyzed 2022-11-25 21:46 UTC

↳ Parent: GLPDO2

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	2
CRAP Score	1

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	1
c	1
b	0
f	0
nc	1
nop	1
dl	0
loc	3
ccs	2
cts	2
cp	1
crap	1
rs	10

<?php

namespace GeekLab\GLPDO2;

// Make EA inspection stop complaining.
use PDO;
use Exception;

class GLPDO2
{
    /** @var PDO $PDO */
    private $PDO;

    public function __construct(PDO $pdo)
    {
        $this->PDO = $pdo;
    }

    /**
     * Begin transaction.
     *
     * @return bool
     */
    public function beginTransaction(): bool
    {
        return $this->PDO->beginTransaction();
    }

    /**
     * Is the operation in the middle of the transaction?
     *
     * @return bool
     */
    public function inTransaction(): bool
    {
        return $this->PDO->inTransaction();
    }

    /**
     * Commit transaction.
     *
     * @return bool
     */
    public function commit(): bool
    {
        return $this->PDO->commit();
    }

    /**
     * Rollback transaction.
     *
     * @return bool
     */
    public function rollback(): bool
    {
        return $this->PDO->rollBack();
    }

    /**
     * Perform UPDATE or DELETE query and return the number of affected rows.
     *
     * @param Statement $SQL
     *
     * @return int
     * @throws Exception
     */
    private function queryAffectedRows(Statement $SQL): int
    {
        // Execute statement
        $sth = $SQL->execute($this->PDO);

        // Return number of rows affected
        return $sth->rowCount();
    }

    /**
     * Perform DELETE query.
     *
     * @param Statement $SQL
     *
     * @return int
     * @throws Exception
     */
    public function queryDelete(Statement $SQL): int
    {
        return $this->queryAffectedRows($SQL);
    }

    /**
     * Perform UPDATE query
     *
     * @param Statement $SQL
     *
     * @return int
     * @throws Exception
     */
    public function queryUpdate(Statement $SQL): int
    {
        return $this->queryAffectedRows($SQL);
    }

    /**
     * Perform INSERT query
     *
     * @param Statement $SQL
     *
     * @return bool|string
     * @throws Exception
     */
    public function queryInsert(Statement $SQL)
    {
        // Execute the statement
        $sth = $SQL->execute($this->PDO);

        if (!$sth->rowCount()) {
            // Insert failed
            return false;
        }

        // Return the ID
        return $this->PDO->lastInsertId();
    }

    /**
     * Execute statement and returns first row of results as an associative array.
     *
     * @param Statement $SQL
     *
     * @return mixed
     * @throws Exception
     */
    public function selectRow(Statement $SQL): mixed
    {
        // Execute the statement
        $sth = $SQL->execute($this->PDO);

        // Return the first row fetched
        return $sth->fetch(PDO::FETCH_ASSOC);
    }

    /**
     * Return multiple rows result as an array
     *
     * @param Statement $SQL
     *
     * @return array{} | false
     * @throws Exception
     */
    public function selectRows(Statement $SQL): bool | array
    {
        // Execute the statement
        $sth = $SQL->execute($this->PDO);

        return $sth->fetchAll(PDO::FETCH_ASSOC);
    }

    /**
     * Executes statement and return a specific column from the first row of results.
     *
     * @param Statement    $SQL
     * @param string       $column
     * @param bool         $caseSensitive
     * @param mixed | null $default
     *
     * @return string | null
     * @throws Exception
     */
    public function selectValue(
        Statement $SQL,
        string $column,
        bool $caseSensitive = false,
        mixed $default = null
    ): ?string {
        $row = $this->selectRow($SQL);

        if (!$caseSensitive) {
            $row = array_change_key_case($row);
            $column = strtolower($column);
        }

        return $row[$column] ?? $default;
    }
}


1		<?php
2
3		namespace GeekLab\GLPDO2;
4
5		// Make EA inspection stop complaining.
6		use PDO;
7		use Exception;
8
9		class GLPDO2
10		{
11		/** @var PDO $PDO */
12		private $PDO;
13
14	1	public function __construct(PDO $pdo)
15		{
16	1	$this->PDO = $pdo;
17		}
18
19		/**
20		* Begin transaction.
21		*
22		* @return bool
23		*/
24	3	public function beginTransaction(): bool
25		{
26	3	return $this->PDO->beginTransaction();
27		}
28
29		/**
30		* Is the operation in the middle of the transaction?
31		*
32		* @return bool
33		*/
34	2	public function inTransaction(): bool
35		{
36	2	return $this->PDO->inTransaction();
37		}
38
39		/**
40		* Commit transaction.
41		*
42		* @return bool
43		*/
44	1	public function commit(): bool
45		{
46	1	return $this->PDO->commit();
47		}
48
49		/**
50		* Rollback transaction.
51		*
52		* @return bool
53		*/
54	1	public function rollback(): bool
55		{
56	1	return $this->PDO->rollBack();
57		}
58
59		/**
60		* Perform UPDATE or DELETE query and return the number of affected rows.
61		*
62		* @param Statement $SQL
63		*
64		* @return int
65		* @throws Exception
66		*/
67	50	private function queryAffectedRows(Statement $SQL): int
68		{
69		// Execute statement
70	50	$sth = $SQL->execute($this->PDO);
71
72		// Return number of rows affected
73	50	return $sth->rowCount();
74		}
75
76		/**
77		* Perform DELETE query.
78		*
79		* @param Statement $SQL
80		*
81		* @return int
82		* @throws Exception
83		*/
84	50	public function queryDelete(Statement $SQL): int
85		{
86	50	return $this->queryAffectedRows($SQL);
87		}
88
89		/**
90		* Perform UPDATE query
91		*
92		* @param Statement $SQL
93		*
94		* @return int
95		* @throws Exception
96		*/
97	1	public function queryUpdate(Statement $SQL): int
98		{
99	1	return $this->queryAffectedRows($SQL);
100		}
101
102		/**
103		* Perform INSERT query
104		*
105		* @param Statement $SQL
106		*
107		* @return bool\|string
108		* @throws Exception
109		*/
110	50	public function queryInsert(Statement $SQL)
111		{
112		// Execute the statement
113	50	$sth = $SQL->execute($this->PDO);
114
115	50	if (!$sth->rowCount()) {
116		// Insert failed
117	50	return false;
118		}
119
120		// Return the ID
121	50	return $this->PDO->lastInsertId();
122		}
123
124		/**
125		* Execute statement and returns first row of results as an associative array.
126		*
127		* @param Statement $SQL
128		*
129		* @return mixed
130		* @throws Exception
131		*/
132	5	public function selectRow(Statement $SQL): mixed
133		{
134		// Execute the statement
135	5	$sth = $SQL->execute($this->PDO);
136
137		// Return the first row fetched
138	5	return $sth->fetch(PDO::FETCH_ASSOC);
139		}
140
141		/**
142		* Return multiple rows result as an array
143		*
144		* @param Statement $SQL
145		*
146		* @return array{} \| false
147		* @throws Exception
148		*/
149	15	public function selectRows(Statement $SQL): bool \| array
150		{
151		// Execute the statement
152	15	$sth = $SQL->execute($this->PDO);
153
154	15	return $sth->fetchAll(PDO::FETCH_ASSOC);
155		}
156
157		/**
158		* Executes statement and return a specific column from the first row of results.
159		*
160		* @param Statement $SQL
161		* @param string $column
162		* @param bool $caseSensitive
163		* @param mixed \| null $default
164		*
165		* @return string \| null
166		* @throws Exception
167		*/
168	2	public function selectValue(
169		Statement $SQL,
170		string $column,
171		bool $caseSensitive = false,
172		mixed $default = null
173		): ?string {
174	2	$row = $this->selectRow($SQL);
175
176	2	if (!$caseSensitive) {
177	1	$row = array_change_key_case($row);
178	1	$column = strtolower($column);
179		}
180
181	2	return $row[$column] ?? $default;
182		}
183		}
184

ellisgl / GeekLab-GLPDO2

GLPDO2::__construct() A last analyzed 2022-11-25 21:46 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

GLPDO2::__construct() A
last analyzed 2022-11-25 21:46 UTC