summaryrefslogtreecommitdiffstats
path: root/packages
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2012-08-15 15:22:01 +0200
committerDan McGee <dan@archlinux.org>2012-08-15 15:22:01 +0200
commita071d800c6a26d3efcdc0d32fe1adb1cde7e6f31 (patch)
tree3e71009b9c6c4e167baac4a5afbaaa77212c6379 /packages
parentca0011c585ec28f9dde0f400a77fd6f859d520b0 (diff)
downloadarchweb-a071d800c6a26d3efcdc0d32fe1adb1cde7e6f31.tar.gz
archweb-a071d800c6a26d3efcdc0d32fe1adb1cde7e6f31.tar.xz
Fix signoffs SQL query
Although the old query returned the same results, the repos IN clause should really be a part of the WHERE, not the JOIN condition. Signed-off-by: Dan McGee <dan@archlinux.org>
Diffstat (limited to 'packages')
-rw-r--r--packages/utils.py3
1 files changed, 2 insertions, 1 deletions
diff --git a/packages/utils.py b/packages/utils.py
index d95c015..ee1b56b 100644
--- a/packages/utils.py
+++ b/packages/utils.py
@@ -363,6 +363,7 @@ class PackageSignoffGroup(object):
return u'%s-%s (%s): %d' % (
self.pkgbase, self.version, self.arch, len(self.signoffs))
+
_SQL_SPEC_OR_SIGNOFF = """
SELECT DISTINCT s.id
FROM %s s
@@ -374,7 +375,7 @@ SELECT DISTINCT s.id
AND s.arch_id = p.arch_id
AND s.repo_id = p.repo_id
)
- AND p.repo_id IN (%s)
+ WHERE p.repo_id IN (%s)
"""