AL\Common\DAO\MemoryDAO

Complexity

Total Complexity

20

Size/Duplication

Total Lines	320
Duplicated Lines	0 %

Importance

Changes

0

15 Methods

Rating	Name	Duplication	Size	Complexity
A	deleteMemory()	0	9	1
A	addMemory()	0	9	1
A	setMemoryForRelease()	0	10	1
A	setMinimumMemoryForRelease()	0	10	1
A	setMemoryIncompatibleForRelease()	0	10	1
A	__construct()	0	2	1
A	deleteMemoryIncompatibleForRelease()	0	10	1
A	deleteMinimumMemoryForRelease()	0	10	1
A	deleteMemoryForRelease()	0	10	1
A	getMinimumMemoryForRelease()	0	27	2
A	getMemoryIncompatibleForRelease()	0	27	2
A	updateMemory()	0	9	1
A	getMemoryForRelease()	0	31	3
A	updateMemoryForRelease()	0	12	1
A	getAllMemory()	0	24	2

<?php
namespace AL\Common\DAO;

require_once __DIR__."/../../lib/Db.php" ;
require_once __DIR__."/../Model/Game/Memory.php" ;
require_once __DIR__."/../Model/Game/Enhancement.php" ;

/**
 * DAO for memory
 */
class MemoryDAO {
    private $mysqli;

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

    /**
     * Get all memory amounts
     *
     * @return \AL\Common\Model\Game\Memory[] An array of memory amounts
     */
    public function getAllMemory() {
        $stmt = \AL\Db\execute_query(
            "MemoryDAO: getAllMemory",
            $this->mysqli,
            "SELECT id, name FROM memory ORDER BY name",
            null, null
        );

        \AL\Db\bind_result(
            "MemoryDAO: getAllMemory",
            $stmt,
            $id, $memory

The variable $memory does not exist. Did you maybe mean $memory_all?

        );

        $memory_all = [];
        while ($stmt->fetch()) {
            $memory_all[] = new \AL\Common\Model\Game\Memory(
                $id, $memory, null
            );
        }

        $stmt->close();

        return $memory_all;
    }

    /**
     * Get list of memory 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 getMemoryForRelease($release_id) {
        $stmt = \AL\Db\execute_query(
            "MemoryDAO: getMemoryForRelease",
            $this->mysqli,
            "SELECT memory_id, memory.name, enhancement.id, enhancement.name
            FROM game_release_memory_enhanced LEFT JOIN
            memory ON (game_release_memory_enhanced.memory_id = memory.id)
            LEFT JOIN enhancement ON (game_release_memory_enhanced.enhancement_id = enhancement.id)
            WHERE release_id = ?",
            "i", $release_id
        );

        \AL\Db\bind_result(
            "MemoryDAO: getMemoryForRelease",
            $stmt,
            $memory_id, $memory, $enhancement_id, $enhancement

The variable $enhancement_id seems to be never defined.

The variable $enhancement seems to be never defined.

The variable $memory does not exist. Did you maybe mean $memory_linked?

        );

        $memory_linked = [];
        while ($stmt->fetch()) {
            $memory_linked[] = new \AL\Common\Model\Game\Memory(
                $memory_id, $memory,
                ($enhancement_id != null)
                    ? new \AL\Common\Model\Game\Enhancement($enhancement_id, $enhancement)
                    : null
            );
        }

        $stmt->close();

        return $memory_linked;
    }

    /**
     * Set the list of memory enhancements for this release
     *
     * @param integer release ID
     * @param integer[] List of memory IDs

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

     */
    public function setMemoryForRelease($release_id, $memory_id, $enhancement_id) {

        $stmt = \AL\Db\execute_query(
            "MemoryDAO: setMemoryForRelease",
            $this->mysqli,
            "INSERT INTO game_release_memory_enhanced (release_id, memory_id, enhancement_id) VALUES (?, ?, ?)",
            "iis", $release_id, $memory_id, $enhancement_id
        );

        $stmt->close();
    }

     /**
     * Update enhancement for memory
     *
     * @param integer Game Release ID
     * @param integer memory ID
     */
    public function updateMemoryForRelease($game_release_id, $memory_id, $enhancement_id) {
        $stmt = \AL\Db\execute_query(
            "MemoryDAO: UpdateMemoryForRelease",
            $this->mysqli,
            "UPDATE game_release_memory_enhanced
            SET
                `enhancement_id` = ?
            WHERE release_id = ? AND memory_id = ?",
            "sii", $enhancement_id, $game_release_id, $memory_id
        );

        $stmt->close();
    }


         /**
     * Delete Memory enhancement for release
     *
     * @param integer Game Release ID
     * @param integer memory ID
     */
    public function deleteMemoryForRelease($game_release_id, $memory_id) {
        $stmt = \AL\Db\execute_query(
            "MemoryDAO: DeleteMemoryForRelease",
            $this->mysqli,
            "DELETE FROM game_release_memory_enhanced
            WHERE release_id = ? AND memory_id = ?",
            "ii", $game_release_id, $memory_id
        );

        $stmt->close();
    }

    /**
     * Get list of minimum memory IDs for a game release
     *
     * @param integer release ID
     */
    public function getMinimumMemoryForRelease($release_id) {
        $stmt = \AL\Db\execute_query(
            "MemoryDAO: getMinimumMemoryForRelease",
            $this->mysqli,
            "SELECT memory_id, name
            FROM game_release_memory_minimum LEFT JOIN
            memory ON (game_release_memory_minimum.memory_id = memory.id)
            WHERE release_id = ?",
            "i", $release_id
        );

        \AL\Db\bind_result(
            "MemoryDAO: getMinimumMemoryForRelease",
            $stmt,
            $memory_id, $memory

The variable $memory does not exist. Did you maybe mean $memory_linked?

        );

        $memory_linked = [];
        while ($stmt->fetch()) {
            $memory_linked[] = new \AL\Common\Model\Game\Memory(
                $memory_id, $memory, null
            );
        }

        $stmt->close();

        return $memory_linked;
    }

    /**
     * Set the list of minimum memory for this release
     *
     * @param integer release ID
     * @param integer[] List of memory IDs
     */
    public function setMinimumMemoryForRelease($release_id, $memory_id) {

        $stmt = \AL\Db\execute_query(
            "MemoryDAO: setMinimumMemoryForRelease",
            $this->mysqli,
            "INSERT INTO game_release_memory_minimum (release_id, memory_id) VALUES (?, ?)",
            "ii", $release_id, $memory_id
        );

        $stmt->close();
    }

    /**
     * Delete minimum memory for release
     *
     * @param integer Game Release ID
     * @param integer memory ID
     */
    public function deleteMinimumMemoryForRelease($game_release_id, $memory_id) {
        $stmt = \AL\Db\execute_query(
            "MemoryDAO: deleteMinimumMemoryForRelease",
            $this->mysqli,
            "DELETE FROM game_release_memory_minimum
            WHERE release_id = ? and memory_id = ?",
            "ii", $game_release_id, $memory_id
        );

        $stmt->close();
    }

     /**
     * Get list of incompatible memory IDs for a game release
     *
     * @param integer release ID
     */
    public function getMemoryIncompatibleForRelease($release_id) {
        $stmt = \AL\Db\execute_query(
            "MemoryDAO: getMemoryIncompatibleForRelease",
            $this->mysqli,
            "SELECT memory_id, name
            FROM game_release_memory_incompatible LEFT JOIN
            memory ON (game_release_memory_incompatible.memory_id = memory.id)
            WHERE release_id = ?",
            "i", $release_id
        );

        \AL\Db\bind_result(
            "MemoryDAO: getMemoryIncompatibleForRelease",
            $stmt,
            $memory_id, $memory

The variable $memory does not exist. Did you maybe mean $memory_linked?

        );

        $memory_linked = [];
        while ($stmt->fetch()) {
            $memory_linked[] = new \AL\Common\Model\Game\Memory(
                $memory_id, $memory, null
            );
        }

        $stmt->close();

        return $memory_linked;
    }

    /**
     * Set the list of incompatible memory for this release
     *
     * @param integer release ID
     * @param integer[] List of memory IDs
     */
    public function setMemoryIncompatibleForRelease($release_id, $memory_id) {

        $stmt = \AL\Db\execute_query(
            "MemoryDAO: setMemoryIncompatibleForRelease",
            $this->mysqli,
            "INSERT INTO game_release_memory_incompatible (release_id, memory_id) VALUES (?, ?)",
            "ii", $release_id, $memory_id
        );

        $stmt->close();
    }

         /**
     * Delete incompatible memory for release
     *
     * @param integer Game Release ID
     * @param integer memory ID
     */
    public function deleteMemoryIncompatibleForRelease($game_release_id, $memory_id) {
        $stmt = \AL\Db\execute_query(
            "MemoryDAO: deleteMemoryIncompatibleForRelease",
            $this->mysqli,
            "DELETE FROM game_release_memory_incompatible
            WHERE release_id = ? and memory_id = ?",
            "ii", $game_release_id, $memory_id
        );

        $stmt->close();
    }

     /**
     * add a memory amount to the database
     *
     * @param varchar memory
     */
    public function addMemory($memory) {
        $stmt = \AL\Db\execute_query(
            "MemoryDAO: addMemory",
            $this->mysqli,
            "INSERT INTO memory (`name`) VALUES (?)",
            "s", $memory
        );

        $stmt->close();
    }

    /**
     * delete a $memory amount
     *
     * @param int $memory_id
     */
    public function deleteMemory($memory_id) {
        $stmt = \AL\Db\execute_query(
            "MemoryDAO: deleteMemory",
            $this->mysqli,
            "DELETE FROM memory WHERE id = ?",
            "i", $memory_id
        );

        $stmt->close();
    }

        /**
     * update a memory amount
     *
     * @param int memory_id

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

     * @param varchar memory_memory

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

     */
    public function updateMemory($memory_id, $memory) {
        $stmt = \AL\Db\execute_query(
            "MemoryDAO: updateMemory",
            $this->mysqli,
            "UPDATE memory SET name = ? WHERE id = ?",
            "si", $memory, $memory_id
        );

        $stmt->close();
    }
}