def import_typeform(filename): import csv fields = ["id"] + typeform.FIELDS + [ "start_time", "submit_time", "network_id" ] vals = [] with open(filename, newline='') as csvfile: reader = csv.DictReader(csvfile, fields) for row in reader: row["first_hack"] = row["first_hack"] == "1" row["sponsor"] = row["sponsor"] == "1" row["swag"] = row["swag"] == "1" row["code_of_conduct"] = row["code_of_conduct"] == "1" row["terms_and_conditions"] = row["terms_and_conditions"] == "1" vals.append(row) create_tables() with db.database.atomic(): (Registration.insert_many(vals[1:]).on_conflict( "update", conflict_target=[Registration.id], preserve=Registration.hacker_discord).execute()) click.echo("Uploaded {0} entries to the Registration table".format( len(vals) - 1))