# HG changeset patch
# User Sylvain Thénault <sylvain.thenault@logilab.fr>
# Date 1286903443 -7200
# Node ID 3234d8d6e264212c5589c2b5353bfd28dbe2f925
# Parent  150246e77cda136dbe4c959428bfa9dea8b69328
[selector] more efficient rql_condition by simply retreiving COUNT()

diff -r 150246e77cda -r 3234d8d6e264 selectors.py
--- a/selectors.py	Tue Oct 12 19:10:08 2010 +0200
+++ b/selectors.py	Tue Oct 12 19:10:43 2010 +0200
@@ -1143,9 +1143,9 @@
     def __init__(self, expression, once_is_enough=False):
         super(rql_condition, self).__init__(once_is_enough)
         if 'U' in frozenset(split_expression(expression)):
-            rql = 'Any X WHERE X eid %%(x)s, U eid %%(u)s, %s' % expression
+            rql = 'Any COUNT(X) WHERE X eid %%(x)s, U eid %%(u)s, %s' % expression
         else:
-            rql = 'Any X WHERE X eid %%(x)s, %s' % expression
+            rql = 'Any COUNT(X) WHERE X eid %%(x)s, %s' % expression
         self.rql = rql
 
     def __repr__(self):
@@ -1153,8 +1153,8 @@
 
     def score(self, req, rset, row, col):
         try:
-            return len(req.execute(self.rql, {'x': rset[row][col],
-                                              'u': req.user.eid}))
+            return req.execute(self.rql, {'x': rset[row][col],
+                                          'u': req.user.eid})[0][0]
         except Unauthorized:
             return 0