graphdb.py

#!/usr/bin/env python3

# Code for drawing a lot of SQLite databases
# https://github.com/yakshaveinc/linux/issues/29#issuecomment-533082911

import os
import sqlite3
from urllib.request import pathname2url

from sqlalchemy_schemadisplay import main


files = open('../sqlites.find').read().splitlines()
numwidth = len(str(len(files)))

for i, path in enumerate(files):
  # TODO sanitize filename or just use numbers
  inpath = 'sqlite:///' + path  # pathname2url(path)
  outpath = f'{i+1:0{numwidth}}.{os.path.basename(path)}.png'
  print(inpath)
  try:
    main(inpath, outpath)
  except Exception as exc: #sqlite3.OperationalError as exc:
    print('!!! Exception occured')
    print(exc)
    input('Press Enter to continue...')