187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
|
}
a = t/fsize;
fossil_print("%*s%d:%d\n", colWidth, "compression-ratio:", a, b);
}
n = db_int(0, "SELECT COUNT(*) FROM event e WHERE e.type='ci'");
fossil_print("%*s%d\n", colWidth, "checkin-count:", n);
n = db_int(0, "SELECT count(*) FROM filename /*scan*/");
/* FIXME/TODO: add the change-count-per-type to each event type,
** plus add 'Event' count
*/
#if 0
m = db_int(0, "SELECT count(distinct mid) FROM mlink /*scan*/");
#endif
fossil_print("%*s%d"/* (%d changes) */"\n", colWidth, "file-count:",
n/*, m */);
#if 0
m = db_int(0, "SELECT COUNT(*) FROM blob b JOIN event e WHERE "
"b.rid=e.objid AND e.type='w'");
#endif
fossil_print("%*s%d"/* (%d changes) */"\n", colWidth, "wikipage-count:",
n/*, m */);
#if 0
m = db_int(0, "SELECT COUNT(*) FROM blob b JOIN event e WHERE "
"b.rid=e.objid AND e.type='t'");
#endif
fossil_print("%*s%d"/* (%d changes)*/"\n", colWidth, "ticket-count:",
n/* , m */);
|
<
<
<
<
<
<
|
<
<
|
<
<
|
<
<
|
<
<
|
<
>
>
>
>
|
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
|
}
a = t/fsize;
fossil_print("%*s%d:%d\n", colWidth, "compression-ratio:", a, b);
}
n = db_int(0, "SELECT COUNT(*) FROM event e WHERE e.type='ci'");
fossil_print("%*s%d\n", colWidth, "checkin-count:", n);
n = db_int(0, "SELECT count(*) FROM filename /*scan*/");
fossil_print("%*s%d across all branches\n", colWidth, "file-count:", n);
n = db_int(0, "SELECT count(*) FROM tag /*scan*/"
" WHERE tagname GLOB 'wiki-*'");
m = db_int(0, "SELECT COUNT(*) FROM event WHERE type='w'");
fossil_print("%*s%d (%d changes)\n", colWidth, "wikipage-count:", n, m);
n = db_int(0, "SELECT count(*) FROM tag /*scan*/"
" WHERE tagname GLOB 'tkt-*'");
m = db_int(0, "SELECT COUNT(*) FROM event WHERE type='t'");
fossil_print("%*s%d (%d changes)\n", colWidth, "ticket-count:", n, m);
n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='e'");
fossil_print("%*s%d\n", colWidth, "event-count:", n);
n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='g'");
fossil_print("%*s%d\n", colWidth, "tagchange-count:", n);
}
n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event)"
" + 0.99");
fossil_print("%*s%d days or approximately %.2f years.\n",
colWidth, "project-age:", n, n/365.24);
fossil_print("%*s%s\n", colWidth, "project-id:", db_get("project-code",""));
fossil_print("%*s%s\n", colWidth, "server-id:", db_get("server-code",""));
|