Code Editor for app.py

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

class Base(DeclarativeBase):
    pass

class Meeting(Base):
    __tablename__ = 'meetings'
    id = Column(String, primary_key=True)
    title = Column(String)
    date_time = Column(DateTime)

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

st.title('Meeting Scheduler')

# Input meeting details
meeting_title = st.text_input('Meeting Title')
meeting_date_time = st.date_input('Date')
meeting_time = st.time_input('Time')

if st.button('Schedule Meeting'):
    if meeting_title and meeting_date_time:
        meeting_datetime = datetime.combine(meeting_date_time, meeting_time)
        with Session(engine) as session:
            meeting = Meeting(id=str(len(session.query(Meeting).all()) + 1), title=meeting_title, date_time=meeting_datetime)
            session.add(meeting)
            session.commit()
        st.success('Meeting scheduled!')
    else:
        st.error('Please fill in all fields')

# Display scheduled meetings
with Session(engine) as session:
    meetings = session.query(Meeting).all()
    if meetings:
        meeting_data = [{'ID': m.id, 'Title': m.title, 'Date & Time': m.date_time} for m in meetings]
        st.subheader('Scheduled Meetings')
        st.table(meeting_data)
    else:
        st.write('No meetings scheduled yet.')