AL\Common\DAO\ChangeDAO

Complexity

Total Complexity

4

Size/Duplication

Total Lines	92
Duplicated Lines	0 %

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getChangeByUpdateId()	0	44	2
A	insertChange()	0	26	1
A	__construct()	0	2	1

<?php
namespace AL\Common\DAO;

require_once __DIR__."/../../lib/Db.php" ;
require_once __DIR__."/../Model/Database/Change.php" ;

/**
 * DAO for DB Change
 */
class ChangeDAO {
    private $mysqli;

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


    /**
     * Get a single change from it's update ID (NOT the automatically incremented
     *  id from the database)
     * @param number $id Update ID of the change to retrieve
     * @return \AL\Common\Model\Database\Change The change
     */
    public function getChangeByUpdateId($update_id) {
        $stmt = \AL\Db\execute_query(
            "ChangeDAO: getChange: $update_id",
            $this->mysqli,
            "SELECT
                database_change_id,
                database_update_id,
                update_description,
                execute_timestamp,
                implementation_state,
                update_filename,
                database_change_script
            FROM database_change WHERE database_update_id = ?",
            "i", $update_id
        );

        \AL\Db\bind_result(
            "ChangeDAO: getChange: $update_id",
            $stmt,
            $database_change_id,
            $database_update_id,

The variable $database_update_id does not exist. Did you maybe mean $update_id?

            $update_description,

The variable $update_description seems to be never defined.

            $execute_timestamp,

The variable $execute_timestamp seems to be never defined.

            $implementation_state,

The variable $implementation_state seems to be never defined.

            $update_filename,

The variable $update_filename seems to be never defined.

            $database_change_script

The variable $database_change_script does not exist. Did you maybe mean $change?

        );

        $change = null;
        if ($stmt->fetch()) {
            $change = new \AL\Common\Model\Database\Change(
                $database_change_id,
                $database_update_id,
                $update_description,
                $execute_timestamp,
                $implementation_state,
                $update_filename,
                $database_change_script
            );
        }

        $stmt->close();

        return $change;
    }

    /**
     * Insert a new change
     *
     * @param  \AL\Common\Model\Database\Change Change to insert
     * @return integer ID of the inserted change
     */
    public function insertChange($change) {
        $stmt = \AL\Db\execute_query(
            "ChangeDAO: insertChange",
            $this->mysqli,
            "INSERT INTO database_change (
                database_update_id,
                update_description,
                execute_timestamp,
                implementation_state,
                update_filename,
                database_change_script
            ) VALUES (?, ?, ?, ?, ?, ?)",
            "isisss",
            $change->getUpdateId(),
            $change->getDescription(),
            $change->getTimestamp(),
            $change->getState(),
            $change->getFilename(),
            $change->getScript()
        );

        $id = $stmt->insert_id;

        $stmt->close();

        return $id;
    }
}