View Issue Details

IDProjectCategoryView StatusLast Update
0000035NewsStatsReportspublic2013-09-02 06:58
ReporterthhAssigned To 
PrioritynormalSeverityfeatureReproducibilityN/A
Status acknowledgedResolutionopen 
ProjectionnoneETAnone 
Product VersionProduct Build 
Target VersionFixed in Version 
Summary0000035: additional output for reports
DescriptionReports should optionally contain
* for each group
  - sums (all postings over the reporting period)
    - yearly sums (all postings in that year)
  - averages (average number of postings during the reporting period)
    - yearly averages
  - percentages (of the whole TLH)
    - optionally: of the groups contained in the report
TagsNo tags attached.

Relationships

related to 0000032 closedthh groupstats: redo output format, sensible defaults 

Activities

There are no notes attached to this issue.

Related Changesets

NewsStats: next edd250f2

2012-05-02 16:11:43

thh

Details Diff
Complete rewrite of groupstats.pl and NewsStats.pm.

* Switch to Getopt::Long, change coding style;
limit line length.

* Replace 'die' and 'warn' by calls to &Bleat().

* Completely redo options and processing:
- merge -m/-p/-a into --month
- replace -i/-q/-d with - much more powerful -
--group-by/--order-by
- replace -t/-l with - much more powerful -
--lower/--upper/--boundary
- remove -b and replace it with --report

Fixes 0000033.

* Add new report types, boundaries and sorting options:
- report types 'average' and 'sums'
- boundaries 'average' and 'sums'
- upper and/or lower boundary
- sort output independently

Issue 0000035.
Fixes 0000034, 0000038.

* Add possibility to cross-check newsgroups against
checkgroups file.

* Complete rewrite of groupstats.pl internal logic:
- modularize construction fo SQL queries
- remove unnecessary special cases
- refactor code into NewsStats.pm functions as much
as possible

Issue 0000037.
Fixes 0000036.

* Rework output formats, fix padding problem by making use
of modularized SQL queries.

Fixes 0000015, 0000032.

* Add some more consistency checks.

Issue 0000012.

* Redo documentation.

* Update TODO list.

Signed-off-by: Thomas Hochstein <thh@inter.net>
Affected Issues
0000012, 0000015, 0000032, 0000033, 0000034, 0000035, 0000036, 0000037, 0000038
mod - groupstats.pl Diff File
mod - NewsStats.pm Diff File
mod - doc/TODO Diff File

Issue History

Date Modified Username Field Change
2011-01-19 23:29 thh New Issue
2011-01-19 23:30 thh Relationship added related to 0000032
2011-01-19 23:34 thh Status new => acknowledged
2013-08-15 13:34 thh Target Version 0.01 =>
2013-09-02 06:58 thh Changeset attached => NewsStats next edd250f2