import csv, re, sqlite3

con = sqlite3.connect("database2.db")
cur = con.cursor()
f = open("externalpresc_init", "w+")



toWrite = ''


for i in range(1, 629):
	cur.execute("Select external from presc_ids where internal like "+str(i))
	result = cur.fetchall()
	if(result == []):
		toWrite = "0\n"
	else:
		toWrite = str(result[0]).replace(')','').replace('(','').replace('\'','')
		toWrite = toWrite[:-1]+"\n"
	f.write(toWrite)