Le Wed, Mar 19, 2025 at 10:44:03AM +0100, Andreas Tille a écrit :
> _for_ _no_ _good_ _reason_-for instance, cases where the maintainer is
> inactive, and nobody truly cares.  Last year I used some UDD query[2]
> 
> udd=> SELECT DISTINCT count(*) FROM sources WHERE release = 'sid' and vcs_url 
> not like '%salsa%' ;
>   2368
> 
> 
> At that time, I stated that I would like to reduce the latter number
> below 2000. As of today, it stands at 1653. However, it was later
> discussed [3] that the old query was incorrect. I have proposed a new
> query [4] that should accurately identify all affected packages:
> 
> 
> udd=> SELECT COUNT(DISTINCT source) FROM sources WHERE release = 'sid' AND
>   (vcs_url IS NULL OR vcs_url like '%alioth.debian.org%' OR vcs_url like 
> '%git.debian.org%' OR vcs_url like '%svn.debian.org%' OR vcs_url like 
> '%anonscm.debian.org%') ;
>  count 
> -------
>   2509
> 
> At the time of writing this query to the list 2025-01-08 this number
> was 2930.  So something happened in the last 2.5 months and I intend
> to continue with this.

Note that this request does not check that the Salsa repository actually
includes the version of the package that is in the archive, so it is
probably overcounting. 

Cheers,
Bill.

Reply via email to