Project

General

Profile

« Previous | Next » 

Revision 60996

Updated info workflow to also set the last update date of the sources of DOIBoost

View differences:

modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/test/profiles/openaireplus/workflows/dm/update-info-date.xml
102 102
				</PARAMETERS>
103 103
				<ARCS>
104 104
					<ARC name="YES" to="UpdateStatsDate"/>
105
					<ARC name="NO" to="success"/>
105
					<ARC name="NO" to="SELECT_CROSSREF_DATE"/>
106 106
				</ARCS>
107 107
			</NODE>
108 108
			<NODE name="UpdateStatsDate" type="ExecuteSql">
......
113 113
					<PARAM name="sql" type="string" managedBy="user" required="true">UPDATE info SET value='YYYY-mm-dd' WHERE key='stats_update_date';</PARAM>
114 114
				</PARAMETERS>
115 115
				<ARCS>
116
					<ARC to="SELECT_CROSSREF_DATE"/>
117
				</ARCS>
118
			</NODE>
119
			<NODE name="SELECT_CROSSREF_DATE" type="Selection">
120
				<DESCRIPTION>Do we update the last update date of Crossref?</DESCRIPTION>
121
				<PARAMETERS>
122
					<PARAM function="validValues(['YES', 'NO'])" managedBy="user" name="selection" required="true" type="string">YES</PARAM>
123
				</PARAMETERS>
124
				<ARCS>
125
					<ARC name="YES" to="UpdateCrossrefDate"/>
126
					<ARC name="NO" to="SELECT_ORCID_DATE"/>
127
				</ARCS>
128
			</NODE>
129
			<NODE name="UpdateCrossrefDate" type="ExecuteSql">
130
				<DESCRIPTION>update the last update date of Crossref</DESCRIPTION>
131
				<PARAMETERS>
132
					<PARAM required="true" type="boolean" name="sqlInClasspath" managedBy="system">false</PARAM>
133
					<PARAM name="dbProperty" type="string" managedBy="system" required="true">dnet.openaire.db.name</PARAM>
134
					<PARAM name="sql" type="string" managedBy="user" required="true">UPDATE info SET value='YYYY-mm-dd' WHERE key='crossref_update_date';</PARAM>
135
				</PARAMETERS>
136
				<ARCS>
137
					<ARC to="SELECT_ORCID_DATE"/>
138
				</ARCS>
139
			</NODE>
140
			<NODE name="SELECT_ORCID_DATE" type="Selection" isStart="true">
141
				<DESCRIPTION>Do we update the last update date of ORCID?</DESCRIPTION>
142
				<PARAMETERS>
143
					<PARAM function="validValues(['YES', 'NO'])" managedBy="user" name="selection" required="true" type="string">YES</PARAM>
144
				</PARAMETERS>
145
				<ARCS>
146
					<ARC name="YES" to="UpdateOrcidDate"/>
147
					<ARC name="NO" to="SELECT_UNPAYWALL_DATE"/>
148
				</ARCS>
149
			</NODE>
150
			<NODE name="UpdateOrcidDate" type="ExecuteSql">
151
				<DESCRIPTION>update the last update date of ORCID</DESCRIPTION>
152
				<PARAMETERS>
153
					<PARAM required="true" type="boolean" name="sqlInClasspath" managedBy="system">false</PARAM>
154
					<PARAM name="dbProperty" type="string" managedBy="system" required="true">dnet.openaire.db.name</PARAM>
155
					<PARAM name="sql" type="string" managedBy="user" required="true">UPDATE info SET value='YYYY-mm-dd' WHERE key='orcid_update_date';</PARAM>
156
				</PARAMETERS>
157
				<ARCS>
158
					<ARC to="SELECT_UNPAYWALL_DATE"/>
159
				</ARCS>
160
			</NODE>
161
			<NODE name="SELECT_UNPAYWALL_DATE" type="Selection" isStart="true">
162
				<DESCRIPTION>Do we update the last update date of Unpaywall?</DESCRIPTION>
163
				<PARAMETERS>
164
					<PARAM function="validValues(['YES', 'NO'])" managedBy="user" name="selection" required="true" type="string">YES</PARAM>
165
				</PARAMETERS>
166
				<ARCS>
167
					<ARC name="YES" to="UpdateUnpaywallDate"/>
168
					<ARC name="NO" to="SELECT_MAG_DATE"/>
169
				</ARCS>
170
			</NODE>
171
			<NODE name="UpdateUnpaywallDate" type="ExecuteSql">
172
				<DESCRIPTION>update the last update date of Unpaywall</DESCRIPTION>
173
				<PARAMETERS>
174
					<PARAM required="true" type="boolean" name="sqlInClasspath" managedBy="system">false</PARAM>
175
					<PARAM name="dbProperty" type="string" managedBy="system" required="true">dnet.openaire.db.name</PARAM>
176
					<PARAM name="sql" type="string" managedBy="user" required="true">UPDATE info SET value='YYYY-mm-dd' WHERE key='unpaywall_update_date';</PARAM>
177
				</PARAMETERS>
178
				<ARCS>
179
					<ARC to="SELECT_MAG_DATE"/>
180
				</ARCS>
181
			</NODE>
182
			<NODE name="SELECT_MAG_DATE" type="Selection" isStart="true">
183
				<DESCRIPTION>Do we update the last update date of Microsoft Academic Graph?</DESCRIPTION>
184
				<PARAMETERS>
185
					<PARAM function="validValues(['YES', 'NO'])" managedBy="user" name="selection" required="true" type="string">YES</PARAM>
186
				</PARAMETERS>
187
				<ARCS>
188
					<ARC name="YES" to="UpdateMAGDate"/>
189
					<ARC name="NO" to="success"/>
190
				</ARCS>
191
			</NODE>
192
			<NODE name="UpdateMAGDate" type="ExecuteSql">
193
				<DESCRIPTION>update the last update date of Microsoft Academic Graph</DESCRIPTION>
194
				<PARAMETERS>
195
					<PARAM required="true" type="boolean" name="sqlInClasspath" managedBy="system">false</PARAM>
196
					<PARAM name="dbProperty" type="string" managedBy="system" required="true">dnet.openaire.db.name</PARAM>
197
					<PARAM name="sql" type="string" managedBy="user" required="true">UPDATE info SET value='YYYY-mm-dd' WHERE key='mag_update_date';</PARAM>
198
				</PARAMETERS>
199
				<ARCS>
116 200
					<ARC to="success"/>
117 201
				</ARCS>
118 202
			</NODE>

Also available in: Unified diff