using GB5Shared.DTO.Framework.Login;
using TCMSDAL.DTO;

namespace TCMSDAL.Interfaces;

public interface ITCMSTestEnvDAL
{
    // ── MSERVERCONFIG queries (gb5system) ──────────────────────────────────────
    Task<IEnumerable<TCMSTestEnvListDTO>>       GetTestEnvironmentsAsync(LoginDTO login, CancellationToken ct);
    Task<TCMSTestEnvListDTO?>                   GetTestEnvByIdAsync(int serverConfigId, CancellationToken ct);
    Task<TCMSTestDbConnectionDTO?>              GetTestDbConnectionRawAsync(int serverConfigId, CancellationToken ct);
    Task<bool>                                  ConnectionNameExistsAsync(string connectionName, CancellationToken ct);
    Task<int>                                   RegisterTestDbAsync(TCMSRegisterTestDbDTO dto, LoginDTO login, CancellationToken ct);
    Task<int>                                   DeregisterTestDbAsync(int serverConfigId, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<TCMSMServerSelectDTO>>     GetMServerSelectListAsync(CancellationToken ct);

    // ── TTESTENVRESETLOG (TCMS DB via IQueryExecutor) ─────────────────────────
    Task<int>                                   InsertResetLogAsync(TCMSTestEnvResetLogDTO log, LoginDTO login, CancellationToken ct);
    Task                                        UpdateResetLogOutcomeAsync(int logId, int durationMs, bool success, string? errorMessage, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<TCMSTestEnvResetLogDTO>>   GetResetHistoryAsync(int serverConfigId, LoginDTO login, CancellationToken ct);

    // ── DDL on target run-DB server ────────────────────────────────────────────
    Task                                        ExecuteDdlOnTargetServerAsync(string connectionString, string ddlSql, int dbType, CancellationToken ct);

    // ── Snapshot catalog queries (run on target server) ───────────────────────
    Task<IEnumerable<TCMSTestEnvSnapshotListDTO>> GetSnapshotsAsync(string adminConnectionString, string runDbName, int dbType, CancellationToken ct);
}