1.40.0 - Archive Manager

Highlights:

AAM-1087 - Getting issue details... STATUS

AAM-1079 - Getting issue details... STATUS

AAM-977 - Getting issue details... STATUS

AAM-1101 - Getting issue details... STATUS

AAM-1096 - Getting issue details... STATUS

Bug fixes:

Stories:

Tasks:

Breaking changes:

Upload SECURITY_MODULE, PARTICIPANT_MODULE from develop branch.
Run the sql from the sql fix section.
Delete old SECURITY_MODULE, PARTICIPANT_MODULE.

SQL Fixes:

update system_template set template_id = '4196c9da-5cab-4f49-a076-4da414edc896' where name = 'PARTICIPANT_MODULE'; 
update system_template set template_id = '2193fab6-b06e-4ba4-ae87-54477dfd3cda' where name = 'SECURITY_MODULE';







do $$
    declare
        r record;
        sql varchar;
    begin
        for r in select id from project where archive_initialized = true
            loop
                sql := 'alter table if exists ' || r.id || '.object_restriction alter column object_reference type uuid using object_reference::uuid';
                execute sql;


                Begin
                    sql := 'ALTER TABLE ' || r.id || '.aktor_relasjon add column object_reference varchar';
                    execute sql;
                EXCEPTION
                    WHEN duplicate_column THEN RAISE NOTICE 'column <column_name> already exists in <table_name>.';
                END;

                sql := 'update ' || r.id || '.aktor_relasjon set object_reference=objekt_id';
               -- raise notice '%s',sql;
                execute sql;

                sql := 'alter table if exists ' || r.id || '.aktor_relasjon alter column object_reference type uuid using object_reference::uuid';
                execute sql;



                sql := 'ALTER TABLE ' || r.id || '.aktor_relasjon drop column objekt_id';
                execute sql;
            end loop;
    end; $$