Mercurial Hosting > traffic-intelligence
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) |