damned-lies r1351 - in trunk: . stats/management/commands

[ogmaciel svn gnome org]

Author: ogmaciel
Date: Thu Jan 15 19:25:03 2009
New Revision: 1351
URL: http://svn.gnome.org/viewvc/damned-lies?rev=1351&view=rev

Log:
Removed the optional DISTINCT keyword for the update-trans script as it broke sqlite.

Modified:
   trunk/ChangeLog
   trunk/stats/management/commands/update-trans.py

Modified: trunk/stats/management/commands/update-trans.py
==============================================================================
--- trunk/stats/management/commands/update-trans.py	(original)
+++ trunk/stats/management/commands/update-trans.py	Thu Jan 15 19:25:03 2009
@@ -38,11 +38,11 @@
         # Extract DB translatable strings into database-content.py
         dbfile = os.path.join(os.path.abspath('.'), 'database-content.py')
         f=open(dbfile, 'w')
-        query = """SELECT description FROM team UNION DISTINCT
-                   SELECT name from language WHERE name <> locale UNION DISTINCT
-                   SELECT description FROM domain UNION DISTINCT
-                   SELECT description FROM module WHERE description <> name UNION DISTINCT
-                   SELECT comment FROM module WHERE comment IS NOT NULL AND comment <> '' UNION DISTINCT
+        query = """SELECT description FROM team UNION 
+                   SELECT name from language WHERE name <> locale UNION 
+                   SELECT description FROM domain UNION 
+                   SELECT description FROM module WHERE description <> name UNION 
+                   SELECT comment FROM module WHERE comment IS NOT NULL AND comment <> '' UNION 
                    SELECT description FROM "release" """
         cursor = connection.cursor()
         if settings.DATABASE_ENGINE == 'mysql':