Subversion Repositories SmartDukaan

Rev

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

Rev 17349 Rev 18258
Line 596... Line 596...
596 
    sendsms = Field(Boolean)
 596 
    sendsms = Field(Boolean)
597 
    messagetext = Field(String(512))
 597 
    messagetext = Field(String(512))
598 
    smsprocessed = Field(Boolean)
 598 
    smsprocessed = Field(Boolean)
599 
    using_options(shortnames=True)
 599 
    using_options(shortnames=True)
600 
    using_table_options(mysql_engine="InnoDB")
 600 
    using_table_options(mysql_engine="InnoDB")
- 
 
 601 
 
- 
 
 602 
class mobileappsettings(Entity):
- 
 
 603 
    id = Field(Integer, primary_key=True, autoincrement=True)
- 
 
 604 
    setting = Field(String(64))
- 
 
 605 
    value = Field(String(512))
601
606 
    created = Field(DateTime)
- 
 
 607 
    modified= Field(DateTime)
- 
 
 608 
    using_options(shortnames=True)
- 
 
 609 
    using_table_options(mysql_engine="InnoDB")
- 
 
 610 
 
- 
 
 611 
class UserMasterData(Entity):
- 
 
 612 
    id = Field(Integer(unsigned=True), primary_key=True)
- 
 
 613 
    user_id = Field(Integer(unsigned=True))
- 
 
 614 
    agent_id=Field(Integer(unsigned=True))
- 
 
 615 
    project_id=Field(Integer(unsigned=True))
- 
 
 616 
    contact1 = Field(String(10))
- 
 
 617 
    pincode_servicable = Field(Boolean)
- 
 
 618 
    status = Field(String(20))
- 
 
 619 
    retry_count = Field(Integer(3))
- 
 
 620 
    invalid_retry_count = Field(Integer(3))
- 
 
 621 
    next_call_time = Field(DateTime)
- 
 
 622 
    counter = Field(Integer(unsigned=True))
- 
 
 623 
    disposition = Field(String(32))
- 
 
 624 
    created = Field(DateTime, default=func.now())
- 
 
 625 
    modified = Field(DateTime, default=func.now(), onupdate=func.now())
- 
 
 626 
    using_options(shortnames=True)
- 
 
 627 
    using_table_options(mysql_engine="InnoDB")
- 
 
 628 
 
602 
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
 629 
def initialize(dbname='dtr', db_hostname="localhost", echo=True):
603 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
 630 
    #metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
604 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
 631 
    #metadata.bind = 'mysql://root:shop2020@localhost/catalog'
605 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 632 
    cengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
606 
    metadata.bind = cengine
 633 
    metadata.bind = cengine
607 
    metadata.bind.echo = echo
 634 
    metadata.bind.echo = echo
608 
    setup_all(True)
 635 
    setup_all(True)
609 
 
 636 
 
610 
if __name__=="__main__":
 637 
if __name__=="__main__":
611 
    initialize()
 638 
    initialize()
612 
 
 - 
 
613
- 
 
614
- 
 
615 

            639