Re: Determining svn conversion order

[Ross Golder <ross golder org>]

เมื่อ พ. 2006-02-15 เวลา 05:03 -0800, C.J. Adams-Collier เขียนว่า:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Ross Golder wrote:
> > เมื่อ จ. 2006-02-13 เวลา 13:48 -0500, Joe Shaw เขียนว่า:
> >> Hey,
> >>
> >> It's hardly scientific, but you might want to prioritize based on
> >>  activity statistics from CIA:
> >>
> >> http://cia.navi.cx/stats/project/gnome
> >>
> > ...
> >>
> >> I noticed that rather big modules like, oh, say, gtk+ were
> >> missing. :)
> >
> > I thought of another way - using our bonsai checkins database. A
> > few minutes playing around and I came up with this :
> >
> > select substr(repositories.repository from 12) as module,
> > count(checkins.repositoryid) as tot from checkins, repositories
> > where checkins.repositoryid = repositories.id and checkins.ci_when
> > > date_sub(curdate(), interval 1 year) group by
> > checkins.repositoryid order by tot desc;
> >
> > This turns up the resultset you can find here:
> >
> > http://www.gnome.org/~rossg/migrations.csv
> >
> > I see 'gtk+' and 'gimp' at the top, amongst the other main
> > high-profile projects :)
> >
> > -- Ross
> >
> IMHO, we should also take into account projects that have stood
> inactive for a long period of time and that are now seeing a lot of
> traffic.
> 
> Don't tell anybody, but my sql-foo is not as great as Ross'
> 

Sorry. Basically, it means 'select the total number of commits per
module from the commits made in the last year and sort in descending
order'.

--
Ross