that is an immensely complicated query and I couldn't tell you what's going on with that being the only context provided, unfortunately.
On Fri, Mar 18, 2022, at 10:16 PM, Michael Bukachi wrote: > Hello, > > So I've got a very weird when trying to set up caching using dogpile based on > the examples provided. I'm using the latest version of SQLAlchemy 1.4. For > some strange reason using selectinload and attempting to cache the frozen > result is causing <AttributeError: 'PathToken' object has no attribute > 'serialize': > Here are the load options I'm using: > > load_options: Optional[List] = [ > joinedload(CatalogProduct.partner).load_only( > "name", "partner_type", "status" > ), > joinedload(CatalogProduct.product).options( > selectinload(Product.attributes), > selectinload(Product.values), > joinedload(Product.subcategory).joinedload(Subcategory.category), > joinedload(Product.template).selectinload(ProductTemplate.attributes), > ), > selectinload(CatalogProduct.uoms) > .joinedload(CatalogProductUoM.uom) > .load_only("name"), > joinedload(CatalogProduct.default_uom) > .joinedload(CatalogProductUoM.uom) > .load_only("name"), > joinedload(CatalogProduct.restock_uom) > .joinedload(CatalogProductUoM.uom) > .load_only("name"), > selectinload(CatalogProduct.areas) > .joinedload(CatalogProductArea.marketplace_area) > .joinedload(CatalogMarketplaceArea.area) > .load_only("name"), > selectinload(CatalogProduct.excluded_areas) > .joinedload(CatalogMarketplaceArea.area) > .load_only("name"), > selectinload(CatalogProduct.allowed_areas).load_only( > "partner_id", "area_id" > ), > selectinload(CatalogProduct.images), > joinedload(CatalogProduct.default_image), > joinedload(CatalogProduct.supplier).load_only( > "name", "partner_type", "status" > ), > raiseload("*"), > ] > > if I replace all the root selectinloads with joinedloads I don't get the > error. Is there something to do with selectinloads and caching that I'm > missing? Perhaps, ordering? > > > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/f3e129fd-c28b-4db5-8f02-2d9a12d66de6n%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/f3e129fd-c28b-4db5-8f02-2d9a12d66de6n%40googlegroups.com?utm_medium=email&utm_source=footer>. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/8dfc9695-2411-400c-884d-37bfea2c6a3f%40www.fastmail.com.