Subversion Repositories SmartDukaan

Rev

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

Rev 12133 Rev 12243
Line 563... Line 563...
563 
    brand = Field(String(100))
 563 
    brand = Field(String(100))
564 
    category_id = Field(Integer)
 564 
    category_id = Field(Integer)
565 
    returnProvision = Field(Float)
 565 
    returnProvision = Field(Float)
566 
    using_options(shortnames=True)
 566 
    using_options(shortnames=True)
567 
    using_table_options(mysql_engine="InnoDB")
 567 
    using_table_options(mysql_engine="InnoDB")
- 
 
 568
- 
 
 569 
class CompetitorPricing(Entity):
- 
 
 570 
    item_id = Field(Integer)
- 
 
 571 
    snapdealScraping = Field(Boolean)
- 
 
 572 
    flipkartScraping = Field(Boolean)
- 
 
 573 
    amazonScraping = Field(Boolean)
- 
 
 574 
    lowestSnapdealPrice = Field(Float)
- 
 
 575 
    lowestFlipkartPrice = Field(Float)
- 
 
 576 
    lowestMfnPrice = Field(Float)
- 
 
 577 
    lowestFbaPrice = Field(Float)
- 
 
 578 
    isProcessed = Field(Boolean)
- 
 
 579 
    uploadId = Field(BigInteger)
- 
 
 580 
    using_options(shortnames=True)
- 
 
 581 
    using_table_options(mysql_engine="InnoDB")
- 
 
 582
568 
 
 583 
 
569 
def initialize(dbname='catalog', db_hostname="localhost"):
 584 
def initialize(dbname='catalog', db_hostname="localhost"):
570 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 585 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
571 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 586 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
572 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 587 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)