from flask import Flask, request, jsonify
from flask_sqlalchemy import SQLAlchemy
app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://username:password@localhost/alumni'
db = SQLAlchemy(app)
class Alumni(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
contact_info = db.Column(db.String(120))
]]>
from flask_migrate import Migrate
migrate = Migrate(app, db)
@app.route('/add', methods=['POST'])
def add_alumni():
data = request.get_json()
new_alumni = Alumni(name=data['name'], contact_info=data['contact_info'])
db.session.add(new_alumni)
db.session.commit()
return jsonify({"message": "Alumni added successfully"}), 201
]]>