BlueGit

timfa bluegit

Files

bluegit / internal / store / pushers.go

pushers.go

feat: koppel commits aan wie ze pushte
timfa project_87923614_bot_3aff574f6f98414b945a8799374f9092 · pushed by timfa · 3 weeks ago
Failed 6c3f521b History
pushers.go 2.5 KiB Download Raw
1package store
2
3import (
4 "context"
5 "database/sql"
6 "strings"
7)
8
9// PushAuthor is de git-auteur van een commit die net nieuw werd.
10type PushAuthor struct {
11 SHA, Name, Email string
12}
13
14// Pusher is wie een commit als eerste in deze repository pushte.
15type Pusher struct {
16 UserID int64
17 Username string
18 AvatarURL string
19 Name string
20 Email string
21}
22
23// RememberPushers onthoudt de pusher. Een commit die al een pusher heeft
24// houdt die: een latere push, rebase of merge overschrijft hem niet.
25func (s *Store) RememberPushers(ctx context.Context, repoID, userID int64, rows []PushAuthor) error {
26 if repoID == 0 || userID == 0 || len(rows) == 0 {
27 return nil
28 }
29 tx, err := s.db.BeginTx(ctx, nil)
30 if err != nil {
31 return err
32 }
33 defer func() { _ = tx.Rollback() }()
34 for _, row := range rows {
35 sha := strings.TrimSpace(row.SHA)
36 if sha == "" {
37 continue
38 }
39 if _, err := tx.ExecContext(ctx, `INSERT OR IGNORE INTO commit_pushers (repo_id, sha, user_id, author_name, author_email, created_at) VALUES (?, ?, ?, ?, ?, ?)`,
40 repoID, sha, userID, row.Name, row.Email, now()); err != nil {
41 return err
42 }
43 }
44 return tx.Commit()
45}
46
47// PushersBySHA leest de eerste pusher van de gevraagde commits.
48func (s *Store) PushersBySHA(ctx context.Context, repoID int64, shas []string) (map[string]Pusher, error) {
49 if repoID == 0 || len(shas) == 0 {
50 return map[string]Pusher{}, nil
51 }
52 hold := make([]string, len(shas))
53 args := make([]any, 0, len(shas)+1)
54 args = append(args, repoID)
55 for i, sha := range shas {
56 hold[i] = "?"
57 args = append(args, sha)
58 }
59 q := pusherSelect + ` WHERE p.repo_id = ? AND p.sha IN (` + strings.Join(hold, ",") + `)`
60 rows, err := s.db.QueryContext(ctx, q, args...)
61 if err != nil {
62 return nil, err
63 }
64 defer rows.Close()
65 return scanPushers(rows)
66}
67
68// PushersByRepo leest elke eerste pusher van een repository.
69func (s *Store) PushersByRepo(ctx context.Context, repoID int64) (map[string]Pusher, error) {
70 rows, err := s.db.QueryContext(ctx, pusherSelect+` WHERE p.repo_id = ?`, repoID)
71 if err != nil {
72 return nil, err
73 }
74 defer rows.Close()
75 return scanPushers(rows)
76}
77
78const pusherSelect = `SELECT p.sha, p.user_id, u.username, u.avatar_url, p.author_name, p.author_email
79 FROM commit_pushers p JOIN users u ON u.id = p.user_id`
80
81func scanPushers(rows *sql.Rows) (map[string]Pusher, error) {
82 out := map[string]Pusher{}
83 for rows.Next() {
84 var sha string
85 var p Pusher
86 if err := rows.Scan(&sha, &p.UserID, &p.Username, &p.AvatarURL, &p.Name, &p.Email); err != nil {
87 return nil, err
88 }
89 out[sha] = p
90 }
91 return out, rows.Err()
92}