Models.py

# models.py - database models
from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import declarative_base
from sqlalchemy.orm import sessionmaker

# Set up the engine and session
engine = create_engine('sqlite:///./python-simpleapi.db', echo=True)
Session = sessionmaker(bind=engine)
session = Session()


Base = declarative_base()

class Students(Base):
    __tablename__ = 'students'
    id = Column(Integer, primary_key=True)
    first_name = Column(String)
    last_name = Column(String)
    email = Column(String)

    def __repr__(self):
        return f"<User(id={self.id}, first_name='{self.first_name}', last_name='{self.last_name}')>"
    def to_dict(self):
        return {
            "id": self.id,
            "first_name": self.first_name,
            "last_name": self.last_name,
            "email": self.email,
        }
    @classmethod
    def by_id(cls, student_id):
        return session.query(cls).filter_by(id=student_id).first()