from sqlalchemy import Column, Integer, String, ForeignKey

from sqlalchemy.orm import relationship

from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class Dormitory(Base):

__tablename__ = 'dormitory'

id = Column(Integer, primary_key=True)

building_name = Column(String(50))

room_number = Column(String(10))

class Student(Base):

__tablename__ = 'student'

id = Column(Integer, primary_key=True)

name = Column(String(50))

phone = Column(String(15))

dorm_id = Column(Integer, ForeignKey('dormitory.id'))

dormitory = relationship("Dormitory")

]]>

from flask import Flask, request, jsonify

from models import Student, Dormitory, Base, engine

app = Flask(__name__)

Base.metadata.create_all(engine)

@app.route('/add_student', methods=['POST'])

def add_student():

data = request.get_json()

new_student = Student(

name=data['name'],

phone=data['phone'],

dorm_id=data['dorm_id']

)

db.session.add(new_student)

db.session.commit()

return jsonify({"message": "Student added successfully!"})

if __name__ == '__main__':

app.run(debug=True)

]]>