Subversion Repositories SmartDukaan

Rev

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

Rev 35608 Rev 35701
Line 141... Line 141...
141
    using_table_options(mysql_engine="InnoDB")
141
    using_table_options(mysql_engine="InnoDB")
142
 
142
 
143
def initialize(dbname="logistics",db_hostname="localhost", echoOn=False, setup=True):
143
def initialize(dbname="logistics",db_hostname="localhost", echoOn=False, setup=True):
144
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
144
    #metadata.bind = "sqlite:///logistics.sqlite" #need to read it from configserver.
145
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname,
145
    engine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname,
146
                           pool_recycle=3600, pool_timeout=30, pool_pre_ping=True)
146
                           pool_recycle=3600, pool_timeout=30)
147
    metadata.bind = engine
147
    metadata.bind = engine
148
    metadata.bind.echo = echoOn
148
    metadata.bind.echo = echoOn
149
    setup_all(setup)
149
    setup_all(setup)
150
 
150
 
151
if __name__=="__main__":
151
if __name__=="__main__":