Subversion Repositories SmartDukaan

Rev

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

Rev 3005 Rev 3187
Line 81... Line 81...
81 
    loggedOn = Field(DateTime)
 81 
    loggedOn = Field(DateTime)
82 
    role = Field(Integer)
 82 
    role = Field(Integer)
83 
    using_options(shortnames=True)
 83 
    using_options(shortnames=True)
84 
    using_table_options(mysql_engine="InnoDB")
84 
    using_table_options(mysql_engine="InnoDB")
85
85
86 
def initialize(dbname='helper'):
 86 
def initialize(dbname='helper', db_hostname='localhost'):
87 
    #metadata.bind = "sqlite:///message.sqlite" #need to read it from configserver.
 87 
    #metadata.bind = "sqlite:///message.sqlite" #need to read it from configserver.
88 
    engine = create_engine('mysql://root:shop2020@localhost/' + dbname, pool_recycle=7200)
 88 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
89 
    metadata.bind = engine
 89 
    metadata.bind = engine
90 
    metadata.bind.echo = True
 90 
    metadata.bind.echo = True
91 
    setup_all(True)
 91 
    setup_all(True)
92 
 
 92 
 
93 
if __name__=="__main__":
 93 
if __name__=="__main__":