for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace Jacobemerick\Web\Domain\Stream\Goodread;
use Aura\Sql\ConnectionLocator;
use DateTime;
class MysqlGoodreadRepository implements GoodreadRepositoryInterface
{
/** @var ConnectionLocator */
protected $connections;
/**
* @param ConnectonLocator $connections
*/
public function __construct(ConnectionLocator $connections)
$this->connections = $connections;
}
public function getGoodreadsUpdatedSince(DateTime $datetime)
$query = "
SELECT *
FROM `jpemeric_stream`.`goodread`
WHERE `updated_at` >= :last_update";
$bindings = [
'last_update' => $datetime->format('Y-m-d H:i:s'),
];
return $this
->connections
->getRead()
->fetchAll($query, $bindings);