package store

import "context"

// SetForkOf legt vast dat repo een fork is van upstream.
func (s *Store) SetForkOf(ctx context.Context, repoID, upstreamID int64) error {
	_, err := s.db.ExecContext(ctx, `UPDATE repos SET fork_of = ? WHERE id = ?`, upstreamID, repoID)
	return err
}

// ForkOf geeft de upstream-id (0 = geen fork).
func (s *Store) ForkOf(ctx context.Context, repoID int64) (int64, error) {
	var id int64
	err := s.db.QueryRowContext(ctx, `SELECT fork_of FROM repos WHERE id = ?`, repoID).Scan(&id)
	return id, err
}

// ForkIDs geeft de ids van de directe forks van upstream.
func (s *Store) ForkIDs(ctx context.Context, upstreamID int64) ([]int64, error) {
	rows, err := s.db.QueryContext(ctx, `SELECT id FROM repos WHERE fork_of = ? ORDER BY id`, upstreamID)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var out []int64
	for rows.Next() {
		var id int64
		if err := rows.Scan(&id); err != nil {
			return nil, err
		}
		out = append(out, id)
	}
	return out, rows.Err()
}

// SetMRForkSource: deze MR komt uit branch van fork repoID.
func (s *Store) SetMRForkSource(ctx context.Context, mrID, repoID int64, branch string) error {
	_, err := s.db.ExecContext(ctx, `UPDATE merge_requests SET source_repo_id = ?, source_repo_branch = ? WHERE id = ?`, repoID, branch, mrID)
	return err
}

// MRForkSource geeft de fork en branch van een MR (0 = zelfde repo).
func (s *Store) MRForkSource(ctx context.Context, mrID int64) (int64, string, error) {
	var id int64
	var b string
	err := s.db.QueryRowContext(ctx, `SELECT source_repo_id, source_repo_branch FROM merge_requests WHERE id = ?`, mrID).Scan(&id, &b)
	return id, b, err
}

// ForkMR is een open MR in upstream met een branch uit een fork als bron.
type ForkMR struct {
	MRID, UpstreamID int64
	Number           int64
	Mirror           string // branch in upstream (forks/...)
}

// OpenForkMRs: open MR's die forkBranch van fork als bron hebben.
func (s *Store) OpenForkMRs(ctx context.Context, forkID int64, forkBranch string) ([]ForkMR, error) {
	rows, err := s.db.QueryContext(ctx, `SELECT id, repo_id, number, source_branch FROM merge_requests WHERE source_repo_id = ? AND source_repo_branch = ? AND status = 'open'`, forkID, forkBranch)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var out []ForkMR
	for rows.Next() {
		var m ForkMR
		if err := rows.Scan(&m.MRID, &m.UpstreamID, &m.Number, &m.Mirror); err != nil {
			return nil, err
		}
		out = append(out, m)
	}
	return out, rows.Err()
}
