| import datetime | |
| import streamlit as st | |
| from config import DEFAULT_ICON | |
| from shared_page import common_page_config | |
| from data_storage import add_new_user, is_admin, DB_PATH, drop_tables, migrate_players_from_week | |
| def admin_add_new_user(): | |
| add_new_user(st.session_state["admin_new_user_email"], st.session_state["admin_new_user_name"]) | |
| def admin_add_new_user_form(): | |
| if st.button("Add new user"): | |
| with st.form("Add new user"): | |
| st.header("Admin add new user") | |
| st.write("Adds new user to sqlite db") | |
| st.text_input("Email Address", key="admin_new_user_email") | |
| st.text_input("Name", key="admin_new_user_name") | |
| st.form_submit_button("Submit", on_click=admin_add_new_user) | |
| def database_backup_form(): | |
| if st.button("DB Backup"): | |
| with st.container(): | |
| st.header("Utility for backing up and restoring db file") | |
| with open(DB_PATH, "rb") as f: | |
| file_name = f"backup-{datetime.datetime.now().strftime('%y%m%d%H%M')}.db" | |
| st.download_button("Download db", f, file_name=file_name) | |
| def drop_db_if_confirmed(): | |
| confirmed = st.session_state.get("delete_confirmation") == "delete" | |
| if confirmed: | |
| drop_tables() | |
| st.warning("Database tables have been dropped") | |
| else: | |
| st.warning("Must confirm deletion by typing 'delete'") | |
| def drop_db_form(): | |
| if st.button("Reset DB"): | |
| with st.form("Reset DB"): | |
| st.header("Reset DB") | |
| st.text_input("Enter 'delete' to confirm deletion", key="delete_confirmation") | |
| st.form_submit_button("Submit", on_click=drop_db_if_confirmed) | |
| def migrate_players_week(): | |
| with st.container(): | |
| st.header("Utility for migrating players to the next week") | |
| week_migrate_from = st.selectbox("week to migrate from", options=[1, 2, 3]) | |
| st.text_input("Enter week to confirm", key="week_migrate_from") | |
| if st.button("Migrate Week"): | |
| if st.session_state.get("week_migrate_from") == str(week_migrate_from): | |
| migrate_players_from_week(week_migrate_from) | |
| st.warning("Week migrated") | |
| else: | |
| st.warning("Must confirm migration by entering matching week") | |
| def get_page(): | |
| page_title = "Admin" | |
| st.set_page_config(page_title=page_title, page_icon=DEFAULT_ICON, layout="wide") | |
| common_page_config() | |
| if not is_admin(st.session_state.get("logged_in_user")): | |
| st.write("Not authorized") | |
| st.stop() | |
| st.title(page_title) | |
| database_backup_form() | |
| admin_add_new_user_form() | |
| drop_db_form() | |
| migrate_players_week() | |
| if __name__ == "__main__": | |
| get_page() | |