ffxiv_libra_dump.py

import sqlite3
import os
import json
import time

sql_data_file = 'app_data.sqlite'

dirname = os.path.dirname(os.path.realpath(__file__))

ts = int(time.time())

try:
    os.makedirs('%s%sdata%s%s' % (dirname, os.sep, os.sep, ts))
except OSError:
    pass

conn = sqlite3.connect(sql_data_file)

c = conn.cursor()

c.execute("SELECT * FROM sqlite_master WHERE type='table'")
tables = c.fetchall()

for table in tables:
    print "Processing", table[1]
    c.execute("SELECT * FROM %s" % table[1])
    d = dict(names=list(map(lambda x: x[0], c.description)),
             data=c.fetchall())
    f = open("%s%sdata%s%s%s%s.json" % (dirname, os.sep, os.sep, ts, os.sep, table[1]), 'w')
    f.write(json.dumps(d))
    f.close()