Hello, guys!
I have a simple code, which not correct work
He throw error if i try sort items by @hybrid_property
*My version of entity class:*
class Product(Base) :
__tablename__ = 'products'
Id = Column('id', Integer, primary_key=True, autoincrement=True)
TitleTranslit = Column('title_translit', String)
Title = Column('title', String)
Description = Column('description', String)
CurrentPrice = Column('current_price', Integer)
OldPrice = Column('old_price', Integer)
CategoryId = Column('category_id', Integer, ForeignKey('categories.id'))
Characteristics:List[ProductCharacteristic] =
relationship('ProductCharacteristic',
primaryjoin="and_(ProductCharacteristic.ProductId==Product.Id)",
lazy='joined')
Reviews:List[ProductReview] = relationship('ProductReview',
primaryjoin="and_(ProductReview.ProductId==Product.Id)", lazy='joined')
Images:List[ProductImage] = relationship('ProductImage',
primaryjoin="and_(ProductImage.ProductId==Product.Id)", lazy='joined')
NumberOfViews = Column('number_of_views', Integer)
@hybrid_property
def Rating(self) :
result = 0
reviewsCount = len(self.Reviews)
if (reviewsCount > 0) :
for review in self.Reviews :
result += review.Rating
result = result / reviewsCount
return result
*My version of call sort event by @hybrid_property:*
filteredProductsQuery = self._sessionService.DBContext.query(Product)\
.filter(Product.CategoryId.in_(categoriesIds)).outerjoin(Product.Characteristics)
if sortType == SortType.HighestRate.value :
filteredProductsQuery =
filteredProductsQuery.order_by(Product.Rating.desc())
*Throwed error if i try execute this query:*
TypeError: object of type 'InstrumentedAttribute' has no len()
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/d6ccf7c1-fd12-4fb8-b16d-5280f54d506an%40googlegroups.com.
