package store import "context" // OpenSidebarCounts telt open merge requests en open issues die de kijker // mag zien. Zonder triage blijven andermans vertrouwelijke issues weg, // dezelfde regel als ListIssues. Eén query, geen N+1. func (s *Store) OpenSidebarCounts(ctx context.Context, repoID, viewerID int64, triage bool) (mrs, issues int, err error) { triageFlag := 0 if triage { triageFlag = 1 } err = s.db.QueryRowContext(ctx, ` SELECT (SELECT COUNT(*) FROM merge_requests WHERE repo_id = ? AND status = 'open'), (SELECT COUNT(*) FROM issues WHERE repo_id = ? AND status = 'open' AND (? = 1 OR confidential = 0 OR author_id = ?))`, repoID, repoID, triageFlag, viewerID, ).Scan(&mrs, &issues) return mrs, issues, err }