diff options
| author | 2019-12-01 07:05:01 +0000 | |
|---|---|---|
| committer | 2019-12-01 07:05:01 +0000 | |
| commit | b3853233861b92f15d546d724b13bbe264f7877e (patch) | |
| tree | d43ccd8c99dc0c4d077300dd5a3f62cb32f09ed5 | |
| parent | utils.irc.parse_hostmask -> utils.irc.hostmask_parse (diff) | |
| signature | ||
fix database.user_settings.find logic
| -rw-r--r-- | src/Database.py | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/Database.py b/src/Database.py index d734eaf7..7e25b03e 100644 --- a/src/Database.py +++ b/src/Database.py @@ -211,9 +211,9 @@ class UserSettings(Table): return values return default def find(self, user_id: int, pattern: str, default: typing.Any=[]): - values = self.database.execute( + values = self.database.execute_fetchall( """SELECT setting, value FROM user_settings WHERE - user_id=? AND setting LIKE '?'""", [user_id, pattern.lower()]) + user_id=? AND setting LIKE ?""", [user_id, pattern.lower()]) if values: for i, value in enumerate(values): values[i] = value[0], json.loads(value[1]) @@ -246,7 +246,7 @@ class UserChannelSettings(Table): default: typing.Any=[]): values = self.database.execute_fetchall( """SELECT setting, value FROM user_channel_settings WHERE - user_id=? AND channel_id=? AND setting LIKE '?'""", + user_id=? AND channel_id=? AND setting LIKE ?""", [user_id, channel_id, pattern.lower()]) if values: for i, value in enumerate(values): |
