from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()
class Research(db.Model):
id = db.Column(db.Integer, primary_key=True)
title = db.Column(db.String(100), nullable=False)
author = db.Column(db.String(100), nullable=False)
abstract = db.Column(db.Text, nullable=False)
region = db.Column(db.String(50), nullable=False)
def __repr__(self):
return f"Research('{self.title}', '{self.author}')"
]]>
from flask import request, jsonify
@app.route('/search', methods=['GET'])
def search():
query = request.args.get('q')
results = Research.query.filter(Research.title.contains(query) | Research.author.contains(query)).all()
return jsonify([{'title': r.title, 'author': r.author} for r in results if r.region == 'Sichuan'])
]]>