医院科研管理系统

from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()

class Patent(db.Model):

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

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

application_number = db.Column(db.String(50), unique=True)

status = db.Column(db.String(50))

import pandas as pd

from flask import Response

def export_patents():

patents = Patent.query.all()

df = pd.DataFrame([{'name': p.name, 'application_number': p.application_number, 'status': p.status} for p in patents])

return Response(df.to_csv(index=False), mimetype='text/csv', headers={'Content-Disposition': 'attachment;filename=patents.csv'})