Formatting to insert

SQLinsertd.py

# data for insert only one column
# ex: ('248957'),('248959'),('248960'),('248961'),('248962')
x='''248957
248959
248960
248961
248962
248963
248964
552416
'''

def formz(x):
    y=x.rstrip().replace('\n','\'),(\'') # '\n','\',\''   '\n',','
    y='(\''+y+'\')'
    return y


with open('SQLinsertval.txt', 'wt') as xfile:
    xfile.write(formz(x))
    xfile.close()
    print('SQLinsertval.txt done!')