Mercurial > gemma

comparison schema/README @ 113:25b28fd0e256

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Moved schema stuff to own subfolder.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 26 Jun 2018 16:14:59 +0200
parents README@aa32ffd5060b
children dad6cf39691e
comparison
equal deleted inserted replaced
112:894f633e2d3f 113:25b28fd0e256
1 Build Dockerfile with e.g.:
2 $ docker build -t wamos .
3
4 Get a running instance with e.g.:
5 $ docker run --name wamos -d -p 54321:5432 -v $PWD:/opt/wamos wamos
6
7 Run tests for RLS policies as database superuser (within container) with:
8 $ psql -d wamos -Xf tap_tests.sql
9
10 Create ER diagrams with e.g.:
11 Auxiliary tables:
12 $ postgresql_autodoc -p 54321 -h $dockerhost \
13 -U wamos --password=wamos -t dot -l . -s 'wamos'
14 $ dot -Tpdf wamos.dot > wamos_auxiliary.pdf
15
16 Waterway related tables:
17 $ postgresql_autodoc -p 54321 -h $dockerhost \
18 -U wamos --password=wamos -t dot -l . -s 'wamos_waterway'
19 $ dot -Tpdf wamos.dot > wamos_waterway.pdf
20
21 Fairway/bottleneck related tables:
22 $ postgresql_autodoc -p 54321 -h $dockerhost \
23 -U wamos --password=wamos -t dot -l . -s 'wamos_fairway'
24 $ dot -Tpdf wamos.dot > wamos_fairway.pdf