通过Pyramid框架实现RESTful API接口

Pyramid框架是一个轻量级的Web框架，适用于开发RESTful API接口。该示例代码使用Pyramid框架实现了一个简单的RESTful API接口，可以对用户信息进行增删改查操作。

from pyramid.config import Configurator
from pyramid.response import Response
from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

engine = create_engine('sqlite:///users.db')
Session = sessionmaker(bind=engine)


class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    age = Column(Integer)
    address = Column(String)

    def __repr__(self):
        return f"<User(name='{self.name}', age='{self.age}', address='{self.address}')>"


def add_user(request):
    session = Session()
    user_data = request.json
    user = User(**user_data)
    session.add(user)
    session.commit()
    return Response('User added successfully')


def get_user(request):
    session = Session()
    user_id = request.matchdict['id']
    user = session.query(User).get(user_id)
    return Response(str(user))


def update_user(request):
    session = Session()
    user_id = request.matchdict['id']
    user_data = request.json
    user = session.query(User).get(user_id)
    for key, value in user_data.items():
        setattr(user, key, value)
    session.commit()
    return Response('User updated successfully')


def delete_user(request):
    session = Session()
    user_id = request.matchdict['id']
    user = session.query(User).get(user_id)
    session.delete(user)
    session.commit()
    return Response('User deleted successfully')


if __name__ == '__main__':
    with Configurator() as config:
        config.include('pyramid_sqlalchemy')
        config.add_route('add_user', '/users', request_method='POST')
        config.add_view(add_user, route_name='add_user', renderer='json')
        config.add_route('get_user', '/users/{id}', request_method='GET')
        config.add_view(get_user, route_name='get_user', renderer='json')
        config.add_route('update_user', '/users/{id}', request_method='PUT')
        config.add_view(update_user, route_name='update_user', renderer='json')
        config.add_route('delete_user', '/users/{id}', request_method='DELETE')
        config.add_view(delete_user, route_name='delete_user', renderer='json')
        app = config.make_wsgi_app()

免责申明：文章和图片全部来源于公开网络，如有侵权，请通知删除 server@dude6.com