MysqlBlogRepository::getBlogByPermalink() - Code Metrics - Inspection of "Removes unnecessary dependencies" - jacobemerick/web - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( f70a65...3f527d )

by Jacob

created 2016-02-11 03:06 UTC

MysqlBlogRepository::getBlogByPermalink() A

↳ Parent: MysqlBlogRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	16
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	1

Metric	Value
c	2
b	0
f	1
dl	0
loc	16
rs	9.4285
cc	1
eloc	8
nc	1
nop	1

<?php

namespace Jacobemerick\Web\Domain\Stream\Blog;

use Aura\Sql\ConnectionLocator;
use DateTime;

class MysqlBlogRepository implements BlogRepositoryInterface
{

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

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

    public function getBlogByPermalink($permalink)
    {
        $query = "
            SELECT *
            FROM `jpemeric_stream`.`blog`
            WHERE `permalink` = :permalink
            LIMIT 1";
        $bindings = [
            'permalink' => $permalink,
        ];

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

    public function getBlogsUpdatedSince(DateTime $datetime)
    {
        $query = "
            SELECT *
            FROM `jpemeric_stream`.`blog`
            WHERE `updated_at` >= :last_update";

        $bindings = [
            'last_update' => $datetime->format('Y-m-d H:i:s'),
        ];

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


1			<?php
2
3			namespace Jacobemerick\Web\Domain\Stream\Blog;
4
5			use Aura\Sql\ConnectionLocator;
6			use DateTime;
7
8			class MysqlBlogRepository implements BlogRepositoryInterface
9			{
10
11			/** @var ConnectionLocator */
12			protected $connections;
13
14			/**
15			* @param ConnectonLocator $connections
16			*/
17			public function __construct(ConnectionLocator $connections)
18			{
19			$this->connections = $connections;
20			}
21
22			public function getBlogByPermalink($permalink)
23			{
24			$query = "
25			SELECT *
26			FROM `jpemeric_stream`.`blog`
27			WHERE `permalink` = :permalink
28			LIMIT 1";
29			$bindings = [
30			'permalink' => $permalink,
31			];
32
33			return $this
34			->connections
35			->getRead()
36			->fetchOne($query, $bindings);
37			}
38
39			public function getBlogsUpdatedSince(DateTime $datetime)
40			{
41			$query = "
42			SELECT *
43			FROM `jpemeric_stream`.`blog`
44			WHERE `updated_at` >= :last_update";
45
46			$bindings = [
47			'last_update' => $datetime->format('Y-m-d H:i:s'),
48			];
49
50			return $this
51			->connections
52			->getRead()
53			->fetchAll($query, $bindings);
54			}
55			}
56

jacobemerick / web

Push — master ( f70a65...3f527d )

MysqlBlogRepository::getBlogByPermalink() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like