#if event.start in df.loc[df['Name'] == event.summary].index: # df.at[event.start, 'cal_id'] = event.event_id # df.at[event.start, 'event_obj'] = event # print('found ', event, event.timezone, event.event_id) # %% df.loc[df['found'] == False] # %% for index, row in df.iterrows(): if row['found'] == False: print('* Adding:', index, row['Name']) evntColor = '1' event = gcEvent(str(row['Name']), start=index, timezone='UTC', color=evntColor) ret_event = calendar.add_event(event) print('ID after add:', event.event_id, 'Returned event ID:', ret_event.event_id) else: print('Skipping', index, row['Name']) # %%
# append to list if str(next_assignment_date) >= term_start_date: course_name.append(next_item["name"]) assignment_due_date.append(next_assignment_date) course_ids.append(next_item["course_id"]) # print(course_name) # print(assignment_due_date) # google calendar credentials user_email = "*****@*****.**" google_cred = os.getenv("GOOGLE_CALENDAR_CRED") gc = GoogleCalendar(credentials_path=google_cred) calendar = GoogleCalendar(user_email) # for loop all lists - and extract matching key values from course_ids for name, due_date, course_id in zip(course_name, assignment_due_date, course_ids): for key, value in course_dict.items(): if course_id == int(key): # print(due_date.split("-")[0]) # print(due_date.split("-")[1]) # print(due_date.split("-")[2]) final_name = name + " " + value start = datetime.datetime(int(due_date.split("-")[0]), int(due_date.split("-")[1]), int(due_date.split("-")[2])) event = Event(final_name, start=start, minutes_before_pop_reminder=30) calendar.add_event(event) # print(event)