[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

[dak/master] dominate: Use a bulk DELETE



Signed-off-by: Niels Thykier <niels@thykier.net>
---
 dak/dominate.py | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/dak/dominate.py b/dak/dominate.py
index accb0df..600d112 100755
--- a/dak/dominate.py
+++ b/dak/dominate.py
@@ -87,11 +87,11 @@ def deleteAssociations(table, idList, session):
     query = """
         DELETE
             FROM %s
-            WHERE id = :id
+            WHERE id IN :idList
     """ % table
-    params = [{'id': id} for id in idList]
-    if len(params) == 0:
+    if not idList:
         return
+    params = {'idList': tuple(idList)}
     session.execute(query, params)
 
 def doDaDoDa(suite, session):
-- 
2.1.4



Reply to: