[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

[dak/master] generate_translations: do not include some descriptions more than once



By no longer using s.source in the GROUP BY clause, identical
descriptions for binary packages built by more than one source
no longer appear multiple times in Translation-en.

Bug: http://bugs.debian.org/660543
---
 dak/generate_packages_sources2.py |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/dak/generate_packages_sources2.py b/dak/generate_packages_sources2.py
index 6ef9fd6..151920c 100755
--- a/dak/generate_packages_sources2.py
+++ b/dak/generate_packages_sources2.py
@@ -273,8 +273,8 @@ FROM binaries b
   JOIN source s ON b.source = s.id
 
 WHERE ba.suite = :suite AND o.component = :component
-GROUP BY s.source, b.package, bm_description_md5.value, bm_description.value
-ORDER BY s.source, b.package, bm_description_md5.value
+GROUP BY b.package, bm_description_md5.value, bm_description.value
+ORDER BY MIN(s.source), b.package, bm_description_md5.value
 """
 
 def generate_translations(suite_id, component_id):
-- 
1.7.2.5


Reply to: