/**
* @return int
*/
public function count()
{
return DatabaseConnection::doInConnection(function (DatabaseConnection $db) {
$query = clone $this;
$query->selectNone()->select("COUNT(*)");
$query->limit(null);
$query->offset(null);
$query->orderBy(null);
return intval($db->fetchOneColumn($query->getQuery($db->getPDO()), $query->getParameters())->get());
});
}
/**
* @return int
*/
public function executeInsert()
{
return DatabaseConnection::doInConnection(function (DatabaseConnection $db) {
return $db->executeInsert($this->getQuery($db->getPDO()), $this->getParameters());
});
}
public function doGet(JsonResponse $response, $id, DatabaseConnection $connection)
{
/** @var Track $track */
$track = $connection->getLightORM()->load(Track::class, $id);
$response->write($track);
}
