namespace AutomationDAL.Query.ScriptParam;

public static class ScriptParamQB
{
    public const string INSERT = @"
        INSERT INTO AUTO.TSCRIPTPARAM
               (SCRIPTID, TENANTID, PARAMNAME, PARAMTYPE, ISREQUIRED, DEFAULTVALUE)
        VALUES (@ScriptId, @TenantId, @ParamName, @ParamType, @IsRequired, @DefaultValue);
        SELECT CAST(SCOPE_IDENTITY() AS INT);";

    // Covering index required: IX_TSCRIPTPARAM_SCRIPTID (SCRIPTID, TENANTID)
    public const string GET_BY_SCRIPT = @"
        SELECT PARAMID, SCRIPTID, PARAMNAME, PARAMTYPE, ISREQUIRED, DEFAULTVALUE, TENANTID
        FROM   AUTO.TSCRIPTPARAM
        WHERE  SCRIPTID = @ScriptId
        AND    TENANTID = @TenantId
        ORDER BY PARAMID";

    public const string DELETE = @"
        DELETE FROM AUTO.TSCRIPTPARAM
        WHERE  PARAMID  = @ParamId
        AND    TENANTID = @TenantId";
}