On 14/02/18 at 13:43 +0100, Bill Allombert wrote: > On Wed, Feb 14, 2018 at 12:47:17PM +0100, Lucas Nussbaum wrote: > > (Adding popcon developers to Cc, and reordering paragraphs so that it's > > easier to follow) > > Hello Lucas, > Please note that popcon-developers@alioth is now debian-popcon@lists.
ah, sorry, I missed that list. > > OK, I looked into how the popcon graphs are implemented. > > > > If nobody objects by 2018-02-21, I'll send you the output of > > > > select p.day, package, p.vote, p.old, p.recent, p.no_files, > > submissions > > from popcon_package pp > > join popcon p on (pp.id = p.package_id) > > join popcon_day pd on (pd.day = p.day) > > where in_debian order by p.day; > > The popcon graphs are only available for official packages. > Please make sure you only send the data for the packages for > which the graphs are available. Right, I think that's what 'in_debian' does in the above query. At least that's what 'select * from popcon_package where not in_debian;' makes me think. Lucas
