Changeset 178 in tracdarcs for tracdarcs/repository.py

Timestamp:

05/12/10 18:40:53 (2 years ago)

Author:

lele@…

Hash name:

20100512164053-97f81-e69d930ef723d57a771c19c6a23bc5ed9781b30a

Message:

Use a parametrized query

File:

• tracdarcs/repository.py (modified) (2 diffs)

tracdarcs/repository.py

@@ -95 +95 @@
         else:
             c = self.db.cursor()
-            q = query_nodes_for_revision(self.id, rev)
-            q += ' AND dnc.path = %s'
-            c.execute(q, (path,))
+            q,args = query_nodes_for_revision(self.id, rev, 'dnc.path = %s')
+            args.append(path)
+            c.execute(q, args)
             row = c.fetchone()
             if row is None:
@@ -334 +334 @@
         if self.__node_type == NODE_FILE_TYPE:
             return
-        q = query_nodes_for_revision(self.repos.id, self.rev)
         if self.__node_id is None:
-            q += ' AND dnc.parent_id IS NULL'
-        else:
-            q += ' AND dnc.parent_id = %d' % self.__node_id
-        c = self.repos.db.cursor()
-        c.execute(q)
+            cond = 'dnc.parent_id IS NULL'
+        else:
+            cond = 'dnc.parent_id = %d' % self.__node_id
+        q,args = query_nodes_for_revision(self.repos.id, self.rev, cond)
+        c = self.repos.db.cursor()
+        c.execute(q, args)
         for node_id,rev,path,_ in c:
             node_type = get_node_type(self.repos.db, self.repos.id, node_id)