mauretto78 / in-memory-list

     *

     * @return mixed

     */

    public function deleteElement($listUuid, $elementUuid)

    {

        $sql = 'DELETE FROM `'.self::LIST_ELEMENT_TABLE_NAME.'` WHERE `uuid` = :uuid AND `list` = :list';

        $stmt = $this->pdo->prepare($sql);

        $stmt->bindParam(':uuid', $elementUuid);

        $stmt->bindParam(':list', $listUuid);

        $stmt->execute();

    }

    /**

     * @param $listUuid

     *

     * @return int

     */

    public function getCounter($listUuid)

    {

        $sql = 'SELECT `uuid` FROM `'.self::LIST_ELEMENT_TABLE_NAME.'` WHERE `list` = :list';

        $stmt = $this->pdo->prepare($sql);

        $stmt->bindParam(':list', $listUuid);

        $stmt->execute();

        return $stmt->rowCount();

    }

    /**

     * creates database schema.