Project

General

Profile

« Previous | Next » 

Revision 62470

update field first_collection_date

View differences:

modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/setLastCollectionInfo.sql
1 1
UPDATE dsm_api
2 2
SET (last_collection_mdid, last_collection_total, last_collection_date) = (:mdId, :total, :date)
3
WHERE id = :apiId AND service = :dsId
3
WHERE id = :apiId AND service = :dsId;
4

  
5
UPDATE dsm_api
6
SET first_collection_date = :date
7
WHERE id = :apiId AND service = :dsId AND first_collection_date IS NULL;

Also available in: Unified diff