-
Notifications
You must be signed in to change notification settings - Fork 0
/
delete_ids.py
42 lines (39 loc) · 1.04 KB
/
delete_ids.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
from connect import Connect
tables = [
'gameData_weather',
'gameData_status',
'gameData_primaryDatacaster',
'gameData_officialScorer',
'gameData_game',
'gameData_flags',
'gameData_datetime',
'liveData_plays_hotcold_pitcher',
'liveData_plays_hotcold_batter',
'liveData_officials',
'liveData_decision',
'liveData_linescore',
'liveData_plays_pitch',
'liveData_plays_runners',
'liveData_plays_matchup',
'liveData_plays_count',
'liveData_plays_about',
'liveData_plays_result',
'gameData_venue',
'gameData_teams',
'gameData_probablePitchers',
'gameData_players',
]
a = Connect()
a.connect()
data=[]
""""
with open('queries.txt','r') as file:
for i in file.readlines():
if 'INSERT INTO gameData_datetime' in i:
data.append(i.split('VALUES (')[1].split(',')[0].replace("'",''))
"""
with open('games_inserted_already.txt','r') as file:
data = [i.replace('\n','') for i in file.readlines()]
for j in tables:
a.insert("DELETE FROM {} WHERE gameid IN ({});".format(str(j),str(','.join(data))))
print("deleted {}".format(j))