1.40.0 - Asta7 Core

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:

1. Upload SECURITY_MODULE, PARTICIPANT_MODULE from develop branch.

2. Run the sql from the sql fix section.

3. 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; $$

How to Upgrade

1. Upload the latest SECURITY_MODULE and PARTICIPANT_MODULE templates in your current version (most likely 1.38) of Asta7.

2. Upgrade to 1.39.1

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

After Asta7 is up and running import an empty file in all the initialized projects. You should also delete the old SECURITY_MODULE and PARTICIPANT_MODULE templates.

Configuration: