suoritusrekisteri
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
arkistoi_opiskeluoikeus_deltat(amount integer, oldest bigint)
Parameters
Name
Type
Mode
amount
integer
IN
oldest
bigint
IN
Definition
DECLARE _resource_id varchar(200); _inserted bigint; _count int := 0; delta record; BEGIN FOR delta IN SELECT resource_id, inserted FROM opiskeluoikeus WHERE not current AND inserted < oldest LIMIT amount LOOP INSERT INTO a_opiskeluoikeus ( resource_id, alku_paiva, loppu_paiva, henkilo_oid, komo, myontaja, source, inserted, deleted) SELECT resource_id, alku_paiva, loppu_paiva, henkilo_oid, komo, myontaja, source, inserted, deleted FROM opiskeluoikeus WHERE resource_id = delta.resource_id AND inserted = delta.inserted; DELETE FROM opiskeluoikeus WHERE resource_id = delta.resource_id AND inserted = delta.inserted; _count := _count + 1; RAISE NOTICE '%: archived opiskeluoikeus delta: %, %', _count, delta.resource_id, delta.inserted; END LOOP; RETURN _count; END;