source: trunk/tools/database/sample.kSqlHtml@ 1502

Last change on this file since 1502 was 830, checked in by bird, 26 years ago

Initial checkin of the database.
File size: 9.4 KB
Line 
1<!kTemplate filename="odin32ImplementationStatus.html"><HTML>
2<Title>Odin32 Implementation Status</Title>
3<BODY>
4<CENTER><H1>Odin32 Implementation Status</H1></CENTER>
5<!kSql sql="SELECT CURDATE() AS currentdate">
6<CENTER><H2>- $(currentdate) -</H2></CENTER>
7</!kSql>
8
9<!-- Content -->
10<H3><A NAME="$TotalContent"><A HREF="#TotalsBody">Project Totals</A></A></H3>
11
12<!-- Currently we'll skip the API Groups -->
13<!kSql sql="SELECT
14 TRIM(SUBSTRING('dll apigroup author', refcode, 11)) AS tablename,
15 TRIM(SUBSTRING('Dlls API Groups Authors', refcode, 11)) AS title,
16 TRIM(SUBSTRING('name refcode refcode', refcode, 11)) AS fileidfield
17 FROM function
18 WHERE refcode IN (1,23) ORDER BY refcode">
19<H3><A NAME="$(Title)Content"><A HREF="#$(Title)Body">$(Title)</A></A></H3>
20<UL>
21<!kSql sql="SELECT name,
22 $(fileidfield) AS fileid
23 FROM $(tablename)
24 ORDER BY name">
25 <li><A HREF="#$(name)">$(name)</A> <A HREF="odin32$(tablename)$(fileid).html">(details)</A><!/kSql>
26</UL>
27<!/kSql>
28
29
30<!-- Body -->
31<!-- Project Totals -->
32<HR>
33<CENTER><A NAME="TotalsBody"><A HREF="#TotalsContent"><H1>Project Totals</H1></A></A></CENTER>
34
35<TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
36 <THEAD> <TR VALIGN=TOP> <TH>State</TH> <TH>Percent</TH> <TH>Count</TH> </TR> </THEAD>
37 <TBODY>
38 <!kSql sql="SELECT count(*) AS totalcount
39 FROM function"
40 ><!kSql sql="SELECT refcode AS currentstate,
41 name AS statedesc,
42 0 AS percent,
43 0 AS count
44 FROM state
45 ORDER BY refcode"
46 ><!kSql sql="SELECT count(*) AS count,
47 ROUND(count(*)*100 / $(totalcount), 1) AS percent
48 FROM function
49 WHERE state = $(currentstate)"
50 ><TR>
51 <TD><P ALIGN=LEFT>$(statedesc)<P></TD>
52 <TD><P ALIGN=RIGHT>$(percent)%<P></TD>
53 <TD><P ALIGN=RIGHT>$(count)<P></TD>
54 </TR><!/kSql><!/kSql>
55 <TR>
56 <TD><P ALIGN=LEFT>Total number of functions<P></TD>
57 <TD><P ALIGN=RIGHT>100.0%<P></TD>
58 <TD><P ALIGN=RIGHT>$(totalcount)<P></TD>
59 </TR><!/kSql>
60 </TBODY>
61</TABLE>
62<!-- Graph -->
63
64
65<!-- DLL -->
66<HR>
67<CENTER><A NAME="Dllsbody"><A HREF="#Dllscontent"><H1>Dlls</H1></A></A></CENTER>
68
69<!kSql sql="SELECT name AS grpname,
70 refcode AS grprefcode,
71 name AS fileid
72 FROM dll ORDER BY name">
73<A NAME="$(grpname)"><H3>$(grpname) <A HREF="odin32Dll$(fileid).html">(details)</A></H3></A>
74<TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
75 <THEAD> <TR VALIGN=TOP> <TH>State</TH> <TH>Percent</TH> <TH>Count</TH> </TR> </THEAD>
76 <TBODY>
77 <!kSql sql="SELECT count(*) AS totalcount
78 FROM function
79 WHERE dll = $(grprefcode)"
80 ><!kSql sql="SELECT refcode AS currentstate,
81 name AS statedesc,
82 color AS statecolor,
83 0 AS percent,
84 0 AS count
85 FROM state
86 ORDER BY refcode"
87 ><!kSql sql="SELECT count(*) AS count,
88 ROUND(count(*)*100 / $(totalcount), 1) AS percent
89 FROM function
90 WHERE dll = $(grprefcode)
91 AND state = $(currentstate)"
92 ><TR>
93 <TD><FONT COLOR="$(statecolor)"><P ALIGN=LEFT>$(statedesc)<P></TD>
94 <TD><P ALIGN=RIGHT>$(percent)%<P></TD>
95 <TD><P ALIGN=RIGHT>$(count)<P></FONT></TD>
96 </TR><!/kSql><!/kSql>
97 <TR>
98 <TD><P ALIGN=LEFT>Total number of functions<P></TD>
99 <TD><P ALIGN=RIGHT>100.0%<P></TD>
100 <TD><P ALIGN=RIGHT>$(totalcount)<P></TD>
101 </TR><!/kSql>
102 </TBODY>
103</TABLE>
104
105<!-- TODO graph TODO -->
106</p><p>
107<!kGraph filename="odin32Dll$(fileid).gif"
108 type=lines cx=400 cy=300
109 data="SELECT date, count, s.color, s.name
110 FROM historydll hd, state s
111 WHERE hd.state = s.refcode AND hd.dll = $(grprefcode)"
112 title="$(grpname)"
113 >
114<IMAGE SRC="odin32Dll$(fileid).gif">
115</p><p>
116<!/kSql>
117
118<!-- Currently we'll skip the API Groups -->
119
120<HR>
121<!-- Author -->
122<CENTER><A NAME="AuthorsBody"><A HREF="#AuthorsContent"><H1>Authors</H1></A></A></CENTER>
123
124<!kSql sql="SELECT name AS grpname,
125 refcode AS grprefcode,
126 refcode AS fileid
127 FROM author ORDER BY name">
128<A NAME="$(grpname)"><H3>$(grpname) <A HREF="odin32Author$(fileid).html">(details)</A></H3></A>
129
130<TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
131 <THEAD> <TR VALIGN=TOP> <TH>State</TH> <TH>Percent</TH> <TH>Count</TH> </TR> </THEAD>
132 <TBODY>
133 <!kSql sql="SELECT count(*) AS totalcount
134 FROM fnauthor
135 WHERE author = $(grprefcode)"
136 ><!kSql sql="SELECT refcode AS currentstate,
137 name AS statedesc,
138 0 AS percent,
139 0 AS count
140 FROM state
141 ORDER BY refcode"
142 ><!kSql sql="SELECT count(*) AS count,
143 ROUND(count(*)*100 / $(totalcount), 1) AS percent
144 FROM fnauthor fa, function fn
145 WHERE fa.function = fn.refcode
146 AND fa.author = $(grprefcode)
147 AND fn.state = $(currentstate)"
148 ><TR>
149 <TD><P ALIGN=LEFT>$(statedesc)<P></TD>
150 <TD><P ALIGN=RIGHT>$(percent)%<P></TD>
151 <TD><P ALIGN=RIGHT>$(count)<P></TD>
152 </TR><!/kSql><!/kSql>
153 <TR>
154 <TD><P ALIGN=LEFT>Total number of functions<P></TD>
155 <TD><P ALIGN=RIGHT>100.0%<P></TD>
156 <TD><P ALIGN=RIGHT>$(totalcount)<P></TD>
157 </TR><!/kSql>
158 </TBODY>
159</TABLE>
160<!/kSql>
161<!/kSql>
162
163</BODY>
164</HTML>
165
166<!-- End of File -->
167<!kSql sql="SELECT refcode AS dllrefcode,
168 name AS dllname,
169 'xxxx' AS ordinal,
170 'no functions' AS functionname,
171 'xxxx' AS statename
172 FROM dll
173 ORDER BY name">
174<!kTemplate filename="odin32Dll$(dllname).html">
175<HTML>
176<TITLE>Details on APIs in $(dllname)</TITLE>
177<BODY>
178<H1>Details on APIs in $(dllname)</H1>
179<TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
180 <THEAD>
181 <TR VALIGN=TOP> <TH>Ordinal</TH> <TH>API name</TH> <TH>State</TH> </TR>
182 </THEAD>
183 <TBODY>
184 <!kSql sql="SELECT ordinal,
185 function.name AS functionname,
186 state.name AS statename
187 FROM function, state
188 WHERE state.refcode = state
189 AND dll = $(dllrefcode)"
190 ><TR>
191 <TD><P ALIGN=RIGHT>$(ordinal)<P></TD>
192 <TD><P ALIGN=LEFT>$(functionname)<P></TD>
193 <TD><P ALIGN=LEFT>$(statename)<P></TD>
194 </TR><!/kSql>
195 <TR>
196 <TD><P ALIGN=RIGHT>xxxx<P></TD>
197 <TD><P ALIGN=LEFT>Total number of functions<P></TD>
198 <!kSql sql="SELECT COUNT(*) AS totalcount
199 FROM function
200 WHERE dll = $(dllrefcode)"
201 ><TD><P ALIGN=RIGHT>$(totalcount)<P></TD>
202 <!/kSql>
203 </TR>
204 </TBODY>
205</TABLE>
206</BODY>
207</HTML>
208<!/kSql>
209
210
211<!-- End of File -->
212<!kSql sql="SELECT refcode AS authorrefcode,
213 name AS authorname,
214 'xxxx' AS ordinal,
215 'no dll' AS dllname,
216 'no functions' AS functionname,
217 'xxxx' AS statename
218 FROM author
219 ORDER BY name">
220<!kTemplate filename="odin32Author$(authorrefcode).html">
221<HTML>
222<TITLE>Details on APIs written by $(authorname)</TITLE>
223<BODY>
224<H1>Details on APIs written by $(authorname)</H1>
225<TABLE BORDER=1 BORDERCOLOR="#000000" CELLPADDING=4 CELLSPACING=0>
226 <THEAD>
227 <TR VALIGN=TOP> <TH>Ordinal</TH> <TH>API name</TH> <TH>State</TH> </TR>
228 </THEAD>
229 <TBODY>
230 <!kSql sql="SELECT ordinal,
231 fn.name AS functionname,
232 s.name AS statename,
233 d.name AS dllname
234 FROM fnauthor fa, function fn, state s, dll d
235 WHERE fa.author = $(authorrefcode)
236 AND fa.function = fn.refcode
237 AND s.refcode = fn.state
238 AND fn.dll = d.refcode
239 ORDER BY dllname, functionname"
240 ><TR>
241 <TD><P ALIGN=RIGHT>$(ordinal)<P></TD>
242 <TD><P ALIGN=RIGHT>$(dllname)<P></TD>
243 <TD><P ALIGN=LEFT>$(functionname)<P></TD>
244 <TD><P ALIGN=LEFT>$(statename)<P></TD>
245 </TR><!/kSql>
246 <TR>
247 <TD><P ALIGN=RIGHT>xxxx<P></TD>
248 <TD><P ALIGN=RIGHT>xxxx<P></TD>
249 <TD><P ALIGN=LEFT>Total number of functions<P></TD>
250 <!kSql sql="SELECT COUNT(*) AS totalcount
251 FROM fnauthor
252 WHERE author = $(authorrefcode)"
253 ><TD><P ALIGN=RIGHT>$(totalcount)<P></TD>
254 <!/kSql>
255 </TR>
256 </TBODY>
257</TABLE>
258</BODY>
259</HTML>
260<!/kSql>
261
262
263
Note: See TracBrowser for help on using the repository browser.