医院科研管理系统

from sqlalchemy import Column, Integer, String, ForeignKey

from sqlalchemy.orm import relationship

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)

class Paper(Base):

__tablename__ = 'papers'

id = Column(Integer, primary_key=True)

title = Column(String(200))

author_id = Column(Integer, ForeignKey('users.id'))

author = relationship("User")

]]>

from flask import Flask, request, jsonify

from models import db, Paper, User

app = Flask(__name__)

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

db.init_app(app)

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

def add_paper():

data = request.get_json()

new_paper = Paper(title=data['title'], author_id=data['author_id'])

db.session.add(new_paper)

db.session.commit()

return jsonify({"message": "Paper added successfully"}), 201

]]>