private function getCountFileByAnalyzers($analyzer)
{
$query = <<<'SQL'
SELECT count(*) AS number
FROM (SELECT DISTINCT file FROM results WHERE analyzer = :analyzer)
SQL;
$stmt = $this->sqlite->prepare($query);
$stmt->bindValue(':analyzer', $analyzer, \SQLITE3_TEXT);
$result = $stmt->execute();
$row = $result->fetchArray(\SQLITE3_ASSOC);
return $row['number'];
}