-
Notifications
You must be signed in to change notification settings - Fork 184
/
sql-results.handlebars
137 lines (135 loc) · 3 KB
/
sql-results.handlebars
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
<html>
<head>
{{!
These styles are intentionally not put next to the other styles so that
they will apply only to the sql iframe output.
}}
<style>
table {
border-collapse: collapse;
border-spacing: 0;
empty-cells: show;
width: 100%;
margin-bottom: 20px;
}
table thead {
background: #e6e6e6;
color: #000;
text-align: left;
vertical-align: bottom;
}
th:first-child {
border-radius: 6px 0 0 0;
}
th:last-child {
border-radius: 0 6px 0 0;
}
th:only-child{
border-radius: 6px 6px 0 0;
}
tbody {
border: 1px solid #dbdbdb;
}
td {
border: 1px solid #eeeeee;
font-family: Monaco, Menlo, 'Ubuntu Mono', Consolas, source-code-pro, monospace;
font-size: inherit;
margin: 0;
overflow: visible;
padding: .3em 1em;
}
th {
font-family: "Proxima Nova", sans-serif;
padding: .4em 1em;
}
th a {
color: #699c52;
}
h1 {
clear: both;
color: #aaa;
font-family: "Proxima Nova", sans-serif;
font-size: 1.1em;
font-weight: normal;
margin-top: 10px;
text-transform: uppercase;
}
table.sql-schema-table {
float:left;
width: auto;
}
table.sql-schema-table .column-type-wrap {
float: right;
margin-left: 20px;
min-width: 70px;
}
table.sql-schema-table .schema-pk {
color: #999;
}
table.sql-schema-table .schema-column-type {
float: left;
color: #999;
}
table.sql-schema-table + table.sql-schema-table {
margin-left: 10px
}
table.sql-schema-table .row-count {
color: #999;
float: right;
margin-left: 30px;
text-align: right;
font-weight: normal;
}
</style>
</head>
<body>
<div class="sql-output">
{{#if tables}}
<h1>{{databaseMsg}}</h1>
{{/if}}
{{#each tables}}
<table class="sql-schema-table" data-table-name="{{name}}">
<thead>
{{#if hasSingleRow}}
<th><a href="javascript:void(0)">{{name}}</a> <span class="row-count">{{rowCount}} row</span></th>
{{else}}
<th><a href="javascript:void(0)">{{name}}</a> <span class="row-count">{{rowCount}} rows</span></th>
{{/if}}
</thead>
<tbody>
{{#each columns}}
<tr><td>
{{name}} {{#if pk}}<span class="schema-pk">(PK)</span>{{/if}} <span class="column-type-wrap"><span class="schema-column-type">{{type}}</span></span>
</td></tr>
{{/each}}
</tbody>
</table>
{{/each}}
{{#if results }}
<h1>{{resultsMsg}}</h1>
{{/if}}
{{#each results}}
<table class="sql-result-table">
<thead>
{{#each columns}}
<th>{{this}}</th>
{{/each}}
</thead>
<tbody>
{{#each values}}
<tr>
{{#each result}}
{{#isNull data}}
<td>NULL</td>
{{else}}
<td>{{data}}</td>
{{/isNull}}
{{/each}}
</tr>
{{/each}}
</tbody>
</table>
{{/each}}
</div>
</body>
</html>