Mercurial > gemma

diff schema/README @ 172:a422471db08a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Automate running DB-tests with an extra database run_tests.sh allows to run database tests easily without affecting other existing databases and on a clean basis. Because roles are cluster-wide, they cannot be easily droped and recreated without affecting other databases. Thus, moved their creation to roles.sql and in passing removed unnecessary role 'gemma'.
author Tom Gottfried <tom@intevation.de>
date Thu, 12 Jul 2018 16:30:01 +0200
parents dad6cf39691e
children 68fd656c3d55
line wrap: on
line diff
--- a/schema/README	Tue Jul 10 14:30:06 2018 +0200
+++ b/schema/README	Thu Jul 12 16:30:01 2018 +0200
@@ -5,20 +5,20 @@
 $ docker run --name gemma -d -p 54321:5432 -v $PWD:/opt/gemma gemma
 
 Run tests for RLS policies as database superuser (within container) with:
-$ psql -d gemma -Xf tap_tests.sql
+$ ./run_tests.sh
 
 Create ER diagrams with e.g.:
 Auxiliary tables:
 $ postgresql_autodoc -p 54321 -h $dockerhost \
-      -U gemma --password=gemma -t dot -l . -s 'gemma'
+      -d gemma -U sophie --password=so2Phie4 -t dot -l . -s 'gemma'
 $ dot -Tpdf gemma.dot > gemma_auxiliary.pdf
 
 Waterway related tables:
 $ postgresql_autodoc -p 54321 -h $dockerhost \
-      -U gemma --password=gemma -t dot -l . -s 'gemma_waterway'
+      -d gemma -U sophie --password=so2Phie4 -t dot -l . -s 'gemma_waterway'
 $ dot -Tpdf gemma.dot > gemma_waterway.pdf
 
 Fairway/bottleneck related tables:
 $ postgresql_autodoc -p 54321 -h $dockerhost \
-      -U gemma --password=gemma -t dot -l . -s 'gemma_fairway'
+      -d gemma -U sophie --password=so2Phie4 -t dot -l . -s 'gemma_fairway'
 $ dot -Tpdf gemma.dot > gemma_fairway.pdf