FrameAppWS

EjecutaScriptBDRQ

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

<?php namespace dtos;

use DateTime;
use Exception;
use DateInterval;
use JsonSerializable;
use ServiceStack\{IReturn,IReturnVoid,IGet,IPost,IPut,IDelete,IPatch,IMeta,IHasSessionId,IHasBearerToken,IHasVersion};
use ServiceStack\{ICrud,ICreateDb,IUpdateDb,IPatchDb,IDeleteDb,ISaveDb,AuditBase,QueryDb,QueryDb2,QueryData,QueryData2,QueryResponse};
use ServiceStack\{ResponseStatus,ResponseError,EmptyResponse,IdResponse,ArrayList,KeyValuePair2,StringResponse,StringsResponse,Tuple2,Tuple3,ByteArray};
use ServiceStack\{JsonConverters,Returns,TypeContext};


// @DataContract
class LogScriptsBD implements JsonSerializable
{
    public function __construct(
        // @DataMember
        /** @var float */
        public float $CodigoServidor=0.0,

        // @DataMember
        /** @var float */
        public float $CodigoDetalle=0.0,

        // @DataMember
        /** @var float */
        public float $CodigoLog=0.0,

        // @DataMember
        /** @var float */
        public float $CodigoScript=0.0,

        // @DataMember
        /** @var string|null */
        public ?string $SQL=null,

        // @DataMember
        /** @var string|null */
        public ?string $SQLAnt=null,

        // @DataMember
        /** @var string|null */
        public ?string $NombreServidor=null,

        // @DataMember
        /** @var string|null */
        public ?string $Mensaje=null,

        // @DataMember
        /** @var DateTime */
        public DateTime $FechaEjecucion=new DateTime(),

        // @DataMember
        /** @var string|null */
        public ?string $LoginAplica=null,

        // @DataMember
        /** @var string|null */
        public ?string $Estado=null
    ) {
    }

    /** @throws Exception */
    public function fromMap($o): void {
        if (isset($o['CodigoServidor'])) $this->CodigoServidor = $o['CodigoServidor'];
        if (isset($o['CodigoDetalle'])) $this->CodigoDetalle = $o['CodigoDetalle'];
        if (isset($o['CodigoLog'])) $this->CodigoLog = $o['CodigoLog'];
        if (isset($o['CodigoScript'])) $this->CodigoScript = $o['CodigoScript'];
        if (isset($o['SQL'])) $this->SQL = $o['SQL'];
        if (isset($o['SQLAnt'])) $this->SQLAnt = $o['SQLAnt'];
        if (isset($o['NombreServidor'])) $this->NombreServidor = $o['NombreServidor'];
        if (isset($o['Mensaje'])) $this->Mensaje = $o['Mensaje'];
        if (isset($o['FechaEjecucion'])) $this->FechaEjecucion = JsonConverters::from('DateTime', $o['FechaEjecucion']);
        if (isset($o['LoginAplica'])) $this->LoginAplica = $o['LoginAplica'];
        if (isset($o['Estado'])) $this->Estado = $o['Estado'];
    }
    
    /** @throws Exception */
    public function jsonSerialize(): mixed
    {
        $o = [];
        if (isset($this->CodigoServidor)) $o['CodigoServidor'] = $this->CodigoServidor;
        if (isset($this->CodigoDetalle)) $o['CodigoDetalle'] = $this->CodigoDetalle;
        if (isset($this->CodigoLog)) $o['CodigoLog'] = $this->CodigoLog;
        if (isset($this->CodigoScript)) $o['CodigoScript'] = $this->CodigoScript;
        if (isset($this->SQL)) $o['SQL'] = $this->SQL;
        if (isset($this->SQLAnt)) $o['SQLAnt'] = $this->SQLAnt;
        if (isset($this->NombreServidor)) $o['NombreServidor'] = $this->NombreServidor;
        if (isset($this->Mensaje)) $o['Mensaje'] = $this->Mensaje;
        if (isset($this->FechaEjecucion)) $o['FechaEjecucion'] = JsonConverters::to('DateTime', $this->FechaEjecucion);
        if (isset($this->LoginAplica)) $o['LoginAplica'] = $this->LoginAplica;
        if (isset($this->Estado)) $o['Estado'] = $this->Estado;
        return empty($o) ? new class(){} : $o;
    }
}

class EjecutaScriptBDRS implements JsonSerializable
{
    public function __construct(
        /** @var array<LogScriptsBD>|null */
        public ?array $LogScript=null,
        /** @var string|null */
        public ?string $Error=null
    ) {
    }

    /** @throws Exception */
    public function fromMap($o): void {
        if (isset($o['LogScript'])) $this->LogScript = JsonConverters::fromArray('LogScriptsBD', $o['LogScript']);
        if (isset($o['Error'])) $this->Error = $o['Error'];
    }
    
    /** @throws Exception */
    public function jsonSerialize(): mixed
    {
        $o = [];
        if (isset($this->LogScript)) $o['LogScript'] = JsonConverters::toArray('LogScriptsBD', $this->LogScript);
        if (isset($this->Error)) $o['Error'] = $this->Error;
        return empty($o) ? new class(){} : $o;
    }
}

class EjecutaScriptBDRQ implements JsonSerializable
{
    public function __construct(
        /** @var float */
        public float $CodigoScript=0.0
    ) {
    }

    /** @throws Exception */
    public function fromMap($o): void {
        if (isset($o['CodigoScript'])) $this->CodigoScript = $o['CodigoScript'];
    }
    
    /** @throws Exception */
    public function jsonSerialize(): mixed
    {
        $o = [];
        if (isset($this->CodigoScript)) $o['CodigoScript'] = $this->CodigoScript;
        return empty($o) ? new class(){} : $o;
    }
}

PHP EjecutaScriptBDRQ DTOs

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

HTTP + OTHER

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

{"CodigoScript":0}

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

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