From 74fd6f47b3683bd727a33f3312582485fa062b95 Mon Sep 17 00:00:00 2001 From: Joris Date: Sun, 31 May 2020 17:47:13 +0200 Subject: Use double quotes instead of simple quotes Follow advice from: https://stackoverflow.com/questions/56011/single-quotes-vs-double-quotes-in-python --- src/db/tags.py | 2 +- src/db/task_tags.py | 2 +- src/db/tasks.py | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) (limited to 'src/db') 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) -- cgit v1.2.3