FrameAppWS

EjecutaScriptBDRQ

The following routes are available for this service:
All Verbs	/Utilidades/EjecutaScriptBD

import datetime
import decimal
from marshmallow.fields import *
from servicestack import *
from typing import *
from dataclasses import dataclass, field
from dataclasses_json import dataclass_json, LetterCase, Undefined, config
from enum import Enum, IntEnum


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class LogScriptsBD:
    codigo_servidor: Decimal = decimal.Decimal(0)
    codigo_detalle: Decimal = decimal.Decimal(0)
    codigo_log: Decimal = decimal.Decimal(0)
    codigo_script: Decimal = decimal.Decimal(0)
    sql: Optional[str] = None
    sql_ant: Optional[str] = None
    nombre_servidor: Optional[str] = None
    mensaje: Optional[str] = None
    fecha_ejecucion: datetime.datetime = datetime.datetime(1, 1, 1)
    login_aplica: Optional[str] = None
    estado: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class EjecutaScriptBDRS:
    log_script: Optional[List[LogScriptsBD]] = None
    error: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class EjecutaScriptBDRQ:
    codigo_script: Decimal = decimal.Decimal(0)

Python EjecutaScriptBDRQ DTOs

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /Utilidades/EjecutaScriptBD HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<EjecutaScriptBDRQ xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <CodigoScript>0</CodigoScript>
</EjecutaScriptBDRQ>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<EjecutaScriptBDRS xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <Error>String</Error>
  <LogScript xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Contexto">
    <d2p1:LogScriptsBD>
      <d2p1:CodigoDetalle>0</d2p1:CodigoDetalle>
      <d2p1:CodigoLog>0</d2p1:CodigoLog>
      <d2p1:CodigoScript>0</d2p1:CodigoScript>
      <d2p1:CodigoServidor>0</d2p1:CodigoServidor>
      <d2p1:Estado>String</d2p1:Estado>
      <d2p1:FechaEjecucion>0001-01-01T00:00:00</d2p1:FechaEjecucion>
      <d2p1:LoginAplica>String</d2p1:LoginAplica>
      <d2p1:Mensaje>String</d2p1:Mensaje>
      <d2p1:NombreServidor>String</d2p1:NombreServidor>
      <d2p1:SQL>String</d2p1:SQL>
      <d2p1:SQLAnt>String</d2p1:SQLAnt>
    </d2p1:LogScriptsBD>
  </LogScript>
</EjecutaScriptBDRS>