view schema/README @ 234:55dce2f649bc

Allow using the same email-address for multiple users This can be useful at least in testing scenarios, where one person wants to have multiple accounts with different roles and there is no other reason to enforce uniqueness.
author Tom Gottfried <tom@intevation.de>
date Thu, 26 Jul 2018 15:10:22 +0200
parents 68fd656c3d55
children
line wrap: on
line source

Build Dockerfile with e.g.:
$ docker build -t gemma_db .

Get a running instance with e.g.:
$ docker run --name gemma_db -d -p 54321:5432 -v $PWD:/opt/gemma gemma_db

Run tests for RLS policies:
$ docker exec gemma_db ./run_tests.sh

Create ER diagrams with e.g.:
Auxiliary tables:
$ postgresql_autodoc -p 54321 -h $dockerhost \
      -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 \
      -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 \
      -d gemma -U sophie --password=so2Phie4 -t dot -l . -s 'gemma_fairway'
$ dot -Tpdf gemma.dot > gemma_fairway.pdf