App\BookmarkRepository

Complexity

Total Complexity

8

Size/Duplication

Total Lines	88
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	findAll()	0	14	3
A	find()	0	13	1
A	save()	0	16	1
A	update()	0	15	1
A	remove()	0	13	1

<?php

namespace App;

use Rhumsaa\Uuid\Uuid;

class BookmarkRepository
{
    /**
     * @var \PDO
     */
    private $connection;

    public function __construct(\PDO $connection)
    {
        $this->connection = $connection;
    }

    public function findAll()
    {
        $bookmarks = array();

        foreach ($this->connection->query('SELECT * FROM bookmarks;') as $row) {
            $bookmark = json_decode($row['data']);
            $bookmark->uuid = $row['uuid'];
            $bookmark->url = $row['url'];
            $bookmark->title = !empty($bookmark->title) ? $bookmark->title : $bookmark->url;
            $bookmarks[] = $bookmark;
        }

        return $bookmarks;
    }

    public function find(Uuid $uuid)
    {
        $statement = $this->connection->prepare('SELECT * FROM bookmarks WHERE uuid = :uuid;');
        $statement->execute(
            array(
                'uuid' => (string) $uuid,
            )
        );

        $row = $statement->fetch(\PDO::FETCH_ASSOC);

        return Bookmark::unserialize($row);
    }

    public function save(Bookmark $bookmark)
    {
        $statement = $this->connection->prepare(
            'INSERT INTO bookmarks (uuid, url, data) VALUES (:uuid, :url, :data);'
        );

        $statement->execute(
            array(
                ':uuid' => (string) $bookmark->getUuid(),
                ':url' => (string) $bookmark->getUrl(),
                ':data' => json_encode($bookmark->getData()),
            )
        );

        return $bookmark;
    }

    public function update(Bookmark $bookmark)
    {
        $statement = $this->connection->prepare(
            'UPDATE bookmarks SET data = :data WHERE uuid = :uuid;'
        );

        $statement->execute(
            array(
                ':uuid' => (string) $bookmark->getUuid(),
                ':data' => json_encode($bookmark->getData()),
            )
        );

        return $bookmark;
    }

    public function remove(Uuid $uuid)
    {
        $bookmark = $this->find($uuid);

        $statement = $this->connection->prepare('DELETE FROM bookmarks WHERE uuid = :uuid;');
        $statement->execute(
            array(
                'uuid' => (string) $uuid,
            )
        );

        return $bookmark;
    }
}