Mercurial > hg > nsaunier > traffic-intelligence

comparison 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
comparison
equal deleted inserted replaced
1290:9012fb72d79a 1291:46a30ce1a2e4
185 185
186 try: 186 try:
187 objectCriteria = getObjectCriteria(objectNumbers) 187 objectCriteria = getObjectCriteria(objectNumbers)
188 queryStatement = None 188 queryStatement = None
189 if trajectoryType == 'feature': 189 if trajectoryType == 'feature':
190 queryStatement = 'SELECT * from '+tableName 190 queryStatement = 'SELECT trajectory_id, frame_number, x_coordinate, y_coordinate from '+tableName
191 if objectNumbers is not None and timeStep is not None: 191 if objectNumbers is not None and timeStep is not None:
192 queryStatement += ' WHERE trajectory_id '+objectCriteria+' AND frame_number%{} = 0'.format(timeStep) 192 queryStatement += ' WHERE trajectory_id '+objectCriteria+' AND frame_number%{} = 0'.format(timeStep)
193 elif objectNumbers is not None: 193 elif objectNumbers is not None:
194 queryStatement += ' WHERE trajectory_id '+objectCriteria 194 queryStatement += ' WHERE trajectory_id '+objectCriteria
195 elif timeStep is not None: 195 elif timeStep is not None: