Mercurial > gemma
diff 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 diff
--- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/schema/README Tue Jun 26 16:14:59 2018 +0200 @@ -0,0 +1,24 @@ +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