Fossil SCM
Add a count of forum posts to the "fossil dbstat" command.
Commit
dd9cfe021beae30142b3cc7837ed41ab89386facd64289ef9757777503a4f629
Parent
0ded250858cfdaa…
1 file changed
+9
+9
| --- src/stat.c | ||
| +++ src/stat.c | ||
| @@ -376,10 +376,19 @@ | ||
| 376 | 376 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 377 | 377 | " WHERE tagname GLOB 'tkt-*'"); |
| 378 | 378 | m = db_int(0, "SELECT COUNT(*) FROM event WHERE type='t'"); |
| 379 | 379 | fossil_print("%*s%,d (%,d changes)\n", colWidth, "tickets:", n, m); |
| 380 | 380 | n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='e'"); |
| 381 | + if( db_table_exists("repository","forumpost") ){ | |
| 382 | + n = db_int(0, "SELECT count(*) FROM forumpost/*scan*/"); | |
| 383 | + if( n>0 ){ | |
| 384 | + int nThread = db_int(0, "SELECT count(*) FROM forumpost" | |
| 385 | + " WHERE froot=fpid"); | |
| 386 | + fossil_print("%*s%,d (on %,d threads)\n", colWidth, "forum-posts:", | |
| 387 | + n, nThread); | |
| 388 | + } | |
| 389 | + } | |
| 381 | 390 | fossil_print("%*s%,d\n", colWidth, "events:", n); |
| 382 | 391 | n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='g'"); |
| 383 | 392 | fossil_print("%*s%,d\n", colWidth, "tag-changes:", n); |
| 384 | 393 | z = db_text(0, "SELECT datetime(mtime) || ' - about ' ||" |
| 385 | 394 | " CAST(julianday('now') - mtime AS INTEGER)" |
| 386 | 395 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -376,10 +376,19 @@ | |
| 376 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 377 | " WHERE tagname GLOB 'tkt-*'"); |
| 378 | m = db_int(0, "SELECT COUNT(*) FROM event WHERE type='t'"); |
| 379 | fossil_print("%*s%,d (%,d changes)\n", colWidth, "tickets:", n, m); |
| 380 | n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='e'"); |
| 381 | fossil_print("%*s%,d\n", colWidth, "events:", n); |
| 382 | n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='g'"); |
| 383 | fossil_print("%*s%,d\n", colWidth, "tag-changes:", n); |
| 384 | z = db_text(0, "SELECT datetime(mtime) || ' - about ' ||" |
| 385 | " CAST(julianday('now') - mtime AS INTEGER)" |
| 386 |
| --- src/stat.c | |
| +++ src/stat.c | |
| @@ -376,10 +376,19 @@ | |
| 376 | n = db_int(0, "SELECT count(*) FROM tag /*scan*/" |
| 377 | " WHERE tagname GLOB 'tkt-*'"); |
| 378 | m = db_int(0, "SELECT COUNT(*) FROM event WHERE type='t'"); |
| 379 | fossil_print("%*s%,d (%,d changes)\n", colWidth, "tickets:", n, m); |
| 380 | n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='e'"); |
| 381 | if( db_table_exists("repository","forumpost") ){ |
| 382 | n = db_int(0, "SELECT count(*) FROM forumpost/*scan*/"); |
| 383 | if( n>0 ){ |
| 384 | int nThread = db_int(0, "SELECT count(*) FROM forumpost" |
| 385 | " WHERE froot=fpid"); |
| 386 | fossil_print("%*s%,d (on %,d threads)\n", colWidth, "forum-posts:", |
| 387 | n, nThread); |
| 388 | } |
| 389 | } |
| 390 | fossil_print("%*s%,d\n", colWidth, "events:", n); |
| 391 | n = db_int(0, "SELECT COUNT(*) FROM event WHERE type='g'"); |
| 392 | fossil_print("%*s%,d\n", colWidth, "tag-changes:", n); |
| 393 | z = db_text(0, "SELECT datetime(mtime) || ' - about ' ||" |
| 394 | " CAST(julianday('now') - mtime AS INTEGER)" |
| 395 |