-
Notifications
You must be signed in to change notification settings - Fork 8
/
html_template.jinja.html
137 lines (117 loc) · 4.85 KB
/
html_template.jinja.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
<!DOCTYPE html>
<html>
<head>
<title>Greenplum System Catalog Reference</title>
<link rel="stylesheet" href="https://bootswatch.com/flatly/bootstrap.min.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css">
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
.table-nonfluid {
width: auto !important;
}
body{
padding-bottom: 40px;
}
a{
text-decoration: none !important;
}
</style>
</head>
<body>
<div class="container-fluid">
<div class="row">
<div class="col-xs-12">
<a name="top"></a>
<h1>Greenplum System Catalog Reference</h1>
<hr>
<p>Built from the following configuration files:
<ul>
<li><a href="https://github.com/greenplum-db/gpdb/tree/master/gpMgmt/bin/gppylib/data/">https://github.com/greenplum-db/gpdb/tree/master/gpMgmt/bin/gppylib/data</a></li>
</ul>
</p>
<hr>
<!--<p>Choose the catalog version:</p>
<div class="btn-toolbar">
<div class="btn-group" repeat.for="catalogConfig of catalogConfigs">
<button click.trigger="setCatalog(catalogConfig)" type="button" class="btn btn-primary">${catalogConfig.version}</button>
</div>
</div>
<hr>-->
<h1>Summary</h1>
<table class="table table-nonfluid table-condensed table-bordered">
<tr><th>Greenplum Version:</th><td>{{catalog.version}}</td></tr>
<tr><th>Catalog Version:</th><td>{{catalog.info.CATALOG_VERSION_NO}}</td></tr>
</table>
<table class="table table-nonfluid table-condensed table-bordered">
<thead>
<tr>
<th>Has OIDs</th>
<th>Shared</th>
<th>Persistent</th>
<th>Master Only</th>
<th>Segment Local</th>
</tr>
</thead>
<tbody>
<tr>
{% for field in catalog_metadata.fields %}
<td>
{% for relation in catalog_metadata.data[field] %}<div><a href="#{{relation}}">{{relation}}</a></div>
{% endfor %}
</td>
{% endfor %}
</tr>
</tbody>
</table>
<hr>
<h1>Relations</h1>
{% for relation in catalog.relations %}
<div repeat.for="relation of " style="font-family: Monospace">
<a name="{{relation.name}}"></a>
<h2><strong>{{relation.name}}</strong> <a class="btn btn-default btn-xs" target="_blank" href="img/{{relation.name}}.png">Diagram</a></h2>
<table class="table table-nonfluid table-condensed table-bordered">
<thead>
<tr>
<th>Column</th>
<th>Type</th>
<th title="Foreign key for this column">Foreign Key <i class="fa fa-arrow-right"></i></th>
<th title="Columns that reference this column as a foreign key">Reference Keys <i class="fa fa-arrow-left"></i></th>
</tr>
</thead>
<tbody>
{% for col in relation.cols %}
<tr>
<td><a name="{{relation.name}}_{{col.colname}}">{{col.colname}}</a></td>
<td>{{col.sqltype}}</td>
<td>{% if col.foreign_key %}
<a href="#{{col.foreign_key.remote_relname}}_{{col.foreign_key.remote_colname}}"><strong>{{col.foreign_key.remote_relname}}</strong>.{{col.foreign_key.remote_colname}}</a></td>
{% endif %}
<td>
{% for ref_key in col.reference_keys %}
<div><a href="#{{ref_key.local_relname}}"><strong>{{ref_key.local_relname}}</strong>.{{ref_key.local_colname}}</a></div>
<!--<a repeat.for="remote_key of col.remote_keys" show.bind="col.remote_keys.length > 0" href="#${col.foreign_key[1]}_${col.foreign_key[2][0]}">${col.foreign_key[1]}.${col.foreign_key[2][0]}</a>-->
{% endfor %}
</td>
</tr>
{% endfor %}
</tbody>
</table>
<table class="table table-nonfluid table-condensed table-bordered">
<tr><td><strong>Indexes</strong></td><td>
{% for index in relation.indexes %}
<div><a>{{index.CamelCaseIndexId|underscore}}</a> {{index.unique|unique}} ({{index.cols|index_cols}})</div>
{% endfor %}
</td></tr>
<tr><td><strong>Has OIDs</strong></td><td>{{relation.with.oid|yesno}}</td></tr>
<tr><td><strong>Content</strong></td><td>{{relation.with.content}}</td></tr>
<tr><td><strong>Shared</strong></td><td>{{relation.with.shared|yesno}}</td></tr>
</table>
</div>
{% endfor %}
<hr>
<a href="#top">Back to top</a>
</div>
</div>
</div>
</body>
</html>