Notes

<start>
<header>
<id>messinaToPcs</id>
<messageId>41321354032</messageId>
</header>
<source>
<id>polling_catania</id>
<startAt></startAt>
<scheduleTime>5</scheduleTime>
<initialDelay>1</initialDelay>
<oneShot>false</oneShot>
<dataProvider>
<providerClass>eu.dedalus.demos.data.provider.LHADataProvider</providerClass>
<driverClass>oracle.jdbc.driver.OracleDriver</driverClass>
<connectionString>jdbc:oracle:thin:@10.251.123.131:1521/arianna</connectionString>
<username>cce</username>
<password>cce</password>
<timeout>10</timeout>
<query>
<script processor="eu.dedalus.demos.script.generator.VelocityGenerator">
<![CDATA[
SELECT
HDN_CODE AS "lha_code",
HDN_DATE AS "hdn_date",
MODIFYDATE AS "modifydate",
ID AS "id",
LUOGO_ASS_DOM AS "luogo_ass_dom",
MOT_RIC AS "motivo_richiesta",
DIAGN_DIMISS AS "diagnosi_dimissione",
DATA_PRES_DIMISS AS "data_pres_dimiss",
FAM_RIFER AS "fam_rifer",
NUM_TEL_FAM AS "num_tel_fam",
MMG AS "mmg",
CASA_PRIVATA AS "casa_privata",
CASA_PRIVATA_ALTRO AS "casa_privata_altro",
STATO_COSCIENZA AS "stato_coscienza",
RESP_OSS_PRESCRIZIONE AS "resp_oss_prescrizione",
COLLABORANTE AS "collaborante",
DEAMBULANTE AS "deambulante",
ALIMENTAZIONE AS "alimentazione",
ALIMENTAZIONE_ALTRO AS "alimentazione_altro",
CONTINENZA AS "continenza",
CONTINENZA_ALTRO AS "continenza_altro",
CONTINENZA_DATA AS "continenza_data",
CONT_FECALE AS "con_fecale",
STOMIA AS "stomia",
STOMIA_ALTRO AS "stomia_altro",
EVACUAZIONE AS "evacuazione",
EVACUAZIONE_ALTRO AS "evacuazione_altro",
ACC_VENOSO_CENTR_ALTRO AS "acc_venoso_centr_altro",
LESIONI_DECUBITO AS "lesioni_decubito",
LESIONI_SEDE AS "lesioni_sede",
LESIONI_GRADO AS "lesioni_grado",
AUSILI_PROTESI AS "ausili_protesi",
MEDICAZIONI_TIPO AS "medicazioni_tipo",
FREQ_PREVEDIBILE AS "freq_prevedibile",
TERAPIA_PROPOSTA AS "terapia_proposta",
NOTE AS "note",
DATA_DIMISSIONE AS "data_dimissione",
CONTINENZA_DISP AS "continenza_disp",
CONTINENZA_TIPO AS "continenza_tipo",
STR_PROPONENTE AS "str_proponente",
REPARTO AS "reparto",
PAT_CRONICA AS "pat_cronica",
STATO AS "stato",
DATA AS "data",
ACC_ESEGUITI_RIC AS "acc_eseguiti_ric",
ASPETTI_CLINICI_SAN AS "aspetti_clinici_san",
CLASSE_INTENSITA AS "classe_intensita",
CLASSE_NYHA AS "classe_nyha",
ACC_AHA AS "acc_aha",
MED_DIMITTENTE AS "med_dimittente",
RIFTELPAZIENTE AS "riftelpaziente",
RIFTELREPARTO AS "riftelreparto",
TRACE_PUA AS "trace_pua",
ID_STRUTTURA AS "id_struttura",
ID_REPARTO AS "id_reparto",
NUM_TEL_MED_FAM AS "num_tel_med_fam",
DESCRIZIONE_PTA AS "descrizione_pta",
IDPTA_DEST AS "idpta_dest"
FROM PUA_DIMISSIONE_PROTETTA
WHERE CAST(TO_TIMESTAMP(MODIFYDATE, 'DD/MM/YYYY HH24:MI:SS.FF3') AS DATE) > ?
ORDER BY MODIFYDATE
]]>
</script>
<!-- SQL PARAMETER MAPPING -->
<mapping>
</mapping>
</query>
</dataProvider>
</source>
<target>
<id>rest</id>
<url>http://localhost:8080/phaedra/webapi/activity/import</url>
<mediaType>application/json</mediaType>
<sanitize>true</sanitize>
<!-- template vm inglobato nella proprietà sottostante come stringa -->
<script processor="eu.dedalus.demos.script.generator.VelocityGenerator">
<![CDATA[
{
"hdn_date" : "$hdn_date",
"modifydate" : "$modifydate",
"data":"$data"
}
]]>
</script>
<!-- mapping works on apache velocity template engine -->
<mapping>
<field>
<input>lha_code</input>
<output>lha_code</output>
</field>
<field>
<input>hdn_date</input>
<output>hdn_date</output>
</field>
<field>
<input>modifydate</input>
<output>modifydate</output>
</field>
<field>
<input>id</input>
<output>id</output>
</field>
<field>
<input>luogo_ass_dom</input>
<output>luogo_ass_dom</output>
</field>
<field>
<input>motivo_richiesta</input>
<output>motivo_richiesta</output>
</field>
<field>
<input>diagnosi_dimissione</input>
<output>diagnosi_dimissione</output>
</field>
<field>
<input>data_pres_dimiss</input>
<output>data_pres_dimiss</output>
</field>
<field>
<input>fam_rifer</input>
<output>fam_rifer</output>
</field>
<field>
<input>num_tel_fam</input>
<output>num_tel_fam</output>
</field>
<field>
<input>mmg</input>
<output>mmg</output>
</field>
<field>
<input>casa_privata</input>
<output>casa_privata</output>
</field>
<field>
<input>casa_privata_altro</input>
<output>casa_privata_altro</output>
</field>
<field>
<input>stato_coscienza</input>
<output>stato_coscienza</output>
</field>
<field>
<input>resp_oss_prescrizione</input>
<output>resp_oss_prescrizione</output>
</field>
<field>
<input>collaborante</input>
<output>collaborante</output>
</field>
<field>
<input>deambulante</input>
<output>deambulante</output>
</field>
<field>
<input>alimentazione</input>
<output>alimentazione</output>
</field>
<field>
<input>alimentazione_altro</input>
<output>alimentazione_altro</output>
</field>
<field>
<input>continenza</input>
<output>continenza</output>
</field>
<field>
<input>continenza_altro</input>
<output>continenza_altro</output>
</field>
<field>
<input>continenza_data</input>
<output>continenza_data</output>
</field>
<field>
<input>con_fecale</input>
<output>con_fecale</output>
</field>
<field>
<input>stomia</input>
<output>stomia</output>
</field>
<field>
<input>stomia_altro</input>
<output>stomia_altro</output>
</field>
<field>
<input>evacuazione</input>
<output>evacuazione</output>
</field>
<field>
<input>evacuazione_altro</input>
<output>evacuazione_altro</output>
</field>
<field>
<input>acc_venoso_centr_altro</input>
<output>acc_venoso_centr_altro</output>
</field>
<field>
<input>lesioni_decubito</input>
<output>lesioni_decubito</output>
</field>
<field>
<input>lesioni_sede</input>
<output>lesioni_sede</output>
</field>
<field>
<input>lesioni_grado</input>
<output>lesioni_grado</output>
</field>
<field>
<input>ausili_protesi</input>
<output>ausili_protesi</output>
</field>
<field>
<input>medicazioni_tipo</input>
<output>medicazioni_tipo</output>
</field>
<field>
<input>freq_prevedibile</input>
<output>freq_prevedibile</output>
</field>
<field>
<input>terapia_proposta</input>
<output>terapia_proposta</output>
</field>
<field>
<input>note</input>
<output>note</output>
</field>
<field>
<input>data_dimissione</input>
<output>data_dimissione</output>
</field>
<field>
<input>continenza_disp</input>
<output>continenza_disp</output>
</field>
<field>
<input>continenza_tipo</input>
<output>continenza_tipo</output>
</field>
<field>
<input>str_proponente</input>
<output>str_proponente</output>
</field>
<field>
<input>reparto</input>
<output>reparto</output>
</field>
<field>
<input>pat_cronica</input>
<output>pat_cronica</output>
</field>
<field>
<input>stato</input>
<output>stato</output>
</field>
<field>
<input>data</input>
<output>data</output>
</field>
<field>
<input>acc_eseguiti_ric</input>
<output>acc_eseguiti_ric</output>
</field>
<field>
<input>aspetti_clinici_san</input>
<output>aspetti_clinici_san</output>
</field>
<field>
<input>classe_intensita</input>
<output>classe_intensita</output>
</field>
<field>
<input>classe_nyha</input>
<output>classe_nyha</output>
</field>
<field>
<input>acc_aha</input>
<output>acc_aha</output>
</field>
<field>
<input>med_dimittente</input>
<output>med_dimittente</output>
</field>
<field>
<input>riftelpaziente</input>
<output>riftelpaziente</output>
</field>
<field>
<input>riftelreparto</input>
<output>riftelreparto</output>
</field>
<field>
<input>trace_pua</input>
<output>trace_pua</output>
</field>
<field>
<input>id_struttura</input>
<output>id_struttura</output>
</field>
<field>
<input>id_reparto</input>
<output>id_reparto</output>
</field>
<field>
<input>num_tel_med_fam</input>
<output>num_tel_med_fam</output>
</field>
<field>
<input>descrizione_pta</input>
<output>descrizione_pta</output>
</field>
<field>
<input>idpta_dest</input>
<output>idpta_dest</output>
</field>

</mapping>
</target>
</start>