Completed
Push — master ( 2a5bde...88acae )
by Jacob
08:08
created

MysqlGoodreadRepository::insertReview()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 20
Code Lines 11

Duplication

Lines 20
Ratio 100 %

Importance

Changes 1
Bugs 0 Features 1
Metric Value
dl 20
loc 20
rs 9.4285
cc 1
eloc 11
nc 1
nop 4
c 1
b 0
f 1
1
<?php
2
3
namespace Jacobemerick\Web\Domain\Stream\Goodread;
4
5
use Aura\Sql\ConnectionLocator;
6
use DateTime;
7
8
class MysqlGoodreadRepository implements GoodreadRepositoryInterface
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 getGoodreadsUpdatedSince(DateTime $datetime)
23
    {
24
        $query = "
25
            SELECT *
26
            FROM `jpemeric_stream`.`goodread`
27
            WHERE `updated_at` >= :last_update";
28
29
        $bindings = [
30
            'last_update' => $datetime->format('Y-m-d H:i:s'),
31
        ];
32
33
        return $this
34
            ->connections
35
            ->getRead()
36
            ->fetchAll($query, $bindings);
37
    }
38
}
39