Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Get the /clusterlist working for non-admin users, though omit sensitive information for non-admins. Show the compressed size of clusters on that page. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
90764bd6561cdade234f68ce7a1344fa |
| User & Date: | drh 2024-12-20 16:50:21.926 |
Context
|
2024-12-20
| ||
| 16:59 | Install hyperlinks to the /clusterlist page. check-in: 3057775b54 user: drh tags: trunk | |
| 16:50 | Get the /clusterlist working for non-admin users, though omit sensitive information for non-admins. Show the compressed size of clusters on that page. check-in: 90764bd656 user: drh tags: trunk | |
| 15:27 | Fix a typo in a column name for the query that deals with phantom entries in the info page for clusters. check-in: 72a218cecf user: drh tags: trunk | |
Changes
Changes to src/name.c.
| ︙ | ︙ | |||
2166 2167 2168 2169 2170 2171 2172 | style_finish_page(); } /* ** WEBPAGE: clusterlist ** ** Show information about all cluster artifacts in the database. | < > | > | > > > > > > > > | | | > > > | | | | | | | | | > | > | 2166 2167 2168 2169 2170 2171 2172 2173 2174 2175 2176 2177 2178 2179 2180 2181 2182 2183 2184 2185 2186 2187 2188 2189 2190 2191 2192 2193 2194 2195 2196 2197 2198 2199 2200 2201 2202 2203 2204 2205 2206 2207 2208 2209 2210 2211 2212 2213 2214 2215 2216 2217 2218 2219 2220 2221 2222 2223 2224 2225 2226 2227 2228 2229 2230 2231 2232 2233 2234 2235 2236 2237 2238 2239 2240 2241 2242 |
style_finish_page();
}
/*
** WEBPAGE: clusterlist
**
** Show information about all cluster artifacts in the database.
*/
void clusterlist_page(void){
Stmt q;
int cnt = 1;
sqlite3_int64 szTotal = 0;
sqlite3_int64 szCTotal = 0;
login_check_credentials();
if( !g.perm.Read ){ login_needed(g.anon.Read); return; }
style_header("All Cluster Artifacts");
db_prepare(&q,
"SELECT blob.uuid, "
" blob.size, "
" octet_length(blob.content), "
" datetime(rcvfrom.mtime),"
" user.login,"
" rcvfrom.ipaddr"
" FROM tagxref JOIN blob ON tagxref.rid=blob.rid"
" LEFT JOIN rcvfrom ON blob.rcvid=rcvfrom.rcvid"
" LEFT JOIN user ON user.uid=rcvfrom.uid"
" WHERE tagxref.tagid=%d"
" ORDER BY rcvfrom.mtime, blob.uuid",
TAG_CLUSTER
);
@ <table cellpadding="2" cellspacing="0" border="1">
@ <tr><th>
@ <th>Hash
@ <th>Date Received
@ <th>Size
@ <th>Compressed Size
if( g.perm.Admin ){
@ <th>User<th>IP-Address
}
while( db_step(&q)==SQLITE_ROW ){
const char *zUuid = db_column_text(&q, 0);
sqlite3_int64 sz = db_column_int64(&q, 1);
sqlite3_int64 szC = db_column_int64(&q, 2);
const char *zDate = db_column_text(&q, 3);
const char *zUser = db_column_text(&q, 4);
const char *zIp = db_column_text(&q, 5);
szTotal += sz;
szCTotal += szC;
@ <tr><td align="right">%d(cnt++)
@ <td><a href="%R/info/%S(zUuid)">%S(zUuid)</a>
if( zDate ){
@ <td>%h(zDate)
}else{
@ <td>
}
@ <td align="right">%,lld(sz)
@ <td align="right">%,lld(szC)
if( g.perm.Admin ){
if( zUser ){
@ <td>%h(zUser)
}else{
@ <td>
}
if( zIp ){
@ <td>%h(zIp)
}else{
@ <td>
}
}
@ </tr>
}
@ </table>
db_finalize(&q);
@ <p>Total size of all clusters: %,lld(szTotal) bytes,
@ %,lld(szCTotal) bytes compressed</p>
style_finish_page();
}
|