CRUD::delete() - Code Metrics - Inspection of "Save method" - nicollassilva/SimplePHP - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( f5e02c...2a0dcd )

by Nícollas

created 2020-07-20 20:54 UTC

CRUD::delete() A

↳ Parent: CRUD

Complexity

Conditions	2
Paths	4

Size

Total Lines	8
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

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

<?php

namespace SimplePHP\Model;

trait CRUD {

    /**
     * @param int $primary
     * @return bool
     */
    public function delete(int $primary): ?bool
    {
        try {
            $sql = $this->conn->prepare("DELETE FROM {$this->table} WHERE {$this->primary} = :primary");
            $sql->bindParam(':primary', $primary);
            return $sql->execute();
        } catch(PDOException $exception) {

            return null;
        }
    }

    /**
     * @param string $params
     * @param array $values
     * @param int $primary
     * @return bool
     */
    public function update(String $params, Array $values, Int $primary): bool
    {
        $params = explode(',', $params);
        $data = [];
        $countParams = count($params);
        for($i = 0; $i < $countParams; $i++) {
            $data[$i] = ":".$params[$i][0].$params[$i][1].$params[$i][2].", ";
        }
        $result = '';
        $final = array_map(null, $params, $data);
        foreach($final as $key => $vals) {
            foreach($vals as $chave => $val) {
                $result .= str_replace(':', ' = :', $val);
            }
        }
        $result = rtrim($result, ', ');
        $sql = $this->conn->prepare("UPDATE {$this->table} SET {$result} WHERE {$this->primary} = '{$primary}'");
        for($i = 0; $i < $countParams; $i++) {
            $data[$i] = ":".$params[$i][0].$params[$i][1].$params[$i][2];
        }
        $countData = count($data);
        for($i = 0; $i < $countData; $i++) {
            $sql->bindParam($data[$i], $values[$i]);
        }
        if($sql->execute()) {
            return true;
        } else {
            return false;
        }
    }
}

1			<?php
2
3			namespace SimplePHP\Model;
4
5			trait CRUD {
6
7			/**
8			* @param int $primary
9			* @return bool
10			*/
11			public function delete(int $primary): ?bool
12			{
13			try {
14			$sql = $this->conn->prepare("DELETE FROM {$this->table} WHERE {$this->primary} = :primary");
15			$sql->bindParam(':primary', $primary);
16			return $sql->execute();
17			} catch(PDOException $exception) {
			0 ignored issues – show Bug introduced 2020-07-20 18:04 UTC by Report Bug Copy Issue Report The type `SimplePHP\Model\PDOException` was not found. Did you mean `PDOException`? If so, make sure to prefix the type with `\`. Loading history...
18			return null;
19			}
20			}
21
22			/**
23			* @param string $params
24			* @param array $values
25			* @param int $primary
26			* @return bool
27			*/
28			public function update(String $params, Array $values, Int $primary): bool
29			{
30			$params = explode(',', $params);
31			$data = [];
32			$countParams = count($params);
33			for($i = 0; $i < $countParams; $i++) {
34			$data[$i] = ":".$params[$i][0].$params[$i][1].$params[$i][2].", ";
35			}
36			$result = '';
37			$final = array_map(null, $params, $data);
38			foreach($final as $key => $vals) {
39			foreach($vals as $chave => $val) {
40			$result .= str_replace(':', ' = :', $val);
41			}
42			}
43			$result = rtrim($result, ', ');
44			$sql = $this->conn->prepare("UPDATE {$this->table} SET {$result} WHERE {$this->primary} = '{$primary}'");
45			for($i = 0; $i < $countParams; $i++) {
46			$data[$i] = ":".$params[$i][0].$params[$i][1].$params[$i][2];
47			}
48			$countData = count($data);
49			for($i = 0; $i < $countData; $i++) {
50			$sql->bindParam($data[$i], $values[$i]);
51			}
52			if($sql->execute()) {
53			return true;
54			} else {
55			return false;
56			}
57			}
58			}

nicollassilva / SimplePHP

Push — master ( f5e02c...2a0dcd )

CRUD::delete() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like