X-Git-Url: https://code.th-h.de/?p=usenet%2Fnewsstats.git;a=blobdiff_plain;f=doc%2FTODO;h=7d6e794361cf1dff07ea59e8601255004335801f;hp=444886a267863279c1816cba64f8882c53c7725d;hb=1703b8e3b454713d4f873acdb5cb400db490a152;hpb=147194c1900490a15e933a3a2c79263a65b9f08e
diff --git a/doc/TODO b/doc/TODO
index 444886a..7d6e794 100644
--- a/doc/TODO
+++ b/doc/TODO
@@ -29,6 +29,9 @@ Bug numbers refer to the Mantis issue tracker at .
- Add other reports
NewsStats should include some other kinds of reports (stats on used clients,
on postings hosts/servers, ...)
+ - Add tools for database management
+ NewsStats should offer tools e.g. to inject postings into the 'raw' database,
+ or to split databases.
* Individual improvements
+ NewsStats.pm
@@ -43,38 +46,20 @@ Bug numbers refer to the Mantis issue tracker at .
- General tests and optimisations
+ feedlog.pl
+ - Gracefully handle interruptions to database connection, at least log
+ lost postings (Bug #30).
+ - Buffer output that cannot be written to database (Bug #31).
- Add / enhance / test error handling
- General tests and optimisations
+ gatherstats.pl
- - Fix database updates when re-running (Bug #18)
- Change REPLACE to DELETE with subsequent INSERT INTO (erase wrong data,
- i.e. non-existent groups)
- - Enhance TLH checks to allow for more than one TLH
- - Make gatherstats aware of hierarchy lists (Bug #17)
- A current (!) list of existing groups (checkgroups or INN active) should
- be honored, with optional modifications. Non-existing groups should be
- (logged and) dropped, existing groups with no postings should be set to 0.
- Hierarchy elements (*.ALL) must be taken into account.
- Perhaps invalid group names should also be checked (but what characters
- should be considered "invalid"?)
- GroupInfo (see above) could be an alternate solution.
+ - Use hierarchy information (see GroupInfo above)
- Add gathering of other stats (clients, hosts, ...)
- better modularisation (code reuse for other reports!)
- Add / enhance / test error handling
- General tests and optimisations
+ groupstats.pl
- - output: fix formatting - GetMaxLength does not work for special queries
- like -l or -b
- - beautify output (formats / captions)
- - -a: improve code - it doesn't make that much sense to get first/last
- month from database just to query that same database with a time period
- that equals no time period ... this part of the WHERE clause should be
- dropped instead
- - change precedence handling of -m/-p/-a: drop -m if -p or -a are present,
- drop -p if -a is present
- - save report(s) to a file (Bug #27)
- better modularisation (code reuse for other reports!)
- Add / enhance / test error handling
- General tests and optimisations