Subversion Repositories SmartDukaan

Rev

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

Rev 11816 Rev 11905
Line 542... Line 542...
542 
    fba = Field(Boolean)
 542 
    fba = Field(Boolean)
543 
    fbb = Field(Boolean)
 543 
    fbb = Field(Boolean)
544 
    using_options(shortnames=True)
 544 
    using_options(shortnames=True)
545 
    using_table_options(mysql_engine="InnoDB")
 545 
    using_table_options(mysql_engine="InnoDB")
546 
 
 546 
 
- 
 
 547 
class PrivateDealsPriceComparison(Entity):
- 
 
 548 
    item_id= Field(Integer, primary_key=True, autoincrement=False)
- 
 
 549 
    asin = String(20)
- 
 
 550 
    fsn = String(20)
- 
 
 551 
    supc = String(20)
- 
 
 552 
    sdPrice = Field(Float)
- 
 
 553 
    fkPrice  = Field(Float)
- 
 
 554 
    amazonPrice = Field(Float)
- 
 
 555 
    dealPrice = Field(Float)
- 
 
 556 
    saholicPrice = Field(Float)
- 
 
 557 
    lastProcessedTimestamp = Field(DateTime)
- 
 
 558 
    using_options(shortnames=True)
- 
 
 559 
    using_table_options(mysql_engine="InnoDB")
547 
 
 560 
 
548 
def initialize(dbname='catalog', db_hostname="localhost"):
 561 
def initialize(dbname='catalog', db_hostname="localhost"):
549 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 562 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
550 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 563 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
551 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 564 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)