Index: src/rebuild.c
==================================================================
--- src/rebuild.c
+++ src/rebuild.c
@@ -543,11 +543,11 @@
** See also: deconstruct, reconstruct
*/
void rebuild_database(void){
int forceFlag;
int randomizeFlag;
- int errCnt;
+ int errCnt = 0;
int omitVerify;
int doClustering;
const char *zPagesize;
int newPagesize = 0;
int activateWal;
Index: src/statrep.c
==================================================================
--- src/statrep.c
+++ src/statrep.c
@@ -406,20 +406,19 @@
all rows. */
stats_report_init_view();
stats_report_event_types_menu("byuser", NULL);
@
Timeline Events
@ (%s(stats_report_label_for_type())) by User
- if( PB("pie") ){
- db_multi_exec(
- "CREATE TEMP TABLE piechart(amt,label);"
- "INSERT INTO piechart SELECT count(*), user FROM v_reports"
- " GROUP BY user ORDER BY count(*) DESC;"
- );
- @
- return;
+ db_multi_exec(
+ "CREATE TEMP TABLE piechart(amt,label);"
+ "INSERT INTO piechart SELECT count(*), user FROM v_reports"
+ " GROUP BY user ORDER BY count(*) DESC;"
+ );
+ if( db_int(0, "SELECT count(*) FROM piechart")>=2 ){
+ @
}
@
@
@
User
@@ -479,11 +478,11 @@
"CREATE TEMP TABLE statrep(filename, cnt);"
"INSERT INTO statrep(filename, cnt)"
" SELECT filename.name, count(distinct mlink.mid)"
" FROM filename, mlink"
" WHERE filename.fnid=mlink.fnid"
- " GROUP BY 1"
+ " GROUP BY 1;"
);
db_prepare(&query,
"SELECT filename, cnt FROM statrep ORDER BY cnt DESC, filename /*sort*/"
);
mxEvent = db_int(1, "SELECT max(cnt) FROM statrep");
@@ -539,10 +538,23 @@
"COUNT(*) AS eventCount "
"FROM v_reports "
"GROUP BY dow ORDER BY dow");
@
Timeline Events
@ (%s(stats_report_label_for_type())) by Day of the Week
+ db_multi_exec(
+ "CREATE TEMP TABLE piechart(amt,label);"
+ "INSERT INTO piechart SELECT count(*), cast(mtime %% 7 AS INT) FROM v_reports"
+ " GROUP BY 2 ORDER BY 2;"
+ "UPDATE piechart SET label = CASE label WHEN 0 THEN 'Monday' WHEN 1 THEN 'Tuesday'"
+ " WHEN 2 THEN 'Wednesday' WHEN 3 THEN 'Thursday' WHEN 4 THEN 'Friday'"
+ " WHEN 5 THEN 'Saturday' ELSE 'Sunday' END;"
+ );
+ if( db_int(0, "SELECT count(*) FROM piechart")>=2 ){
+ @