package store import ( "context" "database/sql" "strings" ) // PushAuthor is de git-auteur van een commit die net nieuw werd. type PushAuthor struct { SHA, Name, Email string } // Pusher is wie een commit als eerste in deze repository pushte. type Pusher struct { UserID int64 Username string AvatarURL string Name string Email string } // RememberPushers onthoudt de pusher. Een commit die al een pusher heeft // houdt die: een latere push, rebase of merge overschrijft hem niet. func (s *Store) RememberPushers(ctx context.Context, repoID, userID int64, rows []PushAuthor) error { if repoID == 0 || userID == 0 || len(rows) == 0 { return nil } tx, err := s.db.BeginTx(ctx, nil) if err != nil { return err } defer func() { _ = tx.Rollback() }() for _, row := range rows { sha := strings.TrimSpace(row.SHA) if sha == "" { continue } if _, err := tx.ExecContext(ctx, `INSERT OR IGNORE INTO commit_pushers (repo_id, sha, user_id, author_name, author_email, created_at) VALUES (?, ?, ?, ?, ?, ?)`, repoID, sha, userID, row.Name, row.Email, now()); err != nil { return err } } return tx.Commit() } // PushersBySHA leest de eerste pusher van de gevraagde commits. func (s *Store) PushersBySHA(ctx context.Context, repoID int64, shas []string) (map[string]Pusher, error) { if repoID == 0 || len(shas) == 0 { return map[string]Pusher{}, nil } hold := make([]string, len(shas)) args := make([]any, 0, len(shas)+1) args = append(args, repoID) for i, sha := range shas { hold[i] = "?" args = append(args, sha) } q := pusherSelect + ` WHERE p.repo_id = ? AND p.sha IN (` + strings.Join(hold, ",") + `)` rows, err := s.db.QueryContext(ctx, q, args...) if err != nil { return nil, err } defer rows.Close() return scanPushers(rows) } // PushersByRepo leest elke eerste pusher van een repository. func (s *Store) PushersByRepo(ctx context.Context, repoID int64) (map[string]Pusher, error) { rows, err := s.db.QueryContext(ctx, pusherSelect+` WHERE p.repo_id = ?`, repoID) if err != nil { return nil, err } defer rows.Close() return scanPushers(rows) } const pusherSelect = `SELECT p.sha, p.user_id, u.username, u.avatar_url, p.author_name, p.author_email FROM commit_pushers p JOIN users u ON u.id = p.user_id` func scanPushers(rows *sql.Rows) (map[string]Pusher, error) { out := map[string]Pusher{} for rows.Next() { var sha string var p Pusher if err := rows.Scan(&sha, &p.UserID, &p.Username, &p.AvatarURL, &p.Name, &p.Email); err != nil { return nil, err } out[sha] = p } return out, rows.Err() }