diff options
Diffstat (limited to 'src/db')
-rw-r--r-- | src/db/tags.py | 2 | ||||
-rw-r--r-- | src/db/task_tags.py | 2 | ||||
-rw-r--r-- | src/db/tasks.py | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/src/db/tags.py b/src/db/tags.py index 76a276d..666bd1e 100644 --- a/src/db/tags.py +++ b/src/db/tags.py @@ -68,5 +68,5 @@ def update(cursor: Cursor, tag: Tag, form: ValidTagForm): def delete(cursor: Cursor, ids): if len(ids) >= 1: cursor.execute( - 'DELETE FROM tags WHERE id IN (%s)' % ','.join('?'*len(ids)), + "DELETE FROM tags WHERE id IN (%s)" % ",".join("?"*len(ids)), ids) diff --git a/src/db/task_tags.py b/src/db/task_tags.py index 93dc627..e8c0ee0 100644 --- a/src/db/task_tags.py +++ b/src/db/task_tags.py @@ -35,5 +35,5 @@ def insert_many(cursor: Cursor, task_id: int, tag_ids: List[int]) -> List[TaskTa def delete(cursor: Cursor, task_ids: List[int]): if len(task_ids) >= 1: cursor.execute( - 'DELETE FROM task_tags WHERE task_id IN (%s)' % ','.join('?'*len(task_ids)), + "DELETE FROM task_tags WHERE task_id IN (%s)" % ",".join("?"*len(task_ids)), task_ids) diff --git a/src/db/tasks.py b/src/db/tasks.py index b72965b..142abae 100644 --- a/src/db/tasks.py +++ b/src/db/tasks.py @@ -86,5 +86,5 @@ def update(cursor: Cursor, task: Task, form: ValidTaskForm): def delete(cursor: Cursor, ids): if len(ids) >= 1: cursor.execute( - 'DELETE FROM tasks WHERE id IN (%s)' % ','.join('?'*len(ids)), + "DELETE FROM tasks WHERE id IN (%s)" % ",".join("?"*len(ids)), ids) |