X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=daklib%2Flists.py;h=5766371ce8382715937caffadb0a6b7682b679ce;hb=55513d80673e99884067b8820ca1a0b3e9aeeeef;hp=e479685499438b5b49178c298d737ac6b8c9d9c5;hpb=72185ff53839913c25dd68b5e376920390a18b49;p=dak.git diff --git a/daklib/lists.py b/daklib/lists.py index e4796854..5766371c 100644 --- a/daklib/lists.py +++ b/daklib/lists.py @@ -42,7 +42,7 @@ def getSources(suite, component, session, timestamp = None): if timestamp: extra_cond = "AND extract(epoch from sa.created) > %d" % timestamp query = """ - SELECT s.id, archive.path || '/pool/', c.name || '/' || f.filename + SELECT s.id, archive.path || 'pool/', c.name || '/' || f.filename FROM source s JOIN src_associations sa ON s.id = sa.source AND sa.suite = :suite %s @@ -112,7 +112,7 @@ CREATE TEMP TABLE gf_candidates ( source text); INSERT INTO gf_candidates (id, filename, path, architecture, src, source) - SELECT bc.id, c.name || '/' || f.filename, archive.path || '/pool/' , bc.architecture, bc.source as src, s.source + SELECT bc.id, c.name || '/' || f.filename, archive.path || 'pool/' , bc.architecture, bc.source as src, s.source FROM b_candidates bc JOIN source s ON bc.source = s.id JOIN files f ON bc.file = f.id