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