| Line 2823... |
Line 2823... |
| 2823 |
return AmazonPromotion.query.filter(AmazonPromotion.startDate>=(to_py_date(startDate))).filter(AmazonPromotion.endDate<=(to_py_date(endDate))).all()
|
2823 |
return AmazonPromotion.query.filter(AmazonPromotion.startDate>=(to_py_date(startDate))).filter(AmazonPromotion.endDate<=(to_py_date(endDate))).all()
|
| 2824 |
|
2824 |
|
| 2825 |
def update_amazon_promotion(amazonPromotions):
|
2825 |
def update_amazon_promotion(amazonPromotions):
|
| 2826 |
for amazonPromotion in amazonPromotions:
|
2826 |
for amazonPromotion in amazonPromotions:
|
| 2827 |
amp = AmazonPromotion.get_by(sku=amazonPromotion.sku,addedOn=amazonPromotion.addedOn, promotionType = amazonPromotion.promotionType )
|
2827 |
amp = AmazonPromotion.get_by(sku=amazonPromotion.sku,addedOn=amazonPromotion.addedOn, promotionType = amazonPromotion.promotionType )
|
| 2828 |
amp.updatedOnMarketplace = datetime.datetime.now()
|
2828 |
amp.updatedOnMarketplace = amazonPromotion.updatedOnMarkeetplace
|
| 2829 |
session.commit()
|
2829 |
session.commit()
|
| 2830 |
|
2830 |
|
| 2831 |
def __get_amazon_promotion_attributes_for_item(item_id):
|
2831 |
def __get_amazon_promotion_attributes_for_item(item_id):
|
| 2832 |
timestamp = datetime.datetime.now()
|
2832 |
timestamp = datetime.datetime.now()
|
| 2833 |
fbaPromo = AmazonPromotion.query.filter(AmazonPromotion.sku=='FBA'+str(item_id)).filter(AmazonPromotion.startDate<=timestamp).filter(AmazonPromotion.endDate>=timestamp).filter(AmazonPromotion.updatedOnMarketplace>to_py_date(0)).order_by(desc(AmazonPromotion.updatedOnMarketplace)).limit(1).all()
|
2833 |
fbaPromo = AmazonPromotion.query.filter(AmazonPromotion.sku=='FBA'+str(item_id)).filter(AmazonPromotion.startDate<=timestamp).filter(AmazonPromotion.endDate>=timestamp).filter(AmazonPromotion.updatedOnMarketplace>to_py_date(0)).order_by(desc(AmazonPromotion.updatedOnMarketplace)).limit(1).all()
|