AL\Common\DAO\EnhancementDAO

Complexity

Total Complexity

6

Size/Duplication

Total Lines	85
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	2	1
A	updateEnhancement()	0	9	1
A	getAllEnhancements()	0	24	2
A	addEnhancement()	0	9	1
A	deleteEnhancement()	0	9	1

<?php
namespace AL\Common\DAO;

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

/**
 * DAO for ports
 */
class EnhancementDAO {
    private $mysqli;

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

    /**
     * Get all Enhancements
     *
     * @return "/../Model/game/Enhancement[] An array of Enhancements

The doc comment "/../Model/game/Enhancement[] at position 0 could not be parsed: Unknown type name '"/../Model/game/Enhancement' at position 0 in "/../Model/game/Enhancement[].

     */
    public function getAllEnhancements() {
        $stmt = \AL\Db\execute_query(
            "EnhancementDAO: getAllEnhancements",
            $this->mysqli,
            "SELECT id, name FROM enhancement ORDER BY name",
            null, null
        );

        \AL\Db\bind_result(
            "EnhancementDAO: getAllEnhancements",
            $stmt,
            $id, $name

The variable $name seems to be never defined.

        );

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

        $stmt->close();

        return $enhancements;
    }
    
    /**
     * add an enhancement to the database
     *
     * @param varchar enhancement
     */
    public function addEnhancement($enhancement) {
        $stmt = \AL\Db\execute_query(
            "EnhancementDAO: addEnhancement",
            $this->mysqli,
            "INSERT INTO enhancement (`name`) VALUES (?)",
            "s", $enhancement
        );

        $stmt->close();
    }
    
    /**
     * delete a Enhancement
     *
     * @param int Enhancement_id

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

     */
    public function deleteEnhancement($enhancement_id) {
        $stmt = \AL\Db\execute_query(
            "EnhancementDAO: deleteEnhancement",
            $this->mysqli,
            "DELETE FROM enhancement WHERE id = ?",
            "s", $enhancement_id
        );

        $stmt->close();
    }
    
        /**
     * update a Enhancement
     *
     * @param int Enhancement_id
     * @param varchar Enhancement_name

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

     */
    public function updateEnhancement($enhancement_id, $enhancement_name) {
        $stmt = \AL\Db\execute_query(
            "EnhancementDAO: updateEnhancement",
            $this->mysqli,
            "UPDATE enhancement SET name = ? WHERE id = ?",
            "ss", $enhancement_name, $enhancement_id
        );
        
        $stmt->close();
    }
}