Mercurial > hg > orthanc-tests

view NewTests/PostgresUpgrades/downgrade.sh @ 843:63a7a9eab0f1 sql-opti

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
PG: Rev599 -> Rev6
author Alain Mazy <am@orthanc.team>
date Tue, 22 Jul 2025 10:24:59 +0200
parents 72540f20d493
children 895215bfb8aa
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
pushd /scripts/orthanc-databases/
hg update -r sql-opti

psql -U postgres -f /scripts/orthanc-databases/PostgreSQL/Plugins/SQL/Downgrades/Rev6ToRev5.sql

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