pip install pyramid
pip install sqlalchemy

pip install pymysql

CREATE DATABASE example_db;

USE example_db;

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    email VARCHAR(255)
);

INSERT INTO users (name, email) VALUES
    ('John', 'john@example.com'),
    ('Mary', 'mary@example.com'),
    ('David', 'david@example.com');

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

# 创建数据库连接
engine = create_engine('mysql+pymysql://root:password@localhost/example_db')

# 创建Session
Session = sessionmaker(bind=engine)
session = Session()

# 声明基本模型类
Base = declarative_base()

# 定义用户模型类
class User(Base):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)
    name = Column(String(255))
    email = Column(String(255))

from pyramid.view import view_config

from .models import User

@view_config(route_name='search', renderer='json')
def search(request):
    keyword = request.params.get('keyword')

    # 不区分大小写的搜索查询
    query = session.query(User).filter(User.name.ilike('%{}%'.format(keyword)))

    # 获取查询结果
    results = [user.name for user in query]

    return {'results': results}

from pyramid.config import Configurator

from .models import Base, engine

def main(global_config, **settings):
    config = Configurator(settings=settings)

    # 创建数据库表
    Base.metadata.create_all(engine)

    # 配置路由
    config.add_route('search', '/search')

    # 配置视图
    config.scan('.views')

    return config.make_wsgi_app()

[app:main]
use = egg:searchapp

sqlalchemy.url = mysql+pymysql://root:password@localhost/example_db

[server:main]
use = egg:waitress#main
listen = localhost:8000

pserve development.ini

http://localhost:8000/search?keyword=John

{
    "results": [
        "John"
    ]
}