Mercurial > gemma

annotate schema/README @ 234:55dce2f649bc

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
36
333c42e341e5 Add README.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
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
333c42e341e5 Add README.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3
333c42e341e5 Add README.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
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
333c42e341e5 Add README.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
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
aa32ffd5060b Mention tests in README.
Tom Gottfried <tom@intevation.de>
parents: 83
diff changeset
9
83
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
10 Create ER diagrams with e.g.:
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
11 Auxiliary tables:
36
333c42e341e5 Add README.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
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
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
15
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
16 Waterway related tables:
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
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
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
20
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
21 Fairway/bottleneck related tables:
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
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