changeset 969:2b1867aa32d9 pg-next-1099

prepare tests for pg rev 1099
author Alain Mazy <am@orthanc.team>
date Mon, 14 Sep 2026 15:17:49 +0200
parents 8f29b8a52125
children a1f8353c0e61
files NewTests/PostgresUpgrades/docker-compose.yml NewTests/PostgresUpgrades/downgrade.sh
diffstat 2 files changed, 14 insertions(+), 10 deletions(-) [+]
line wrap: on
line diff
--- a/NewTests/PostgresUpgrades/docker-compose.yml	Mon Sep 14 14:25:04 2026 +0200
+++ b/NewTests/PostgresUpgrades/docker-compose.yml	Mon Sep 14 15:17:49 2026 +0200
@@ -17,7 +17,7 @@
 
   # Orthanc previous version
   orthanc-pg-15-previous-revision:
-    image: orthancteam/orthanc:25.11.3
+    image: orthancteam/orthanc:26.9.0
     container_name: orthanc-pg-15-previous-revision
     depends_on: [pg-15]
     restart: unless-stopped
@@ -30,7 +30,7 @@
 
   # Orthanc previous version to run the integration tests
   orthanc-pg-15-previous-revision-for-integ-tests:
-    image: orthancteam/orthanc:25.11.3
+    image: orthancteam/orthanc:26.9.0
     container_name: orthanc-pg-15-previous-revision-for-integ-tests
     depends_on: [pg-15]
     restart: unless-stopped
--- a/NewTests/PostgresUpgrades/downgrade.sh	Mon Sep 14 14:25:04 2026 +0200
+++ b/NewTests/PostgresUpgrades/downgrade.sh	Mon Sep 14 15:17:49 2026 +0200
@@ -4,16 +4,20 @@
 
 apt-get update && apt-get install -y wget
 
-# hg clone is often rejected from Azure runners, let's try a download from http
-wget https://orthanc.uclouvain.be/downloads/sources/orthanc-postgresql/OrthancPostgreSQL-10.0.tar.gz --output-document /tmp/pg.tar.gz
-# ex for an intermediate release (or if download from uclouvain is rejected)
-# wget https://public-files.orthanc.team/tmp-builds/hg-repos/orthanc-databases-81d837d7d20d.tar.gz --output-document /tmp/pg.tar.gz
+    # # hg clone is often rejected from Azure runners, let's try a download from http
+    # wget https://orthanc.uclouvain.be/downloads/sources/orthanc-postgresql/OrthancPostgreSQL-10.0.tar.gz --output-document /tmp/pg.tar.gz
+    # # ex for an intermediate release (or if download from uclouvain is rejected)
+    # # wget https://public-files.orthanc.team/tmp-builds/hg-repos/orthanc-databases-81d837d7d20d.tar.gz --output-document /tmp/pg.tar.gz
 
-mkdir -p /scripts/orthanc-databases/
-pushd /scripts/orthanc-databases/
-tar xvf /tmp/pg.tar.gz --strip-components=1
+    # mkdir -p /scripts/orthanc-databases/
+    # pushd /scripts/orthanc-databases/
+    # tar xvf /tmp/pg.tar.gz --strip-components=1
 
-psql -U postgres -f /scripts/orthanc-databases/PostgreSQL/Plugins/SQL/Downgrades/Rev10ToRev6.sql
+    # psql -U postgres -f /scripts/orthanc-databases/PostgreSQL/Plugins/SQL/Downgrades/Rev10ToRev6.sql
+
+wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/tip/PostgreSQL/Plugins/SQL/Downgrades/Rev1099ToRev10.sql --output-document /tmp/downgrade.sql
+
+psql -U postgres -f /tmp/downgrade.sql
 
 # if you want to test a downgrade procedure, you may use this code ...
 # psql -U postgres -f downgrade.sql