uw = UWaterlooAPI(api_key="013cadb105a7dc1943443cb5ebf7edde") # Open database connection db = MySQLdb.connect("localhost","SE464","SE464project","classroomfinder" ) try: cursorTruncate = db.cursor() cursorTruncate.execute("TRUNCATE TABLE classroomfinder.courses") cursor = db.cursor() cursor.execute("SELECT * FROM classroomfinder.building_rooms") result = cursor.fetchall() for row in result: print "processing room..." building = row[0] room = row[1] try: UWresult = uw.course_by_building_room(building, room) for c in UWresult: sub = c['subject'] catalog_number = c['catalog_number'] title = c['title'] weekdays = c['weekdays'] start_time = c['start_time'] end_time = c['end_time'] cursorInsert = db.cursor(); cursorInsert.execute('''INSERT INTO classroomfinder.courses VALUES (%s, %s, %s, %s, %s, %s, %s, %s)''', (sub, catalog_number, title, weekdays, start_time, end_time, building, room)) cursorInsert.execute('COMMIT') print "inserted class..." except: "Error: unable to create data" except: print "Error: unable to read data"