Mercurial > gemma
annotate schema/README @ 465:ab07eb290fa3
Drop metamorph role too when tearing down database.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 22 Aug 2018 17:21:25 +0200 |
parents | 68fd656c3d55 |
children |
rev | line source |
---|---|
36 | 1 Build Dockerfile with e.g.: |
174
68fd656c3d55
Use better example names for Docker image and container
Tom Gottfried <tom@intevation.de>
parents:
172
diff
changeset
|
2 $ docker build -t gemma_db . |
36 | 3 |
4 Get a running instance with e.g.: | |
174
68fd656c3d55
Use better example names for Docker image and container
Tom Gottfried <tom@intevation.de>
parents:
172
diff
changeset
|
5 $ docker run --name gemma_db -d -p 54321:5432 -v $PWD:/opt/gemma gemma_db |
36 | 6 |
174
68fd656c3d55
Use better example names for Docker image and container
Tom Gottfried <tom@intevation.de>
parents:
172
diff
changeset
|
7 Run tests for RLS policies: |
68fd656c3d55
Use better example names for Docker image and container
Tom Gottfried <tom@intevation.de>
parents:
172
diff
changeset
|
8 $ docker exec gemma_db ./run_tests.sh |
101 | 9 |
83 | 10 Create ER diagrams with e.g.: |
11 Auxiliary tables: | |
36 | 12 $ postgresql_autodoc -p 54321 -h $dockerhost \ |
172
a422471db08a
Automate running DB-tests with an extra database
Tom Gottfried <tom@intevation.de>
parents:
116
diff
changeset
|
13 -d gemma -U sophie --password=so2Phie4 -t dot -l . -s 'gemma' |
116
dad6cf39691e
Renamed remaining wamos stuff to gemma.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
113
diff
changeset
|
14 $ dot -Tpdf gemma.dot > gemma_auxiliary.pdf |
83 | 15 |
16 Waterway related tables: | |
17 $ postgresql_autodoc -p 54321 -h $dockerhost \ | |
172
a422471db08a
Automate running DB-tests with an extra database
Tom Gottfried <tom@intevation.de>
parents:
116
diff
changeset
|
18 -d gemma -U sophie --password=so2Phie4 -t dot -l . -s 'gemma_waterway' |
116
dad6cf39691e
Renamed remaining wamos stuff to gemma.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
113
diff
changeset
|
19 $ dot -Tpdf gemma.dot > gemma_waterway.pdf |
83 | 20 |
21 Fairway/bottleneck related tables: | |
22 $ postgresql_autodoc -p 54321 -h $dockerhost \ | |
172
a422471db08a
Automate running DB-tests with an extra database
Tom Gottfried <tom@intevation.de>
parents:
116
diff
changeset
|
23 -d gemma -U sophie --password=so2Phie4 -t dot -l . -s 'gemma_fairway' |
116
dad6cf39691e
Renamed remaining wamos stuff to gemma.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
113
diff
changeset
|
24 $ dot -Tpdf gemma.dot > gemma_fairway.pdf |