diff options
| author | atp (Open ERP) <atp@tinyerp.co.in> | 2010-06-22 10:45:44 +0530 |
|---|---|---|
| committer | atp (Open ERP) <atp@tinyerp.co.in> | 2010-06-22 10:45:44 +0530 |
| commit | b0efd26edd9f4e2aa75424b787ea46d2be15cd04 (patch) | |
| tree | e78cdb693e62a5c9a17f77a395eec51fb34becbf /addons/idea/idea.py | |
| parent | 46bb1ea51be702758d68a5f69db32c82dbccf9bd (diff) | |
| parent | 2319190c5a20cb8095f85cacca89a33164ba93d7 (diff) | |
[MERGE]: merge with lp:~openerp-dev/openobject-addons/trunk-dev-addons2
bzr revid: atp@tinyerp.co.in-20100622051544-c7hig73zk2at66cy
Diffstat (limited to 'addons/idea/idea.py')
| -rw-r--r-- | addons/idea/idea.py | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/addons/idea/idea.py b/addons/idea/idea.py index 20a2904c4e6..dd0a22cf523 100644 --- a/addons/idea/idea.py +++ b/addons/idea/idea.py @@ -68,11 +68,11 @@ class idea_idea(osv.osv): sql = """SELECT i.id, avg(v.score::integer) FROM idea_idea i LEFT OUTER JOIN idea_vote v ON i.id = v.idea_id - WHERE i.id = ANY(%s) + WHERE i.id IN %s GROUP BY i.id """ - cr.execute(sql, (ids,)) + cr.execute(sql, (tuple(ids),)) return dict(cr.fetchall()) def _vote_count(self, cr, uid, ids, name, arg, context=None): @@ -88,11 +88,11 @@ class idea_idea(osv.osv): sql = """SELECT i.id, COUNT(1) FROM idea_idea i LEFT OUTER JOIN idea_vote v ON i.id = v.idea_id - WHERE i.id = ANY(%s) + WHERE i.id IN %s GROUP BY i.id """ - cr.execute(sql, (ids,)) + cr.execute(sql, (tuple(ids),)) return dict(cr.fetchall()) def _comment_count(self, cr, uid, ids, name, arg, context=None): @@ -108,11 +108,11 @@ class idea_idea(osv.osv): sql = """SELECT i.id, COUNT(1) FROM idea_idea i LEFT OUTER JOIN idea_comment c ON i.id = c.idea_id - WHERE i.id = ANY(%s) + WHERE i.id IN %s GROUP BY i.id """ - cr.execute(sql, (ids,)) + cr.execute(sql, (tuple(ids),)) return dict(cr.fetchall()) def _vote_read(self, cr, uid, ids, name, arg, context = None): |