Mercurial Hosting > traffic-intelligence
comparison python/storage.py @ 690:463150a8e129 dev
minor updates
author | Nicolas Saunier <nicolas.saunier@polymtl.ca> |
---|---|
date | Mon, 29 Jun 2015 15:47:30 -0400 |
parents | 94b291a5f933 |
children | 5ee22bf7e4d5 |
comparison
equal
deleted
inserted
replaced
689:9990ef119bce | 690:463150a8e129 |
---|---|
301 print('no trajectory type was chosen') | 301 print('no trajectory type was chosen') |
302 | 302 |
303 if objectNumbers is None: | 303 if objectNumbers is None: |
304 query = '' | 304 query = '' |
305 elif type(objectNumbers) == int: | 305 elif type(objectNumbers) == int: |
306 query = statementBeginning+'between 0 and {0} '.format(objectNumbers) | 306 query = statementBeginning+'between 0 and {0} '.format(objectNumbers-1) |
307 elif type(objectNumbers) == list: | 307 elif type(objectNumbers) == list: |
308 query = statementBeginning+'in ('+', '.join([str(n) for n in objectNumbers])+') ' | 308 query = statementBeginning+'in ('+', '.join([str(n) for n in objectNumbers])+') ' |
309 return query | 309 return query |
310 | 310 |
311 def loadTrajectoriesFromTable(connection, tableName, trajectoryType, objectNumbers = None): | 311 def loadTrajectoriesFromTable(connection, tableName, trajectoryType, objectNumbers = None): |