From 72185ff53839913c25dd68b5e376920390a18b49 Mon Sep 17 00:00:00 2001 From: Ansgar Burchardt Date: Sun, 12 Aug 2012 18:16:28 +0200 Subject: [PATCH] daklib/lists.py: update for multiarch changes --- daklib/lists.py | 22 ++++++++++++++++------ 1 file changed, 16 insertions(+), 6 deletions(-) diff --git a/daklib/lists.py b/daklib/lists.py index 320184e3..e4796854 100644 --- a/daklib/lists.py +++ b/daklib/lists.py @@ -42,14 +42,20 @@ def getSources(suite, component, session, timestamp = None): if timestamp: extra_cond = "AND extract(epoch from sa.created) > %d" % timestamp query = """ - SELECT s.id, l.path, 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 + JOIN suite + ON sa.suite = suite.id + JOIN archive + ON suite.archive_id = archive.id JOIN files f ON s.file = f.id - JOIN location l - ON f.location = l.id AND l.component = :component + JOIN files_archive_map fam + ON fam.file_id = f.id AND fam.component_id = :component + JOIN component c + ON fam.component_id = c.id ORDER BY filename """ % extra_cond args = { 'suite': suite.suite_id, @@ -106,12 +112,16 @@ CREATE TEMP TABLE gf_candidates ( source text); INSERT INTO gf_candidates (id, filename, path, architecture, src, source) - SELECT bc.id, f.filename, l.path, 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 - JOIN location l ON f.location = l.id - WHERE l.component = :component; + JOIN files_archive_map fam ON f.id = fam.file_id + JOIN component c ON fam.component_id = c.id + JOIN archive ON fam.archive_id = archive.id + JOIN suite ON suite.archive_id = archive.id + + WHERE c.id = :component AND suite.id = :suite; WITH arch_any AS -- 2.39.5