... and it doesn't happen much, at the sqlite timeline as well as the
fossil timeline. Enjoy the couples of days off!

As it's unusual hot here and that would be some kind of excuse to just
tinker around I tried to come up with an orderd list of the longest time
spans without any commit in a repository.

It may be the heat or my SQL is to limited or my limited understanding
of the fossil database inner yard or all together but the closest I was
able to find within a half hour is:

select datetime(b.mtime), datetime(a.mtime), a.mtime - b.mtime
from event as a, event as b
where a.mtime > b.mtime
and a.type = 'ci'
and b.type = 'ci'
-- limit to past years, if you wish
-- and cast (strftime('%Y', a.mtime) as integer) > 2012
and not exists (select 1 from event
                where event.mtime < a.mtime
                and event.mtime > b.mtime)
select datetime(c.mtime), datetime('now'), julianday('now') - c.mtime
from event as c
where c.type = 'ci'
and not exists (select 1 from event where mtime > c.mtime)
order by 3 desc
limit 100;

Although, that is painful slow. Is there a better way?

While trying this I missed some explanation of the database schema -
what is stored in which tables, what are the relations between the
tables - or my search fu missed me. Is there something like this?

It's not so hard, to find its way by just looking at the thing and the
source code. But then there is obviously fine print. Say: The fossil
repository as of 2dec4bdf has 9587 rows with type 'ci' in the event
table, but the UI says and shows only 9553 check-ins. So some of the
'ci' type rows of event doesn't document a check-in, but something else.
Maybe something related to shuning - but looking at that table doesn't
show a clear match, so ...

fossil-users mailing list

Reply via email to