Re: Popcon time-series data points
On Wed, 2018-02-14 at 13:57 +0100, Lucas Nussbaum wrote:
> 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@list
> > s.
>
> 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
Kind reminder.
Cheers,
Nikos
Reply to: