from sqlalchemy import Column, Integer, String

from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class User(Base):

__tablename__ = 'users'

id = Column(Integer, primary_key=True)

username = Column(String(50), unique=True)

password = Column(String(128))

]]>

from flask import Flask, request, jsonify

在線實習管理平臺

from werkzeug.security import generate_password_hash, check_password_hash

from models import User

app = Flask(__name__)

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

def login():

data = request.get_json()

username = data['username']

password = data['password']

user = User.query.filter_by(username=username).first()

if user and check_password_hash(user.password, password):

return jsonify({'message': 'Login successful!'})

else:

return jsonify({'message': 'Invalid credentials'}), 401

]]>

class Student(Base):

__tablename__ = 'students'

id = Column(Integer, primary_key=True)

name = Column(String(100))

score = Column(Integer)

major = Column(String(50))

]]>