Fossil

Check-in [04bcc6ce]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Fix a sorting bug on the /artifact_stats page.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256:04bcc6ce6e7fa34bb882a3a5e470c1152c79bcbfa6510f76047021a7fd276544
User & Date: drh 2017-12-09 22:07:59
Context
2017-12-10
00:51
Fix the sorttable.js module so that it works with more than one sortable table on the same screen. check-in: 23083200 user: drh tags: trunk
2017-12-09
22:07
Fix a sorting bug on the /artifact_stats page. check-in: 04bcc6ce user: drh tags: trunk
22:01
Add the /artifact_stats page for use by administrators. check-in: d96bee1c user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to src/stat.c.

646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
  gather_artifact_stats();
  db_prepare(&q,
    "SELECT atype, count(*), sum(isDelta), sum(szCmpr), sum(szExp)"
    "  FROM artstat GROUP BY 1"
    " UNION ALL "
    "SELECT 'ALL', count(*), sum(isDelta), sum(szCmpr), sum(szExp)"
    "  FROM artstat"
    " ORDER BY 5;"
  );
  @ <table class='sortable' border='1' \
  @ data-column-types='tkkkkk' data-init-sort='5'>
  @ <thead><tr>
  @ <th>Artifact Type</th>
  @ <th>Count</th>
  @ <th>Full-Text</th>







|







646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
  gather_artifact_stats();
  db_prepare(&q,
    "SELECT atype, count(*), sum(isDelta), sum(szCmpr), sum(szExp)"
    "  FROM artstat GROUP BY 1"
    " UNION ALL "
    "SELECT 'ALL', count(*), sum(isDelta), sum(szCmpr), sum(szExp)"
    "  FROM artstat"
    " ORDER BY 4;"
  );
  @ <table class='sortable' border='1' \
  @ data-column-types='tkkkkk' data-init-sort='5'>
  @ <thead><tr>
  @ <th>Artifact Type</th>
  @ <th>Count</th>
  @ <th>Full-Text</th>