Code Editor for app.py

import streamlit as st
import sqlite3

# Connect to SQLite database
conn = sqlite3.connect('chat_messages.db')
c = conn.cursor()

# Create table if it doesn't exist
c.execute('''
    CREATE TABLE IF NOT EXISTS messages (
        role TEXT,
        content TEXT
    )
''')
conn.commit()

st.title("Echo Bot")

if "messages" not in st.session_state:
    # Load messages from database into session state
    st.session_state.messages = []
    c.execute('SELECT role, content FROM messages')
    for row in c.fetchall():
        st.session_state.messages.append({"role": row[0], "content": row[1]})

for message in st.session_state.messages:
    with st.chat_message(message["role"]):
        st.markdown(message["content"])

if prompt := st.chat_input("What is up?"):
    st.chat_message("user").markdown(prompt)
    st.session_state.messages.append({"role": "user", "content": prompt})
    c.execute('INSERT INTO messages (role, content) VALUES (?, ?)', ("user", prompt))

    response = f"Echo: {prompt}"
    with st.chat_message("assistant"):
        st.markdown(response)

    st.session_state.messages.append({"role": "assistant", "content": response})
    c.execute('INSERT INTO messages (role, content) VALUES (?, ?)', ("assistant", response))

conn.commit()

# ensure the messages are there
c.execute('SELECT role, content FROM messages')
existing_messages = c.fetchall()
print(existing_messages)

conn.close()