annotate README @ 112:894f633e2d3f

WIP: Add failing test.
author Tom Gottfried <tom@intevation.de>
date Fri, 15 Jun 2018 20:20:44 +0200
parents aa32ffd5060b
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.:
333c42e341e5 Add README.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2 $ docker build -t wamos .
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.:
57
353f804e86ae Use volume to have sql in container.
Tom Gottfried <tom@intevation.de>
parents: 36
diff changeset
5 $ docker run --name wamos -d -p 54321:5432 -v $PWD:/opt/wamos wamos
36
333c42e341e5 Add README.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
6
101
aa32ffd5060b Mention tests in README.
Tom Gottfried <tom@intevation.de>
parents: 83
diff changeset
7 Run tests for RLS policies as database superuser (within container) with:
aa32ffd5060b Mention tests in README.
Tom Gottfried <tom@intevation.de>
parents: 83
diff changeset
8 $ psql -d wamos -Xf tap_tests.sql
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 \
68
7a91106668b8 Respect custom template and schema in README.
Tom Gottfried <tom@intevation.de>
parents: 57
diff changeset
13 -U wamos --password=wamos -t dot -l . -s 'wamos'
83
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
14 $ dot -Tpdf wamos.dot > wamos_auxiliary.pdf
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 \
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
18 -U wamos --password=wamos -t dot -l . -s 'wamos_waterway'
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
19 $ dot -Tpdf wamos.dot > wamos_waterway.pdf
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 \
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
23 -U wamos --password=wamos -t dot -l . -s 'wamos_fairway'
d9d01dc58f60 Update README.
Tom Gottfried <tom@intevation.de>
parents: 68
diff changeset
24 $ dot -Tpdf wamos.dot > wamos_fairway.pdf