changeset 826:b5a146281887 sql-opti

pg upgrade tests
author Alain Mazy <am@orthanc.team>
date Wed, 04 Jun 2025 15:30:11 +0200
parents d6df874bbe0b
children 3d2cd36378f1
files NewTests/PostgresUpgrades/docker-compose.yml NewTests/PostgresUpgrades/downgrade.sh
diffstat 2 files changed, 3 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/NewTests/PostgresUpgrades/docker-compose.yml	Wed Jun 04 10:47:22 2025 +0200
+++ b/NewTests/PostgresUpgrades/docker-compose.yml	Wed Jun 04 15:30:11 2025 +0200
@@ -17,7 +17,7 @@
 
   # Orthanc previous version
   orthanc-pg-15-previous-revision:
-    image: orthancteam/orthanc:25.1.1
+    image: orthancteam/orthanc:25.5.1
     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.1.1
+    image: orthancteam/orthanc:25.5.1
     container_name: orthanc-pg-15-previous-revision-for-integ-tests
     depends_on: [pg-15]
     restart: unless-stopped
--- a/NewTests/PostgresUpgrades/downgrade.sh	Wed Jun 04 10:47:22 2025 +0200
+++ b/NewTests/PostgresUpgrades/downgrade.sh	Wed Jun 04 15:30:11 2025 +0200
@@ -5,7 +5,7 @@
 apt-get update && apt-get install -y wget mercurial
 hg clone https://orthanc.uclouvain.be/hg/orthanc-databases
 hg update -r default
-psql -U postgres -f /scripts/orthanc-databases/PostgreSQL/Plugins/SQL/Downgrades/Rev4ToRev3.sql
+psql -U postgres -f /scripts/orthanc-databases/PostgreSQL/Plugins/SQL/Downgrades/Rev99ToRev4.sql
 
 # if you want to test a downgrade procedure, you may use this code ...
 # psql -U postgres -f downgrade.sql