import streamlit as st
import os
import matplotlib.pyplot as plt
from database_interface.utils import *
st.set_page_config(
    page_title='DataBoard' ,
    page_icon= plt.imread(os.path.abspath('static/logo.png')),
)


def on_table_radio_change(db_name) :
    if db_name in st.session_state :
        table_selected = st.session_state.get(db_name)
        st.subheader(f'{table_selected} table from {db_name} database dashboarding')
        st.dataframe(get_table_in_database(cnx,db_name = db_name, table_name= table_selected))

st.session_state.dfs = os.listdir(os.path.abspath('database/dataframes'))

def on_selectbox_change() :
    df = pd.read_csv(os.path.abspath('database/dataframes')+'\\'+st.session_state.df_name)
    st.dataframe(df)

st.sidebar.title('DataFrames')
with st.sidebar:
    st.selectbox(label='Which dataframe to display?',
                 options=st.session_state.dfs,
                 on_change=on_selectbox_change,
                 key='df_name',
                 )