Advertisement
Guest User

Untitled

a guest
May 20th, 2020
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.75 KB | None | 0 0
  1. for grad in graduates:
  2.     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)"
  3.     cursor.execute(
  4.         sql,
  5.         (
  6.             grad["Your Full Name"],
  7.             grad["Email Address"],
  8.             grad["Phonetic spelling of your name"],
  9.             grad["Your Degree"],
  10.             grad["Anything else you'd like to include?"],
  11.             grad["Your Major(s)"],
  12.             grad["Senior quote?"],
  13.             universityToId[grad["School"]],
  14.             ceremonyToId[grad["Ceremony Name"]],
  15.             grad["UUID"],
  16.             convertDate(grad["Start Time UTC"]),
  17.         ),
  18.     )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement