annotate schema/dot.tmpl @ 5560:f2204f91d286

Join the log lines of imports to the log exports to recover data from them. Used in SR export to extract information that where in the meta json but now are only found in the log.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 09 Feb 2022 18:34:40 +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 }