Mercurial > gemma

annotate schema/README @ 296:b1116c4ce57f usermanagement

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
merge with default
author Thomas Junk <thomas.junk@intevation.de>
date Tue, 31 Jul 2018 15:56:11 +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