Subversion Repositories SmartDukaan

Rev

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

Rev 14780 Rev 14862
Line 365... Line 365...
365 
    minimumPossibleTpVoi = Field(Float)
 365 
    minimumPossibleTpVoi = Field(Float)
366 
    courierCostVoi = Field(Float)
 366 
    courierCostVoi = Field(Float)
367 
    serviceTaxVoi = Field(Float)
 367 
    serviceTaxVoi = Field(Float)
368 
    transferPriceVoi = Field(Float)
 368 
    transferPriceVoi = Field(Float)
369 
    commissionVoi = Field(Float)
 369 
    commissionVoi = Field(Float)
- 
 
 370 
    courierCostMarketplaceVoi = Field(Float)
- 
 
 371 
    commissionPercentageVoi = Field(Float)
370 
    using_options(shortnames=True)
 372 
    using_options(shortnames=True)
371 
    using_table_options(mysql_engine="InnoDB")
 373 
    using_table_options(mysql_engine="InnoDB")
372 
 
 374 
 
373 
class MarketPlaceUpdateHistory(Entity):
 375 
class MarketPlaceUpdateHistory(Entity):
374 
    id  = Field(Integer, primary_key=True, autoincrement = True)
 376 
    id  = Field(Integer, primary_key=True, autoincrement = True)
Line 763... Line 765...
763 
    addedTimestamp = Field(DateTime)
 765 
    addedTimestamp = Field(DateTime)
764 
    addedBy = Field(String(100))
 766 
    addedBy = Field(String(100))
765 
    using_options(shortnames=True)
 767 
    using_options(shortnames=True)
766 
    using_table_options(mysql_engine="InnoDB")
 768 
    using_table_options(mysql_engine="InnoDB")
767 
 
 769 
 
- 
 
 770 
class VoiSnapdealItemInfo(Entity):
- 
 
 771 
    item_id = Field(Integer, primary_key=True, autoincrement = False)
- 
 
 772 
    voiSkuAtSnapdeal = Field(String(255))
- 
 
 773 
    sellingPriceSnapdeal = Field(Float)
- 
 
 774 
    transferPriceSnapdeal = Field(Float)
- 
 
 775 
    fixedMargin = Field(Float)
- 
 
 776 
    fixedMarginPercentage = Field(Float)
- 
 
 777 
    logisticCostSnapdeal = Field(Float)
- 
 
 778 
    woodenPackagingCost = Field(Float)
- 
 
 779 
    weightSnapdeal = Field(Float)
- 
 
 780 
 
768 
def initialize(dbname='catalog', db_hostname="localhost"):
 781 
def initialize(dbname='catalog', db_hostname="localhost"):
769 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 782 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
770 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 783 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
771 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 784 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
772 
    metadata.bind = cengine
 785 
    metadata.bind = cengine
773 
    metadata.bind.echo = False
 786 
    metadata.bind.echo = True
774 
    setup_all(True)
 787 
    setup_all(True)
775 
 
 788 
 
776 
if __name__=="__main__":
 789 
if __name__=="__main__":
777 
    initialize()
 790 
    initialize()