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 .jsv suffix or ?format=jsv

HTTP + JSV

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: text/jsv
Content-Type: text/jsv
Content-Length: length

{
	CodigoScript: 0
}

HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

{
	LogScript: 
	[
		{
			CodigoServidor: 0,
			CodigoDetalle: 0,
			CodigoLog: 0,
			CodigoScript: 0,
			SQL: String,
			SQLAnt: String,
			NombreServidor: String,
			Mensaje: String,
			LoginAplica: String,
			Estado: String
		}
	],
	Error: String
}