from flask import Flask

from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)

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

db = SQLAlchemy(app)

class User(db.Model):

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

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

智慧迎新系统

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

class Project(db.Model):

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

title = db.Column(db.String(100), nullable=False)

description = db.Column(db.Text, nullable=True)

user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)

class Task(db.Model):

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

title = db.Column(db.String(100), nullable=False)

status = db.Column(db.String(20), default='pending')

project_id = db.Column(db.Integer, db.ForeignKey('project.id'), nullable=False)

]]>

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

def add_user():

# 添加新用户的逻辑

pass

@app.route('/get_projects/')

def get_projects(user_id):

projects = Project.query.filter_by(user_id=user_id).all()

return {'projects': [p.title for p in projects]}

]]>