Subversion Repositories SmartDukaan

Rev

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

Rev 7384 Rev 7397
Line 1614... Line 1614...
1614
    session.commit()
1614
    session.commit()
1615
    
1615
    
1616
def add_amazon_item(amazonlisted):
1616
def add_amazon_item(amazonlisted):
1617
    if (not amazonlisted) or (not amazonlisted.itemid) or (not amazonlisted.asin):
1617
    if (not amazonlisted) or (not amazonlisted.itemid) or (not amazonlisted.asin):
1618
        return
1618
        return
-
 
1619
    amazonItem = Amazonlisted.get_by(itemId=amazonlisted.itemid)
-
 
1620
    if amazonItem is None:
1619
    amazon_item = Amazonlisted()
1621
        amazon_item = Amazonlisted()
1620
    if amazonlisted.itemid:
1622
        if amazonlisted.itemid:
1621
        amazon_item.itemId=amazonlisted.itemid
1623
            amazon_item.itemId=amazonlisted.itemid
1622
    if amazonlisted.asin:
1624
        if amazonlisted.asin:
1623
        amazon_item.asin=amazonlisted.asin
1625
            amazon_item.asin=amazonlisted.asin
1624
    if amazonlisted.brand:
1626
        if amazonlisted.brand:
1625
        amazon_item.brand=amazonlisted.brand
1627
            amazon_item.brand=amazonlisted.brand
-
 
1628
        else:
-
 
1629
            amazon_item.brand=''
-
 
1630
        if amazonlisted.model:
-
 
1631
            amazon_item.model=amazonlisted.model
-
 
1632
        else:
-
 
1633
            amazon_item.model=''
-
 
1634
        if amazonlisted.manufacturer_name:
-
 
1635
            amazon_item.manufacturer_name=amazonlisted.manufacturer_name
-
 
1636
        else:
-
 
1637
            amazon_item.manufacturer_name=''
-
 
1638
        if amazonlisted.name:
-
 
1639
            amazon_item.name=amazonlisted.name
-
 
1640
        else:
-
 
1641
            amazon_item.name=''
-
 
1642
        if amazonlisted.part_number:
-
 
1643
            amazon_item.part_number=amazonlisted.part_number
-
 
1644
        else:
-
 
1645
            amazon_item.part_number=''
-
 
1646
        if amazonlisted.ean:
-
 
1647
            amazon_item.ean=amazonlisted.ean
-
 
1648
        else:
-
 
1649
            amazon_item.ean=''
-
 
1650
        if amazonlisted.upc:
-
 
1651
            amazon_item.upc=amazonlisted.upc
-
 
1652
        else:
-
 
1653
            amazon_item.upc=''
-
 
1654
        if amazonlisted.sellingPrice:
-
 
1655
            amazon_item.sellingPrice=amazonlisted.sellingPrice
-
 
1656
        if amazonlisted.fbaPrice:
-
 
1657
            amazon_item.fbaPrice=amazonlisted.fbaPrice
-
 
1658
        if amazonlisted.isFba:
-
 
1659
            amazon_item.isFba=amazonlisted.isFba
-
 
1660
        if amazonlisted.isNonFba:
-
 
1661
            amazon_item.isNonFba=amazonlisted.isNonFba
-
 
1662
        if amazonlisted.isInventoryOverride:
-
 
1663
            amazon_item.isInventoryOverride=amazonlisted.isInventoryOverride
-
 
1664
        if amazonlisted.category:
-
 
1665
            amazon_item.category=amazonlisted.category
-
 
1666
        else:
-
 
1667
            amazon_item.category=''
-
 
1668
        if amazonlisted.color:
-
 
1669
            amazon_item.color=amazonlisted.color
-
 
1670
        else:
-
 
1671
            amazon_item.category=''
-
 
1672
    elif (amazonItem.asin!=amazonlisted.asin):
-
 
1673
        if amazonlisted.asin:
-
 
1674
            amazonItem.asin=amazonlisted.asin
-
 
1675
        if amazonlisted.brand:
-
 
1676
            amazonItem.brand=amazonlisted.brand
-
 
1677
        else:
-
 
1678
            amazonItem.brand=''
-
 
1679
        if amazonlisted.model:
-
 
1680
            amazonItem.model=amazonlisted.model
-
 
1681
        else:
-
 
1682
            amazonItem.model=''
-
 
1683
        if amazonlisted.manufacturer_name:
-
 
1684
            amazonItem.manufacturer_name=amazonlisted.manufacturer_name
-
 
1685
        else:
-
 
1686
            amazonItem.manufacturer_name=''
-
 
1687
        if amazonlisted.name:
-
 
1688
            amazonItem.name=amazonlisted.name
-
 
1689
        else:
-
 
1690
            amazonItem.name=''
-
 
1691
        if amazonlisted.part_number:
-
 
1692
            amazonItem.part_number=amazonlisted.part_number
-
 
1693
        else:
-
 
1694
            amazonItem.part_number=''
-
 
1695
        if amazonlisted.ean:
-
 
1696
            amazonItem.ean=amazonlisted.ean
-
 
1697
        else:
-
 
1698
            amazonItem.ean=''
-
 
1699
        if amazonlisted.upc:
-
 
1700
            amazonItem.upc=amazonlisted.upc
-
 
1701
        else:
-
 
1702
            amazonItem.upc=''
-
 
1703
        if amazonlisted.sellingPrice:
-
 
1704
            amazonItem.sellingPrice=amazonlisted.sellingPrice
-
 
1705
        if amazonlisted.fbaPrice:
-
 
1706
            amazonItem.fbaPrice=amazonlisted.fbaPrice
-
 
1707
        if amazonlisted.isFba:
-
 
1708
            amazonItem.isFba=amazonlisted.isFba
-
 
1709
        if amazonlisted.isNonFba:
-
 
1710
            amazonItem.isNonFba=amazonlisted.isNonFba
-
 
1711
        if amazonlisted.isInventoryOverride:
-
 
1712
            amazonItem.isInventoryOverride=amazonlisted.isInventoryOverride
-
 
1713
        if amazonlisted.category:
-
 
1714
            amazonItem.category=amazonlisted.category
-
 
1715
        else:
-
 
1716
            amazonItem.category=''
-
 
1717
        if amazonlisted.color:
-
 
1718
            amazonItem.color=amazonlisted.color
-
 
1719
        else:
-
 
1720
            amazonItem.category=''
1626
    else:
1721
    else:
1627
        amazon_item.brand=''
-
 
1628
    if amazonlisted.model:
-
 
1629
        amazon_item.model=amazonlisted.model
-
 
1630
    else:
-
 
1631
        amazon_item.model=''
-
 
1632
    if amazonlisted.manufacturer_name:
-
 
1633
        amazon_item.manufacturer_name=amazonlisted.manufacturer_name
-
 
1634
    else:
-
 
1635
        amazon_item.manufacturer_name=''
-
 
1636
    if amazonlisted.name:
-
 
1637
        amazon_item.name=amazonlisted.name
-
 
1638
    else:
-
 
1639
        amazon_item.name=''
-
 
1640
    if amazonlisted.part_number:
-
 
1641
        amazon_item.part_number=amazonlisted.part_number
-
 
1642
    else:
-
 
1643
        amazon_item.part_number=''
-
 
1644
    if amazonlisted.ean:
-
 
1645
        amazon_item.ean=amazonlisted.ean
-
 
1646
    else:
-
 
1647
        amazon_item.ean=''
-
 
1648
    if amazonlisted.upc:
-
 
1649
        amazon_item.upc=amazonlisted.upc
-
 
1650
    else:
-
 
1651
        amazon_item.upc=''
-
 
1652
    if amazonlisted.sellingPrice:
-
 
1653
        amazon_item.sellingPrice=amazonlisted.sellingPrice
-
 
1654
    if amazonlisted.fbaPrice:
-
 
1655
        amazon_item.fbaPrice=amazonlisted.fbaPrice
-
 
1656
    if amazonlisted.isFba:
-
 
1657
        amazon_item.isFba=amazonlisted.isFba
-
 
1658
    if amazonlisted.isNonFba:
-
 
1659
        amazon_item.isNonFba=amazonlisted.isNonFba
-
 
1660
    if amazonlisted.isInventoryOverride:
-
 
1661
        amazon_item.isInventoryOverride=amazonlisted.isInventoryOverride
-
 
1662
    if amazonlisted.category:
-
 
1663
        amazon_item.category=amazonlisted.category
-
 
1664
    else:
-
 
1665
        amazon_item.category=''
-
 
1666
    if amazonlisted.color:
-
 
1667
        amazon_item.color=amazonlisted.color
-
 
1668
    else:
1722
        return
1669
        amazon_item.category=''
-
 
1670
    session.commit()
1723
    session.commit()
1671
    
1724
    
1672
def get_asin_items():
1725
def get_asin_items():
1673
    from_date=datetime.datetime.now() - datetime.timedelta(days=10)
1726
    from_date=datetime.datetime.now() - datetime.timedelta(days=10)
1674
    return Item.query.filter(Item.updatedOn > from_date).all()
1727
    return Item.query.filter(Item.updatedOn > from_date).all()