package knowledgeqa

import (
	"testing"

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

	"github.com/tidbcloud/AgentTeam/internal/coredb"
)

func TestCompletedTurnIsRetryableOnlyWithCurrentAttemptWarning(t *testing.T) {
	for _, test := range []struct {
		name         string
		warningCount int64
		want         bool
	}{
		{name: "warning", warningCount: 1, want: true},
		{name: "clean", warningCount: 0, want: false},
	} {
		t.Run(test.name, func(t *testing.T) {
			sqlDB, mock, err := sqlmock.New()
			if err != nil {
				t.Fatal(err)
			}
			defer sqlDB.Close()
			mock.ExpectBegin()
			mock.ExpectQuery(`(?s)SELECT COUNT\(\*\) FROM knowledge_qa_events.*attempt_id=.*kind='diagnostic'.*status='warning'`).
				WithArgs("kqa_current", "kqt_1").
				WillReturnRows(sqlmock.NewRows([]string{"count"}).AddRow(test.warningCount))
			mock.ExpectRollback()

			db := coredb.WrapSQLDB(sqlDB)
			tx, err := db.BeginTx(t.Context(), coredb.TxOptions{})
			if err != nil {
				t.Fatal(err)
			}
			got, err := retryableKnowledgeQATurn(t.Context(), tx, Turn{
				ID: "kqt_1", CurrentAttemptID: "kqa_current", Status: "completed",
			})
			if err != nil {
				t.Fatal(err)
			}
			if got != test.want {
				t.Fatalf("retryableKnowledgeQATurn() = %v, want %v", got, test.want)
			}
			if err := tx.Rollback(t.Context()); err != nil {
				t.Fatal(err)
			}
			if err := mock.ExpectationsWereMet(); err != nil {
				t.Fatal(err)
			}
		})
	}
}