Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- category_product = db.Table('category_product',
- db.Column('category_id',
- db.Integer,
- db.ForeignKey('category.id')),
- db.Column('product_id',
- db.Integer,
- db.ForeignKey('product.id')))
- class Product(db.Model):
- """ SQLAlchemy Product Model """
- id = db.Column(db.Integer, primary_key=True)
- sku = db.Column(db.String(10), unique=True, nullable=False)
- name = db.Column(db.String(80), nullable=False)
- categories = db.relationship('Category', secondary=category_product,
- backref=db.backref('categories',
- lazy='dynamic'))
- def __init__(self, name):
- self.name = name
- def __repr__(self):
- return '<Product {}>'.format(self.name)
- class Category(db.Model):
- """ SQLAlchemy Category Model """
- id = db.Column(db.Integer, primary_key=True)
- name = db.Column(db.String(80), nullable=False)
- products = db.relationship('Product', secondary=category_product,
- backref=db.backref('products', lazy='dynamic'))
- def __init__(self, name):
- self.name = name
- def __repr__(self):
- return '<Category {}>'.format(self.name)
- products = db.session.query(Category).
- filter_by(id=category_id).
- products.
- all()
- AttributeError: 'Query' object has no attribute 'products'
- products = db.session.query(Category).
- filter_by(id=category_id).
- products.
- all()
- all_products = Category.query.
- filter_by(id=category_id).
- first().
- products
- product = Product.query.filter(Category.products.any(id=cat_id)).all()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement