BlueGit

timfa bluegit

Files

bluegit / internal / store / sidebar.go

sidebar.go

sidebar.go 745 B Download Raw
1package store
2
3import "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.
8func (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, `
14SELECT
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}