package connector_outboundintent

import (
	"strings"
	"testing"
	"time"

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

func TestRepositoryNegativeWorkHintIsOneReadOnlyStatement(t *testing.T) {
	db, mock, err := sqlmock.New()
	if err != nil {
		t.Fatal(err)
	}
	defer db.Close()

	repository := NewRepository(db)
	repository.now = func() time.Time { return time.Date(2026, 8, 16, 3, 0, 0, 0, time.UTC) }
	mock.ExpectQuery(`(?s)^\s*SELECT\s+EXISTS.*_System_IntegrationOutboundCommand`).
		WillReturnRows(sqlmock.NewRows([]string{"has_work"}).AddRow(false))

	found, err := repository.HasWorkHint(t.Context(), outboundIntentTestScope())
	if err != nil || found {
		t.Fatalf("HasWorkHint = %v, %v, want false, nil", found, err)
	}
	if err := mock.ExpectationsWereMet(); err != nil {
		t.Fatal(err)
	}
}

func TestOutboundWorkHintContainsEveryRecoveryClassWithoutLocksOrWrites(t *testing.T) {
	normalized := strings.ToLower(outboundWorkHintSQL)
	for _, required := range []string{
		"state = ?", "state in (?, ?)", "leaseexpiresat <= ?",
		"nextattemptat is null", "claimtoken is null", "not exists",
		"acceptancesequence < candidate.acceptancesequence",
	} {
		if !strings.Contains(normalized, required) {
			t.Fatalf("work hint is missing %q", required)
		}
	}
	for _, forbidden := range []string{"for update", "start transaction", "update _system_", "delete from", "insert into"} {
		if strings.Contains(normalized, forbidden) {
			t.Fatalf("work hint contains mutating/locking fragment %q", forbidden)
		}
	}
}

func TestOutboundNextWorkTimeCoversSchedulingClassesWithoutAuthority(t *testing.T) {
	normalized := strings.ToLower(outboundNextWorkAtSQL)
	for _, required := range []string{
		"min(scheduled.wakeat)", "state = ?", "state in (?, ?)",
		"leaseexpiresat", "nextattemptat", "not exists",
		"acceptancesequence < candidate.acceptancesequence",
	} {
		if !strings.Contains(normalized, required) {
			t.Fatalf("next-work scheduler is missing %q", required)
		}
	}
	for _, forbidden := range []string{"for update", "start transaction", "update _system_", "delete from", "insert into"} {
		if strings.Contains(normalized, forbidden) {
			t.Fatalf("next-work scheduler contains mutating/locking fragment %q", forbidden)
		}
	}
}