Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- output = ((5153419, 5178566), (5153419, 5178568), (5153419, 5178565), (5153419, 5178562), (5153419, 5178567), (5153419, 5178563), (5153419, 5178561), (5153419, 5178564))
- connection = sqlite3.connect("test_database.db")
- c = connection.cursor()
- c.execute("DROP TABLE IF EXISTS Meeting")
- c.execute("CREATE TABLE Meeting(MeetingID INT, RaceID INT)")
- c.executemany("INSERT INTO Meeting VALUES(?,?)", output)
- c.execute("SELECT MeetingID, RaceID from Meeting")
- for row in c.fetchall():
- print(row)
- ## Output
- [saythrenshaw@localhost racing]$ /usr/bin/python3 /home/saythrenshaw/racing/parse_nsw.py
- (5153419, 5178566)
- (5153419, 5178568)
- (5153419, 5178565)
- (5153419, 5178562)
- (5153419, 5178567)
- (5153419, 5178563)
- (5153419, 5178561)
- (5153419, 5178564)
Add Comment
Please, Sign In to add comment