Mercurial Hosting > traffic-intelligence
comparison trafficintelligence/storage.py @ 1265:0f5bebd62a55
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: |