fetch_blocks.py

   1 from requests import get
   2 from hashlib import sha256
   3 import sqlite3
   4 from bs4 import BeautifulSoup
   5
   6 headers = {
   7     "user-agent": "Mozilla/5.0 (Windows NT 10.0; rv:91.0) Gecko/20100101 Firefox/91.0"
   8 }
   9
  10
  11 def get_mastodon_blocks(domain: str) -> dict:
  12     blocks = {
  13         "Suspended servers": [],
  14         "Filtered media": [],
  15         "Limited servers": [],
  16         "Silenced servers": [],
  17     }
  18
  19     translations = {
  20         "Gesperrte Server": "Suspended servers",
  21         "Gefilterte Medien": "Filtered media",
  22         "Stummgeschaltete Server": "Silenced servers",
  23         "停止済みのサーバー": "Suspended servers",
  24         "メディアを拒否しているサーバー": "Filtered media",
  25         "サイレンス済みのサーバー": "Silenced servers",
  26         "Serveurs suspendus": "Suspended servers",
  27         "Médias filtrés": "Filtered media",
  28         "Serveurs limités": "Silenced servers",
  29     }
  30
  31     try:
  32         doc = BeautifulSoup(
  33             get(f"https://{domain}/about/more", headers=headers, timeout=5).text,
  34             "html.parser",
  35         )
  36     except:
  37         return {}
  38
  39     for header in doc.find_all("h3"):
  40         for line in header.find_next_siblings("table")[0].find_all("tr")[1:]:
  41             header_text = header.text
  42             if header_text in translations:
  43                     header_text = translations[header_text]
  44             if header_text in blocks:
  45                 blocks[header_text].append(
  46                     {
  47                         "domain": line.find("span").text,
  48                         "hash": line.find("span")["title"][9:],
  49                         "reason": line.find_all("td")[1].text.strip(),
  50                     }
  51                 )
  52     return {
  53         "reject": blocks["Suspended servers"],
  54         "media_removal": blocks["Filtered media"],
  55         "federated_timeline_removal": blocks["Limited servers"]
  56         + blocks["Silenced servers"],
  57     }
  58
  59
  60 def get_hash(domain: str) -> str:
  61     return sha256(domain.encode("utf-8")).hexdigest()
  62
  63
  64 def get_type(domain: str) -> str:
  65     try:
  66         res = get(f"https://{domain}/nodeinfo/2.1.json", headers=headers, timeout=5)
  67         if res.status_code == 404:
  68             res = get(f"https://{domain}/nodeinfo/2.0.json", headers=headers, timeout=5)
  69         if res.ok and "text/html" in res.headers["content-type"]:
  70             res = get(f"https://{domain}/nodeinfo/2.1", headers=headers, timeout=5)
  71         if res.ok:
  72             if res.json()["software"]["name"] == "akkoma"
  73                 return "pleroma"
  74             else
  75                 return res.json()["software"]["name"]
  76         elif res.status_code == 404:
  77             res = get(f"https://{domain}/api/v1/instance", headers=headers, timeout=5)
  78         if res.ok:
  79             return "mastodon"
  80     except:
  81         return None
  82
  83
  84 conn = sqlite3.connect("blocks.db")
  85 c = conn.cursor()
  86
  87 c.execute(
  88     "select domain, software from instances where software in ('pleroma', 'mastodon')"
  89 )
  90
  91 for blocker, software in c.fetchall():
  92     if software == "pleroma":
  93         print(blocker)
  94         try:
  95             # Blocks
  96             federation = get(
  97                 f"https://{blocker}/nodeinfo/2.1.json", headers=headers, timeout=5
  98             ).json()["metadata"]["federation"]
  99             if "mrf_simple" in federation:
 100                 for block_level, blocks in (
 101                     {**federation["mrf_simple"],
 102                     **{"quarantined_instances": federation["quarantined_instances"]}}
 103                 ).items():
 104                     for blocked in blocks:
 105                         if blocked == "":
 106                             continue
 107                         c.execute(
 108                             "select domain from instances where domain = ?", (blocked,)
 109                         )
 110                         if c.fetchone() == None:
 111                             c.execute(
 112                                 "insert into instances select ?, ?, ?",
 113                                 (blocked, get_hash(blocked), get_type(blocked)),
 114                             )
 115                         c.execute(
 116                             "select * from blocks where blocker = ? and blocked = ? and block_level = ?",
 117                             (blocker, blocked, block_level),
 118                         )
 119                         if c.fetchone() == None:
 120                             c.execute(
 121                                 "insert into blocks select ?, ?, '', ?",
 122                                 (blocker, blocked, block_level),
 123                             )
 124             conn.commit()
 125             # Reasons
 126             if "mrf_simple_info" in federation:
 127                 for block_level, info in (
 128                     {**federation["mrf_simple_info"],
 129                     **(federation["quarantined_instances_info"]
 130                     if "quarantined_instances_info" in federation
 131                     else {})}
 132                 ).items():
 133                     for blocked, reason in info.items():
 134                         c.execute(
 135                             "update blocks set reason = ? where blocker = ? and blocked = ? and block_level = ?",
 136                             (reason["reason"], blocker, blocked, block_level),
 137                         )
 138             conn.commit()
 139         except Exception as e:
 140             print("error:", e, blocker)
 141     elif software == "mastodon":
 142         print(blocker)
 143         try:
 144             json = get_mastodon_blocks(blocker)
 145             for block_level, blocks in json.items():
 146                 for instance in blocks:
 147                     blocked, blocked_hash, reason = instance.values()
 148                     if blocked.count("*") <= 1:
 149                         c.execute(
 150                             "select hash from instances where hash = ?", (blocked_hash,)
 151                         )
 152                         if c.fetchone() == None:
 153                             c.execute(
 154                                 "insert into instances select ?, ?, ?",
 155                                 (blocked, get_hash(blocked), get_type(blocked)),
 156                             )
 157                     c.execute(
 158                         "select * from blocks where blocker = ? and blocked = ? and block_level = ?",
 159                         (blocker, blocked, block_level),
 160                     )
 161                     if c.fetchone() == None:
 162                         c.execute(
 163                             "insert into blocks select ?, ?, ?, ?",
 164                             (
 165                                 blocker,
 166                                 blocked if blocked.count("*") <= 1 else blocked_hash,
 167                                 reason,
 168                                 block_level,
 169                             ),
 170                         )
 171             conn.commit()
 172         except Exception as e:
 173             print("error:", e, blocker)
 174 conn.close()