using SQLVision.Core.Enums;
using SQLVision.Core.Models;
using System.Data;

namespace SQLVision.Core.Interfaces;

public interface ISqlExecutionService
{
    Task<ExecutionResult> ExecuteAsync(
        ScriptMetadata script,
        Dictionary<string, object> parameters,
        CancellationToken cancellationToken = default);

    Task<ExecutionResult> ExecuteAsync(
        string sql,
        Dictionary<string, object> parameters,
        string connectionString,
        CancellationToken cancellationToken = default);

    Task<bool> TestConnectionAsync(
        string connectionString,
        DatabaseProvider provider,
        CancellationToken cancellationToken = default);

    Task<DataTable> LoadComboBoxDataAsync(
        string query,
        string connectionString,
        DatabaseProvider provider,
        CancellationToken cancellationToken = default);
}