Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Added "brief" option to /json/stat, mirroring the change in [d01ca14d08]. |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | json |
| Files: | files | file ages | folders |
| SHA1: |
17f11a0884475283bdd43a4d3a527874 |
| User & Date: | stephan 2011-09-27 01:51:19.416 |
Context
|
2011-09-27
| ||
| 02:09 | Changed /json/stat to use brief mode by default due to relatively high runtime cost, replaced 'brief' param with 'full'. Added json_getenv_bool(). ... (check-in: c1914eaa user: stephan tags: json) | |
| 01:51 | Added "brief" option to /json/stat, mirroring the change in [d01ca14d08]. ... (check-in: 17f11a08 user: stephan tags: json) | |
| 01:32 | Added /json/user/xyz to ajax demo. /json/user/get/USERNAME now works as an alias for ?name=USERNAME. ... (check-in: 585be130 user: stephan tags: json) | |
Changes
Changes to src/json.c.
| ︙ | ︙ | |||
1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 |
/*
** Implementation of the /json/stat page/command.
**
*/
cson_value * json_page_stat(){
i64 t, fsize;
int n, m;
const char *zDb;
enum { BufLen = 1000 };
char zBuf[BufLen];
cson_value * jv = NULL;
cson_object * jo = NULL;
cson_value * jv2 = NULL;
cson_object * jo2 = NULL;
if( !g.perm.Read ){
g.json.resultCode = FSL_JSON_E_DENIED;
return NULL;
}
#define SETBUF(O,K) cson_object_set(O, K, cson_value_new_string(zBuf, strlen(zBuf)));
jv = cson_value_new_object();
jo = cson_value_get_object(jv);
sqlite3_snprintf(BufLen, zBuf, db_get("project-name",""));
SETBUF(jo, "projectName");
/* FIXME: don't include project-description until we ensure that
zBuf will always be big enough. We "should" replace zBuf
with a blob for this purpose.
*/
fsize = file_size(g.zRepositoryName);
cson_object_set(jo, "repositorySize", cson_value_new_integer((cson_int_t)fsize));
| > > > > > > > | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | > | 1220 1221 1222 1223 1224 1225 1226 1227 1228 1229 1230 1231 1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248 1249 1250 1251 1252 1253 1254 1255 1256 1257 1258 1259 1260 1261 1262 1263 1264 1265 1266 1267 1268 1269 1270 1271 1272 1273 1274 1275 1276 1277 1278 1279 1280 1281 1282 1283 1284 1285 1286 1287 1288 1289 1290 1291 1292 1293 1294 1295 1296 1297 1298 1299 1300 1301 1302 1303 1304 |
/*
** Implementation of the /json/stat page/command.
**
*/
cson_value * json_page_stat(){
i64 t, fsize;
int n, m;
int brief;
const char *zDb;
enum { BufLen = 1000 };
char zBuf[BufLen];
cson_value * jv = NULL;
cson_object * jo = NULL;
cson_value * jv2 = NULL;
cson_object * jo2 = NULL;
if( !g.perm.Read ){
g.json.resultCode = FSL_JSON_E_DENIED;
return NULL;
}
if( g.isHTTP ){
brief = json_getenv_int("brief",0);
}else{
brief = (0!=find_option("brief","b",0));
}
#define SETBUF(O,K) cson_object_set(O, K, cson_value_new_string(zBuf, strlen(zBuf)));
jv = cson_value_new_object();
jo = cson_value_get_object(jv);
sqlite3_snprintf(BufLen, zBuf, db_get("project-name",""));
SETBUF(jo, "projectName");
/* FIXME: don't include project-description until we ensure that
zBuf will always be big enough. We "should" replace zBuf
with a blob for this purpose.
*/
fsize = file_size(g.zRepositoryName);
cson_object_set(jo, "repositorySize", cson_value_new_integer((cson_int_t)fsize));
if(!brief){
n = db_int(0, "SELECT count(*) FROM blob");
m = db_int(0, "SELECT count(*) FROM delta");
cson_object_set(jo, "blobCount", cson_value_new_integer((cson_int_t)n));
cson_object_set(jo, "deltaCount", cson_value_new_integer((cson_int_t)m));
if( n>0 ){
int a, b;
Stmt q;
db_prepare(&q, "SELECT total(size), avg(size), max(size)"
" FROM blob WHERE size>0");
db_step(&q);
t = db_column_int64(&q, 0);
cson_object_set(jo, "uncompressedArtifactSize",
cson_value_new_integer((cson_int_t)t));
cson_object_set(jo, "averageArtifactSize",
cson_value_new_integer((cson_int_t)db_column_int(&q, 1)));
cson_object_set(jo, "maxArtifactSize",
cson_value_new_integer((cson_int_t)db_column_int(&q, 2)));
db_finalize(&q);
if( t/fsize < 5 ){
b = 10;
fsize /= 10;
}else{
b = 1;
}
a = t/fsize;
sqlite3_snprintf(BufLen,zBuf, "%d:%d", a, b);
SETBUF(jo, "compressionRatio");
}
n = db_int(0, "SELECT count(distinct mid) FROM mlink /*scan*/");
cson_object_set(jo, "checkinCount", cson_value_new_integer((cson_int_t)n));
n = db_int(0, "SELECT count(*) FROM filename /*scan*/");
cson_object_set(jo, "fileCount", cson_value_new_integer((cson_int_t)n));
n = db_int(0, "SELECT count(*) FROM tag /*scan*/"
" WHERE +tagname GLOB 'wiki-*'");
cson_object_set(jo, "wikiPageCount", cson_value_new_integer((cson_int_t)n));
n = db_int(0, "SELECT count(*) FROM tag /*scan*/"
" WHERE +tagname GLOB 'tkt-*'");
cson_object_set(jo, "ticketCount", cson_value_new_integer((cson_int_t)n));
}/*!brief*/
n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event)"
" + 0.99");
cson_object_set(jo, "ageDays", cson_value_new_integer((cson_int_t)n));
cson_object_set(jo, "ageYears", cson_value_new_double(n/365.24));
sqlite3_snprintf(BufLen, zBuf, db_get("project-code",""));
SETBUF(jo, "projectCode");
sqlite3_snprintf(BufLen, zBuf, db_get("server-code",""));
|
| ︙ | ︙ |