Mercurial Hosting > traffic-intelligence
comparison python/storage.py @ 712:21aeadcfbabb
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') |