Mercurial > hg > orthanc-databases

comparison PostgreSQL/Plugins/PrepareIndex.sql @ 431:7c1fe5d6c12c pg-transactions

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
PG: IncrementGlobalProperty
author Alain Mazy <am@osimis.io>
date Thu, 07 Dec 2023 12:13:43 +0100
parents a7f0f27fe33c
children 8b7c1c423367
comparison
equal deleted inserted replaced
430:f1f3c5554283 431:7c1fe5d6c12c
132 --RAISE NOTICE 'Delete resource %', old.parentId; 132 --RAISE NOTICE 'Delete resource %', old.parentId;
133 INSERT INTO DeletedResources VALUES (old.resourceType, old.publicId); 133 INSERT INTO DeletedResources VALUES (old.resourceType, old.publicId);
134 134
135 -- http://stackoverflow.com/a/11299968/881731 135 -- http://stackoverflow.com/a/11299968/881731
136 IF EXISTS (SELECT 1 FROM Resources WHERE parentId = old.parentId) THEN 136 IF EXISTS (SELECT 1 FROM Resources WHERE parentId = old.parentId) THEN
137 -- Signal that the deleted resource has a remaining parent 137 -- Signal that the deleted resource has a remaining parent
138 -- (a parent that must not be deleted but whose LastUpdate must be updated)
138 INSERT INTO RemainingAncestor 139 INSERT INTO RemainingAncestor
139 SELECT resourceType, publicId FROM Resources WHERE internalId = old.parentId; 140 SELECT resourceType, publicId FROM Resources WHERE internalId = old.parentId;
140 ELSE 141 ELSE
141 -- Delete a parent resource when its unique child is deleted 142 -- Delete a parent resource when its unique child is deleted
142 DELETE FROM Resources WHERE internalId = old.parentId; 143 DELETE FROM Resources WHERE internalId = old.parentId;