Project

General

Profile

« Previous | Next » 

Revision 58973

Added by Alessia Bardi almost 4 years ago

Added node to change the last update date of the stats

View differences:

modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/test/profiles/openaireplus/workflows/dm/update-info-date.xml
43 43 
			</ARCS>
44 44 
		</NODE>
45 45 
			<NODE name="UpdateLastIISDate" type="ExecuteSql">
46 
				<DESCRIPTION>update the last claim load date</DESCRIPTION>
46 
				<DESCRIPTION>update the last inference date</DESCRIPTION>
47 47 
				<PARAMETERS>
48 48 
					<PARAM required="true" type="boolean" name="sqlInClasspath" managedBy="system">false</PARAM>
49 49 
					<PARAM name="dbProperty" type="string" managedBy="system" required="true">dnet.openaire.db.name</PARAM>
......
81 81 
				</PARAMETERS>
82 82 
				<ARCS>
83 83 
					<ARC name="YES" to="UpdateODFLoadDate"/>
84 
					<ARC name="NO" to="success"/>
84 
					<ARC name="NO" to="SELECT_STATS_DATE"/>
85 85 
				</ARCS>
86 86 
			</NODE>
87 87 
			<NODE name="UpdateODFLoadDate" type="ExecuteSql">
......
92 92 
					<PARAM name="sql" type="string" managedBy="user" required="true">UPDATE info SET value='YYYY-mm-dd' WHERE key='odf_load_date';</PARAM>
93 93 
				</PARAMETERS>
94 94 
				<ARCS>
95 
					<ARC to="SELECT_STATS_DATE"/>
96 
				</ARCS>
97 
			</NODE>
98 
			<NODE name="SELECT_STATS_DATE" type="Selection">
99 
				<DESCRIPTION>Do we update the last stats update date?</DESCRIPTION>
100 
				<PARAMETERS>
101 
					<PARAM function="validValues(['YES', 'NO'])" managedBy="user" name="selection" required="true" type="string">YES</PARAM>
102 
				</PARAMETERS>
103 
				<ARCS>
104 
					<ARC name="YES" to="UpdateStatsDate"/>
105 
					<ARC name="NO" to="success"/>
106 
				</ARCS>
107 
			</NODE>
108 
			<NODE name="UpdateStatsDate" type="ExecuteSql">
109 
				<DESCRIPTION>update the last stats update date</DESCRIPTION>
110 
				<PARAMETERS>
111 
					<PARAM required="true" type="boolean" name="sqlInClasspath" managedBy="system">false</PARAM>
112 
					<PARAM name="dbProperty" type="string" managedBy="system" required="true">dnet.openaire.db.name</PARAM>
113 
					<PARAM name="sql" type="string" managedBy="user" required="true">UPDATE info SET value='YYYY-mm-dd' WHERE key='stats_update_date';</PARAM>
114 
				</PARAMETERS>
115 
				<ARCS>
95 116 
					<ARC to="success"/>
96 117 
				</ARCS>
97 118 
			</NODE>

Also available in: Unified diff