package packs

import (
	"context"
	"database/sql"
	"testing"

	"github.com/DATA-DOG/go-sqlmock"
	"github.com/nexuscrm/shared/pkg/models"
)

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

	layout, err := parseUserPageLayout()
	if err != nil {
		t.Fatalf("parseUserPageLayout: %v", err)
	}

	mock.ExpectQuery(`SELECT COUNT\(\*\)\s+FROM _System_PageLayout`).
		WithArgs(curatedUserObjectAPIName).
		WillReturnRows(sqlmock.NewRows([]string{"COUNT(*)"}).AddRow(0))
	mock.ExpectQuery(`SELECT COUNT\(\*\)\s+FROM _System_LayoutAssignment`).
		WithArgs(curatedUserObjectAPIName).
		WillReturnRows(sqlmock.NewRows([]string{"COUNT(*)"}).AddRow(0))
	mock.ExpectQuery(`SELECT COUNT\(\*\)\s+FROM _System_LayoutAssignment`).
		WithArgs(curatedUserObjectAPIName, models.LayoutAssignmentRouteSourceAdminAuthored).
		WillReturnRows(sqlmock.NewRows([]string{"COUNT(*)"}).AddRow(0))
	mock.ExpectQuery(`SELECT la\.` + "`Id`" + `, la\.` + "`LayoutId`").
		WithArgs(curatedUserObjectAPIName).
		WillReturnError(sql.ErrNoRows)
	mock.ExpectQuery(`SELECT ` + "`Id`" + `, COALESCE`).
		WithArgs(curatedUserLayoutID).
		WillReturnError(sql.ErrNoRows)
	mock.ExpectQuery(`SELECT ` + "`Id`" + `, COALESCE`).
		WithArgs(curatedUserObjectAPIName).
		WillReturnError(sql.ErrNoRows)
	mock.ExpectQuery(`SELECT COUNT\(\*\) FROM ` + "`_System_PageLayout`").
		WithArgs(curatedUserObjectAPIName).
		WillReturnRows(sqlmock.NewRows([]string{"COUNT(*)"}).AddRow(0))

	mock.ExpectBegin()
	mock.ExpectQuery(`SELECT ` + "`Id`" + `, COALESCE`).
		WithArgs(curatedUserLayoutID).
		WillReturnError(sql.ErrNoRows)
	mock.ExpectQuery(`SELECT ` + "`Id`" + `, COALESCE`).
		WithArgs(curatedUserObjectAPIName, layout.LayoutName).
		WillReturnRows(sqlmock.NewRows([]string{"Id", "Config", "Source", "IsCustomized", "IsDefault", "OwnerPack"}))
	mock.ExpectExec(`INSERT INTO _System_PageLayout`).
		WithArgs(
			curatedUserLayoutID,
			curatedUserObjectAPIName,
			layout.LayoutName,
			layout.Type,
			true,
			sqlmock.AnyArg(),
			curatedLayoutSource,
			(&PlatformUXPack{}).Name(),
		).
		WillReturnResult(sqlmock.NewResult(1, 1))
	mock.ExpectExec(`UPDATE _System_PageLayout`).
		WithArgs(curatedUserObjectAPIName, curatedUserLayoutID).
		WillReturnResult(sqlmock.NewResult(0, 0))
	mock.ExpectExec(`UPDATE _System_PageLayout`).
		WithArgs(curatedUserLayoutID).
		WillReturnResult(sqlmock.NewResult(1, 1))
	mock.ExpectExec(`DELETE FROM _System_LayoutAssignment`).
		WithArgs(curatedUserObjectAPIName).
		WillReturnResult(sqlmock.NewResult(0, 0))
	mock.ExpectExec(`INSERT INTO _System_LayoutAssignment`).
		WithArgs(
			curatedUserAssignmentID,
			curatedUserObjectAPIName,
			curatedUserLayoutID,
			models.LayoutAssignmentRouteSourceManagedSeed,
			(&PlatformUXPack{}).Name(),
		).
		WillReturnResult(sqlmock.NewResult(1, 1))
	mock.ExpectCommit()

	if err := applyUserPageLayout(context.Background(), db); err != nil {
		t.Fatalf("applyUserPageLayout() error = %v", err)
	}
	if err := mock.ExpectationsWereMet(); err != nil {
		t.Fatalf("sqlmock expectations unmet: %v", err)
	}
}

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

	mock.ExpectExec(`UPDATE _System_PageLayout`).
		WithArgs((&PlatformUXPack{}).Name(), curatedUserLayoutID, curatedUserObjectAPIName, curatedLayoutSource).
		WillReturnResult(sqlmock.NewResult(0, 1))
	mock.ExpectExec(`UPDATE _System_LayoutAssignment`).
		WithArgs((&PlatformUXPack{}).Name(), curatedUserAssignmentID, curatedUserObjectAPIName, curatedUserLayoutID, models.LayoutAssignmentRouteSourceManagedSeed).
		WillReturnResult(sqlmock.NewResult(0, 1))

	if err := BackfillLegacyOwnerlessCuratedUserLayoutOwnership(context.Background(), db); err != nil {
		t.Fatalf("BackfillLegacyOwnerlessCuratedUserLayoutOwnership() error = %v", err)
	}
	if err := mock.ExpectationsWereMet(); err != nil {
		t.Fatalf("sqlmock expectations unmet: %v", err)
	}
}