Re: Popcon time-series data points
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
Reply to: