From df94020ef5862b8102042d726f55c2bdb2b614b0 Mon Sep 17 00:00:00 2001
From: jesopo
Date: Sat, 6 Oct 2018 09:54:21 +0100
Subject: Add database.find_by_setting, send github commits to interested
 channels

---
 src/Database.py | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'src/Database.py')

diff --git a/src/Database.py b/src/Database.py
index 27e4f113..c1d07869 100644
--- a/src/Database.py
+++ b/src/Database.py
@@ -140,6 +140,19 @@ class ChannelSettings(Table):
             """DELETE FROM channel_settings WHERE channel_id=?
             AND setting=?""", [channel_id, setting.lower()])
 
+    def find_by_setting(self, setting, default=[]):
+        values = self.database.execute_fetchall(
+            """SELECT channels.server_id, channels.name,
+            channel_settings.value FROM channel_settings
+            INNER JOIN channels ON
+            channel_settings.channel_id=channels.channel_id
+            WHERE channel_settings.setting=?""", [setting])
+        if values:
+            for i, value in enumerate(values):
+                values[i] = value[0], value[1], json.loads(value[2])
+            return values
+        return default
+
 class UserSettings(Table):
     def set(self, user_id, setting, value):
         self.database.execute(
-- 
cgit v1.3.1-10-gc9f91