Indice
Gw Scheduler
Scopo
Funzionalità per schedulare facilmente l'esecuzione di codice contenuto in un qualunque file .groovy disponibile nei contenuti statici. Grazie a questo componente si possono schedulare task usando una apposita gwClass di Geoweb in gestione che modella definizioni di schedulazione.
Caratteristiche
- possibilità di definire più di una schedulazione per la stessa istanza di Geoweb, con impostazioni temporali distinte per ciascuna schedulazione.
- schedulazioni facilmente dispiegabili tramite file .groovy
- possibilità di attivare/disattivare la schedulazione da interfaccia utente
- possibilità di modificare i parametri temporali per la schedulazione da interfaccia utente
- le modifiche su attivazione/disattivazione e dei parametri temporali sono applicati istantaneamente
- senza dover riavviare il server od altro
- le esecuzioni di task in corso al momento del cambio parametri/disattivazione finiscono normalmente
Generalità
I trigger applicativi che stanno dietro la gwClass provvederanno a far si che le modifiche vengano applicate istantaneamente. Se si inserisce una schedule definition, con il flag enabled a true, essa verrà subito schedulata, e partirà secondo la configurazione. Se si modifica una schedule definition, le modifiche verranno applicate immediatamente (ma eventuali task attualmente in corso finiranno normalmente). Se si elimina una schedule definition dalla lista dei record della classe, quel task verrà rimosso dalla programmazione (ma eventuali task attualmente in corso finiranno normalmente).
Per Iniziare
- class gw_sched_def Se necessario importarla usando i file .xml della classe o del tema
- aggiungere in un qualche progetto di configurazione questo leafitem
<leafItem name="gw_sched_def_test" label="gw_sched_def test" image="" type="gwClassList"> <parameter name="className" value="gw_sched_def" hideToClient="false"></parameter> </leafItem>
- assicurarsi che nel configuration.properties il flag non sia settato a false
################################################################## # G W S C H E D U L E R ################################################################## #toggle the gwSchedluer execution, optional, default true gwscheduler.enabled=false
Parametri gestiti dalla gwClass
I seguenti parametri sono configurabili e gestibili tramite l'interfaccia dell'apposita gwClass (vedi sotto) Geoweb:
- sched_def_name String, nome della definizione, deve essere univoco o verra lanciata un'eccezione
- script_name String, The .groovy file that will be executed (comprensive of .groovy extention, with the eventual relative path starting form 'WEB/groovy' folder existing in static contents
- enabled Integer, Toggle the script execution
- cron String, Cron Expression [must be of 6 slot]. It has priority on all other values (when provided all other parameters are simply ignored)
- start_time Date, When available it's used to give to execution a start time, maybe combined with period or delay values. if absent execution will start as soon as possible
- delay Integer, Delay after the last execution end (ms)
- period Integer,Period between two consecutive executions start (ms). Has priority over delay
- parameters_json String, this is the JSON string representation of the java.util.Map that will be available as incoming parameter inside the .groovy file, under name 'parameters'
I primi 3 parametri sono richiesti e sono comuni ad ogni definizione. I parametri cron, start_time, delay, period sono opzionali e vanno usati a seconda delle esigenze. Se ne puo impostare solo uno o combinarne due. Ci sono delle priorità nella valutazione di questi parametri.
Ordine di valutazione
- cron Schedule the given {@link Runnable}, invoking it whenever the trigger indicates a next execution time.
- both startTime and period Schedule the given {@link Runnable}, invoking it at the specified execution time and subsequently with the given period.
- both startTime and delay Schedule the given {@link Runnable}, invoking it at the specified execution time and subsequently with the given delay between the completion of one execution and the start of the next.
- only startTime Schedule the given {@link Runnable}, invoking it at the specified execution time. Execution will end once the scheduler shuts down or the returned
- only period Schedule the given {@link Runnable}, starting as soon as possible and invoking it with the given period.
- only delay Schedule the given {@link Runnable}, starting as soon as possible and invoking it with the given delay between the completion of one execution and the start of the next.
Note
La differenza tra period e delay è che il primo considera il tempo che passa tra l'avvio di un task ed il successivo, indipendentemente dal tempo necessario all'esecuzione del task, mentre delay conta il tempo a partire dalla fine della precedente esecuzione.
Casi di utilizzo tipici
Eseguire un task ogni ora:
- settare period con l'equivalente dei ms presenti in un'ora (partirà appena schedulata, con enabled a true)
Eseguire un task ogni ora avendo controllo sulla precisa data di inizio:
- settare period con l'equivalente dei ms presenti in un'ora e start_time all'ora desiderata
Eseguire un task ogni ora con min 0 sec 0
- settare cron cosi: 0 0 0/1 * * *
Class XML
<list> <Class> <className>gw_sched_def</className> <label>Scheduler Definition</label> <description>Scheduler Definition</description> <note>GwClass usata per poter gestire definizioni di schedulazioni. I record inseriti in questa gwClass vengono valutati dal bean Spring GwScheduler durante la sua inizializzazione, che si preoccupa di schedulare l'esecuzione dello script groovy. Il trigger correlato alla gwClass si preoccupa invece di modificare al volo i parametri della schedulazione: attivo/disattivo, cron expression, start time, delay, period. Questo in caso di update, mentre in caso di delete la schedulazione verrà annullata In tutti i casi se una groovy è gia partito la sua esecuzione verrà comunque terminata anche in caso di update/delete della definizione della schedulazione</note> <author>GSC</author> <status>IN USE</status> <useType>STANDARD</useType> <version>1</version> <insertDate>2019-04-19 08:05:34.628 UTC</insertDate> <updateDate>2019-04-19 08:05:34.628 UTC</updateDate> <tableName>gw_sched_def</tableName> <type>0</type> <keyColumn>sched_def_id</keyColumn> <nameColumn>sched_def_name</nameColumn> <geomColumn> </geomColumn> <classOrder>1</classOrder> <hidden>0</hidden> <tableEditName>gw_sched_def</tableEditName> <geomKeyColumn>sched_def_id</geomKeyColumn> <layout>default</layout> <eventTrigger>com.geowebframework.webclient.scheduler.GwSchedDefTrigger</eventTrigger> <actionsList> <Action> <actionCode>standardListSelectedAllAttributeExportToExcel(queryParameter, grid)</actionCode> <name>exl_export_all_attributes</name> <label>Esporta in XLS</label> <description>Esporta tutti gli attributi in XLS</description> <author>GW</author> <version>1</version> <insertDate>2019-04-19 08:05:34.632 UTC</insertDate> <updateDate>2019-04-19 08:05:34.632 UTC</updateDate> <tooltip>Esporta in XLS</tooltip> <typology>1</typology> </Action> </actionsList> <attributeGroupList> <AttributeGroup> <description>main</description> <attributeList> <Attribute> <columnName>sched_def_name</columnName> <label>Schedulation Definition Name</label> <description>Schedulation Definition Name</description> <name>sched_def_name</name> <dataType>STRING</dataType> <listOrder>1</listOrder> <filterOrder>1</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>0</ctrlType> <ctrlParam> <width>250</width> <height>18</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>true</required> <readonly>false</readonly> <scopeName></scopeName> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> </ctrlParam> </Attribute> <Attribute> <columnName>script_name</columnName> <label>Script Name (.groovy file)</label> <description>The .groovy file that will be executed (comprensive of .groovy extention, with the eventual relative path starting form 'WEB/groovy' folder existing in static contents</description> <name>script_name</name> <dataType>STRING</dataType> <listOrder>2</listOrder> <hidden>false</hidden> <filtered>false</filtered> <listed>true</listed> <ctrlType>0</ctrlType> <ctrlParam> <width>250</width> <height>18</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>true</required> <readonly>false</readonly> <scopeName></scopeName> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> </ctrlParam> </Attribute> <Attribute> <columnName>enabled</columnName> <label>Enabled</label> <description>Toggle the script execution</description> <name>enabled</name> <dataType>INTEGER</dataType> <listOrder>3</listOrder> <filterOrder>2</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>6</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.CheckBox"> <width>250</width> <defaultValue>checked</defaultValue> <required>true</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <handleThreeState>false</handleThreeState> <typeValue>1/0</typeValue> <labels>Yes/No</labels> </ctrlParam> </Attribute> <Attribute> <columnName>cron</columnName> <label>Cron Expression (6 digit)</label> <description>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek. It has priority on all other values (when provided all other parameters are simply ignored)</description> <name>cron</name> <dataType>STRING</dataType> <listOrder>4</listOrder> <filterOrder>4</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>1</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.TextBox"> <width>250</width> <height>18</height> <listWidth>140</listWidth> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <disabled>false</disabled> <hideRelations>false</hideRelations> <intermediateChanges>false</intermediateChanges> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <regExp></regExp> <regExpGen></regExpGen> <placeHolder>6 digit cron expressions</placeHolder> <promptMessage>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek</promptMessage> <invalidMessage>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek</invalidMessage> <missingMessage>A valid 6 digit cron expressions is required</missingMessage> <trim>true</trim> <lowercase>false</lowercase> <uppercase>false</uppercase> <propercase>false</propercase> </ctrlParam> </Attribute> <Attribute> <columnName>human_readable_cron</columnName> <label>Human Readable Cron Expression</label> <description>Human Readable Cron Expression</description> <name>human_readable_cron</name> <dataType>STRING</dataType> <filterOrder>3</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>false</listed> <ctrlType>16</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Textarea"> <width>250</width> <height>40</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>true</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <DEFAULT__NUMROWS>0</DEFAULT__NUMROWS> <DEFAULT__NUMCOLS>0</DEFAULT__NUMCOLS> <DEFAULT__TYPE>0</DEFAULT__TYPE> <DEFAULT__MIN__WIDTH>0</DEFAULT__MIN__WIDTH> <DEFAULT__MAX__WIDTH>0</DEFAULT__MAX__WIDTH> <DEFAULT__MIN__HEIGHT>0</DEFAULT__MIN__HEIGHT> <DEFAULT__MAX__HEIGHT>0</DEFAULT__MAX__HEIGHT> <numRows>5</numRows> <numCols>50</numCols> <type>0</type> <maxWidth>250</maxWidth> <maxHeight>200</maxHeight> </ctrlParam> </Attribute> <Attribute> <columnName>start_time</columnName> <label>Start Time</label> <description>When available it's used to give to execution a start time, maybe combined with period or delay values. if absent execution will start as soon as possible</description> <name>start_time</name> <dataType>DATE</dataType> <listOrder>5</listOrder> <filterOrder>5</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>5</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Date"> <width>250</width> <listWidth>120</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <format>dd-MM-yyyy</format> <formatTime>HH:mm:ss</formatTime> <handleTime>true</handleTime> </ctrlParam> </Attribute> <Attribute> <columnName>delay</columnName> <label>Delay (ms)</label> <description>Delay after the last execution end (ms)</description> <name>delay</name> <dataType>INTEGER</dataType> <listOrder>7</listOrder> <filterOrder>7</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <listWidth>100</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> <Attribute> <columnName>period</columnName> <label>Period (ms)</label> <description>Period between two consecutive executions start (ms). Has priority over delay</description> <name>period</name> <dataType>INTEGER</dataType> <listOrder>6</listOrder> <filterOrder>6</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <listWidth>100</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> <Attribute> <columnName>parameters_json</columnName> <label>Parameters Json</label> <description>This is the JSON string representation of the java.util.Map that will be available as incoming parameter inside the .groovy file, under name 'parameters'</description> <name>parameters_json</name> <dataType>STRING</dataType> <hidden>false</hidden> <filtered>false</filtered> <listed>false</listed> <ctrlType>16</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Textarea"> <width>250</width> <height>40</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <disabled>false</disabled> <hideRelations>false</hideRelations> <intermediateChanges>false</intermediateChanges> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <DEFAULT__NUMROWS>0</DEFAULT__NUMROWS> <DEFAULT__NUMCOLS>0</DEFAULT__NUMCOLS> <DEFAULT__TYPE>0</DEFAULT__TYPE> <DEFAULT__MIN__WIDTH>0</DEFAULT__MIN__WIDTH> <DEFAULT__MAX__WIDTH>0</DEFAULT__MAX__WIDTH> <DEFAULT__MIN__HEIGHT>0</DEFAULT__MIN__HEIGHT> <DEFAULT__MAX__HEIGHT>0</DEFAULT__MAX__HEIGHT> <numRows>5</numRows> <numCols>50</numCols> <type>0</type> <maxWidth>250</maxWidth> <maxHeight>200</maxHeight> </ctrlParam> </Attribute> </attributeList> </AttributeGroup> </attributeGroupList> <attributesWithNoGroupList> <Attribute> <columnName>sched_def_id</columnName> <label>Schedulation Definition ID</label> <description>Schedulation Definition ID</description> <name>sched_def_id</name> <dataType>INTEGER</dataType> <filtered>false</filtered> <listed>false</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> </attributesWithNoGroupList> <detailLayoutsList> <DetailLayout> <name>default</name> <layout class="ContainerNode" type="ContentPane" width="500" widthUOM="px" height="450" heightUOM="px" title="main" startSelectedInParent="false" attributeGroup="main"/> </DetailLayout> </detailLayoutsList> <hasDynamicAcl>false</hasDynamicAcl> <gwVersion>4.4.0</gwVersion> </Class> </list>
Theme XML
<list> <Theme> <name>GW - Scheduler</name> <description>GW - Scheduler</description> <hidden>0</hidden> <classesList> <Class> <className>gw_sched_def</className> <label>Scheduler Definition</label> <description>Scheduler Definition</description> <note>GwClass usata per poter gestire definizioni di schedulazioni. I record inseriti in questa gwClass vengono valutati dal bean Spring GwScheduler durante la sua inizializzazione, che si preoccupa di schedulare l'esecuzione dello script groovy. Il trigger correlato alla gwClass si preoccupa invece di modificare al volo i parametri della schedulazione: attivo/disattivo, cron expression, start time, delay, period. Questo in caso di update, mentre in caso di delete la schedulazione verrà annullata In tutti i casi se una groovy è gia partito la sua esecuzione verrà comunque terminata anche in caso di update/delete della definizione della schedulazione</note> <author>GSC</author> <status>IN USE</status> <useType>STANDARD</useType> <version>1</version> <insertDate>2019-04-19 08:05:34.628 UTC</insertDate> <updateDate>2019-04-19 08:05:34.628 UTC</updateDate> <tableName>gw_sched_def</tableName> <type>0</type> <keyColumn>sched_def_id</keyColumn> <nameColumn>sched_def_name</nameColumn> <geomColumn> </geomColumn> <classOrder>1</classOrder> <hidden>0</hidden> <tableEditName>gw_sched_def</tableEditName> <geomKeyColumn>sched_def_id</geomKeyColumn> <layout>default</layout> <eventTrigger>com.geowebframework.webclient.scheduler.GwSchedDefTrigger</eventTrigger> <actionsList> <Action> <actionCode>standardListSelectedAllAttributeExportToExcel(queryParameter, grid)</actionCode> <name>exl_export_all_attributes</name> <label>Esporta in XLS</label> <description>Esporta tutti gli attributi in XLS</description> <author>GW</author> <version>1</version> <insertDate>2019-04-19 08:05:34.632 UTC</insertDate> <updateDate>2019-04-19 08:05:34.632 UTC</updateDate> <tooltip>Esporta in XLS</tooltip> <typology>1</typology> </Action> </actionsList> <attributeGroupList> <AttributeGroup> <description>main</description> <attributeList> <Attribute> <columnName>sched_def_name</columnName> <label>Schedulation Definition Name</label> <description>Schedulation Definition Name</description> <name>sched_def_name</name> <dataType>STRING</dataType> <listOrder>1</listOrder> <filterOrder>1</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>0</ctrlType> <ctrlParam> <width>250</width> <height>18</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>true</required> <readonly>false</readonly> <scopeName></scopeName> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> </ctrlParam> </Attribute> <Attribute> <columnName>script_name</columnName> <label>Script Name (.groovy file)</label> <description>The .groovy file that will be executed (comprensive of .groovy extention, with the eventual relative path starting form 'WEB/groovy' folder existing in static contents</description> <name>script_name</name> <dataType>STRING</dataType> <listOrder>2</listOrder> <hidden>false</hidden> <filtered>false</filtered> <listed>true</listed> <ctrlType>0</ctrlType> <ctrlParam> <width>250</width> <height>18</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>true</required> <readonly>false</readonly> <scopeName></scopeName> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> </ctrlParam> </Attribute> <Attribute> <columnName>enabled</columnName> <label>Enabled</label> <description>Toggle the script execution</description> <name>enabled</name> <dataType>INTEGER</dataType> <listOrder>3</listOrder> <filterOrder>2</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>6</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.CheckBox"> <width>250</width> <defaultValue>checked</defaultValue> <required>true</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <handleThreeState>false</handleThreeState> <typeValue>1/0</typeValue> <labels>Yes/No</labels> </ctrlParam> </Attribute> <Attribute> <columnName>cron</columnName> <label>Cron Expression (6 digit)</label> <description>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek. It has priority on all other values (when provided all other parameters are simply ignored)</description> <name>cron</name> <dataType>STRING</dataType> <listOrder>4</listOrder> <filterOrder>4</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>1</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.TextBox"> <width>250</width> <height>18</height> <listWidth>140</listWidth> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <disabled>false</disabled> <hideRelations>false</hideRelations> <intermediateChanges>false</intermediateChanges> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <regExp></regExp> <regExpGen></regExpGen> <placeHolder>6 digit cron expressions</placeHolder> <promptMessage>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek</promptMessage> <invalidMessage>Cron expression must consist of 6 fields: seconds, minutes, hours, daysOfMonth, months, daysOfWeek</invalidMessage> <missingMessage>A valid 6 digit cron expressions is required</missingMessage> <trim>true</trim> <lowercase>false</lowercase> <uppercase>false</uppercase> <propercase>false</propercase> </ctrlParam> </Attribute> <Attribute> <columnName>human_readable_cron</columnName> <label>Human Readable Cron Expression</label> <description>Human Readable Cron Expression</description> <name>human_readable_cron</name> <dataType>STRING</dataType> <filterOrder>3</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>false</listed> <ctrlType>16</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Textarea"> <width>250</width> <height>40</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>true</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <DEFAULT__NUMROWS>0</DEFAULT__NUMROWS> <DEFAULT__NUMCOLS>0</DEFAULT__NUMCOLS> <DEFAULT__TYPE>0</DEFAULT__TYPE> <DEFAULT__MIN__WIDTH>0</DEFAULT__MIN__WIDTH> <DEFAULT__MAX__WIDTH>0</DEFAULT__MAX__WIDTH> <DEFAULT__MIN__HEIGHT>0</DEFAULT__MIN__HEIGHT> <DEFAULT__MAX__HEIGHT>0</DEFAULT__MAX__HEIGHT> <numRows>5</numRows> <numCols>50</numCols> <type>0</type> <maxWidth>250</maxWidth> <maxHeight>200</maxHeight> </ctrlParam> </Attribute> <Attribute> <columnName>start_time</columnName> <label>Start Time</label> <description>When available it's used to give to execution a start time, maybe combined with period or delay values. if absent execution will start as soon as possible</description> <name>start_time</name> <dataType>DATE</dataType> <listOrder>5</listOrder> <filterOrder>5</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>5</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Date"> <width>250</width> <listWidth>120</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <format>dd-MM-yyyy</format> <formatTime>HH:mm:ss</formatTime> <handleTime>true</handleTime> </ctrlParam> </Attribute> <Attribute> <columnName>delay</columnName> <label>Delay (ms)</label> <description>Delay after the last execution end (ms)</description> <name>delay</name> <dataType>INTEGER</dataType> <listOrder>7</listOrder> <filterOrder>7</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <listWidth>100</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> <Attribute> <columnName>period</columnName> <label>Period (ms)</label> <description>Period between two consecutive executions start (ms). Has priority over delay</description> <name>period</name> <dataType>INTEGER</dataType> <listOrder>6</listOrder> <filterOrder>6</filterOrder> <hidden>false</hidden> <filtered>true</filtered> <listed>true</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <listWidth>100</listWidth> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> <Attribute> <columnName>parameters_json</columnName> <label>Parameters Json</label> <description>This is the JSON string representation of the java.util.Map that will be available as incoming parameter inside the .groovy file, under name 'parameters'</description> <name>parameters_json</name> <dataType>STRING</dataType> <hidden>false</hidden> <filtered>false</filtered> <listed>false</listed> <ctrlType>16</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.Textarea"> <width>250</width> <height>40</height> <maxLength>255</maxLength> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <disabled>false</disabled> <hideRelations>false</hideRelations> <intermediateChanges>false</intermediateChanges> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <DEFAULT__NUMROWS>0</DEFAULT__NUMROWS> <DEFAULT__NUMCOLS>0</DEFAULT__NUMCOLS> <DEFAULT__TYPE>0</DEFAULT__TYPE> <DEFAULT__MIN__WIDTH>0</DEFAULT__MIN__WIDTH> <DEFAULT__MAX__WIDTH>0</DEFAULT__MAX__WIDTH> <DEFAULT__MIN__HEIGHT>0</DEFAULT__MIN__HEIGHT> <DEFAULT__MAX__HEIGHT>0</DEFAULT__MAX__HEIGHT> <numRows>5</numRows> <numCols>50</numCols> <type>0</type> <maxWidth>250</maxWidth> <maxHeight>200</maxHeight> </ctrlParam> </Attribute> </attributeList> </AttributeGroup> </attributeGroupList> <attributesWithNoGroupList> <Attribute> <columnName>sched_def_id</columnName> <label>Schedulation Definition ID</label> <description>Schedulation Definition ID</description> <name>sched_def_id</name> <dataType>INTEGER</dataType> <filtered>false</filtered> <listed>false</listed> <ctrlType>25</ctrlType> <ctrlParam class="com.geowebframework.transfer.model.widget.NumberBox"> <width>250</width> <height>18</height> <defaultValue></defaultValue> <required>false</required> <readonly>false</readonly> <isDefaultOrderBy>true</isDefaultOrderBy> <isDefaultOrderByAscending>true</isDefaultOrderByAscending> <isDefaultOrderByOnFieldToShow>true</isDefaultOrderByOnFieldToShow> <listCellTextAlign></listCellTextAlign> <listCellStyleRules></listCellStyleRules> <listCellClass></listCellClass> <listCellHeaderStyleRules></listCellHeaderStyleRules> <importCSVWithoutDecoding>false</importCSVWithoutDecoding> <numberFormatType>NUMBER</numberFormatType> <pattern>#.</pattern> <min>0.0</min> <max>1.7976931348623157E308</max> <currencyCode>EUR</currencyCode> </ctrlParam> </Attribute> </attributesWithNoGroupList> <detailLayoutsList> <DetailLayout> <name>default</name> <layout class="ContainerNode" type="ContentPane" width="500" widthUOM="px" height="450" heightUOM="px" title="main" startSelectedInParent="false" attributeGroup="main"/> </DetailLayout> </detailLayoutsList> <hasDynamicAcl>false</hasDynamicAcl> </Class> </classesList> <gwVersion>4.4.0</gwVersion> </Theme> </list>
SCRIPT
Oracle
CREATE TABLE "SCHEMA_NAME"."GW_SCHED_DEF" ( "SCHED_DEF_ID" NUMBER(*,0) NOT NULL ENABLE, "SCHED_DEF_NAME" VARCHAR2(250 BYTE), "CRON" VARCHAR2(4000 BYTE), "HUMAN_READABLE_CRON" VARCHAR2(4000 BYTE), "START_TIME" DATE, "DELAY" NUMBER(38,0), "PERIOD" NUMBER(38,0), "SCRIPT_NAME" VARCHAR2(250 BYTE), "PARAMETERS_JSON" VARCHAR2(4000 BYTE), "ENABLED" NUMBER(1,0), CONSTRAINT "GW_SCHED_DEF_PK" PRIMARY KEY ("SCHED_DEF_ID"), CONSTRAINT "GW_SCHED_DEF_UK" UNIQUE ("SCHED_DEF_NAME") );
Postgres
CREATE TABLE gw_sched_def ( sched_def_id INTEGER NOT NULL, sched_def_name CHARACTER VARYING, script_name CHARACTER VARYING, enabled INTEGER, cron CHARACTER VARYING, human_readable_cron CHARACTER VARYING, start_time TIMESTAMP WITHOUT TIME zone, delay BIGINT, period BIGINT, parameters_json CHARACTER VARYING, CONSTRAINT gw_sched_def_pk PRIMARY KEY (sched_def_id), CONSTRAINT gw_sched_def_uk UNIQUE (sched_def_name) ) WITH ( OIDS=FALSE ); ALTER TABLE gw_sched_def OWNER TO "AEC";
SqlServer
TODO ADD