1.49.0 - Asta7 Core

Highlights:

AAM-1140 - Getting issue details... STATUS

Story:

AAM-1140 - Getting issue details... STATUS

AAM-1144 - Getting issue details... STATUS

Tasks:

AAM-1143 - Getting issue details... STATUS

AAM-1147 - Getting issue details... STATUS

Bug Fixes:

AAM-1142 - Getting issue details... STATUS

SQL Fixes:

1. For AAM-1140 issue need to perform these SQL fixes:
   
   Upload the latest security_module template.

   update system_template set template_id = '64b0d486-bc51-476b-bab0-9c78221f8422' where name = 'SECURITY_MODULE'; 
   
   delete from keycloak.user_role_mapping where role_id in (select id from keycloak.keycloak_role where name like 'am|rg|%');
   delete from keycloak.keycloak_role where name like 'am|rg|%';
   
   do $$
       declare
           r record;
           sql varchar;
       begin
           for r in select id from project where archive_initialized = true and exists (select project_id from project_system_template where project_id = id and template_name = 'SECURITY_MODULE')
               loop
                   execute format('alter table %s.restriction alter column number_of_years drop not null', r.id);
                   execute format('alter table %s.object_restriction alter column planned_termination_year drop not null', r.id);
               
                   execute format('drop table if exists %s.content_screening', r.id);
                   execute format('drop table if exists %s.content_access_group', r.id);
   
                   execute format('create table %s.content_access_group
   (
       _amid       uuid default uuid_generate_v4()   not null
           unique,
       created     timestamp,
       created_by  varchar,
       updated     timestamp,
       updated_by  varchar,
       type        varchar                           not null,
       id          uuid default uuid_generate_v1mc() not null
           primary key,
       name        varchar(36)                       not null
           unique,
       description varchar
   )', r.id);
                   execute format('alter table %s.content_access_group owner to "archive-manager"', r.id);
   
                   execute format('create table %s.content_screening
   (
       _amid                uuid default uuid_generate_v4() not null
           unique,
       created              timestamp,
       created_by           varchar,
       updated              timestamp,
       updated_by           varchar,
       cag_id               uuid                            not null
           constraint fk_29d876ad_dd73_4c04_aa9f_8655e43c7a82
               references %s.content_access_group
               deferrable initially deferred,
       object_id            uuid                            not null,
       table_name_reference varchar                         not null,
       scope                varchar                         not null,
       field_names          varchar(2000),
       constraint content_screening_pk
           primary key (object_id, cag_id)
   )', r.id, r.id);
                   execute format('alter table %s.content_screening owner to "archive-manager"', r.id);
   
                   execute format('insert into %s.code_table(name, cs_name) values(''contentAccessGroupType'', ''security'')', r.id);
                   execute format('insert into %s.code_value(ct_name, code, value) values(''contentAccessGroupType'', ''NORMAL'', ''Normal'')', r.id);
                   execute format('insert into %s.code_value(ct_name, code, value) values(''contentAccessGroupType'', ''RESTRICTED'', ''Begrenset'')', r.id);
                   execute format('delete from %s.code_value where ct_name = ''contentScreeningScope'' and code = ''100''', r.id);
                   execute format('insert into %s.code_value(_amid, code, ct_name, value, uid) values (''42755dd9-cc42-4559-9afa-ae22727ab506'', ''40'', ''contentScreeningScope'', ''Kan gjøre hva som helst'', ''9ab730d6-1f7d-4dbb-bc17-7290f668f21f'')', r.id);
               end loop;
       end; $$

   MongoDB

   db.getCollection("fs.screening").drop();

   Elasticsearch

   curl -XDELETE localhost:9200/*==digital-files

   Then reindex all the projects.
   

2. For AAM-1147 issue need to perform this SQL fix:
   
   Upload the latest participant_module template.

update system_template set template_id = '61d2e7e4-2fe4-4d7e-83b6-236355a15660' where name = 'PARTICIPANT_MODULE';

do $$
    declare
        r record;
        sql varchar;
    begin
        for r in select id from project where archive_initialized = true and exists (select project_id from project_system_template where project_id = id and template_name = 'PARTICIPANT_MODULE')
            loop
                execute format('alter table %s.aktor_struktur add column if not exists startdato varchar null', r.id);
                execute format('alter table %s.aktor_struktur add column if not exists sluttdato varchar null', r.id);
                execute format('alter table %s.alternativt_navn add column if not exists type varchar null', r.id);
            end loop;
    end; $$

How to upgrade:

1. Upload the latest PARTICIPANT_MODULE and SECURITY_MODULE templates

2. Upgrade to 1.49

3. Go to the asta7 directory and run the following script

4. Delete the old PARTICIPANT_MODULE and SECURITY_MODULE templates

5. Reindex all the projects search data