1.55.0/1/2 - Asta7 Core

Highlights:

https://stiftelsenasta.atlassian.net/browse/AAM-1122

https://stiftelsenasta.atlassian.net/browse/AAM-1182

Tasks:

https://stiftelsenasta.atlassian.net/browse/AAM-1193

https://stiftelsenasta.atlassian.net/browse/AAM-1121

https://stiftelsenasta.atlassian.net/browse/AAM-1122

https://stiftelsenasta.atlassian.net/browse/AAM-1102

https://stiftelsenasta.atlassian.net/browse/AAM-1182

https://stiftelsenasta.atlassian.net/browse/AAM-1195

Bugs:

https://stiftelsenasta.atlassian.net/browse/AAM-1194

Scripts:

AAM-1121

SET TIME ZONE 'UTC';
DO
$$
    DECLARE
        schema_name_var text;
        table_name_var  text;
        column_name_var text;
    BEGIN
        FOR schema_name_var IN (SELECT id 
        						FROM project 
        						WHERE archive_initialized = true)
            LOOP
                FOR table_name_var IN (SELECT table_name
                                       FROM information_schema.tables
                                       WHERE table_schema = schema_name_var)
                    LOOP
                        FOR column_name_var IN (SELECT column_name
                                                FROM information_schema.columns
                                                WHERE table_schema = schema_name_var
                                                  AND table_name = table_name_var
                                                  AND data_type = 'timestamp without time zone')
                            LOOP
                                EXECUTE 'ALTER TABLE ' || schema_name_var || '.' || table_name_var ||
                                        ' ALTER COLUMN ' || column_name_var || ' TYPE timestamp with time zone;';
                                EXECUTE 'ALTER TABLE ' || schema_name_var || '.' || table_name_var ||
                                        ' ALTER COLUMN ' || column_name_var ||
                                        ' SET DATA TYPE timestamp with time zone USING ' || column_name_var ||
                                        ' AT TIME ZONE ''UTC'';';
                            END LOOP;
                    END LOOP;
            END LOOP;
    END
$$;

AAM-1182

DO
$$
    DECLARE
        ar text[] = array['job', 'job_log', 'project_log'];
        a text;
    BEGIN
        FOREACH a IN array ar LOOP
            EXECUTE 'drop sequence if exists ' || a || '_seq cascade';
            EXECUTE 'create sequence if not exists ' || a || '_id_seq';
            EXECUTE 'alter sequence ' || a || '_id_seq owner to "archive-manager"';
            EXECUTE 'alter sequence ' || a || '_id_seq owned by ' || a || '.id';
            EXECUTE 'alter table ' || a || ' alter column id set default nextval(''' || a || '_id_seq''::regclass)';
            EXECUTE 'SELECT setval(''' || a || '_id_seq'', COALESCE((SELECT MAX(id) + 1 FROM ' || a || '), 10), false)';
        END LOOP;
    END;
$$;

How to upgrade:

Download and extract Asta7 1.55.0
Go to asta7 directory and run the following script
The container will no longer restart after the system reboot, in order to start them up automatically run the following script, it will install a systemd service on startup