create a csv file to be imported into mca selector from coreprotect database

selectthingy.py

import sqlite3
from contextlib import redirect_stdout

ro_db = lambda a : "file:" + a + "?mode=ro"

db = sqlite3.connect("file:out.db?mode=ro", uri=True)
db.set_trace_callback(print)
c = db.cursor()


to_save = c.execute("""
    SELECT DISTINCT x >> 4, z >> 4 FROM co_block
        LEFT JOIN co_user ON co_block.user = co_user.id
        WHERE (action = 0 OR action = 1) AND wid = 1 AND co_user.uuid IS NOT NULL
""").fetchall()

to_print = ""
for row in to_save:
    to_print += "%d;%d;%d;%d\n" % (row[0] >> 5, row[1] >> 5, row[0], row[1])

with open('out.csv', 'w') as f:
    with redirect_stdout(f):
        print(to_print)

db.close()