Mercurial > hg > nsaunier > traffic-intelligence

diff trafficintelligence/storage.py @ 1291:46a30ce1a2e4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
dealing with modified table structures
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Thu, 15 Aug 2024 17:04:16 -0400
parents 76f5693b530c
children 51893de43293
line wrap: on
line diff
--- a/trafficintelligence/storage.py	Fri Jul 26 21:53:03 2024 +0200
+++ b/trafficintelligence/storage.py	Thu Aug 15 17:04:16 2024 -0400
@@ -187,7 +187,7 @@
         objectCriteria = getObjectCriteria(objectNumbers)
         queryStatement = None
         if trajectoryType == 'feature':
-            queryStatement = 'SELECT * from '+tableName
+            queryStatement = 'SELECT trajectory_id, frame_number, x_coordinate, y_coordinate from '+tableName
             if objectNumbers is not None and timeStep is not None:
                 queryStatement += ' WHERE trajectory_id '+objectCriteria+' AND frame_number%{} = 0'.format(timeStep)
             elif objectNumbers is not None: