Mercurial > hg > nsaunier > traffic-intelligence

comparison trafficintelligence/storage.py @ 1265:0f5bebd62a55

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
minor modifications
author Nicolas Saunier <nicolas.saunier@polymtl.ca>
date Fri, 24 May 2024 16:15:38 -0400
parents 28aeec1f2788
children 785c86013d2c
comparison
equal deleted inserted replaced
1264:dff5b678a33a 1265:0f5bebd62a55
495 def saveInteraction(cursor, interaction): 495 def saveInteraction(cursor, interaction):
496 roadUserNumbers = list(interaction.getRoadUserNumbers()) 496 roadUserNumbers = list(interaction.getRoadUserNumbers())
497 cursor.execute('INSERT INTO interactions VALUES({}, {}, {}, {}, {})'.format(interaction.getNum(), roadUserNumbers[0], roadUserNumbers[1], interaction.getFirstInstant(), interaction.getLastInstant())) 497 cursor.execute('INSERT INTO interactions VALUES({}, {}, {}, {}, {})'.format(interaction.getNum(), roadUserNumbers[0], roadUserNumbers[1], interaction.getFirstInstant(), interaction.getLastInstant()))
498 498
499 def saveInteractionsToSqlite(filename, interactions): 499 def saveInteractionsToSqlite(filename, interactions):
500 'Saves the interactions in the table' 500 'Saves only the interactions in the table'
501 with sqlite3.connect(filename) as connection: 501 with sqlite3.connect(filename) as connection:
502 cursor = connection.cursor() 502 cursor = connection.cursor()
503 try: 503 try:
504 createInteractionTable(cursor) 504 createInteractionTable(cursor)
505 for inter in interactions: 505 for inter in interactions: