view NewTests/PostgresUpgrades/downgrade.sh @ 608:ba06331ac8dd

new test for issue #219
author Alain Mazy <am@osimis.io>
date Wed, 24 Jan 2024 13:23:29 +0100
parents f3475c3e42e5
children 087888659ba3
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/pg-transactions/PostgreSQL/Plugins/SQL/Downgrades/V6.2ToV6.1.sql
psql -U postgres -f V6.2ToV6.1.sql

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