Converts a sqlite database table to a JSON file

sqlite_to_json.py

import json
import os
import sqlite3
import sys
 
    
def dict_factory(cursor, row):
    d = {}
    for idx, col in enumerate(cursor.description):
        d[col[0]] = row[idx]
    return d
 

if len(sys.argv) != 4:
    print("usage:\n\tsqlite_to_json.py DATABASE TABLE_NAME OUTPUT_FILE")
    sys.exit(1)
if not os.path.exists(sys.argv[1]):
    print(f"{sys.argv[1]} does not exist")
    sys.exit(1)
connection = sqlite3.connect(sys.argv[1])
connection.row_factory = dict_factory
cursor = connection.cursor()
cursor.execute(f"select * from {sys.argv[2]}")
results = cursor.fetchall()
with open(sys.argv[3], 'w') as f:
    json.dump(results, f)
connection.close()