public function getClassByRelease($release = null)
{
$query = 'SELECT class, release FROM classes
JOIN namespaces
ON classes.namespace_id = namespaces.id
JOIN releases
ON namespaces.release_id = releases.id';
if ($release !== null) {
$query .= " WHERE releases.release = \"release-{$release}.0\"";
}
$res = $this->sqlite->query($query);
$return = array();
while ($row = $res->fetchArray(\SQLITE3_ASSOC)) {
if (isset($return[$row['release']])) {
$return[$row['release']][] = $row['class'];
} else {
$return[$row['release']] = array($row['class']);
}
}
return $return;
}