package repository_test

import (
	"path/filepath"
	"testing"
	"time"

	"github.com/z/tg-apicreator-bot/internal/database"
	"github.com/z/tg-apicreator-bot/internal/repository"
)

func newTestRepo(t *testing.T) *repository.Repository {
	t.Helper()
	path := filepath.Join(t.TempDir(), "test.db")
	db, err := database.Open(path)
	if err != nil {
		t.Fatalf("open db: %v", err)
	}
	t.Cleanup(func() { db.Close() })
	return repository.New(db)
}

func TestUserUpsertAndBan(t *testing.T) {
	r := newTestRepo(t)
	u, err := r.UpsertUser(database.User{TgID: 111, Username: "alice", Language: "fa"})
	if err != nil {
		t.Fatalf("upsert: %v", err)
	}
	if u.ID == 0 {
		t.Fatal("expected non-zero id")
	}
	// Second upsert updates rather than duplicating.
	u2, err := r.UpsertUser(database.User{TgID: 111, Username: "alice2"})
	if err != nil {
		t.Fatalf("upsert2: %v", err)
	}
	if u2.ID != u.ID {
		t.Fatalf("expected same id, got %d vs %d", u2.ID, u.ID)
	}
	if u2.Username != "alice2" {
		t.Fatalf("expected username updated to alice2, got %q", u2.Username)
	}
	if err := r.SetBanned(111, true); err != nil {
		t.Fatalf("ban: %v", err)
	}
	got, err := r.GetUserByTgID(111)
	if err != nil {
		t.Fatalf("get: %v", err)
	}
	if !got.IsBanned {
		t.Fatal("expected banned=true")
	}
}

func TestAPIKeyCreateAndList(t *testing.T) {
	r := newTestRepo(t)
	u, _ := r.UpsertUser(database.User{TgID: 222})
	id, err := r.CreateAPIKey(database.APIKey{
		UserID: u.ID, TgID: u.TgID, Phone: "98912", AppTitle: "app1",
		AppShortname: "shrt", AppPlatform: "android", APIID: "123", APIHash: "hashxxx",
	})
	if err != nil || id == 0 {
		t.Fatalf("create key: %v id=%d", err, id)
	}
	keys, err := r.ListAPIKeysByUser(u.ID)
	if err != nil {
		t.Fatalf("list: %v", err)
	}
	if len(keys) != 1 || keys[0].APIID != "123" {
		t.Fatalf("unexpected keys: %+v", keys)
	}
	if err := r.RevokeAPIKey(id); err != nil {
		t.Fatalf("revoke: %v", err)
	}
	keys, _ = r.ListAPIKeysByUser(u.ID)
	if keys[0].Status != "revoked" {
		t.Fatalf("expected revoked status, got %q", keys[0].Status)
	}
}

func TestDailyUsageAndStats(t *testing.T) {
	r := newTestRepo(t)
	u, _ := r.UpsertUser(database.User{TgID: 333})
	day := time.Now().UTC().Format("2006-01-02")
	c, err := r.IncrementDaily(u.ID, day)
	if err != nil || c != 1 {
		t.Fatalf("first increment: c=%d err=%v", c, err)
	}
	c, _ = r.IncrementDaily(u.ID, day)
	if c != 2 {
		t.Fatalf("second increment: c=%d", c)
	}
	got, _ := r.DailyCount(u.ID, day)
	if got != 2 {
		t.Fatalf("DailyCount=%d want 2", got)
	}
	_, _ = r.CreateAPIKey(database.APIKey{UserID: u.ID, TgID: u.TgID, Phone: "x", APIID: "1", APIHash: "h"})
	st, err := r.Stats()
	if err != nil {
		t.Fatalf("stats: %v", err)
	}
	if st.Users != 1 || st.Keys != 1 {
		t.Fatalf("stats: %+v", st)
	}
}

func TestSettingsRoundtrip(t *testing.T) {
	r := newTestRepo(t)
	if v, _ := r.GetSetting("nope"); v != "" {
		t.Fatalf("missing setting should be empty, got %q", v)
	}
	_ = r.SetSetting("daily_limit", "5")
	v, _ := r.GetSetting("daily_limit")
	if v != "5" {
		t.Fatalf("got %q want 5", v)
	}
	_ = r.SetSetting("daily_limit", "9")
	v, _ = r.GetSetting("daily_limit")
	if v != "9" {
		t.Fatalf("update: got %q want 9", v)
	}
}

func TestProxyCreateAndToggle(t *testing.T) {
	r := newTestRepo(t)
	id, err := r.CreateProxy(database.Proxy{Kind: "http", Host: "1.1.1.1", Port: 8080, Enabled: true})
	if err != nil || id == 0 {
		t.Fatalf("create proxy: %v id=%d", err, id)
	}
	all, _ := r.ListProxies()
	if len(all) != 1 || !all[0].Enabled {
		t.Fatalf("list: %+v", all)
	}
	if err := r.ToggleProxy(id, false); err != nil {
		t.Fatalf("toggle: %v", err)
	}
	en, _ := r.ListEnabledProxies()
	if len(en) != 0 {
		t.Fatalf("expected 0 enabled, got %d", len(en))
	}
}

// quiet: keep the time import meaningful
var _ = time.Second
