[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: