#!/usr/bin/python
import sys
for arg in sys.argv:
	f = open(arg)
	for l in f.readlines():
		r = l.strip().split(', ')
		t = r[0]
		cols = r[1:]
		names = []
		name_types = ''
		for c in cols:
			(name, type) = c.split()
			names.append(name)
			if type in ('STRING', 'TEXT'):
				name_types += " || ',' || quote(%s) " % name
			else:
				name_types += " || ',' || quote(%s) " % name
		print "SELECT 'INSERT INTO %s (ROWID, %s) VALUES ( ' || ROWID %s || ');' FROM %s;" % (t, ', '.join(names), name_types, t)