# main.py
import streamlit as st

st.set_page_config(
    page_title="Faculty Evaluation",
    layout="centered"
)


# from app5_selectbox import load_llama2  # load_llama2() or initialized
# load_llama2.load()


from app5_selectbox import academic_list, class_tbl, instructor, program, student, subject, subj_inst, evaluation
import app5
from app5_selectbox.database_con import cursor, db_connection


# db_connection.reconnect()

# Streamlit app title
# st.title("University Evaluation App")

app5.app5()




# Close the database connection
# db_connection.close()
# db_connection.disconnect()




#################################### 2/4/24

# # main.py
# import streamlit as st
# from app5_selectbox import academic_list, class_tbl, instructor, program, student, subject, subj_inst, evaluation
# import app5
# from app5_selectbox.database_con import cursor, db_connection

# # db_connection.reconnect()

# # Streamlit app title
# st.title("University Evaluation App")

# # Create a Streamlit sidebar to select the table for insertion
# table_name = st.sidebar.selectbox("Select Table", ("academic_list", "class", "instructor", "program", "student", "subject", "subj_inst", "evaluation", "app5"))

# if table_name == "academic_list":
#     # Include academic_list-specific code from academic_list.py
#     academic_list.academic_list(table_name)
#     # pass
# elif table_name == "class":
#     # Include class-specific code from class.py
#     class_tbl.class_tbl(table_name)
#     # pass
# elif table_name == "instructor":
#     # Include instructor-specific code from instructor.py
#     instructor.instructor(table_name)
#     # pass
# elif table_name == "program":
#     # Include program-specific code from program.py
#     program.program(table_name)
#     # pass
# elif table_name == "student":
#     # Include student-specific code from student.py
#     student.student(table_name)
#     # pass
# elif table_name == "subject":
#     # Include subject-specific code from subject.py
#     subject.subject(table_name)
#     # pass
# elif table_name == "subj_inst":
#     # Include subj_inst-specific code from subj_inst.py
#     subj_inst.subj_inst(table_name)
#     # pass
# elif table_name == "evaluation":
#     # Include table_name-specific code from table_name.py
#     evaluation.evaluation()
#     # pass
# elif table_name == "app5":
#     # Include table_name-specific code from table_name.py
#     app5.app5()
#     # pass
# else:
#     st.error("Select a valid table from the sidebar.")

# # Close the database connection
# # db_connection.close()
# # db_connection.disconnect()