# HG changeset patch
# User Alain Mazy <am@orthanc.team>
# Date 1789391869 -7200
# Node ID 2b1867aa32d9119b29d896a4de26c635b542edbc
# Parent  8f29b8a521258e56176d3fe6a8d2ad6c683a2622
prepare tests for pg rev 1099

diff -r 8f29b8a52125 -r 2b1867aa32d9 NewTests/PostgresUpgrades/docker-compose.yml
--- 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
diff -r 8f29b8a52125 -r 2b1867aa32d9 NewTests/PostgresUpgrades/downgrade.sh
--- 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