Subversion Repositories SmartDukaan

Rev

Rev 12476 | Rev 12478 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 12476 Rev 12477
Line 103... Line 103...
103 
def fetchItemsForAutoDecrease(time):
 103 
def fetchItemsForAutoDecrease(time):
104 
    successfulAutoDecrease = []
 104 
    successfulAutoDecrease = []
105 
    autoDecrementItems = session.query(AmazonScrapingHistory).join((Amazonlisted,AmazonScrapingHistory.item_id==Amazonlisted.itemId))\
 105 
    autoDecrementItems = session.query(AmazonScrapingHistory).join((Amazonlisted,AmazonScrapingHistory.item_id==Amazonlisted.itemId))\
106 
    .filter(AmazonScrapingHistory.timestamp==time).filter(or_(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.AMONG_CHEAPEST_CAN_COMPETE,AmazonScrapingHistory.competitiveCategory==CompetitionCategory.COMPETITIVE, AmazonScrapingHistory.competitiveCategory==CompetitionCategory.ALMOST_COMPETE ))\
 106 
    .filter(AmazonScrapingHistory.timestamp==time).filter(or_(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.AMONG_CHEAPEST_CAN_COMPETE,AmazonScrapingHistory.competitiveCategory==CompetitionCategory.COMPETITIVE, AmazonScrapingHistory.competitiveCategory==CompetitionCategory.ALMOST_COMPETE ))\
107 
    .filter(Amazonlisted.autoDecrement==True).all()
 107 
    .filter(Amazonlisted.autoDecrement==True).all()
- 
 
 108 
    print len(autoDecrementItems)
108 
    for autoDecrementItem in autoDecrementItems:
 109 
    for autoDecrementItem in autoDecrementItems:
109 
        if autoDecrementItem.warehouseLocation == 1:
 110 
        if autoDecrementItem.warehouseLocation == 1:
110 
            sku = 'FBA'+str(autoDecrementItem.item_id)
 111 
            sku = 'FBA'+str(autoDecrementItem.item_id)
111 
        else:
 112 
        else:
112 
            sku = 'FBB'+str(autoDecrementItem.item_id)
 113 
            sku = 'FBB'+str(autoDecrementItem.item_id)
Line 162... Line 163...
162 
    successfulAutoIncrease = []
 163 
    successfulAutoIncrease = []
163 
    autoIncrementItems = session.query(AmazonScrapingHistory).join((Amazonlisted,AmazonScrapingHistory.item_id==Amazonlisted.itemId))\
 164 
    autoIncrementItems = session.query(AmazonScrapingHistory).join((Amazonlisted,AmazonScrapingHistory.item_id==Amazonlisted.itemId))\
164 
    .filter(AmazonScrapingHistory.timestamp==time).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.BUY_BOX)\
 165 
    .filter(AmazonScrapingHistory.timestamp==time).filter(AmazonScrapingHistory.competitiveCategory==CompetitionCategory.BUY_BOX)\
165 
    .filter(Amazonlisted.autoIncrement==True).all()
 166 
    .filter(Amazonlisted.autoIncrement==True).all()
166 
    transaction_client = TransactionClient().get_client()
 167 
    transaction_client = TransactionClient().get_client()
- 
 
 168 
    print len(autoIncrementItems)
167 
    for autoIncrementItem in autoIncrementItems:
 169 
    for autoIncrementItem in autoIncrementItems:
168 
        if autoIncrementItem.warehouseLocation == 1:
 170 
        if autoIncrementItem.warehouseLocation == 1:
169 
            sku = 'FBA'+str(autoIncrementItem.item_id)
 171 
            sku = 'FBA'+str(autoIncrementItem.item_id)
170 
        else:
 172 
        else:
171 
            sku = 'FBB'+str(autoIncrementItem.item_id)
 173 
            sku = 'FBB'+str(autoIncrementItem.item_id)