X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=preload_db.py;h=ac6aa284f059f73e1f504590ba381ca6bfad7a84;hb=187e46376ee8252eb27b77856b2d193b8a2637b5;hp=fde4eaf377f82fdb8bc583b1f091aab258d5e403;hpb=303ab15adcf42dd9ca334c4d1933bc49557ceb70;p=fba.git diff --git a/preload_db.py b/preload_db.py index fde4eaf..ac6aa28 100644 --- 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