Code Editor for app.py

import streamlit as st
from sqlalchemy import create_engine, Column, String, Integer
from sqlalchemy.orm import DeclarativeBase, Session

# Database setup
engine = create_engine("sqlite:///mydb.sqlite")

class Base(DeclarativeBase):
    pass

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    username = Column(String, unique=True)
    email = Column(String)
    tel = Column(String)
    passw = Column(String)

# Create tables if they don't exist
Base.metadata.create_all(bind=engine)

# Login form
st.title("Login")

with st.form(key='login_form'):
    username = st.text_input("Username")
    password = st.text_input("Password", type='password')
    submitted = st.form_submit_button("Login")

    if submitted:
        with Session(engine) as session:
            user = session.query(User).filter_by(username=username, passw=password).first()
            if user:
                st.success(f'Welcome back, {username}!')
            else:
                st.error('Invalid username or password.')