import sqlite3
import uuid
import json
import streamlit as st
from utilities import (
    load_local_css,
    set_header,
    load_authenticator,
    send_email,
)
import streamlit_authenticator as stauth
import yaml
from yaml import SafeLoader



# st.set_page_config(layout="wide")
# load_local_css("styles.css")
# set_header()
# for k, v in st.session_state.items():
#     if k not in ["logout", "login", "config"] and not k.startswith(
#         "FormSubmitter"
#     ):
#         st.session_state[k] = v
# with open("config.yaml") as file:
#     config = yaml.load(file, Loader=SafeLoader)
#     st.session_state["config"] = config
# authenticator = stauth.Authenticate(
#     config["credentials"],
#     config["cookie"]["name"],
#     config["cookie"]["key"],
#     config["cookie"]["expiry_days"],
#     config["preauthorized"],
# )
# st.session_state["authenticator"] = authenticator
# name, authentication_status, username = authenticator.login("Login", "main")
# auth_status = st.session_state.get("authentication_status")
# if auth_status == True:
#     authenticator.logout("Logout", "main")
#     is_state_initiaized = st.session_state.get("initialized", False)
#     if not is_state_initiaized:
database_file = r'C:\Users\ManojP\Documents\Mastercard\Build\DB_Sample\DB\User.db'

conn = sqlite3.connect(database_file)
c = conn.cursor()


#c.execute('DROP TABLE  IF EXISTS users  ')
# c.execute('DROP TABLE  IF EXISTS sessions ')
# conn.commit()

#output = c.fetchall()

#st.write(output)

c.execute('''CREATE TABLE IF NOT EXISTS users
            (user_id INTEGER PRIMARY KEY,
            username TEXT,
            email TEXT,
            user_type TEXT )''')

c.execute('''CREATE TABLE IF NOT EXISTS sessions
            (user_id INTEGER,
             owner TEXT,
            session_id INTEGER,
            session_name TEXT,
            status TEXT,
            created_time TIMESTAMP,
            updated_time TIMESTAMP,
            allowed_users TEXT)''')

#c.execute("DELETE FROM sessions")


 
user_id = str(uuid.uuid4())




# c.executemany("INSERT INTO users (username, email,user_type) VALUES (?, ?,?)",
#         [("Geetha Krishna", "geetha1732@gmail.com","technical"),
#         ("Samkeet Sangai", "samkeet.sangai@blend360.com","technical"),
#         ('Manoj P','manojp1732@gmail.com',"technical"),
#         ('Srishti Verma','srishti.verma@blend360.com',"technical"),
#         ('Ismail mohammed',"mohammed.ismail@blend360.com","technical"),
#         ('Sharon Sheng','sharon.sheng@mastercard.com',"technical"),
#         ('Ioannis Papadopoulos','ioannis.papadopoulos@mastercard.com',"business"),
#         ('Herman Kwong',"herman.kwong@mastercard.com",'technical'),

#         ])




conn.commit()