from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker from sqlalchemy.ext.declarative import declarative_base from sqlalchemy_searchable import make_searchable from sqlalchemy_searchable import SearchQuery
# 创建数据库引擎,链接到SQLite数据库(或其他数据库) engine = create_engine('sqlite:///example.db') # 创建基本模型类 Base = declarative_base()
# 初始化搜索功能 make_searchable()
# 定义模型类 classUser(Base): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String) email = db.Column(db.String)