package store

import (
	"context"
	"strings"
	"time"

	"gitlab.com/Timfa/bluegit/internal/i18n"
)

// SetMergeOptions bewaart of de bronbranch weg mag en of de commits één commit worden.
func (s *Store) SetMergeOptions(ctx context.Context, id int64, remove, squash bool, message string) error {
	rb, sb := 0, 0
	if remove {
		rb = 1
	}
	if squash {
		sb = 1
	}
	_, err := s.db.ExecContext(ctx, `UPDATE merge_requests SET remove_source_branch = ?, squash = ?, squash_message = ?, updated_at = ? WHERE id = ?`,
		rb, sb, trim(message, 20000), now(), id)
	return err
}

// SetDraft zet of haalt het conceptvinkje weg.
func (s *Store) SetDraft(ctx context.Context, id int64, draft bool) error {
	bit := 0
	if draft {
		bit = 1
	}
	_, err := s.db.ExecContext(ctx, `UPDATE merge_requests SET draft = ?, updated_at = ? WHERE id = ?`, bit, now(), id)
	return err
}

// UpdateMergeRequest bewaart titel, beschrijving en labels.
func (s *Store) UpdateMergeRequest(ctx context.Context, id int64, title, description, labels string) error {
	title = trim(title, 200)
	if title == "" {
		return i18n.E("err.mrTitle")
	}
	description = trim(description, 20000)
	labels = trim(labels, 200)
	_, err := s.db.ExecContext(ctx, `UPDATE merge_requests SET title = ?, description = ?, labels = ?, updated_at = ? WHERE id = ?`,
		title, description, labels, now(), id)
	return err
}

// RenameOpenMRBranches werkt open verzoeken bij als een branch een nieuwe naam krijgt.
func (s *Store) RenameOpenMRBranches(ctx context.Context, repoID int64, oldName, newName string) error {
	ts := now()
	if _, err := s.db.ExecContext(ctx, `UPDATE merge_requests SET source_branch = ?, updated_at = ? WHERE repo_id = ? AND source_branch = ? AND status = 'open'`,
		newName, ts, repoID, oldName); err != nil {
		return err
	}
	_, err := s.db.ExecContext(ctx, `UPDATE merge_requests SET target_branch = ?, updated_at = ? WHERE repo_id = ? AND target_branch = ? AND status = 'open'`,
		newName, ts, repoID, oldName)
	return err
}

// MREvent is één gebeurtenis op de tijdlijn van een merge request.
type MREvent struct {
	ID        int64
	ActorID   int64
	Actor     string
	Kind      string
	Body      string
	CreatedAt time.Time
}

// AddMREvent bewaart een gebeurtenis. actorID 0 is toegestaan.
func (s *Store) AddMREvent(ctx context.Context, repoID, mrID, actorID int64, kind, body string) error {
	kind = strings.TrimSpace(kind)
	if kind == "" {
		return i18n.E("err.badForm")
	}
	_, err := s.db.ExecContext(ctx, `INSERT INTO mr_events (repo_id, mr_id, actor_id, kind, body, created_at) VALUES (?, ?, ?, ?, ?, ?)`,
		repoID, mrID, actorID, trim(kind, 40), trim(body, 4000), now())
	return err
}

// ListMREvents geeft de gebeurtenissen, oudste eerst.
func (s *Store) ListMREvents(ctx context.Context, mrID int64) ([]MREvent, error) {
	rows, err := s.db.QueryContext(ctx, `SELECT e.id, e.actor_id, COALESCE(u.username, ''), e.kind, e.body, e.created_at
		FROM mr_events e LEFT JOIN users u ON u.id = e.actor_id
		WHERE e.mr_id = ? ORDER BY e.id`, mrID)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var out []MREvent
	for rows.Next() {
		var e MREvent
		var created string
		if err := rows.Scan(&e.ID, &e.ActorID, &e.Actor, &e.Kind, &e.Body, &created); err != nil {
			return nil, err
		}
		e.CreatedAt = parseTime(created)
		out = append(out, e)
	}
	return out, rows.Err()
}

// PipelinesForMR geeft de pipelines van deze merge request, oudste eerst.
func (s *Store) PipelinesForMR(ctx context.Context, repoID, mrID int64) ([]Pipeline, error) {
	rows, err := s.db.QueryContext(ctx, pipelineCols+` WHERE repo_id = ? AND mr_id = ? ORDER BY id`, repoID, mrID)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var out []Pipeline
	for rows.Next() {
		p, err := scanPipeline(rows)
		if err != nil {
			return nil, err
		}
		out = append(out, p)
	}
	return out, rows.Err()
}
