Mercurial > gemma

annotate schema/dot.tmpl @ 2455:54c9fe587fe6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Subdivide SQL function to prepare for improved error handling The context of an error (e.g. the function in which it occured) can be inferred by the database client. Not doing all in one statement will render the context more meaningful.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Mar 2019 18:38:02 +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 }