| 1 | package store |
| 2 | |
| 3 | import ( |
| 4 | "context" |
| 5 | "database/sql" |
| 6 | "strings" |
| 7 | ) |
| 8 | |
| 9 | // PushAuthor is de git-auteur van een commit die net nieuw werd. |
| 10 | type PushAuthor struct { |
| 11 | SHA, Name, Email string |
| 12 | } |
| 13 | |
| 14 | // Pusher is wie een commit als eerste in deze repository pushte. |
| 15 | type 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. |
| 25 | func (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. |
| 48 | func (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. |
| 69 | func (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 | |
| 78 | const 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 | |
| 81 | func 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 | } |