Mercurial > hg > nsaunier > traffic-intelligence

comparison python/storage.py @ 712:21aeadcfbabb

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
added script to test SQLite performance and impact of indices
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Thu, 23 Jul 2015 01:13:32 -0400
parents 523eda2fafd4
children d6c69d3d09e5
comparison
equal deleted inserted replaced
711:523eda2fafd4 712:21aeadcfbabb
336 logging.debug(queryStatement) 336 logging.debug(queryStatement)
337 elif trajectoryType == 'object': 337 elif trajectoryType == 'object':
338 queryStatement = 'SELECT OF.object_id, P.frame_number, avg(P.x_coordinate), avg(P.y_coordinate) from '+tableName+' P, objects_features OF where P.trajectory_id = OF.trajectory_id' 338 queryStatement = 'SELECT OF.object_id, P.frame_number, avg(P.x_coordinate), avg(P.y_coordinate) from '+tableName+' P, objects_features OF where P.trajectory_id = OF.trajectory_id'
339 if objectNumbers is not None: 339 if objectNumbers is not None:
340 queryStatement += ' and OF.object_id '+objectCriteria 340 queryStatement += ' and OF.object_id '+objectCriteria
341 queryStatement += ' group by OF.object_id, P.frame_number ORDER BY OF.object_id, P.frame_number' 341 queryStatement += ' GROUP BY OF.object_id, P.frame_number ORDER BY OF.object_id, P.frame_number'
342 cursor.execute(queryStatement) 342 cursor.execute(queryStatement)
343 logging.debug(queryStatement) 343 logging.debug(queryStatement)
344 elif trajectoryType in ['bbtop', 'bbbottom']: 344 elif trajectoryType in ['bbtop', 'bbbottom']:
345 if trajectoryType == 'bbtop': 345 if trajectoryType == 'bbtop':
346 corner = 'top_left' 346 corner = 'top_left'
347 elif trajectoryType == 'bbbottom': 347 elif trajectoryType == 'bbbottom':
348 corner = 'bottom_right' 348 corner = 'bottom_right'
349 queryStatement = 'SELECT object_id, frame_number, x_'+corner+', y_'+corner+' FROM '+tableName 349 queryStatement = 'SELECT object_id, frame_number, x_'+corner+', y_'+corner+' FROM '+tableName
350 if objectNumbers is not None: 350 if objectNumbers is not None:
351 queryStatement += ' where object_id '+objectCriteria 351 queryStatement += ' WHERE object_id '+objectCriteria
352 queryStatement += ' ORDER BY object_id, frame_number' 352 queryStatement += ' ORDER BY object_id, frame_number'
353 cursor.execute(queryStatement) 353 cursor.execute(queryStatement)
354 logging.debug(queryStatement) 354 logging.debug(queryStatement)
355 else: 355 else:
356 print('no trajectory type was chosen') 356 print('no trajectory type was chosen')