MysqlBlogCommentRepository::insertBlogComment() - 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

MysqlBlogCommentRepository::insertBlogComment() A

↳ Parent: Project

Complexity

Conditions	1
Paths	1

Size

Total Lines	19
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
dl	0
loc	19
rs	9.4285
cc	1
eloc	10
nc	1
nop	3
c	1
b	0
f	1

<?php

namespace Jacobemerick\Web\Domain\Stream\BlogComment;

use Aura\Sql\ConnectionLocator;
use DateTime;

class MysqlBlogCommentRepository implements BlogCommentRepositoryInterface
{

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

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

    /**
     * @param integer $limit
     * @param integer $offset
     *
     * @return array|false
     */
    public function getBlogComments($limit = null, $offset = 0)
    {
        $query = "
            SELECT `id`, `permalink`, `datetime`
            FROM `jpemeric_stream`.`blog_comment`
            ORDER BY `datetime` DESC";
        if (!is_null($limit)) {
            $query .= "
            LIMIT {$offset}, {$limit}";
        }

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

    /**
     * @param string $permalink
     *
     * @return array|false
     */
    public function getBlogCommentByPermalink($permalink)
    {
        $query = "
            SELECT *
            FROM `jpemeric_stream`.`blog_comment`
            WHERE `permalink` = :permalink
            LIMIT 1";

        $bindings = [
            'permalink' => $permalink,
        ];

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


1			<?php
2
3			namespace Jacobemerick\Web\Domain\Stream\BlogComment;
4
5			use Aura\Sql\ConnectionLocator;
6			use DateTime;
7
8			class MysqlBlogCommentRepository implements BlogCommentRepositoryInterface
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			/**
23			* @param integer $limit
24			* @param integer $offset
25			*
26			* @return array\|false
27			*/
28			public function getBlogComments($limit = null, $offset = 0)
29			{
30			$query = "
31			SELECT `id`, `permalink`, `datetime`
32			FROM `jpemeric_stream`.`blog_comment`
33			ORDER BY `datetime` DESC";
34			if (!is_null($limit)) {
35			$query .= "
36			LIMIT {$offset}, {$limit}";
37			}
38
39			return $this
40			->connections
41			->getRead()
42			->fetchAll($query);
43			}
44
45			/**
46			* @param string $permalink
47			*
48			* @return array\|false
49			*/
50			public function getBlogCommentByPermalink($permalink)
51			{
52			$query = "
53			SELECT *
54			FROM `jpemeric_stream`.`blog_comment`
55			WHERE `permalink` = :permalink
56			LIMIT 1";
57
58			$bindings = [
59			'permalink' => $permalink,
60			];
61
62			return $this
63			->connections
64			->getRead()
65			->fetchOne($query, $bindings);
66			}
67			}
68

jacobemerick / web

Push — master ( f70a65...3f527d )

MysqlBlogCommentRepository::insertBlogComment() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like