view NewTests/PostgresUpgrades/downgrade.sh @ 649:5d7b6e43ab7d

updated copyright, as Orthanc Team now replaces Osimis
author Sebastien Jodogne <s.jodogne@gmail.com>
date Thu, 30 May 2024 21:51:11 +0200
parents 087888659ba3
children c76a8c783996
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/tip/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