Mercurial > gemma

annotate schema/dot.tmpl @ 2006:35acb7f9ae0c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Do anything else before expectedly failing role creation Creating roles during database setup expectedly fails in case there already is another gemma database in the cluster. Doing it at the end of the transaction ensures it does not hide errors in other commands in the script. In passing, add the default admin via the designated view to ensure it will become a correctly set up application user.
author Tom Gottfried <tom@intevation.de>
date Thu, 24 Jan 2019 17:23:43 +0100
parents 25b28fd0e256
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
61
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 digraph g {
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2 graph [
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
3 rankdir = "LR",
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
4 concentrate = true,
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
5 ratio = auto
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
6 ];
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
7 node [
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
8 fontsize = "10",
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
9 shape = record
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
10 ];
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
11 edge [
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
12 ];
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
13 <TMPL_LOOP name="schemas"><TMPL_LOOP name="tables"><TMPL_UNLESS name="view_definition">
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
14 "<TMPL_IF name="number_of_schemas"><TMPL_VAR name="schema_dot">.</TMPL_IF name="number_of_schemas"><TMPL_VAR name="table_dot">" [shape = plaintext, label = <<TABLE BORDER="1" CELLBORDER="0" CELLSPACING="0"><TR><TD PORT="ltcol0"></TD><TD border="1" COLSPAN="2"> \N </TD><TD PORT="rtcol0"></TD></TR><TMPL_LOOP name="columns"><TR><TD PORT="ltcol<TMPL_VAR name="column_number">"></TD><TD align="left"><TMPL_VAR name="column_dot"></TD><TD align="left"><TMPL_VAR name="column_type"></TD><TD align="left" PORT="rtcol<TMPL_VAR name="column_number">"></TD></TR></TMPL_LOOP name="columns"></TABLE>> ];
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
15 </TMPL_UNLESS name="view_definition"></TMPL_LOOP name="tables"></TMPL_LOOP name="schemas">
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
16
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
17 <TMPL_LOOP name="fk_links">
63
c18f1db22077 Omit rather useless labels of relations.
Tom Gottfried <tom@intevation.de>
parents: 61
diff changeset
18 "<TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle0_schema">.</TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle0_name">":rtcol<TMPL_VAR name="handle0_connection"> -> "<TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle1_schema">.</TMPL_IF name="number_of_schemas"><TMPL_VAR name="handle1_name">":ltcol<TMPL_VAR name="handle1_connection"> [];</TMPL_LOOP name="fk_links">
61
a5749fd004c3 Add template for postgresql_autodoc.
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
19 }