diff options
| author | 2018-08-31 15:17:15 +0100 | |
|---|---|---|
| committer | 2018-08-31 15:18:59 +0100 | |
| commit | edc0d9d391dbccb4c66b070c4910663b553c0db2 (patch) | |
| tree | 2fbcf036fa32d74a7f37fb8c97b14f72bcfdd486 | |
| parent | Add Database.UserChannelSettings.find_all_by_setting (diff) | |
| signature | ||
Turns out we didn't need find_all_by_setting
| -rw-r--r-- | Database.py | 12 |
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 |
