from flask import Flask
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///alumni.db'
db = SQLAlchemy(app)
class Alumni(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
graduation_year = db.Column(db.Integer, nullable=False)
major = db.Column(db.String(50), nullable=False)
]]>
@app.route('/alumni', methods=['GET'])
def get_alumni():
alumni = Alumni.query.all()
return {'alumni': [a.name for a in alumni]}
@app.route('/add_alumni', methods=['POST'])
def add_alumni():
data = request.get_json()
new_alumni = Alumni(name=data['name'], graduation_year=data['graduation_year'], major=data['major'])
db.session.add(new_alumni)
db.session.commit()
return {'message': 'Alumni added successfully'}, 201
]]>
@app.route('/recommend_jobs', methods=['POST'])
def recommend_jobs():
data = request.get_json()
recommended_jobs = []
for major in data['majors']:
jobs = Job.query.filter_by(major=major).all()
recommended_jobs.extend(jobs)
return {'recommended_jobs': [j.title for j in recommended_jobs]}
]]>