在线排课系统的实现与探讨

研究生管理

POST /api/courses

{

"name": "Math",

"teacher": "John Doe",

"timeSlot": "9AM-11AM"

}

from sqlalchemy import create_engine, Column, Integer, String

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy.orm import sessionmaker

engine = create_engine('sqlite:///courses.db')

Base = declarative_base()

class Course(Base):

__tablename__ = 'courses'

id = Column(Integer, primary_key=True)

name = Column(String)

teacher = Column(String)

timeSlot = Column(String)

Session = sessionmaker(bind=engine)

session = Session()

new_course = Course(name="Math", teacher="John Doe", timeSlot="9AM-11AM")

session.add(new_course)

session.commit()