package rest

import (
	"encoding/json"
	"net/http"
	"net/http/httptest"
	"testing"

	"github.com/DATA-DOG/go-sqlmock"
	"github.com/gin-gonic/gin"
)

func TestSentryMetricsHandler_Schema(t *testing.T) {
	gin.SetMode(gin.TestMode)
	h := NewSentryMetricsHandler(nil /* nil DB */, "v-test")
	r := gin.New()
	r.GET("/internal/sentry-metrics", h.Get)

	rec := httptest.NewRecorder()
	req := httptest.NewRequest(http.MethodGet, "/internal/sentry-metrics", nil)
	r.ServeHTTP(rec, req)

	if rec.Code != http.StatusOK {
		t.Fatalf("status = %d, want 200", rec.Code)
	}
	var body map[string]any
	if err := json.Unmarshal(rec.Body.Bytes(), &body); err != nil {
		t.Fatalf("bad json: %v", err)
	}
	for _, k := range []string{"collected_at", "version", "uptime_sec", "runtime", "db_pool", "http", "outbox", "file_upload_operations"} {
		if _, ok := body[k]; !ok {
			t.Errorf("missing field %q", k)
		}
	}
	if body["version"].(string) != "v-test" {
		t.Errorf("version = %v", body["version"])
	}
}

func TestSentryMetricsHandler_IncludesUploadOperationMetrics(t *testing.T) {
	gin.SetMode(gin.TestMode)

	db, mock, err := sqlmock.New(sqlmock.QueryMatcherOption(sqlmock.QueryMatcherRegexp))
	if err != nil {
		t.Fatalf("sqlmock.New: %v", err)
	}
	defer db.Close()

	h := NewSentryMetricsHandler(db, "v-test")
	r := gin.New()
	r.GET("/internal/sentry-metrics", h.Get)

	mock.ExpectQuery("SELECT `Status`, COUNT\\(\\*\\) FROM `_System_OutboxEvent` GROUP BY `Status`").
		WillReturnRows(sqlmock.NewRows([]string{"Status", "COUNT(*)"}).
			AddRow("pending", 2).
			AddRow("processed", 1))
	mock.ExpectQuery("SELECT COUNT\\(\\*\\) FROM `_System_FileUploadOperation`").
		WillReturnRows(sqlmock.NewRows([]string{"COUNT(*)"}).AddRow(4))
	mock.ExpectQuery("SELECT `State`, COUNT\\(\\*\\) FROM `_System_FileUploadOperation` GROUP BY `State`").
		WillReturnRows(sqlmock.NewRows([]string{"State", "COUNT(*)"}).
			AddRow("PREPARED", 1).
			AddRow("COMPLETED", 3))
	mock.ExpectQuery("SELECT COUNT\\(\\*\\) FROM `_System_FileUploadOperation` WHERE `ExpiresAt` IS NOT NULL AND `ExpiresAt` < \\?").
		WithArgs(sqlmock.AnyArg()).
		WillReturnRows(sqlmock.NewRows([]string{"COUNT(*)"}).AddRow(1))

	rec := httptest.NewRecorder()
	req := httptest.NewRequest(http.MethodGet, "/internal/sentry-metrics", nil)
	r.ServeHTTP(rec, req)

	if rec.Code != http.StatusOK {
		t.Fatalf("status = %d, want 200", rec.Code)
	}
	var body map[string]any
	if err := json.Unmarshal(rec.Body.Bytes(), &body); err != nil {
		t.Fatalf("bad json: %v", err)
	}
	raw, ok := body["file_upload_operations"].(map[string]any)
	if !ok {
		t.Fatalf("file_upload_operations = %#v, want object", body["file_upload_operations"])
	}
	if raw["total"] != float64(4) || raw["prepared"] != float64(1) || raw["completed"] != float64(3) || raw["expired"] != float64(1) {
		t.Fatalf("file_upload_operations = %#v", raw)
	}
	if err := mock.ExpectationsWereMet(); err != nil {
		t.Fatalf("expectations: %v", err)
	}
}

func TestSentryMetricsHandler_SoftFailsWhenUploadOperationMetricsQueryErrors(t *testing.T) {
	gin.SetMode(gin.TestMode)

	db, mock, err := sqlmock.New(sqlmock.QueryMatcherOption(sqlmock.QueryMatcherRegexp))
	if err != nil {
		t.Fatalf("sqlmock.New: %v", err)
	}
	defer db.Close()

	h := NewSentryMetricsHandler(db, "v-test")
	r := gin.New()
	r.GET("/internal/sentry-metrics", h.Get)

	mock.ExpectQuery("SELECT `Status`, COUNT\\(\\*\\) FROM `_System_OutboxEvent` GROUP BY `Status`").
		WillReturnRows(sqlmock.NewRows([]string{"Status", "COUNT(*)"}).
			AddRow("pending", 2).
			AddRow("failed", 1))
	mock.ExpectQuery("SELECT COUNT\\(\\*\\) FROM `_System_FileUploadOperation`").
		WillReturnError(assertAnError{})

	rec := httptest.NewRecorder()
	req := httptest.NewRequest(http.MethodGet, "/internal/sentry-metrics", nil)
	r.ServeHTTP(rec, req)

	if rec.Code != http.StatusOK {
		t.Fatalf("status = %d, want 200", rec.Code)
	}
	var body map[string]any
	if err := json.Unmarshal(rec.Body.Bytes(), &body); err != nil {
		t.Fatalf("bad json: %v", err)
	}
	raw, ok := body["file_upload_operations"].(map[string]any)
	if !ok {
		t.Fatalf("file_upload_operations = %#v, want object", body["file_upload_operations"])
	}
	if raw["total"] != float64(0) || raw["prepared"] != float64(0) || raw["blob_stored"] != float64(0) || raw["completed"] != float64(0) || raw["failed"] != float64(0) || raw["expired"] != float64(0) {
		t.Fatalf("file_upload_operations = %#v, want zeroed object", raw)
	}
	if err := mock.ExpectationsWereMet(); err != nil {
		t.Fatalf("expectations: %v", err)
	}
}

type assertAnError struct{}

func (assertAnError) Error() string { return "boom" }

// TestSentryMetricsHandler_ExposesProcessingBucket asserts the outbox
// snapshot surfaces Status='processing' alongside pending/processed/failed.
// This closes Round 2 H2: stuck-in-processing rows were previously invisible
// to the existing dashboard because the switch silently dropped them.
func TestSentryMetricsHandler_ExposesProcessingBucket(t *testing.T) {
	gin.SetMode(gin.TestMode)

	db, mock, err := sqlmock.New(sqlmock.QueryMatcherOption(sqlmock.QueryMatcherRegexp))
	if err != nil {
		t.Fatalf("sqlmock.New: %v", err)
	}
	defer db.Close()

	h := NewSentryMetricsHandler(db, "v-test")
	r := gin.New()
	r.GET("/internal/sentry-metrics", h.Get)

	mock.ExpectQuery("SELECT `Status`, COUNT\\(\\*\\) FROM `_System_OutboxEvent` GROUP BY `Status`").
		WillReturnRows(sqlmock.NewRows([]string{"Status", "COUNT(*)"}).
			AddRow("pending", 3).
			AddRow("processing", 7).
			AddRow("processed", 42).
			AddRow("failed", 1))
	mock.ExpectQuery("SELECT COUNT\\(\\*\\) FROM `_System_FileUploadOperation`").
		WillReturnRows(sqlmock.NewRows([]string{"COUNT(*)"}).AddRow(0))
	mock.ExpectQuery("SELECT `State`, COUNT\\(\\*\\) FROM `_System_FileUploadOperation` GROUP BY `State`").
		WillReturnRows(sqlmock.NewRows([]string{"State", "COUNT(*)"}))
	mock.ExpectQuery("SELECT COUNT\\(\\*\\) FROM `_System_FileUploadOperation` WHERE `ExpiresAt` IS NOT NULL AND `ExpiresAt` < \\?").
		WithArgs(sqlmock.AnyArg()).
		WillReturnRows(sqlmock.NewRows([]string{"COUNT(*)"}).AddRow(0))

	rec := httptest.NewRecorder()
	req := httptest.NewRequest(http.MethodGet, "/internal/sentry-metrics", nil)
	r.ServeHTTP(rec, req)

	if rec.Code != http.StatusOK {
		t.Fatalf("status = %d, want 200", rec.Code)
	}
	var body map[string]any
	if err := json.Unmarshal(rec.Body.Bytes(), &body); err != nil {
		t.Fatalf("bad json: %v", err)
	}
	outbox, ok := body["outbox"].(map[string]any)
	if !ok {
		t.Fatalf("outbox = %#v, want object", body["outbox"])
	}
	if outbox["pending"] != float64(3) || outbox["processing"] != float64(7) || outbox["processed"] != float64(42) || outbox["failed"] != float64(1) {
		t.Fatalf("outbox = %#v, want pending=3 processing=7 processed=42 failed=1", outbox)
	}
	if err := mock.ExpectationsWereMet(); err != nil {
		t.Fatalf("expectations: %v", err)
	}
}

func TestSentryMetricsHandler_SoftFailsWhenOutboxQueryErrors(t *testing.T) {
	gin.SetMode(gin.TestMode)

	db, mock, err := sqlmock.New(sqlmock.QueryMatcherOption(sqlmock.QueryMatcherRegexp))
	if err != nil {
		t.Fatalf("sqlmock.New: %v", err)
	}
	defer db.Close()

	h := NewSentryMetricsHandler(db, "v-test")
	r := gin.New()
	r.GET("/internal/sentry-metrics", h.Get)

	mock.ExpectQuery("SELECT `Status`, COUNT\\(\\*\\) FROM `_System_OutboxEvent` GROUP BY `Status`").
		WillReturnError(assertAnError{})
	mock.ExpectQuery("SELECT COUNT\\(\\*\\) FROM `_System_FileUploadOperation`").
		WillReturnRows(sqlmock.NewRows([]string{"COUNT(*)"}).AddRow(2))
	mock.ExpectQuery("SELECT `State`, COUNT\\(\\*\\) FROM `_System_FileUploadOperation` GROUP BY `State`").
		WillReturnRows(sqlmock.NewRows([]string{"State", "COUNT(*)"}).
			AddRow("BLOB_STORED", 1).
			AddRow("FAILED", 1))
	mock.ExpectQuery("SELECT COUNT\\(\\*\\) FROM `_System_FileUploadOperation` WHERE `ExpiresAt` IS NOT NULL AND `ExpiresAt` < \\?").
		WithArgs(sqlmock.AnyArg()).
		WillReturnRows(sqlmock.NewRows([]string{"COUNT(*)"}).AddRow(0))

	rec := httptest.NewRecorder()
	req := httptest.NewRequest(http.MethodGet, "/internal/sentry-metrics", nil)
	r.ServeHTTP(rec, req)

	if rec.Code != http.StatusOK {
		t.Fatalf("status = %d, want 200", rec.Code)
	}
	var body map[string]any
	if err := json.Unmarshal(rec.Body.Bytes(), &body); err != nil {
		t.Fatalf("bad json: %v", err)
	}
	outbox, ok := body["outbox"].(map[string]any)
	if !ok {
		t.Fatalf("outbox = %#v, want object", body["outbox"])
	}
	if outbox["pending"] != float64(0) || outbox["processing"] != float64(0) || outbox["processed"] != float64(0) || outbox["failed"] != float64(0) {
		t.Fatalf("outbox = %#v, want zeroed object", outbox)
	}
	raw, ok := body["file_upload_operations"].(map[string]any)
	if !ok {
		t.Fatalf("file_upload_operations = %#v, want object", body["file_upload_operations"])
	}
	if raw["total"] != float64(2) || raw["blob_stored"] != float64(1) || raw["failed"] != float64(1) {
		t.Fatalf("file_upload_operations = %#v", raw)
	}
	if err := mock.ExpectationsWereMet(); err != nil {
		t.Fatalf("expectations: %v", err)
	}
}