App\Repository\NoteRepository

Complexity

Total Complexity

12

Size/Duplication

Total Lines	135
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	1
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	getQueryNotesByPage()	0	3	1
A	checkAndGetNote()	0	12	2
A	getNotesByPage()	0	23	3
A	update()	0	22	1
A	create()	0	18	1
A	search()	0	21	2
A	getAllNotes()	0	7	1
A	delete()	0	6	1

<?php

declare(strict_types=1);

namespace App\Repository;

use App\Exception\NoteException;
use App\Entity\Note;

final class NoteRepository extends BaseRepository
{
    public function checkAndGetNote(int $noteId): Note
    {
        $query = 'SELECT * FROM `notes` WHERE `id` = :id';
        $statement = $this->getDb()->prepare($query);
        $statement->bindParam('id', $noteId);
        $statement->execute();
        $note = $statement->fetchObject(Note::class);
        if (!$note) {
            throw new NoteException('Note not found.', 404);
        }

        return $note;
    }

    public function getAllNotes(): array
    {
        $query = 'SELECT * FROM `notes` ORDER BY `id`';
        $statement = $this->getDb()->prepare($query);
        $statement->execute();

        return (array) $statement->fetchAll();
    }

    public function getQueryNotesByPage(): string
    {
        return "
            SELECT *
            FROM `notes`
            WHERE `name` LIKE CONCAT('%', :name, '%')
            AND `description` LIKE CONCAT('%', :description, '%')
            ORDER BY `id`
        ";
    }

    public function getNotesByPage(
        int $page,
        int $perPage,
        ?string $name,
        ?string $description
    ): array {
        $params = [
            'name' => is_null($name) ? '' : $name,
            'description' => is_null($description) ? '' : $description,
        ];
        $query = $this->getQueryNotesByPage();
        $statement = $this->getDb()->prepare($query);
        $statement->bindParam('name', $params['name']);
        $statement->bindParam('description', $params['description']);
        $statement->execute();
        $total = $statement->rowCount();

        return $this->getResultsWithPagination(
            $query,
            $page,
            $perPage,
            $params,
            $total
        );
    }

    public function search(string $strNotes): array
    {
        $query = '
            SELECT *
            FROM `notes`
            WHERE `name` LIKE :name OR `description` LIKE :description
            ORDER BY `id`
        ';
        $name = '%' . $strNotes . '%';
        $description = '%' . $strNotes . '%';
        $statement = $this->getDb()->prepare($query);
        $statement->bindParam('name', $name);
        $statement->bindParam('description', $description);
        $statement->execute();
        $notes = (array) $statement->fetchAll();
        if (!$notes) {

The expression $notes of type array is implicitly converted to a boolean; are you sure this is intended? If so, consider using empty($expr) instead to make it clear that you intend to check for an array without elements.

            $message = 'No notes were found with that name or description.';
            throw new NoteException($message, 404);
        }

        return $notes;
    }

    public function create(Note $note): Note
    {
        $query = '
            INSERT INTO `notes`
                (`name`, `description`, `createdAt`)
            VALUES
                (:name, :description, :createdAt)
        ';
        $statement = $this->getDb()->prepare($query);
        $name = $note->getName();
        $desc = $note->getDescription();
        $created = $note->getCreatedAt();
        $statement->bindParam('name', $name);
        $statement->bindParam('description', $desc);
        $statement->bindParam('createdAt', $created);
        $statement->execute();

        return $this->checkAndGetNote((int) $this->getDb()->lastInsertId());
    }

    public function update(Note $note): Note
    {
        $query = '
            UPDATE `notes`
            SET 
                `name` = :name, 
                `description` = :description, 
                `updatedAt` = :updatedAt
            WHERE `id` = :id
        ';
        $statement = $this->getDb()->prepare($query);
        $id = $note->getId();
        $name = $note->getName();
        $desc = $note->getDescription();
        $updated = $note->getUpdatedAt();
        $statement->bindParam('id', $id);
        $statement->bindParam('name', $name);
        $statement->bindParam('description', $desc);
        $statement->bindParam('updatedAt', $updated);
        $statement->execute();

        return $this->checkAndGetNote((int) $id);
    }

    public function delete(int $noteId): void
    {
        $query = 'DELETE FROM `notes` WHERE `id` = :id';
        $statement = $this->getDb()->prepare($query);
        $statement->bindParam('id', $noteId);
        $statement->execute();
    }
}