dnet45/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/setLastCollectionInfo.sql @ 62942
1 |
UPDATE dsm_api |
---|---|
2 |
SET (last_collection_mdid, last_collection_total, last_collection_date) = (:mdId, :total, :date) |
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; |