// =============================================================================
// GB5 Framework — ReportServerConfigDTO
// Namespace : GB5Shared.DTO.ReportOrchestration
// Purpose   : Lightweight resolved configuration for a single database target.
//             Populated by IReportConnectionResolver from MSERVERCONFIG rows.
//             Never contains plaintext passwords in transit — only used
//             server-side within the connection resolver.
// =============================================================================

using GB5Shared.Enums.ReportOrchestration;

namespace GB5Shared.DTO.ReportOrchestration
{
    /// <summary>
    /// Resolved database server configuration for one DataSourceType.
    /// Built from MSERVERCONFIG by <see cref="IReportConnectionResolver"/>.
    /// One instance per DataSourceType (OLTP / ReportDB / ArchiveDB).
    /// </summary>
    public sealed class ReportServerConfigDTO
    {
        /// <summary>
        /// The MSERVERCONFIG.SERVERCONFIGID for this database target.
        /// -1 indicates no separate config exists; fall back to OLTP.
        /// </summary>
        public int ServerConfigId { get; init; }

        /// <summary>
        /// The RDBMS provider type. Drives which IDbConnection is instantiated.
        /// Sourced from MSERVERCONFIG.DATABASETYPE.
        /// </summary>
        public DatabaseProviderType ProviderType { get; init; }

        /// <summary>
        /// Fully formed connection string for this database target.
        /// Built by the resolver from MSERVERCONFIG fields.
        /// Never logged, never serialised to client.
        /// </summary>
        public string ConnectionString { get; init; } = string.Empty;

        /// <summary>
        /// The physical database/catalog name.
        /// Sourced from MSERVERCONFIG.DATABASENAME.
        /// </summary>
        public string DatabaseName { get; init; } = string.Empty;

        /// <summary>
        /// Whether this config is a genuine separate DB or a fallback
        /// to the OLTP connection (when REPORTSERVERCONFIGID /
        /// ARCHIVESERVERCONFIGID = -1).
        /// When true, NOLOCK hints and read-optimised settings are applied.
        /// </summary>
        public bool IsDedicatedAnalyticsDb { get; init; }

        /// <summary>
        /// The DataSourceType this config was resolved for.
        /// Used for diagnostic logging.
        /// </summary>
        public DataSourceType ResolvedDataSource { get; init; }
    }
}