Mercurial > gemma
annotate schema/README @ 113:25b28fd0e256
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 |
rev | line source |
---|---|
36 | 1 Build Dockerfile with e.g.: |
2 $ docker build -t wamos . | |
3 | |
4 Get a running instance with e.g.: | |
57
353f804e86ae
Use volume to have sql in container.
Tom Gottfried <tom@intevation.de>
parents:
36
diff
changeset
|
5 $ docker run --name wamos -d -p 54321:5432 -v $PWD:/opt/wamos wamos |
36 | 6 |
101 | 7 Run tests for RLS policies as database superuser (within container) with: |
8 $ psql -d wamos -Xf tap_tests.sql | |
9 | |
83 | 10 Create ER diagrams with e.g.: |
11 Auxiliary tables: | |
36 | 12 $ postgresql_autodoc -p 54321 -h $dockerhost \ |
68
7a91106668b8
Respect custom template and schema in README.
Tom Gottfried <tom@intevation.de>
parents:
57
diff
changeset
|
13 -U wamos --password=wamos -t dot -l . -s 'wamos' |
83 | 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 |