Changeset 178 in tracdarcs for tracdarcs/updatedb.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/updatedb.py (modified) (2 diffs)

tracdarcs/updatedb.py

@@ -252 +252 @@
         if path in self.ignore_paths_in_db:
             return None
-        q = query_nodes_for_revision(self.repo_id)
-        q += ' AND dnc.path = %s'
-        c = self.db.cursor()
-        c.execute(q, (path,))
+        q,args = query_nodes_for_revision(self.repo_id, cond='dnc.path = %s')
+        args.append(path)
+        c = self.db.cursor()
+        c.execute(q, args)
         row = c.fetchone()
         if row is None:
@@ -279 +279 @@
                 out.append(info)
         c = self.db.cursor()
-        q = query_nodes_for_revision(self.repo_id)
-        q += ' AND dnc.path LIKE %s'
-        c.execute(q, (path+'/%',))
+        q,args = query_nodes_for_revision(self.repo_id, cond='dnc.path LIKE %s')
+        args.append(path+'/%')
+        c.execute(q, args)
         for row in c:
             node_id,rev,path,parent_id = row