| 1 | package store |
| 2 | |
| 3 | import "context" |
| 4 | |
| 5 | // OpenSidebarCounts telt open merge requests en open issues die de kijker |
| 6 | // mag zien. Zonder triage blijven andermans vertrouwelijke issues weg, |
| 7 | // dezelfde regel als ListIssues. Eén query, geen N+1. |
| 8 | func (s *Store) OpenSidebarCounts(ctx context.Context, repoID, viewerID int64, triage bool) (mrs, issues int, err error) { |
| 9 | triageFlag := 0 |
| 10 | if triage { |
| 11 | triageFlag = 1 |
| 12 | } |
| 13 | err = s.db.QueryRowContext(ctx, ` |
| 14 | SELECT |
| 15 | (SELECT COUNT(*) FROM merge_requests WHERE repo_id = ? AND status = 'open'), |
| 16 | (SELECT COUNT(*) FROM issues WHERE repo_id = ? AND status = 'open' |
| 17 | AND (? = 1 OR confidential = 0 OR author_id = ?))`, |
| 18 | repoID, repoID, triageFlag, viewerID, |
| 19 | ).Scan(&mrs, &issues) |
| 20 | return mrs, issues, err |
| 21 | } |