Re: New upstream data in blends query
Hi Andreas,
I'll combine your two e-mails.
Andreas Tille <andreas@an3as.eu> writes:
> There are no such fields Upstream-Bugs in any of the upstream files:
>
> $ grep Upstream-Bugs /srv/udd/mirrors/machine-readable/*/*.upstream
>
> So what exactly are you missing?
You inserted into website/webtools/blendstasktools into statement
"PREPARE query_pkgs text[],text[],text) AS
SELECT * FROM blends_query_packages($1,$2,$3) AS (...)"
the fields
"upstream_bugs" text,
"upstream_repository" text,
"edam_topics" text[]
(325155e9 2016-02-21 08:32:34 +0100). at the end, and these I referred to here.
Andreas Tille <andreas@an3as.eu> writes:
> On Fri, Mar 04, 2016 at 01:46:46PM +0100, Ole Streicher wrote:
>> Something is not completely working here: I get no upstream_repository
>> entry, and also only a few upstream_bugs entries, although I have quite
>> many packages with d/u/metadata conteining them. Somehow they don't pass
>> via UDD.
>
> udd=> select key, count(*) from upstream_metadata group by key order by key;
> key | count
> -------------------+-------
> ASCL-Id | 3
> Bug-Database | 683
> Bug-Submit | 34
> Repository | 538
> Repository-Browse | 583
That sounds reasonable. However, in the in the "upstream_bugs" column
stated above (which should match to the "Bug-Database" in
upstream_metadata), there are just a few entries. And the
"upstream_repository" column in the prepared statement on top, there are
no entries at all (for debian-astro), while the fields are there.
Best regards
Ole
Reply to: