Hiho,
On Fri, Jan 11, 2013 at 9:04 PM, j. v. d. hoff <veedeeh...@googlemail.com>wrote:
> e.g. for the fossil repo itself (as of today at e4ca677a6c), `fossil info'
> reports
>
> checkin-count: 4845
>
> however, I do see a total (files+wiki+ticket) of 8799 checkins and
>
> fossil time -t ci -n 11111|grep ^[0-9]|wc -l
> yields 4009.
>
i just tried that grep and still get the same 4009, though there have been
commits since then that time:
stephan@tiny:~/cvs/fossil/fossil$ f time -t ci
=== 2013-01-13 ===
02:01:18 [a0dd51e9af] *CURRENT* Allow the FOSSIL_USER environment variable
to
be used as a fallback when creating a new repository. (user:
mistachkin tags: trunk)
...
stephan@tiny:~/cvs/fossil/fossil$ f time -t ci -n 11111|grep ^[0-9]|wc -l
4009
So apparently there's a flaw with that counting logic (but i don't see what
it is off hand).
>
> so what is `checkin-count' actually reporting??
>
i tried a second query for this and get results comparable (but not
identical) to the /stat page:
stephan@tiny:~/cvs/fossil/fossil$ sqlite3 ../fossil.fsl
...
sqlite> select count(*) from blob b JOIN event e where b.rid=e.objid and
e.type='ci';
4890
"info" (or the /stat page) says:
stephan@tiny:~/cvs/fossil/fossil$ f info
...
checkin-count: 4846
version: This is fossil version 1.25 [0fb6c829f2] 2013-01-08 16:55:39 UTC
For ticket and wiki modifications i get these numbers:
sqlite> select count(*) from blob b JOIN event e where b.rid=e.objid and
e.type='t';
3137
sqlite> select count(*) from blob b JOIN event e where b.rid=e.objid and
e.type='w';
282
and events:
sqlite> select count(*) from blob b JOIN event e where b.rid=e.objid and
e.type='e';
4
For a total number of repository "events" (not to be confused with "Event"
entries) of:
sqlite> select count(*) from event;
8802
(note that i skipped over (e.type='g'))
> what I currently would find most useful is to see the total number (8799
> in the example), but maybe instead a more
> detailed statistics (file ci: xxx; wiki ci: yyyy, bug ci: zzzz) is also of
> interest.
>
The wiki/ticket change counts seem to [me to] be quite unambiguous, but i'm
still not sure which of these two queries is "more correct" for file
commits:
sqlite> select count(*) from blob b JOIN event e where b.rid=e.objid and
e.type='ci';
4890
or
sqlite> SELECT count(distinct mid) FROM mlink;
4846
While the former "seems" to me to be correct, the latter has been in use
since Ancient Times in the /stat page, so i suspect that it is the correct
one.
Thoughts?
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
