MysqlBlogRepository::getUnmappedBlogs() - Code Metrics - Inspection of "Adds new stream db repositories and use them to re..." - jacobemerick/web - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( c330e2...cf0c7a )

by Jacob

created 2015-12-27 02:18 UTC

MysqlBlogRepository::getUnmappedBlogs() A

↳ Parent: MysqlBlogRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	13
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
dl	0
loc	13
rs	9.4286
c	1
b	0
f	1
cc	1
eloc	6
nc	1
nop	0

<?php

namespace Jacobemerick\Web\Domain\Stream\Blog;

use Aura\Sql\ConnectionLocator;

class MysqlBlogRepository implements BlogRepositoryInterface
{

    /** @var  ConnectionLocator */
    protected $connections;

    /**
     * @param ConnectonLocator $connections
     */
    public function __construct(ConnectionLocator $connections)
    {
        $this->connections = $connections;
    }

    /**
     * @param integer $id
     *
     * @return array|false
     */
    public function getBlogById($id)
    {
        $query = "
            SELECT *
            FROM `jpemeric_stream`.`blog`
            WHERE `id` = :id
            LIMIT 1";
        $bindings = [
            'id' => $id,
        ];

        return $this
            ->connections
            ->getRead()
            ->fetchOne($query, $bindings);
    }

    /**
     * @param string $title
     *
     * @return array|false
     */
    public function getBlogByTitle($title)
    {
        $query = "
            SELECT *
            FROM `jpemeric_stream`.`blog`
            WHERE `title` = :title
            LIMIT 1";
        $bindings = [
            'title' => $title,
        ];

        return $this
            ->connections
            ->getRead()
            ->fetchOne($query, $bindings);
    }

    /**
     * @return array|false
     */
    public function getUnmappedBlogs()
    {
        $query = "
            SELECT `id`, `date`
            FROM `jpemeric_stream`.`blog`
            LEFT JOIN `jpemeric_stream`.`post`
            ON `post`.`type_id` = `blog`.`id` AND `post`.`id` IS NULL";

        return $this
            ->connections
            ->getRead()
            ->fetchAll($query);
    }
}


1			<?php
2
3			namespace Jacobemerick\Web\Domain\Stream\Blog;
4
5			use Aura\Sql\ConnectionLocator;
6
7			class MysqlBlogRepository implements BlogRepositoryInterface
8			{
9
10			/** @var ConnectionLocator */
11			protected $connections;
12
13			/**
14			* @param ConnectonLocator $connections
15			*/
16			public function __construct(ConnectionLocator $connections)
17			{
18			$this->connections = $connections;
19			}
20
21			/**
22			* @param integer $id
23			*
24			* @return array\|false
25			*/
26			public function getBlogById($id)
27			{
28			$query = "
29			SELECT *
30			FROM `jpemeric_stream`.`blog`
31			WHERE `id` = :id
32			LIMIT 1";
33			$bindings = [
34			'id' => $id,
35			];
36
37			return $this
38			->connections
39			->getRead()
40			->fetchOne($query, $bindings);
41			}
42
43			/**
44			* @param string $title
45			*
46			* @return array\|false
47			*/
48			public function getBlogByTitle($title)
49			{
50			$query = "
51			SELECT *
52			FROM `jpemeric_stream`.`blog`
53			WHERE `title` = :title
54			LIMIT 1";
55			$bindings = [
56			'title' => $title,
57			];
58
59			return $this
60			->connections
61			->getRead()
62			->fetchOne($query, $bindings);
63			}
64
65			/**
66			* @return array\|false
67			*/
68			public function getUnmappedBlogs()
69			{
70			$query = "
71			SELECT `id`, `date`
72			FROM `jpemeric_stream`.`blog`
73			LEFT JOIN `jpemeric_stream`.`post`
74			ON `post`.`type_id` = `blog`.`id` AND `post`.`id` IS NULL";
75
76			return $this
77			->connections
78			->getRead()
79			->fetchAll($query);
80			}
81			}
82

jacobemerick / web

Push — master ( c330e2...cf0c7a )

MysqlBlogRepository::getUnmappedBlogs() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like