source: trunk/tools/database/sample.kSqlHtml

Last change on this file was 2818, checked in by bird, 26 years ago

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