comparison trafficintelligence/metadata.py @ 1087:9cc51a2d3c46

bug corrected
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Wed, 31 Oct 2018 16:25:10 -0400
parents 8734742c08c0
children 78dddfe7aa0f
comparison
equal deleted inserted replaced
1086:8734742c08c0 1087:9cc51a2d3c46
339 # results: sqlite 339 # results: sqlite
340 340
341 def createDatabase(filename): 341 def createDatabase(filename):
342 'creates a session to query the filename' 342 'creates a session to query the filename'
343 if Path(filename).is_file(): 343 if Path(filename).is_file():
344 print('The file '+filename+' exists')
345 return None
346 else:
344 engine = create_engine('sqlite:///'+filename) 347 engine = create_engine('sqlite:///'+filename)
345 Base.metadata.create_all(engine) 348 Base.metadata.create_all(engine)
346 Session = sessionmaker(bind=engine) 349 Session = sessionmaker(bind=engine)
347 return Session() 350 return Session()
348 else:
349 print('The file '+filename+' does not exist')
350 return None
351 351
352 def connectDatabase(filename): 352 def connectDatabase(filename):
353 'creates a session to query the filename' 353 'creates a session to query the filename'
354 if Path(filename).is_file(): 354 if Path(filename).is_file():
355 engine = create_engine('sqlite:///'+filename) 355 engine = create_engine('sqlite:///'+filename)