Fossil SCM
Expanded the "dbstat" command output a bit.
Commit
29a9e237d83d4845abd07f88eb410e57c82953b9
Parent
4f510b66cb76c42…
1 file changed
+9
-20
+9
-20
| --- src/stat.c | ||
| +++ src/stat.c | ||
| @@ -189,34 +189,23 @@ | ||
| 189 | 189 | fossil_print("%*s%d:%d\n", colWidth, "compression-ratio:", a, b); |
| 190 | 190 | } |
| 191 | 191 | n = db_int(0, "SELECT COUNT(*) FROM event e WHERE e.type='ci'"); |
| 192 | 192 | fossil_print("%*s%d\n", colWidth, "checkin-count:", n); |
| 193 | 193 | n = db_int(0, "SELECT count(*) FROM filename /*scan*/"); |
| 194 | - /* FIXME/TODO: add the change-count-per-type to each event type, | |
| 195 | - ** plus add 'Event' count | |
| 196 | - */ | |
| 197 | -#if 0 | |
| 198 | - m = db_int(0, "SELECT count(distinct mid) FROM mlink /*scan*/"); | |
| 199 | -#endif | |
| 200 | - fossil_print("%*s%d"/* (%d changes) */"\n", colWidth, "file-count:", | |
| 201 | - n/*, m */); | |
| 194 | + fossil_print("%*s%d across all branches\n", colWidth, "file-count:", n); | |
| 202 | 195 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 203 | 196 | " WHERE tagname GLOB 'wiki-*'"); |
| 204 | -#if 0 | |
| 205 | - m = db_int(0, "SELECT COUNT(*) FROM blob b JOIN event e WHERE " | |
| 206 | - "b.rid=e.objid AND e.type='w'"); | |
| 207 | -#endif | |
| 208 | - fossil_print("%*s%d"/* (%d changes) */"\n", colWidth, "wikipage-count:", | |
| 209 | - n/*, m */); | |
| 197 | + m = db_int(0, "SELECT COUNT(*) FROM event WHERE type='w'"); | |
| 198 | + fossil_print("%*s%d (%d changes)\n", colWidth, "wikipage-count:", n, m); | |
| 210 | 199 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 211 | 200 | " WHERE tagname GLOB 'tkt-*'"); |
| 212 | -#if 0 | |
| 213 | - m = db_int(0, "SELECT COUNT(*) FROM blob b JOIN event e WHERE " | |
| 214 | - "b.rid=e.objid AND e.type='t'"); | |
| 215 | -#endif | |
| 216 | - fossil_print("%*s%d"/* (%d changes)*/"\n", colWidth, "ticket-count:", | |
| 217 | - n/* , m */); | |
| 201 | + m = db_int(0, "SELECT COUNT(*) FROM event WHERE type='t'"); | |
| 202 | + fossil_print("%*s%d (%d changes)\n", colWidth, "ticket-count:", n, m); | |
| 203 | + n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='e'"); | |
| 204 | + fossil_print("%*s%d\n", colWidth, "event-count:", n); | |
| 205 | + n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='g'"); | |
| 206 | + fossil_print("%*s%d\n", colWidth, "tagchange-count:", n); | |
| 218 | 207 | } |
| 219 | 208 | n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event)" |
| 220 | 209 | " + 0.99"); |
| 221 | 210 | fossil_print("%*s%d days or approximately %.2f years.\n", |
| 222 | 211 | colWidth, "project-age:", n, n/365.24); |
| 223 | 212 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -189,34 +189,23 @@ | |
| 189 | fossil_print("%*s%d:%d\n", colWidth, "compression-ratio:", a, b); |
| 190 | } |
| 191 | n = db_int(0, "SELECT COUNT(*) FROM event e WHERE e.type='ci'"); |
| 192 | fossil_print("%*s%d\n", colWidth, "checkin-count:", n); |
| 193 | n = db_int(0, "SELECT count(*) FROM filename /*scan*/"); |
| 194 | /* FIXME/TODO: add the change-count-per-type to each event type, |
| 195 | ** plus add 'Event' count |
| 196 | */ |
| 197 | #if 0 |
| 198 | m = db_int(0, "SELECT count(distinct mid) FROM mlink /*scan*/"); |
| 199 | #endif |
| 200 | fossil_print("%*s%d"/* (%d changes) */"\n", colWidth, "file-count:", |
| 201 | n/*, m */); |
| 202 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 203 | " WHERE tagname GLOB 'wiki-*'"); |
| 204 | #if 0 |
| 205 | m = db_int(0, "SELECT COUNT(*) FROM blob b JOIN event e WHERE " |
| 206 | "b.rid=e.objid AND e.type='w'"); |
| 207 | #endif |
| 208 | fossil_print("%*s%d"/* (%d changes) */"\n", colWidth, "wikipage-count:", |
| 209 | n/*, m */); |
| 210 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 211 | " WHERE tagname GLOB 'tkt-*'"); |
| 212 | #if 0 |
| 213 | m = db_int(0, "SELECT COUNT(*) FROM blob b JOIN event e WHERE " |
| 214 | "b.rid=e.objid AND e.type='t'"); |
| 215 | #endif |
| 216 | fossil_print("%*s%d"/* (%d changes)*/"\n", colWidth, "ticket-count:", |
| 217 | n/* , m */); |
| 218 | } |
| 219 | n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event)" |
| 220 | " + 0.99"); |
| 221 | fossil_print("%*s%d days or approximately %.2f years.\n", |
| 222 | colWidth, "project-age:", n, n/365.24); |
| 223 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -189,34 +189,23 @@ | |
| 189 | fossil_print("%*s%d:%d\n", colWidth, "compression-ratio:", a, b); |
| 190 | } |
| 191 | n = db_int(0, "SELECT COUNT(*) FROM event e WHERE e.type='ci'"); |
| 192 | fossil_print("%*s%d\n", colWidth, "checkin-count:", n); |
| 193 | n = db_int(0, "SELECT count(*) FROM filename /*scan*/"); |
| 194 | fossil_print("%*s%d across all branches\n", colWidth, "file-count:", n); |
| 195 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 196 | " WHERE tagname GLOB 'wiki-*'"); |
| 197 | m = db_int(0, "SELECT COUNT(*) FROM event WHERE type='w'"); |
| 198 | fossil_print("%*s%d (%d changes)\n", colWidth, "wikipage-count:", n, m); |
| 199 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 200 | " WHERE tagname GLOB 'tkt-*'"); |
| 201 | m = db_int(0, "SELECT COUNT(*) FROM event WHERE type='t'"); |
| 202 | fossil_print("%*s%d (%d changes)\n", colWidth, "ticket-count:", n, m); |
| 203 | n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='e'"); |
| 204 | fossil_print("%*s%d\n", colWidth, "event-count:", n); |
| 205 | n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='g'"); |
| 206 | fossil_print("%*s%d\n", colWidth, "tagchange-count:", n); |
| 207 | } |
| 208 | n = db_int(0, "SELECT julianday('now') - (SELECT min(mtime) FROM event)" |
| 209 | " + 0.99"); |
| 210 | fossil_print("%*s%d days or approximately %.2f years.\n", |
| 211 | colWidth, "project-age:", n, n/365.24); |
| 212 |