public function getFilesCount($limit = null)
{
$list = Analyzer::getThemeAnalyzers($this->themesToShow);
$list = '"' . join('", "', $list) . '"';
$query = "SELECT file, count(*) AS number\n FROM results\n WHERE analyzer IN ({$list})\n GROUP BY file\n ORDER BY number DESC ";
if ($limit !== null) {
$query .= " LIMIT " . $limit;
}
$result = $this->sqlite->query($query);
$data = array();
while ($row = $result->fetchArray()) {
$data[] = array('file' => $row['file'], 'value' => $row['number']);
}
return $data;
}