aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorGravatar jesopo2019-12-01 07:05:01 +0000
committerGravatar jesopo2019-12-01 07:05:01 +0000
commitb3853233861b92f15d546d724b13bbe264f7877e (patch)
treed43ccd8c99dc0c4d077300dd5a3f62cb32f09ed5 /src
parentutils.irc.parse_hostmask -> utils.irc.hostmask_parse (diff)
signature
fix database.user_settings.find logic
Diffstat (limited to 'src')
-rw-r--r--src/Database.py6
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):