package store

import (
	"context"
	"testing"
	"time"
)

func TestContributionsFilterAndNotes(t *testing.T) {
	s := openTest(t)
	ctx := context.Background()
	tim, err := s.UpsertUser(ctx, 1, "tim", "", false)
	if err != nil {
		t.Fatal(err)
	}
	ada, err := s.UpsertUser(ctx, 2, "ada", "", false)
	if err != nil {
		t.Fatal(err)
	}
	demo, err := s.CreateRepo(ctx, "user", tim.ID, "demo", "", "master", "private")
	if err != nil {
		t.Fatal(err)
	}
	geheim, err := s.CreateRepo(ctx, "user", tim.ID, "geheim", "", "master", "private")
	if err != nil {
		t.Fatal(err)
	}
	march := time.Date(2026, 3, 3, 12, 0, 0, 0, time.UTC)
	may := time.Date(2026, 5, 5, 12, 0, 0, 0, time.UTC)
	if err := s.AddContributions(ctx, []Contribution{
		{UserID: tim.ID, RepoID: geheim.ID, Kind: "commit", Ref: "aaa", At: march},
		{UserID: tim.ID, RepoID: demo.ID, Kind: "commit", Ref: "bbb", At: may},
		{UserID: tim.ID, RepoID: demo.ID, Kind: "commit", Ref: "bbb", At: may.Add(time.Hour)},
		{UserID: ada.ID, RepoID: demo.ID, Kind: "commit", Ref: "ccc", At: may},
	}); err != nil {
		t.Fatal(err)
	}
	since := time.Date(2025, 1, 1, 0, 0, 0, 0, time.UTC)
	timDemo, err := s.ContributionTimes(ctx, tim.ID, []int64{demo.ID}, since)
	if err != nil || len(timDemo) != 1 {
		t.Fatalf("tim demo %v %v", timDemo, err)
	}
	allDemo, err := s.ContributionTimes(ctx, 0, []int64{demo.ID}, since)
	if err != nil || len(allDemo) != 2 {
		t.Fatalf("demo %v %v", allDemo, err)
	}
	none, err := s.ContributionTimes(ctx, tim.ID, nil, since)
	if err != nil || len(none) != 0 {
		t.Fatalf("lege lijst %v %v", none, err)
	}
	id, ok := s.UserIDByGitAuthor(ctx, "Tim@users.git.timfalken.com")
	if !ok || id != tim.ID {
		t.Fatalf("auteur %d %v", id, ok)
	}
	if id, ok := s.UserIDByGitAuthor(ctx, "ada@example.com"); !ok || id != ada.ID {
		t.Fatalf("lokaal deel %d %v", id, ok)
	}
	if _, ok := s.UserIDByGitAuthor(ctx, "onbekend@example.com"); ok {
		t.Fatal("onbekende auteur gekoppeld")
	}
	if _, ok := s.UserIDByGitAuthor(ctx, "tim"); ok {
		t.Fatal("naam zonder e-mail gekoppeld")
	}
	if err := s.RememberPushers(ctx, demo.ID, tim.ID, []PushAuthor{{SHA: "abc", Name: "Other Person", Email: "other@example.com"}}); err != nil {
		t.Fatal(err)
	}
	if err := s.RememberPushers(ctx, demo.ID, ada.ID, []PushAuthor{{SHA: "abc", Name: "Other Person", Email: "other@example.com"}, {SHA: "", Name: "leeg", Email: ""}}); err != nil {
		t.Fatal(err)
	}
	got, err := s.PushersBySHA(ctx, demo.ID, []string{"abc", "missing"})
	if err != nil {
		t.Fatal(err)
	}
	if got["abc"].Username != "tim" || got["abc"].UserID != tim.ID {
		t.Fatalf("eerste pusher %+v", got["abc"])
	}
	if _, ok := got["missing"]; ok {
		t.Fatal("ontbrekende sha")
	}
	mr, err := s.CreateMergeRequest(ctx, demo.ID, tim.ID, "titel", "", "feature", "master")
	if err != nil {
		t.Fatal(err)
	}
	note, err := s.AddNote(ctx, demo.ID, mr.ID, ada.ID, "  <b>mooi</b>  ")
	if err != nil {
		t.Fatal(err)
	}
	if note.Body != "<b>mooi</b>" {
		t.Fatal(note.Body)
	}
	if _, err := s.AddNote(ctx, demo.ID, mr.ID, ada.ID, "   "); err == nil {
		t.Fatal("lege reactie geaccepteerd")
	}
	notes, err := s.ListNotes(ctx, mr.ID)
	if err != nil || len(notes) != 1 || notes[0].Author != "ada" {
		t.Fatalf("%+v %v", notes, err)
	}
	adaDemo, err := s.ContributionTimes(ctx, ada.ID, []int64{demo.ID}, since)
	if err != nil || len(adaDemo) != 2 {
		t.Fatalf("ada %d %v", len(adaDemo), err)
	}
}
