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()
}
