aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorGravatar jesopo2018-08-31 15:17:15 +0100
committerGravatar jesopo2018-08-31 15:17:15 +0100
commit303cf85ac6a74395d4337307af408d2ec25707f5 (patch)
tree2ce22293d9ae9fb4d83c06902daf8f4e6a8503fa
parentAdd Database.UserChannelSettings.find_all_by_setting (diff)
signature
Turns out we didn't need find_all_by_setting
-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