package identity

import (
	"context"
	"testing"
	"time"

	"github.com/DATA-DOG/go-sqlmock"
	"github.com/stretchr/testify/require"

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

func TestUpdateUserAvatarURLAcceptsUnchangedAvatarURL(t *testing.T) {
	t.Parallel()

	sqlDB, mock, err := sqlmock.New()
	require.NoError(t, err)
	t.Cleanup(func() { _ = sqlDB.Close() })

	now := time.Now().UTC()
	mock.ExpectBegin()
	mock.ExpectExec("UPDATE users").
		WithArgs("/api/v1/users/usr_1/avatar", "usr_1").
		WillReturnResult(sqlmock.NewResult(0, 0))
	mock.ExpectQuery("SELECT id, COALESCE\\(email").
		WithArgs("usr_1").
		WillReturnRows(sqlmock.NewRows([]string{
			"id", "email", "mobile", "name", "display_name", "avatar_url", "is_admin",
			"email_verified_at", "mobile_verified_at", "created_at", "updated_at",
		}).AddRow(
			"usr_1", "alice@example.com", "", "alice", "Alice",
			"/api/v1/users/usr_1/avatar", false, now, nil, now, now,
		))
	mock.ExpectCommit()

	store := New(coredb.WrapSQLDB(sqlDB), Options{})
	user, err := store.UpdateUserAvatarURL(
		context.Background(),
		"usr_1",
		"/api/v1/users/usr_1/avatar",
	)
	require.NoError(t, err)
	require.Equal(t, "/api/v1/users/usr_1/avatar", user.AvatarURL)
	require.NoError(t, mock.ExpectationsWereMet())
}