Mercurial > hg > orthanc-tests

diff NewTests/PostgresUpgrades/downgrade.sh @ 599:f3475c3e42e5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
run integ tests after a PG downgrade
author Alain Mazy <am@osimis.io>
date Thu, 18 Jan 2024 17:46:54 +0100
parents
children 087888659ba3
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/NewTests/PostgresUpgrades/downgrade.sh	Thu Jan 18 17:46:54 2024 +0100
@@ -0,0 +1,11 @@
+#!/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
\ No newline at end of file