基于学工管理系统的秦皇岛高校信息平台开发与实现

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class User(db.Model):

id = db.Column(db.Integer, primary_key=True)

username = db.Column(db.String(80), unique=True, nullable=False)

password = db.Column(db.String(120), nullable=False)

email = db.Column(db.String(120), unique=True, nullable=False)

def __repr__(self):

return '' % self.username

app = Flask(__name__)

app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///users.db'

db.init_app(app)

@app.route('/users', methods=['GET'])

def get_users():

users = User.query.all()

return jsonify([user.to_dict() for user in users])

@app.route('/users/', methods=['GET'])

def get_user(user_id):

user = User.query.get_or_404(user_id)

return jsonify(user.to_dict())

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

def create_user():

实训实习管理系统

data = request.json

new_user = User(username=data['username'], password=data['password'], email=data['email'])

db.session.add(new_user)

db.session.commit()

return jsonify(new_user.to_dict()), 201

@app.route('/users/', methods=['PUT'])

def update_user(user_id):

user = User.query.get_or_404(user_id)

data = request.json

user.username = data['username']

user.password = data['password']

user.email = data['email']

db.session.commit()

return jsonify(user.to_dict())

@app.route('/users/', methods=['DELETE'])

def delete_user(user_id):

user = User.query.get_or_404(user_id)

db.session.delete(user)

db.session.commit()

return '', 204