Subversion Repositories SmartDukaan

Rev

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

Rev 18736 Rev 19236
Line 303... Line 303...
303
    expiredTime = Field(DateTime)
303
    expiredTime = Field(DateTime)
304
    expired = Field(Boolean)
304
    expired = Field(Boolean)
305
    using_options(shortnames=True)
305
    using_options(shortnames=True)
306
    using_table_options(mysql_engine="InnoDB")
306
    using_table_options(mysql_engine="InnoDB")
307
 
307
 
308
def initialize(dbname='user', db_hostname="localhost"):
308
def initialize(dbname='user', db_hostname="localhost", setup=True):
309
    #metadata.bind = "sqlite:///user.sqlite" #need to read it from configserver.
309
    #metadata.bind = "sqlite:///user.sqlite" #need to read it from configserver.
310
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200, max_overflow=20)
310
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname, pool_recycle=7200, max_overflow=20)
311
    metadata.bind = engine
311
    metadata.bind = engine
312
    metadata.bind.echo = True
312
    metadata.bind.echo = True
313
    setup_all(True)
313
    setup_all(setup)
314
 
314
 
315
if __name__=="__main__":
315
if __name__=="__main__":
316
    initialize()
316
    initialize()