#!/bin/sh
python3 - <<'PY'
import sqlite3
c = sqlite3.connect('/tmp/.settings.db')
print('== columns settings', [d[0] for d in c.execute('select * from settings limit 1').description])
for row in c.execute('select * from settings'):
    print(' | '.join(str(x)[:120] for x in row))
print('== user schema')
for r in c.execute("select sql from sqlite_master where name='user'"):
    print(r[0])
for row in c.execute('select * from user'):
    print(row)
print('== appliance')
c2 = sqlite3.connect('/tmp/.appliance.db')
for row in c2.execute('select * from appliance'):
    print(' | '.join(str(x)[:160] for x in row))
PY
