Re: Non-normalised field Provides in UDD table

[Andreas Tille <andreas@an3as.eu>]

On Thu, Apr 12, 2018 at 12:02:38PM +0200, Ole Streicher wrote:
> 
> > It has another really great feature.  It has the following warning
> > output:
> >
> > WARNING:__main__:"filo" has been replaced with "bedtools"
> 
> Where does it get this from? Is this issued when "filo" is a "Provides"?

See

    https://salsa.debian.org/blends-team/blends-gsoc/blob/master/devtools/sec-blend-gen-control

        query = """
        SELECT distinct p.package, p.replaces FROM packages p JOIN releases r ON p.release = r.release
            WHERE r.role='{1}' AND replaces ~ ('((\s|,)'||'({0})'||'(\s+|,|$)|^'||'({0})'||'$)')
        """.format('|'.join(missing),release)

 
> > WARNING:__main__: **Missing package python3-bd2k has the following existing versions:
> > WARNING:__main__:python-bd2k

Same file as above

       query = """
                SELECT DISTINCT p.package, regexp_replace(p.package , '\d|\.', '', 'g')
                 FROM packages p JOIN releases r ON p.release = r.release.
                WHERE r.role='{1}' AND p.package ~ '{0}' order by p.package""".format('|'.join(regex_clause), release)

Hope this helps

    Andreas. 

-- 
http://fam-tille.de