Generate SQL INSERT script with random key string

table_data.py

import string
import random

def id_generator(size=8, chars=string.ascii_lowercase+string.digits):
    return ''.join(random.choice(chars) for x in range(size))

with open('data.tsv') as f:
    data = f.readlines()

rows = [l.split('\t') for l in data]
for r in rows:
    last, first, email, _, _ = r
    print "insert into PotentialUser (\
FisrtName, LastName, EMail, RegisterKey) values \
(N'%s', N'%s', N'%s', N'%s')" % (first, last, email, id_generator())