CopyProtectionDAO::__construct() - Code Metrics - atari-legend/legacy - Measure and Improve Code Quality continuously with Scrutinizer

CopyProtectionDAO::__construct() A
last analyzed 2024-03-07 17:20 UTC

↳ Parent: CopyProtectionDAO

Complexity

Conditions	1
Paths	1

Size

Total Lines	2
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes

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

<?php
namespace AL\Common\DAO;

require_once __DIR__."/../../lib/Db.php" ;
require_once __DIR__."/../Model/Game/CopyProtection.php" ;

/**
 * DAO for Copy Protection
 */
class CopyProtectionDAO {
    private $mysqli;

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

    /**
     * Get all Copy Protection Types
     *
     * @return \AL\Common\Model\Game\CopyProtection[] An array of copy protection types
     */
    public function getAllCopyProtections() {
        $stmt = \AL\Db\execute_query(
            "CopyProtectionDAO: getAllCopyProtections",
            $this->mysqli,
            "SELECT id, name FROM copy_protection ORDER BY name",
            null, null
        );

        \AL\Db\bind_result(
            "CopyProtectionDAO: getAllCopyProtections",
            $stmt,
            $id, $name

        );

        $copy_protection_types = [];
        while ($stmt->fetch()) {
            $copy_protection_types[] = new \AL\Common\Model\Game\CopyProtection(
                $id, $name, null
            );
        }

        $stmt->close();

        return $copy_protection_types;
    }

    /**
     * Get list of copy_protection IDs for a game release
     *
     * @param integer release ID
filter:
    dependency_paths: ["lib/*"]
     */
    public function getCopyProtectionsForRelease($release_id) {
        $stmt = \AL\Db\execute_query(
            "CopyProtectionDAO: getCopyProtectionsForRelease",
            $this->mysqli,
            "SELECT copy_protection_id, name, notes
            FROM game_release_copy_protection LEFT JOIN 
            copy_protection ON (game_release_copy_protection.copy_protection_id = copy_protection.id)
            WHERE release_id = ?",
            "i", $release_id
        );

        \AL\Db\bind_result(
            "CopyProtectionDAO: getCopyProtectionsForRelease",
            $stmt,
            $copy_protection_id, $name, $notes

        );

        $copy_protection_types = [];
        while ($stmt->fetch()) {
            $copy_protection_types[] = new \AL\Common\Model\Game\CopyProtection(
                $copy_protection_id, $name, $notes
            );
        }

        $stmt->close();

        return $copy_protection_types;
    }
    
     /**
     * Add copy Protection for release
     *
     * @param integer Game Release ID
     * @param integer protection ID
filter:
    dependency_paths: ["lib/*"]
     * $param text note
     */
    public function addCopyProtectionForRelease($game_release_id, $protection_id, $note) {
       
        $stmt = \AL\Db\execute_query(
            "copyProtectionDAO: addCopyProtectionForRelease",
            $this->mysqli,
            "INSERT INTO game_release_copy_protection (release_id, copy_protection_id, notes) VALUES (?, ?, ?)",
            "iis", $game_release_id, $protection_id, $note
        );

        $stmt->close();
    }
    
     /**
     * Delete copy Protection for release
     *
     * @param integer Game Release ID
     * @param integer protection ID
     */
    public function deleteCopyProtectionForRelease($game_release_id, $protection_id) {
        $stmt = \AL\Db\execute_query(
            "copyProtectionDAO: deleteCopyProtectionForRelease",
            $this->mysqli,
            "DELETE FROM game_release_copy_protection
            WHERE release_id = ? AND copy_protection_id = ?",
            "ii", $game_release_id, $protection_id
        );

        $stmt->close();
    }
     
     /**
     * add a copy protection to the database
     *
     * @param varchar copy_protection
filter:
    dependency_paths: ["lib/*"]
     */
    public function addCopyProtection($copy_protection) {
        $stmt = \AL\Db\execute_query(
            "CopyProtectionDAO: addCopyProtection",
            $this->mysqli,
            "INSERT INTO copy_protection (`name`) VALUES (?)",
            "s", $copy_protection
        );

        $stmt->close();
    }
    
    /**
     * delete a copy_protection
     *
     * @param int $copy_protection_id
     */
    public function deleteCopyProtection($copy_protection_id) {
        $stmt = \AL\Db\execute_query(
            "CopyProtectionDAO: deleteCopyProtection",
            $this->mysqli,
            "DELETE FROM copy_protection WHERE id = ?",
            "i", $copy_protection_id
        );

        $stmt->close();
    }
    
        /**
     * update a copy_protection
     *
     * @param int copy_protection_id
filter:
    dependency_paths: ["lib/*"]
     * @param varchar copy_protection
     */
    public function updateCopyProtection($copy_protection_id, $copy_protection_name) {
        $stmt = \AL\Db\execute_query(
            "CopyProtectionDAO: updateCopyProtection",
            $this->mysqli,
            "UPDATE copy_protection SET name = ? WHERE id = ?",
            "si", $copy_protection_name, $copy_protection_id
        );
        
        $stmt->close();
    }
}


1			<?php
2			namespace AL\Common\DAO;
3
4			require_once __DIR__."/../../lib/Db.php" ;
5			require_once __DIR__."/../Model/Game/CopyProtection.php" ;
6
7			/**
8			* DAO for Copy Protection
9			*/
10			class CopyProtectionDAO {
11			private $mysqli;
12
13			public function __construct($mysqli) {
14			$this->mysqli = $mysqli;
15			}
16
17			/**
18			* Get all Copy Protection Types
19			*
20			* @return \AL\Common\Model\Game\CopyProtection[] An array of copy protection types
21			*/
22			public function getAllCopyProtections() {
23			$stmt = \AL\Db\execute_query(
24			"CopyProtectionDAO: getAllCopyProtections",
25			$this->mysqli,
26			"SELECT id, name FROM copy_protection ORDER BY name",
27			null, null
28			);
29
30			\AL\Db\bind_result(
31			"CopyProtectionDAO: getAllCopyProtections",
32			$stmt,
33			$id, $name
			0 ignored issues – show Comprehensibility Best Practice introduced 2020-12-06 16:57 UTC by Report Bug Copy Issue Report The variable `$name` seems to be never defined. Loading history...
34			);
35
36			$copy_protection_types = [];
37			while ($stmt->fetch()) {
38			$copy_protection_types[] = new \AL\Common\Model\Game\CopyProtection(
39			$id, $name, null
40			);
41			}
42
43			$stmt->close();
44
45			return $copy_protection_types;
46			}
47
48			/**
49			* Get list of copy_protection IDs for a game release
50			*
51			* @param integer release ID
			0 ignored issues – show Bug introduced 2020-12-06 16:57 UTC by Report Bug Copy Issue Report The type `AL\Common\DAO\release` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
52			*/
53			public function getCopyProtectionsForRelease($release_id) {
54			$stmt = \AL\Db\execute_query(
55			"CopyProtectionDAO: getCopyProtectionsForRelease",
56			$this->mysqli,
57			"SELECT copy_protection_id, name, notes
58			FROM game_release_copy_protection LEFT JOIN
59			copy_protection ON (game_release_copy_protection.copy_protection_id = copy_protection.id)
60			WHERE release_id = ?",
61			"i", $release_id
62			);
63
64			\AL\Db\bind_result(
65			"CopyProtectionDAO: getCopyProtectionsForRelease",
66			$stmt,
67			$copy_protection_id, $name, $notes
			0 ignored issues – show Comprehensibility Best Practice introduced 2020-12-06 16:57 UTC by Report Bug Copy Issue Report The variable `$name` seems to be never defined. Loading history... Comprehensibility Best Practice introduced 2020-12-06 16:57 UTC by Report Bug Copy Issue Report The variable `$notes` seems to be never defined. Loading history...
68			);
69
70			$copy_protection_types = [];
71			while ($stmt->fetch()) {
72			$copy_protection_types[] = new \AL\Common\Model\Game\CopyProtection(
73			$copy_protection_id, $name, $notes
74			);
75			}
76
77			$stmt->close();
78
79			return $copy_protection_types;
80			}
81
82			/**
83			* Add copy Protection for release
84			*
85			* @param integer Game Release ID
86			* @param integer protection ID
			0 ignored issues – show Bug introduced 2020-12-06 16:57 UTC by Report Bug Copy Issue Report The type `AL\Common\DAO\protection` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
87			* $param text note
88			*/
89			public function addCopyProtectionForRelease($game_release_id, $protection_id, $note) {
90
91			$stmt = \AL\Db\execute_query(
92			"copyProtectionDAO: addCopyProtectionForRelease",
93			$this->mysqli,
94			"INSERT INTO game_release_copy_protection (release_id, copy_protection_id, notes) VALUES (?, ?, ?)",
95			"iis", $game_release_id, $protection_id, $note
96			);
97
98			$stmt->close();
99			}
100
101			/**
102			* Delete copy Protection for release
103			*
104			* @param integer Game Release ID
105			* @param integer protection ID
106			*/
107			public function deleteCopyProtectionForRelease($game_release_id, $protection_id) {
108			$stmt = \AL\Db\execute_query(
109			"copyProtectionDAO: deleteCopyProtectionForRelease",
110			$this->mysqli,
111			"DELETE FROM game_release_copy_protection
112			WHERE release_id = ? AND copy_protection_id = ?",
113			"ii", $game_release_id, $protection_id
114			);
115
116			$stmt->close();
117			}
118
119			/**
120			* add a copy protection to the database
121			*
122			* @param varchar copy_protection
			0 ignored issues – show Bug introduced 2020-12-06 16:57 UTC by Report Bug Copy Issue Report The type `AL\Common\DAO\copy_protection` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
123			*/
124			public function addCopyProtection($copy_protection) {
125			$stmt = \AL\Db\execute_query(
126			"CopyProtectionDAO: addCopyProtection",
127			$this->mysqli,
128			"INSERT INTO copy_protection (`name`) VALUES (?)",
129			"s", $copy_protection
130			);
131
132			$stmt->close();
133			}
134
135			/**
136			* delete a copy_protection
137			*
138			* @param int $copy_protection_id
139			*/
140			public function deleteCopyProtection($copy_protection_id) {
141			$stmt = \AL\Db\execute_query(
142			"CopyProtectionDAO: deleteCopyProtection",
143			$this->mysqli,
144			"DELETE FROM copy_protection WHERE id = ?",
145			"i", $copy_protection_id
146			);
147
148			$stmt->close();
149			}
150
151			/**
152			* update a copy_protection
153			*
154			* @param int copy_protection_id
			0 ignored issues – show Bug introduced 2020-12-06 16:57 UTC by Report Bug Copy Issue Report The type `AL\Common\DAO\copy_protection_id` was not found. Maybe you did not declare it correctly or list all dependencies? The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g. `excluded_paths: ["lib/"]`, you can move it to the dependency path list as follows: filter: dependency_paths: ["lib/"] For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths Loading history...
155			* @param varchar copy_protection
156			*/
157			public function updateCopyProtection($copy_protection_id, $copy_protection_name) {
158			$stmt = \AL\Db\execute_query(
159			"CopyProtectionDAO: updateCopyProtection",
160			$this->mysqli,
161			"UPDATE copy_protection SET name = ? WHERE id = ?",
162			"si", $copy_protection_name, $copy_protection_id
163			);
164
165			$stmt->close();
166			}
167			}
168

atari-legend / legacy

CopyProtectionDAO::__construct() A last analyzed 2024-03-07 17:20 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

CopyProtectionDAO::__construct() A
last analyzed 2024-03-07 17:20 UTC