Subversion Repositories SmartDukaan

Rev

Rev 13214 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 13214 Rev 35608
Line 170... Line 170...
170 
    using_table_options(mysql_engine = "InnoDB")
 170 
    using_table_options(mysql_engine = "InnoDB")
171
171
172 
 
 172 
 
173 
def initialize(dbname='helper', db_hostname='localhost'):
 173 
def initialize(dbname='helper', db_hostname='localhost'):
174 
    #metadata.bind = "sqlite:///message.sqlite" #need to read it from configserver.
 174 
    #metadata.bind = "sqlite:///message.sqlite" #need to read it from configserver.
175 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200)
 175 
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname,
- 
 
 176 
                           pool_recycle=3600, pool_timeout=30, pool_pre_ping=True)
176 
    metadata.bind = engine
 177 
    metadata.bind = engine
177 
    metadata.bind.echo = True
 178 
    metadata.bind.echo = False
178 
    setup_all(True)
 179 
    setup_all(True)
179 
 
 180 
 
180 
if __name__=="__main__":
 181 
if __name__=="__main__":
181 
    initialize()
 182 
    initialize()
182
183