Page Comparison

update system_template set template_id = 'd10f1600-00db-4733-b4f5-858feb69103f' where name = 'SECURITY_MODULE';
do $$   '.content_screening (object_id)';            
   declare         rend recordloop;
    beginend;
$$

do $$
    fordeclare
r in select id FROM project where archive_initialized =r true   record;
        ps loop  varchar[] := array ['READ', 'WRITE'];
        p  execute 'alter tablevarchar;
if exists ' || r.id || '.restriction add columnrole ifvarchar;
not exists is_predefined_for_suggestion boolean null';    grp varchar;
        i int;
 execute 'alter table ifbegin
exists ' || r.id || '.restriction alter column namefor type varchar(1000)';
       r in select id FROM project where archive_initialized = true
    end loop;     end; $$

update system_template set template_id = 'ccff22f4-d532-4d1b-add5-5427d1044e09' where name = 'PARTICIPANT_MODULE';
do $$ loop
              declare  foreach p in array ps
  r record;     begin         for r in selectloop
id FROM project where archive_initialized = true             loop     role := format('am|project|%s|CONTENT_SCREENING_%s', r.id, p);
         execute 'alter table if exists ' || r.id || '.aktor_relasjon add column if not exists startdato varcharexecute nullformat(';insert into keycloak.keycloak_role values (%L, ''archive-manager'', false, null,
         execute 'alter table if exists ' || r.id || '.aktor_relasjon add column if not exists sluttdato varchar null';  %L, ''archive-manager'', null, null) on conflict do nothing', uuid_generate_v4(), role);

    execute 'alter table if exists ' || r.id || '.aktor_relasjon drop column if exists object_reference';         grp :=   end loopformat('am|project|%s|ADMIN', r.id);
    end; $$

do $$     declare         r record;   execute format('select count(*) from keycloak.keycloak_group  sql varcharwhere name = %L', grp) into i;
    begin         for r in SELECT        if i > 0 then
         tc.table_schema,                   execute format('insert into tckeycloak.constraint_name,group_role_mapping
                    values ((select id from tckeycloak.tablekeycloak_role where name = %L),
                     kcu.column_name,
              (select id from keycloak.keycloak_group where name = %L)) on conflict do nothing', role, grp);
             ccu.table_schema  AS foreign_table_schema,        end if;
            ccu.table_name AS foreign_table_name,      end loop;

             ccu.column_name AS foreign_column_name execute format('select count(*) from %s.coding_scheme where name = %L', r.id, 'security') into i;
    FROM            if i > 0 then
     information_schema.table_constraints AS tc             execute format('insert into %s.code_table ("_amid", name, cs_name, created)
     JOIN information_schema.key_column_usage AS kcu        values (''c20f0ff2-8119-4f3a-b350-fe81a44ccb92'', ''contentScreeningScope'', ''security'', now())
                on conflict do ONnothing', tc.constraint_name = kcu.constraint_namer.id);
                execute format('INSERT                  AND tc.table_schema = kcu.table_schema
   INTO %s.code_value (_amid, code, value, ct_name, uid)
                     JOIN information_schema.constraint_column_usage AS ccu
VALUES (''347e584a-a9d1-4766-9147-70e307360213'', ''100'', ''Kan ikke gjøre noe'', ''contentScreeningScope'',
                        ''c68170c4-c231-47a6-a57d-a0f05d7a9390'')
    ON ccu.constraint_name = tc.constraint_name         on conflict do nothing', r.id);
                execute format('INSERT INTO   AND ccu.table_schema = tc.table_schema
  %s.code_value (_amid, code, value, ct_name, uid)
              WHERE tc.constraint_type =VALUES ('FOREIGN KEY' and tc.table_schema in (select id from project where archive_initialized = true)'5a114ba7-a31a-4a42-aa8b-7d532904ad0f'', ''90'', ''Kan lese felt'', ''contentScreeningScope'',
                 loop       ''d58a5738-a033-4323-8034-620ba3cf3040'')
         sql := 'alter table ' || r.table_schema || '.' || r.table_name ||' drop constraint if exists '|| r.constraint_name on conflict do nothing', r.id);
                -- raise notice '%', sql;
     execute format('INSERT INTO %s.code_value (_amid, code, value, ct_name, uid)
          execute sql;     VALUES (''38b23289-7dcf-4a76-bce5-69a2dde2c910'', ''80'', ''Kan lese'', ''contentScreeningScope'',
  end loop;          for r in select schemaname, tablename, indexname from pg_indexes where schemaname in (select id from project where archive_initialized = true) and indexname like 'index%' ''b6b0b2f4-d7cd-4a55-9b5f-66d5f0eef624'')
                on conflict do nothing', r.id);
   loop             execute format('INSERT INTO  sql := 'drop index if exists ' || r.schemaname || '.' || r.indexname;%s.code_value (_amid, code, value, ct_name, uid)
                VALUES (''76677f95-5107-471f-9ba9-6b71d912b204'', ''70'', ''Kan lese felt og skrive execute sql;felt'', ''contentScreeningScope'',
                -- raise notice '%', sql      ''c77a1264-2879-482f-84c2-afe2f04d7e11'')
                on conflict do nothing', r.id);
            end loop;   execute  end;
$$;