Code Editor for app.py

import streamlit as st
import pandas as pd
from sqlalchemy import create_engine
from sqlalchemy.orm import Session, DeclarativeBase
from sqlalchemy import Column, Integer, String, DateTime
import datetime

class Base(DeclarativeBase):
    pass

class Attendance(Base):
    __tablename__ = 'attendance'
    id = Column(Integer, primary_key=True)
    name = Column(String, nullable=False)
    timestamp = Column(DateTime, default=datetime.datetime.utcnow)

engine = create_engine('sqlite:///attendance.db')
Base.metadata.create_all(bind=engine)

st.title('Attendance Monitor')

name = st.text_input('Enter Name')
if st.button('Mark Attendance'):
    with Session(engine) as session:
        new_attendance = Attendance(name=name)
        session.add(new_attendance)
        session.commit()
    st.success(f'Attendance marked for {name}')

if st.button('Show Attendance List'):
    with Session(engine) as session:
        attendance_list = session.query(Attendance).all()
    st.table(pd.DataFrame([(a.id, a.name, a.timestamp) for a in attendance_list], columns=['ID', 'Name', 'Timestamp']))