/**
* @param integer $limit
* @param integer $offset
*
* @return array|false
*/
public function getChanges($limit = null, $offset = 0)
{
$query = "\n SELECT `id`, `message`, `message_short`, `datetime`, `commit_link`\n FROM `jpemeric_stream`.`changelog`\n ORDER BY `datetime` DESC";
if (!is_null($limit)) {
$query .= "\n LIMIT {$offset}, {$limit}";
}
return $this->connections->getRead()->fetchAll($query);
}
private function getConnectionLocator()
{
$config = $this->config;
$connections = new ConnectionLocator();
if (isset($config['default'])) {
$connections->setDefault(function () use($config) {
return new ExtendedPdo($config['default']['database_driver'] . ':host=' . $config['default']['database_host'] . ';dbname=' . $config['default']['database_name'] . ';port=' . $config['default']['database_port'] . ';charset=' . $config['default']['database_charset'], $config['default']['database_user'], $config['default']['database_password']);
});
}
if (isset($config['write'])) {
foreach ($config['write'] as $name => $db) {
$connections->setWrite($name, function () use($db) {
return new ExtendedPdo($db['database_driver'] . ':host=' . $db['database_host'] . ';dbname=' . $db['database_name'] . ';port=' . $db['database_port'] . ';charset=' . $db['database_charset'], $db['database_user'], $db['database_password']);
});
}
}
if (isset($config['read'])) {
foreach ($config['read'] as $name => $db) {
$connections->setRead($name, function () use($db) {
return new ExtendedPdo($db['database_driver'] . ':host=' . $db['database_host'] . ';dbname=' . $db['database_name'] . ';port=' . $db['database_port'] . ';charset=' . $db['database_charset'], $db['database_user'], $db['database_password']);
});
}
}
return $connections;
}
public function getActivitiesByTypeCount($type)
{
$query = "\n SELECT COUNT(1) AS `count`\n FROM `jpemeric_stream`.`activity`\n WHERE `type` = :type";
$bindings = ['type' => $type];
return $this->connections->getRead()->fetchValue($query, $bindings);
}
