def store_config_calendar(sheet: gspread.models.Worksheet): info = sheet.get_all_values()[4:] for calendar_link, calendar_image, color in info: config['calendar']['calendarlink'] = calendar_link config['calendar']['calendarimage'] = calendar_image config['calendar']['color'] = color
def store_config_game_managers(sheet: gspread.models.Worksheet): gm_dir_info = sheet.get_all_values()[4:] for i, gm in enumerate(gm_dir_info): for j, info in enumerate(gm): config[f'gm-info-{j + 1}'][str(i + 1)] = str(info).replace( "%", "<>")
def store_config_faq(sheet: gspread.models.Worksheet): q_and_a = sheet.get_all_values()[4:] questions = [i[0] for i in q_and_a] answers = [i[1] for i in q_and_a] for i in range(len(q_and_a)): config['faq'][str(questions[i])] = str(answers[i])
def get_dataframe(sheet: gspread.models.Worksheet) -> pd.DataFrame: column_names = [ "Resource Name", "Category", "Tags", "Club/Organization", "Description", "Website", "Image Link", "Facebook", "Card Link", "iOS Link", "Android Link", "Ready for Upload", "Uploaded" ] FIRST_ROW = 8 return pd.DataFrame(sheet.get_all_values(), columns=column_names).iloc[FIRST_ROW:]
def store_help_directory_config(sheet: gspread.models.Worksheet): """ :param sheet: help directory sheet :return: None """ help_dir_info = sheet.get_all_values()[4:] for i, leader in enumerate(help_dir_info): for j, info in enumerate(leader): config[f'contact-info-{j+1}'][str(i + 1)] = info
def store_config_reserved_pcs_blue(sheet: gspread.models.Worksheet): blue_room_values = sheet.get_all_values()[4:] reserved_pcs = [i[1] for i in blue_room_values] # Col 2 descriptions = [i[2] for i in blue_room_values] # Col 3 # Column 1 is reserved for PC numbers- these are nonfunctional labels for users config['lab-blue-description']['content'] = descriptions[0] for i, pc in enumerate(reserved_pcs): config['lab-blue-reservations'][str(i + 1)] = pc
def store_config_event_subs(sheet: gspread.models.Worksheet): event_subs = sheet.get_all_values()[4:] role_names = [i[0] for i in event_subs] # Col 2 emoji_names = [i[1] for i in event_subs] description = [i[2] for i in event_subs] for i, item in enumerate(event_subs): key = configutil.get_key_name_as_convention(role_names[i]) config['role-events'][key] = str(role_names[i]) config['emoji-events'][key] = str(emoji_names[i]) config['description-events'][key] = str(description[i])
def store_config_supported_games(sheet: gspread.models.Worksheet): supported_games = sheet.get_all_values()[4:] role_names = [i[0] for i in supported_games] emoji_names = [i[1] for i in supported_games] for i in range(len(supported_games)): config['role-games'][configutil.get_key_name_as_convention( role_names[i])] = str(role_names[i]) config['emoji-games'][configutil.get_key_name_as_convention( emoji_names[i])] = str(emoji_names[i])
def store_config_authed_users(sheet: gspread.models.Worksheet): authed_users = sheet.get_all_values()[4:] for i, users in enumerate(authed_users): config['id-authed'][f'{i+1}'] = str(users[1])
def store_config_channels(sheet: gspread.models.Worksheet): channel_names = sheet.get_all_values()[4:] for i, channel_name in enumerate(channel_names): as_key = str(channel_name[1]).replace("-", "") config['channel'][as_key] = str(channel_name[1])
def get_dataframe(sheet: gspread.models.Worksheet) -> pd.DataFrame: df = pd.DataFrame(sheet.get_all_values()) header = df.iloc[0] df = df[1:] df.columns = header return df