Subversion Repositories SmartDukaan

Rev

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

Rev 16412 Rev 16479
Line 427... Line 427...
427 
    user_id =  Field(Integer(unsigned=True))
 427 
    user_id =  Field(Integer(unsigned=True))
428 
    type=Field(Enum('clear','brand'))
 428 
    type=Field(Enum('clear','brand'))
429 
    filters = Field(String(256))
 429 
    filters = Field(String(256))
430 
    using_options(shortnames=True)
 430 
    using_options(shortnames=True)
431 
    using_table_options(mysql_engine="InnoDB")
 431 
    using_table_options(mysql_engine="InnoDB")
- 
 
 432 
 
- 
 
 433 
class app_offers(Entity):
- 
 
 434 
    id = Field(Integer, primary_key=True)
- 
 
 435 
    affiliate_id = Field(Integer)
- 
 
 436 
    affiliate_app_id = Field(String(256))
- 
 
 437 
    startDate = Field(DateTime)
- 
 
 438 
    endDate = Field(DateTime)
- 
 
 439 
    affiliate_offer_id = Field(String(256))
- 
 
 440 
    offer_price = Field(Float)
- 
 
 441 
    app_name = Field(String(256))
- 
 
 442 
    image_url = Field(String(256))
- 
 
 443 
    description = Field(String(256))
- 
 
 444 
    link = Field(String(256))
- 
 
 445 
    offer_active = Field(Boolean)
- 
 
 446 
    action = Field(String)
- 
 
 447 
    priority = Field(String)
- 
 
 448 
    show = Field(Boolean)
- 
 
 449 
    using_options(shortnames=True)
- 
 
 450 
    using_table_options(mysql_engine="InnoDB")
- 
 
 451 
 
- 
 
 452 
class app_affiliates(Entity):
- 
 
 453 
    id = Field(Integer, primary_key=True)
- 
 
 454 
    name = Field(String(256))
- 
 
 455 
    isActive = Field(Boolean)
- 
 
 456 
    using_options(shortnames=True)
- 
 
 457 
    using_table_options(mysql_engine="InnoDB")
- 
 
 458
- 
 
 459
432
460
433 
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
 461 
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
434 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 462 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
435 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 463 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
436 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 464 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)