aboutsummaryrefslogtreecommitdiff
path: root/Database.py
diff options
context:
space:
mode:
authorGravatar jesopo2018-08-31 15:17:15 +0100
committerGravatar dongfix2018-08-31 15:18:59 +0100
commitedc0d9d391dbccb4c66b070c4910663b553c0db2 (patch)
tree2fbcf036fa32d74a7f37fb8c97b14f72bcfdd486 /Database.py
parentAdd Database.UserChannelSettings.find_all_by_setting (diff)
signature
Turns out we didn't need find_all_by_setting
Diffstat (limited to 'Database.py')
-rw-r--r--Database.py12
1 files changed, 0 insertions, 12 deletions
diff --git a/Database.py b/Database.py
index 8ea22b9e..80444cef 100644
--- a/Database.py
+++ b/Database.py
@@ -219,18 +219,6 @@ class UserChannelSettings(Table):
values[i] = value[0], json.loads(value[1])
return values
return default
- def find_all_by_setting(self, channel_id, setting, default=[]):
- values = self.database.execute_fetchall(
- """SELECT users.name, user_channel_settings.value FROM
- user_channel_settings INNER JOIN users ON
- user_channel_settings.user_id=users.user_id
- WHERE user_channel_setting.setting=?
- AND user_channel_settings.channel_id=?""", [setting, channel_id])
- if values:
- for i, value in enumerate(values):
- values[i] = value[0], json.loads(value[1])
- return values
- return default
def delete(self, user_id, channel_id, setting):
self.database.execute(
"""DELETE FROM user_channel_settings WHERE