| Line 608... |
Line 608... |
| 608 |
|
608 |
|
| 609 |
class AmazonPromotion(Entity):
|
609 |
class AmazonPromotion(Entity):
|
| 610 |
sku = Field(String(20))
|
610 |
sku = Field(String(20))
|
| 611 |
standardPrice = Field(Float)
|
611 |
standardPrice = Field(Float)
|
| 612 |
salePrice = Field(Float)
|
612 |
salePrice = Field(Float)
|
| - |
|
613 |
subsidy = Field(Float)
|
| 613 |
startDate = Field(DateTime)
|
614 |
startDate = Field(DateTime)
|
| 614 |
endDate = Field(DateTime)
|
615 |
endDate = Field(DateTime)
|
| 615 |
addedOn = Field(DateTime)
|
616 |
addedOn = Field(DateTime)
|
| 616 |
updatedOnMarketplace = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')
|
617 |
updatedOnMarketplace = Field(DateTime,default = datetime.datetime.strptime('01-01-1970 00:00:00', '%d-%m-%Y %H:%M:%S'),server_default = '1970-01-01')
|
| 617 |
promotionActive = Field(Boolean)
|
618 |
promotionActive = Field(Boolean)
|
| Line 623... |
Line 624... |
| 623 |
class AmazonScrapingHistory(Entity):
|
624 |
class AmazonScrapingHistory(Entity):
|
| 624 |
item_id = Field(Integer, primary_key=True, autoincrement=False)
|
625 |
item_id = Field(Integer, primary_key=True, autoincrement=False)
|
| 625 |
warehouseLocation = Field(Integer, primary_key=True, autoincrement=False)
|
626 |
warehouseLocation = Field(Integer, primary_key=True, autoincrement=False)
|
| 626 |
parentCategoryId = Field(Integer)
|
627 |
parentCategoryId = Field(Integer)
|
| 627 |
ourSellingPrice = Field(Float)
|
628 |
ourSellingPrice = Field(Float)
|
| 628 |
ourTp = Field(Float)
|
- |
|
| 629 |
lowestPossibleTp = Field(Float)
|
- |
|
| 630 |
lowestPossibleSp = Field(Float)
|
629 |
lowestPossibleSp = Field(Float)
|
| 631 |
ourRank = Field(Integer)
|
630 |
ourRank = Field(Integer)
|
| 632 |
ourInventory = Field(Integer)
|
631 |
ourInventory = Field(Integer)
|
| 633 |
lowestSellerName = Field(String(255))
|
632 |
lowestSellerName = Field(String(255))
|
| 634 |
lowestSellerSp = Field(Float)
|
633 |
lowestSellerSp = Field(Float)
|
| - |
|
634 |
lowestSellerShippingTime = Field(String(10))
|
| - |
|
635 |
lowestSellerRating = Field(String(10))
|
| - |
|
636 |
lowestSellerType = Field(String(20))
|
| 635 |
secondLowestSellerName = Field(String(255))
|
637 |
secondLowestSellerName = Field(String(255))
|
| 636 |
secondLowestSellerSp = Field(Float)
|
638 |
secondLowestSellerSp = Field(Float)
|
| - |
|
639 |
secondLowestSellerShippingTime = Field(String(10))
|
| - |
|
640 |
secondLowestSellerRating = Field(String(10))
|
| - |
|
641 |
secondLowestSellerType = Field(String(20))
|
| 637 |
thirdLowestSellerName = Field(String(255))
|
642 |
thirdLowestSellerName = Field(String(255))
|
| 638 |
thirdLowestSellerSp = Field(Float)
|
643 |
thirdLowestSellerSp = Field(Float)
|
| - |
|
644 |
thirdLowestSellerShippingTime = Field(String(10))
|
| - |
|
645 |
thirdLowestSellerRating = Field(String(10))
|
| - |
|
646 |
thirdLowestSellerType = Field(String(20))
|
| 639 |
competitiveCategory = Field(Integer)
|
647 |
competitiveCategory = Field(Integer)
|
| 640 |
wanlc = Field(Float)
|
648 |
wanlc = Field(Float)
|
| 641 |
commission = Field(Float)
|
649 |
commission = Field(Float)
|
| 642 |
competitorCommission = Field(Float)
|
650 |
competitorCommission = Field(Float)
|
| 643 |
returnProvision = Field(Float)
|
651 |
returnProvision = Field(Float)
|
| Line 647... |
Line 655... |
| 647 |
totalSeller = Field(Integer)
|
655 |
totalSeller = Field(Integer)
|
| 648 |
ourEnoughStock = Field(Boolean)
|
656 |
ourEnoughStock = Field(Boolean)
|
| 649 |
marginIncreasedPotential = Field(Float)
|
657 |
marginIncreasedPotential = Field(Float)
|
| 650 |
avgSale = Field(Float)
|
658 |
avgSale = Field(Float)
|
| 651 |
multipleListings = Field(Boolean)
|
659 |
multipleListings = Field(Boolean)
|
| - |
|
660 |
isPromotion = Field(Boolean)
|
| 652 |
proposedSp = Field(Float)
|
661 |
proposedSp = Field(Float)
|
| 653 |
proposedTp = Field(Float)
|
662 |
proposedTp = Field(Float)
|
| 654 |
targetNlc = Field(Float)
|
663 |
targetNlc = Field(Float)
|
| 655 |
decision = Field(Integer)
|
664 |
decision = Field(Integer)
|
| 656 |
reason = Field(String(255))
|
665 |
reason = Field(String(255))
|
| 657 |
timestamp =Field(DateTime, primary_key=True, autoincrement=False)
|
666 |
timestamp =Field(DateTime, primary_key=True, autoincrement=False)
|
| 658 |
using_options(shortnames=True)
|
667 |
using_options(shortnames=True)
|
| 659 |
using_table_options(mysql_engine="InnoDB")
|
668 |
using_table_options(mysql_engine="InnoDB")
|
| 660 |
|
- |
|
| 661 |
|
- |
|
| 662 |
|
- |
|
| 663 |
|
669 |
|
| 664 |
|
670 |
|
| 665 |
def initialize(dbname='catalog', db_hostname="localhost"):
|
671 |
def initialize(dbname='catalog', db_hostname="localhost"):
|
| 666 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
672 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 667 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|
673 |
#metadata.bind = 'mysql://root:shop2020@localhost/catalog'
|