Subversion Repositories SmartDukaan

Rev

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

Rev 11905 Rev 12133
Line 544... Line 544...
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):
 547 
class PrivateDealsPriceComparison(Entity):
548 
    item_id= Field(Integer, primary_key=True, autoincrement=False)
 548 
    item_id= Field(Integer, primary_key=True, autoincrement=False)
549 
    asin = String(20)
 549 
    asin = Field(String(20))
550 
    fsn = String(20)
 550 
    fsn = Field(String(20))
551 
    supc = String(20)
 551 
    supc = Field(String(20))
552 
    sdPrice = Field(Float)
 552 
    sdPrice = Field(Float)
553 
    fkPrice  = Field(Float)
 553 
    fkPrice  = Field(Float)
554 
    amazonPrice = Field(Float)
 554 
    amazonPrice = Field(Float)
555 
    dealPrice = Field(Float)
 555 
    dealPrice = Field(Float)
556 
    saholicPrice = Field(Float)
 556 
    saholicPrice = Field(Float)
557 
    lastProcessedTimestamp = Field(DateTime)
 557 
    lastProcessedTimestamp = Field(DateTime)
558 
    using_options(shortnames=True)
 558 
    using_options(shortnames=True)
559 
    using_table_options(mysql_engine="InnoDB")
 559 
    using_table_options(mysql_engine="InnoDB")
560 
 
 560 
 
- 
 
 561 
class SourceReturnPercentage(Entity):
- 
 
 562 
    source = Field(Integer)
- 
 
 563 
    brand = Field(String(100))
- 
 
 564 
    category_id = Field(Integer)
- 
 
 565 
    returnProvision = Field(Float)
- 
 
 566 
    using_options(shortnames=True)
- 
 
 567 
    using_table_options(mysql_engine="InnoDB")
- 
 
 568 
 
561 
def initialize(dbname='catalog', db_hostname="localhost"):
 569 
def initialize(dbname='catalog', db_hostname="localhost"):
562 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 570 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
563 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 571 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
564 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 572 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
565 
    metadata.bind = cengine
 573 
    metadata.bind = cengine