| Line 254... |
Line 254... |
| 254 |
using_table_options(mysql_engine="InnoDB")
|
254 |
using_table_options(mysql_engine="InnoDB")
|
| 255 |
def initialize(dbname='inventory', db_hostname="localhost", setup=True):
|
255 |
def initialize(dbname='inventory', db_hostname="localhost", setup=True):
|
| 256 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
256 |
#metadata.bind = "sqlite:///inventory-new.sqlite" #need to read it from configserver.
|
| 257 |
#metadata.bind = 'mysql://root:shop2020@localhost/inventory'
|
257 |
#metadata.bind = 'mysql://root:shop2020@localhost/inventory'
|
| 258 |
iengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname,
|
258 |
iengine = create_engine('mysql://root:shop2020@' + db_hostname + '/' + dbname,
|
| 259 |
pool_recycle=3600, pool_timeout=30, pool_pre_ping=True)
|
259 |
pool_recycle=3600, pool_timeout=30)
|
| 260 |
metadata.bind = iengine
|
260 |
metadata.bind = iengine
|
| 261 |
metadata.bind.echo = False
|
261 |
metadata.bind.echo = False
|
| 262 |
setup_all(setup)
|
262 |
setup_all(setup)
|
| 263 |
|
263 |
|
| 264 |
if __name__=="__main__":
|
264 |
if __name__=="__main__":
|