From 68b730887b6207719256e9fcff548bef3a8cf130 Mon Sep 17 00:00:00 2001 From: Ansgar Burchardt Date: Sat, 7 Jul 2012 18:12:19 -0600 Subject: [PATCH] daklib/contents.py: update for multi-archive changes --- daklib/contents.py | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/daklib/contents.py b/daklib/contents.py index 02abe1f9..2fb7dfcd 100644 --- a/daklib/contents.py +++ b/daklib/contents.py @@ -183,10 +183,9 @@ create index sources_binaries_by_source on newest_sources (source); insert into newest_sources (id, source) select distinct on (source) s.id, s.source from source s - join files f on f.id = s.file - join location l on l.id = f.location + join files_archive_map af on s.file = af.file_id where s.id in (select source from src_associations where suite = :suite_id) - and l.component = :component_id + and af.component_id = :component_id order by source, version desc;''' self.session.execute(sql_create_temp, params=params) -- 2.39.2