Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Newer
Older
100644 67 lines (48 sloc) 1.825 kB
db2a89c @mrjbq7 Initial version.
authored
1 ==========
2 TODO
3 ==========
4
5 Some various ideas for improving tracstats (in no particular order):
6
7 * Select by author, path, file extension, etc.
8 * Most edited files, directories, projects, etc.
9 * Active users by revisions, by changes, by frequency, etc.
10 * Commits - total, first, last, average-per-day, etc.
11 * Graphs by day-of-week, by hour-of-day, etc.
12 * Percent of codebase modified
13 * Percent of paths modified
14 * Lines of code changed - average, top 10, etc.
15 * Ticket duration (open to close) -- worst, best, average, etc.
16 * Ticket response time (open to first response) -- same...
17
18 Perhaps we should separate into sections:
19
20 * Project Summary
21 * Developer Leaderboard
22 * Developer Profile
23 * Codebase Statistics
24 * Wiki Statistics
25 * Tickets Statistics
26 * Recent Activity
27
28 Main page::
29
30 Total # of authors
31 Total revisions
32 Total pages
33 Total tickets
34
35 [X] Code [X] Wiki [X] Tickets
36
37 [ Code Changes ] [ Wiki Changes ] [Ticket Changes ]
38
39 Latest commits
40 #120234 "Something is changed..." committed "2 hours ago" by "username"
41
42 Latest wiki changes
43 "WikiPage" changed "4 hours ago" by "username"
44
45 Latest tickets reported
46 #34234 "Something is broken" reported "14 hours ago" by "username"
47
48 Tickets::
49
50 Open
51 Critical
52 New
53 Unassigned
54 All bugs ever reported
55
56 Detect languages used (perhaps just file extensions)::
57
58 Languages: Python, C, Assembly
59
60 Performance::
61
62 time sqlite3 trac.db "select rev, path, change_type, author from node_change join revision using (rev)" > ~/foo
63 time sqlite3 trac.db "select rev, path, change_type from node_change" > ~/foo
64 time sqlite3 trac.db "select rev, path, change_type from node_change left join revision rev using (rev)" > ~/foo
65 time sqlite3 trac.db "select rev, path, change_type from node_change" > ~/foo
66
Something went wrong with that request. Please try again.