Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- for grad in graduates:
- sql = "INSERT INTO `graduates` (`name`, `email`, `pronunciation`, `degreeLevel`, `honors`, `major`, `seniorQuote`, `university`, `ceremony`, `uuid`, `timeslot`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)"
- cursor.execute(
- sql,
- (
- grad["Your Full Name"],
- grad["Email Address"],
- grad["Phonetic spelling of your name"],
- grad["Your Degree"],
- grad["Anything else you'd like to include?"],
- grad["Your Major(s)"],
- grad["Senior quote?"],
- universityToId[grad["School"]],
- ceremonyToId[grad["Ceremony Name"]],
- grad["UUID"],
- convertDate(grad["Start Time UTC"]),
- ),
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement