Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- import re
- with open("procedure_list.csv", mode="r", newline='\n') as csvfile:
- r = csv.reader(csvfile)
- for row in r:
- code = row[0]
- description = row[1]
- effective_date = row[2]
- end_date = row[3]
- if effective_date is None or effective_date == "":
- effective_date = "NULL"
- else:
- effective_date = "'" + effective_date + "'"
- if end_date is None or end_date == "":
- end_date = "NULL"
- else:
- end_date = "'" + end_date + "'"
- query = "INSERT INTO procedure(active, description, print_description, cpt_code, effective_date, end_date) VALUES('t', '{0}', '{0}', '{1}', {2}, {3});".format(description, code, effective_date, end_date)
- print(query)
Advertisement
Add Comment
Please, Sign In to add comment