namespace SwDAL.DTO.DmlScript;

// ── DML execution request ──────────────────────────────────────────────────

public class DmlExecutionRequestDTO
{
    /// <summary>Target client database ID to execute against.</summary>
    public int ClientDatabaseId { get; set; }

    /// <summary>Target schema — defaults to "dbo" if empty.</summary>
    public string SchemaName { get; set; } = "dbo";

    /// <summary>Target table name — bracket-quoted before embedding in SQL.</summary>
    public string TableName  { get; set; } = string.Empty;

    /// <summary>Operation: Insert, Update, Delete.</summary>
    public DmlOperation Operation { get; set; }

    /// <summary>Column→value pairs for the row being inserted or updated.</summary>
    public Dictionary<string, object?> RowValues { get; set; } = new();

    /// <summary>Column→value pairs used in WHERE clause (required for Update/Delete).</summary>
    public Dictionary<string, object?> WhereValues { get; set; } = new();
}

public enum DmlOperation : byte { Insert = 0, Update = 1, Delete = 2 }

// ── DML execution result ───────────────────────────────────────────────────

public class DmlExecutionResultDTO
{
    public int    RowsAffected { get; set; }
    public string Message      { get; set; } = string.Empty;
    public bool   Success      { get; set; }
}