X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=daemon.py;h=eb36051cf3c5fb9ad43ace00e7f00991e5c7697f;hb=cd1c1b1771dce37f7036793a580107121f6b2ac2;hp=3865980d9dbd6bb6b1fe02008c968941aa7ec0dc;hpb=50efdd86d3fb6d44d86b1250d64de356235134ac;p=fba.git diff --git a/daemon.py b/daemon.py index 3865980..eb36051 100755 --- a/daemon.py +++ b/daemon.py @@ -56,7 +56,7 @@ templates = Jinja2Templates(directory="templates") @router.get(config.get("base_url") + "/api/info.json", response_class=JSONResponse) def api_info(): - database.cursor.execute("SELECT (SELECT COUNT(domain) FROM instances), (SELECT COUNT(domain) FROM instances WHERE software IN ('pleroma', 'mastodon', 'lemmy', 'friendica', 'misskey', 'peertube', 'takahe', 'gotosocial', 'brighteon', 'wildebeest', 'bookwyrm', 'mitra', 'areionskey', 'mammuthus', 'neodb')), (SELECT COUNT(blocker) FROM blocks), (SELECT COUNT(domain) FROM instances WHERE last_error_details IS NOT NULL)") + database.cursor.execute("SELECT (SELECT COUNT(domain) FROM instances), (SELECT COUNT(domain) FROM instances WHERE software IN ('pleroma', 'mastodon', 'lemmy', 'friendica', 'misskey', 'peertube', 'takahe', 'gotosocial', 'brighteon', 'wildebeest', 'bookwyrm', 'mitra', 'areionskey', 'mammuthus', 'neodb', 'smithereen', 'vebinet')), (SELECT COUNT(blocker) FROM blocks), (SELECT COUNT(domain) FROM instances WHERE last_error_details IS NOT NULL)") row = database.cursor.fetchone() return JSONResponse(status_code=200, content={ @@ -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() @@ -537,4 +537,10 @@ def index(request: Request): }) if __name__ == "__main__": - uvicorn.run("daemon:router", host=config.get("host"), port=config.get("port"), log_level=config.get("log_level"), proxy_headers=True) + uvicorn.run( + "daemon:router", + host=config.get("host"), + port=config.get("port"), + log_level=config.get("log_level"), + proxy_headers=True + )