Home | 简体中文 | 繁体中文 | 杂文 | Github | 知乎专栏 | 51CTO学院 | CSDN程序员研修院 | OSChina 博客 | 腾讯云社区 | 阿里云栖社区 | Facebook | Linkedin | Youtube | 打赏(Donations) | About
知乎专栏多维度架构

9.12. 返回指定列

		
async def open(picture_book_id: int):
    session = database.session()
    try:
        from sqlalchemy.orm import load_only

        data = (
            session.query(Picture)
            .join(PictureBookHasPicture, Picture.id == PictureBookHasPicture.picture_id)
            .filter(PictureBookHasPicture.picture_book_id == picture_book_id)
            .options(load_only(Picture.image, Picture.story))
            .all()
        )
        if data:
            response = Response(True, "打开绘本", data)
        else:
            response = Response(False, "打开绘本没有数据", data)
    except Exception as e:
        response = Response(False, e, None)
        logger.error(response)
    finally:
        session.close()
    logger.info(response)
    return response