from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()
class Student(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), nullable=False)
major = db.Column(db.String(120), nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
def __repr__(self):
return '
]]>
@app.route('/students', methods=['GET'])
def get_students():
students = Student.query.all()
return jsonify([student.to_dict() for student in students])
]]>