医院科研管理系统

from sqlalchemy import create_engine, Column, Integer, String, func

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class Researcher(Base):

__tablename__ = 'researchers'

id = Column(Integer, primary_key=True)

name = Column(String)

citations = Column(Integer)

engine = create_engine('sqlite:///research.db')

Session = sessionmaker(bind=engine)

session = Session()

# 查询并按引用次数降序排列

researchers = session.query(Researcher).order_by(Researcher.citations.desc()).limit(10).all()

for r in researchers:

print(r.name, r.citations)