Mercurial > hg > orthanc-databases

comparison PostgreSQL/Plugins/SQL/PrepareIndexV2.sql @ 438:f790232b77ef pg-transactions

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
fix InsertOrUpdateMetadata
author Alain Mazy <am@osimis.io>
date Mon, 18 Dec 2023 19:17:09 +0100
parents d979f25e60cf
children 2a48f8fcec6e
comparison
equal deleted inserted replaced
437:d979f25e60cf 438:f790232b77ef
451 revisions INTEGER[]) 451 revisions INTEGER[])
452 RETURNS VOID AS $body$ 452 RETURNS VOID AS $body$
453 BEGIN 453 BEGIN
454 FOR i IN 1 .. ARRAY_LENGTH(resource_ids, 1) LOOP 454 FOR i IN 1 .. ARRAY_LENGTH(resource_ids, 1) LOOP
455 -- RAISE NOTICE 'Parameter %: % % %', i, resource_ids[i], metadata_types[i], metadata_values[i]; 455 -- RAISE NOTICE 'Parameter %: % % %', i, resource_ids[i], metadata_types[i], metadata_values[i];
456 INSERT INTO Metadata VALUES(resource_ids[i], metadata_types[i], metadata_values[i], revisions[i]) ON CONFLICT DO NOTHING; 456 INSERT INTO Metadata VALUES(resource_ids[i], metadata_types[i], metadata_values[i], revisions[i])
457 ON CONFLICT (id, type) DO UPDATE SET value = EXCLUDED.value, revision = EXCLUDED.revision;
457 END LOOP; 458 END LOOP;
458 459
459 END; 460 END;
460 $body$ LANGUAGE plpgsql; 461 $body$ LANGUAGE plpgsql;
461 462