... 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) union 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 email@example.com http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users