Converts sqlite database for pointshop to mysql (outputs sql file)

pointshop-sqlite2mysql.py

# -*- coding: utf-8 -*-
import sqlite3
conn = sqlite3.connect('sv.db')

c = conn.cursor()

sql = """SELECT
		`uid`,
		(SELECT value FROM `playerpdata` WHERE `infoid` = (`uid` || '[PS_Points]')) as points,
		(SELECT value FROM `playerpdata` WHERE `infoid` = (`uid` || '[PS_Items]')) as items
	FROM
	(
		SELECT
			substr(`infoid`, 1, length(`infoid`)-11) as `uid`
		FROM
			`playerpdata`
		WHERE
			substr(`infoid`, -1, -9) = 'PS_Points'
	) as p"""

c.execute(sql)

players = c.fetchall()

with open("output.sql", "w+") as f:
	for k,v in enumerate(players):
		items = v[2].replace("\"", "\\\"") if v[2] is not None else "{}"
		f.write("INSERT INTO `pointshop_data` VALUES (%s, %s,\"%s\");\n" % (v[0], v[1], items,))
		if (k+1) % 100 == 0:
			print("%s players converted." % (k+1,))

conn.close()