diff options
| author | Joris | 2020-05-31 17:47:13 +0200 |
|---|---|---|
| committer | Joris | 2020-05-31 17:47:14 +0200 |
| commit | 74fd6f47b3683bd727a33f3312582485fa062b95 (patch) | |
| tree | 87d4a3045e5585dde9e75cf957e755f47de61775 /src/db | |
| parent | 1bed85a9b107d1b03e71b848829cb7b1f33060f4 (diff) | |
Use double quotes instead of simple quotes
Follow advice from:
https://stackoverflow.com/questions/56011/single-quotes-vs-double-quotes-in-python
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) |