[dak/master] dak/dakdb/update75.py: fix adding architectures for new and byhand
---
dak/dakdb/update75.py | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/dak/dakdb/update75.py b/dak/dakdb/update75.py
index fb736a5..e668433 100644
--- a/dak/dakdb/update75.py
+++ b/dak/dakdb/update75.py
@@ -131,6 +131,7 @@ def _convert_policy_queues(cnf, c):
FROM policy_queue pq
JOIN suite ON pq.id = suite.policy_queue_id
JOIN suite_architectures sa ON suite.id = sa.suite
+ WHERE pq.queue_name NOT IN ('byhand', 'new')
GROUP BY pq.suite_id, sa.architecture""")
# We only add architectures from suite_architectures to only add
@@ -139,8 +140,7 @@ def _convert_policy_queues(cnf, c):
# to generate Packages indices.
c.execute("""INSERT INTO suite_architectures (suite, architecture)
SELECT DISTINCT pq.suite_id, sa.architecture
- FROM build_queue bq
- JOIN suite_architectures sa
+ FROM policy_queue pq, suite_architectures sa
WHERE pq.queue_name IN ('byhand', 'new')""")
c.execute("""CREATE TABLE policy_queue_upload (
--
1.7.2.5
Reply to: