public function getInterfaceByRelease($release = null)
{
$query = 'SELECT interface, release FROM interfaces
JOIN namespaces
ON interfaces.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['interface'];
} else {
$return[$row['release']] = array($row['interface']);
}
}
return $return;
}