Changeset 457

Timestamp:

09/12/08 14:36:31 (5 years ago)

Author:

cbalan

Message:

UserManager?: - Fixed get_usernames_with_attributes's sql.

File:

• trunk/plugins/usermanagerplugin/tracusermanager/api.py (modified) (1 diff)

trunk/plugins/usermanagerplugin/tracusermanager/api.py

@@ -470 +470 @@
                     return "name=%s AND value " + (k.startswith('NOT_') and 'NOT' or '') + " LIKE %s"
                     
-                cursor.execute("SELECT sid, count(sid) cnt"
+                cursor.execute("SELECT sid"
                                " FROM session_attribute"
                                " WHERE " + " OR ".join([ _get_condition(k,v) for k,v in attributes_dict.items()]) +
                                " GROUP BY sid"
-                               " HAVING cnt=%s", attributes_list)
-                
-            return [id for id, cnd in cursor]
+                               " HAVING count(*)=%s", attributes_list)
+            return [id for id, in cursor]
         except Exception, e:
             out = StringIO()