view NewTests/PostgresUpgrades/downgrade.sh @ 826:b5a146281887 sql-opti

pg upgrade tests
author Alain Mazy <am@orthanc.team>
date Wed, 04 Jun 2025 15:30:11 +0200 (6 weeks ago)
parents de1ee0264916
children 3d2cd36378f1
line wrap: on
line source
#!/bin/bash

pushd /scripts

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/Rev99ToRev4.sql

# if you want to test a downgrade procedure, you may use this code ...
# psql -U postgres -f downgrade.sql
popd