package organization

import (
	"testing"

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

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

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

	mock.ExpectBegin()
	mock.ExpectQuery(`(?s)SELECT om.id, om.org_role.*WHERE om.organization_id = .*AND om.user_id =`).
		WithArgs("org_1", "usr_1").
		WillReturnRows(sqlmock.NewRows([]string{"id", "org_role"}).
			AddRow("orm_1", organizationRoleAdmin))
	mock.ExpectCommit()

	store := &Store{db: coredb.WrapSQLDB(sqlDB)}
	if err := store.RequireOrganizationAdmin(t.Context(), " usr_1 ", " org_1 "); err != nil {
		t.Fatal(err)
	}
	if err := mock.ExpectationsWereMet(); err != nil {
		t.Fatal(err)
	}
}