using Dapper;
using Galaeth.Core.Entities;
using Galaeth.Core.Infrastructure;
using Galaeth.Core.RepositoryInterfaces;
using Injectio.Attributes;

namespace Galaeth.DAL.Repositories;

/// <inheritdoc cref="Galaeth.Core.RepositoryInterfaces.IEmailDomainBlacklistRepository" />
[RegisterScoped]
public class EmailDomainBlacklistRepository : BaseRepository<EmailDomainBlacklist, string>, IEmailDomainBlacklistRepository
{
    /// <summary>
    /// Initializes a new instance of the <see cref="EmailDomainBlacklistRepository"/> class.
    /// </summary>
    /// <param name="db">Instance of <see cref="IDbConnectionProvider"/>.</param>
    public EmailDomainBlacklistRepository(IDbConnectionProvider db)
        : base(db)
    {
    }

    /// <inheritdoc cref="Galaeth.Core.RepositoryInterfaces.IEmailDomainBlacklistRepository" />
    public async Task<long> CountEntries()
    {
        return await WithDatabaseAsync(async connection =>
            await connection.QueryFirstAsync<long>($"SELECT COUNT(*) FROM {Table};"));
    }
}