sqlite-to-json.py

import json
import sqlite3

file = "data.db"
table = "booths"
rows = ["title", "description", "video", "school"]
columnForFileName = 'title'
targetDir = "export"
conn = sqlite3.connect(file)


def transform(row):
    ret = {}
    idex = 0
    for i in rows:
        ret[i] = row[idex]
        idex += 1
    return ret


if __name__ == "__main__":
    for row in conn.execute(f"""SELECT {', '.join(rows)} FROM {table}"""):
        row = transform(row)
        with open(f"{targetDir}/{row[columnForFileName]}.json", 'w') as f:
            json.dump(row, f)