public long FileCount(Tag tag)
{
var tagId = Find(tag);
var count = _db.ExecuteScalar("SELECT COUNT(*) FROM Tags JOIN FileTags ON FileTags.TagId = Tags.Id WHERE Tags.Id = @tagId", new SqliteParameter("@tagId", tagId)) as long?;
return(count ?? 0);
}
private async Task <long?> Find(File file)
{
return(_db.ExecuteScalar("SELECT Id FROM Files WHERE Hash = @hash", new SqliteParameter("@hash", await file.Hash)) as long?);
}
