Mercurial > gemma
annotate schema/dot.tmpl @ 3176:1cb6676d1510
Handle failing INSERTs gracefully during gauge measurements import
Makes obsolete the code duplicating constraint checking in the application.
Although automated constraint naming by PostgreSQL is predictable,
name the constraint used for trapping the error explicitly to
improve control and traceability.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 06 May 2019 18:18:17 +0200 |
parents | 25b28fd0e256 |
children |
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 } |