dnet45/modules/dnet-openaire-datasource-manager/trunk/src/main/resources/eu/dnetlib/enabling/datasources/queries/setLastCollectionInfo.sql @ 62470
| 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; |