added other instances to preload

[fba.git] / preload_db.py

diff --git a/preload_db.py b/preload_db.py
index fde4eaf377f82fdb8bc583b1f091aab258d5e403..ac6aa284f059f73e1f504590ba381ca6bfad7a84 100644 (file)
--- a/preload_db.py
+++ b/preload_db.py
@@ -1,7 +1,7 @@
 import sqlite3
 from hashlib import sha256
 
-conn = sqlite3.connect("blocks_default.db")
+conn = sqlite3.connect("blocks_preloaded.db")
 c = conn.cursor()
 
 with open("pleroma_instances.txt", "r") as f:
@@ -14,4 +14,12 @@ with open("mastodon_instances.txt", "r") as f:
     while line := f.readline():
         print(line.rstrip(), sha256(bytes(line.rstrip(), "utf-8")).hexdigest())
         c.execute(f"insert into instances select \"{line.rstrip()}\", \"{sha256(bytes(line.rstrip(), 'utf-8')).hexdigest()}\"")
-        conn.commit()
\ No newline at end of file
+        conn.commit()
+
+with open("other_instances.txt", "r") as f:
+    while line := f.readline():
+        print(line.rstrip(), sha256(bytes(line.rstrip(), "utf-8")).hexdigest())
+        c.execute(f"insert into instances select \"{line.rstrip()}\", \"{sha256(bytes(line.rstrip(), 'utf-8')).hexdigest()}\"")
+        conn.commit()
+
+conn.close()
\ No newline at end of file