From c457f1e1a8507b99ba204172464a350dad220731 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Sun, 10 Dec 2023 23:08:50 +0100 Subject: [PATCH] Continued: - Python still needs a backslash here --- daemon.py | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/daemon.py b/daemon.py index c876651..695ab04 100755 --- a/daemon.py +++ b/daemon.py @@ -472,10 +472,10 @@ def rss(request: Request, domain: str = None): wildchar = "*." + ".".join(domain.split(".")[-domain.count("."):]) punycode = domain.encode("idna").decode("utf-8") - database.cursor.execute("SELECT blocker, blocked, block_level, reason, first_seen, last_seen -FROM blocks -WHERE blocked = ? OR blocked = ? OR blocked = ? OR blocked = ? OR blocked = ? OR blocked = ? -ORDER BY first_seen DESC + database.cursor.execute("SELECT blocker, blocked, block_level, reason, first_seen, last_seen \ +FROM blocks \ +WHERE blocked = ? OR blocked = ? OR blocked = ? OR blocked = ? OR blocked = ? OR blocked = ? \ +ORDER BY first_seen DESC \ LIMIT ?", [ domain, "*." + domain, wildchar, @@ -485,9 +485,9 @@ LIMIT ?", [ config.get("rss_limit") ]) else: - database.cursor.execute("SELECT blocker, blocked, block_level, reason, first_seen, last_seen -FROM blocks -ORDER BY first_seen DESC + database.cursor.execute("SELECT blocker, blocked, block_level, reason, first_seen, last_seen \ +FROM blocks \ +ORDER BY first_seen DESC \ LIMIT ?", [config.get("rss_limit")]) result = database.cursor.fetchall() -- 2.39.5