Mercurial > gemma
view 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 |
line wrap: on
line source
Build Dockerfile with e.g.: $ docker build -t wamos . Get a running instance with e.g.: $ docker run --name wamos -d -p 54321:5432 -v $PWD:/opt/wamos wamos Run tests for RLS policies as database superuser (within container) with: $ psql -d wamos -Xf tap_tests.sql Create ER diagrams with e.g.: Auxiliary tables: $ postgresql_autodoc -p 54321 -h $dockerhost \ -U wamos --password=wamos -t dot -l . -s 'wamos' $ dot -Tpdf wamos.dot > wamos_auxiliary.pdf Waterway related tables: $ postgresql_autodoc -p 54321 -h $dockerhost \ -U wamos --password=wamos -t dot -l . -s 'wamos_waterway' $ dot -Tpdf wamos.dot > wamos_waterway.pdf Fairway/bottleneck related tables: $ postgresql_autodoc -p 54321 -h $dockerhost \ -U wamos --password=wamos -t dot -l . -s 'wamos_fairway' $ dot -Tpdf wamos.dot > wamos_fairway.pdf