Mercurial > hg > orthanc-tests

view NewTests/PostgresUpgrades/downgrade.sh @ 676:85c1447fa86b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
DW test for empty PatientName
author Alain Mazy <am@orthanc.team>
date Wed, 04 Sep 2024 12:57:56 +0200
parents c3aa39672db1
children e3d41c4168c3
line wrap: on
line source

#!/bin/bash

pushd /scripts

# TODO: change pg-transactions by the plugin version number !
apt-get update && apt-get install -y wget && wget https://orthanc.uclouvain.be/hg/orthanc-databases/raw-file/default/PostgreSQL/Plugins/SQL/Downgrades/Rev2ToRev1.sql
psql -U postgres -f Rev2ToRev1.sql

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