Code Editor for app.py

import streamlit as st
import pandas as pd
from sqlalchemy import create_engine
from sqlalchemy.orm import Session, declarative_base

Base = declarative_base()

class DataModel(Base):
    __tablename__ = 'data'
    id = Column(Integer, primary_key=True)
    value = Column(String)

# Setup SQLite database
engine = create_engine('sqlite:///mydb.sqlite')
# Create tables
Base.metadata.create_all(bind=engine)

st.title('Data Entry and Display')

# Data entry form
with st.form(key='data_form'):
    new_value = st.text_input('Enter a value')
    submit_button = st.form_submit_button('Submit')

    if submit_button:
        with Session(engine) as session:
            new_entry = DataModel(value=new_value)
            session.add(new_entry)
            session.commit()
            st.success('Data saved!')

# Display stored data
with Session(engine) as session:
    data_entries = session.query(DataModel).all()
    data_to_display = [{'id': entry.id, 'value': entry.value} for entry in data_entries]

st.table(data_to_display)