AL\Common\DAO\CopyProtectionDAO

Complexity

Total Complexity

10

Size/Duplication

Total Lines	156
Duplicated Lines	0 %

Importance

Changes

0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	deleteCopyProtectionForRelease()	0	10	1
A	__construct()	0	2	1
A	addCopyProtectionForRelease()	0	10	1
A	getAllCopyProtections()	0	24	2
A	getCopyProtectionsForRelease()	0	27	2
A	addCopyProtection()	0	9	1
A	updateCopyProtection()	0	9	1
A	deleteCopyProtection()	0	9	1

<?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

The variable $name seems to be never defined.

        );

        $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

The type AL\Common\DAO\release was not found. Maybe you did not declare it correctly or list all dependencies?

     */
    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

The variable $name seems to be never defined.

The variable $notes seems to be never defined.

        );

        $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

The type AL\Common\DAO\protection was not found. Maybe you did not declare it correctly or list all dependencies?

     * $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

The type AL\Common\DAO\copy_protection was not found. Maybe you did not declare it correctly or list all dependencies?

     */
    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

The type AL\Common\DAO\copy_protection_id was not found. Maybe you did not declare it correctly or list all dependencies?

     * @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();
    }
}