Mercurial > hg > orthanc-tests

annotate NewTests/PostgresUpgrades/downgrade.sh @ 615:087888659ba3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
rename PG downgrade script
author Alain Mazy <am@osimis.io>
date Mon, 05 Feb 2024 09:50:24 +0100
parents f3475c3e42e5
children c76a8c783996
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
599
f3475c3e42e5 run integ tests after a PG downgrade
Alain Mazy <am@osimis.io>
parents:
diff changeset
1 #!/bin/bash
f3475c3e42e5 run integ tests after a PG downgrade
Alain Mazy <am@osimis.io>
parents:
diff changeset
2
f3475c3e42e5 run integ tests after a PG downgrade
Alain Mazy <am@osimis.io>
parents:
diff changeset
3 pushd /scripts
f3475c3e42e5 run integ tests after a PG downgrade
Alain Mazy <am@osimis.io>
parents:
diff changeset
4
f3475c3e42e5 run integ tests after a PG downgrade
Alain Mazy <am@osimis.io>
parents:
diff changeset
5 # TODO: change pg-transactions by the plugin version number !
615
087888659ba3 rename PG downgrade script
Alain Mazy <am@osimis.io>
parents: 599
diff changeset
6 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
087888659ba3 rename PG downgrade script
Alain Mazy <am@osimis.io>
parents: 599
diff changeset
7 psql -U postgres -f Rev2ToRev1.sql
599
f3475c3e42e5 run integ tests after a PG downgrade
Alain Mazy <am@osimis.io>
parents:
diff changeset
8
f3475c3e42e5 run integ tests after a PG downgrade
Alain Mazy <am@osimis.io>
parents:
diff changeset
9 # if you want to test a downgrade procedure, you may use this code ...
f3475c3e42e5 run integ tests after a PG downgrade
Alain Mazy <am@osimis.io>
parents:
diff changeset
10 # psql -U postgres -f downgrade.sql
f3475c3e42e5 run integ tests after a PG downgrade
Alain Mazy <am@osimis.io>
parents:
diff changeset
11 popd