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