for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?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)
WHERE `updated_at` >= :last_update";
'last_update' => $datetime->format('Y-m-d H:i:s'),
->fetchAll($query, $bindings);