Mercurial > hg > orthanc-databases
view MySQL/Plugins/DeleteResources.sql @ 604:ce2a754600ef find-refactoring
simplification by removing MultipleTags and MultipleMetadata in protobuf
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Mon, 16 Dec 2024 11:25:15 +0100 |
parents | d0dd95ff0662 |
children |
line wrap: on
line source
DROP PROCEDURE IF EXISTS DeleteResources; CREATE PROCEDURE DeleteResources( IN p_id BIGINT ) BEGIN DECLARE v_internalId BIGINT@ DECLARE done INT DEFAULT FALSE@ DECLARE cur1 CURSOR FOR SELECT internalId FROM DeletedResources@ DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = TRUE@ set done=FALSE@ OPEN cur1@ REPEAT FETCH cur1 INTO v_internalId@ IF NOT done THEN DELETE FROM Resources WHERE internalId=v_internalId@ END IF@ UNTIL done END REPEAT@ CLOSE cur1@ END;