Revision 62470
Added by Michele Artini over 1 year ago
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
update field first_collection_date