-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathPresale_api.py
192 lines (160 loc) · 7.6 KB
/
Presale_api.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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
'''
Eventos con venta al público entre fechas determinadas.
Se debe ingresar un rango de fechas de venta al público como número entero.
0 es hoy, -7 una semana hacia atras, -14 dos semanas hacia adelante (todavía no se pusieron a la venta al público).
'''
# from Onsale_module import *
#*************************************************
#Importaciones
from time import strftime, localtime
import datetime
from nested_lookup import nested_lookup
from datetime import timedelta,date,datetime
from GA_module import *
#*************************************************
LowPriceTreshold = 10 #PrecioMax mínimo que debe tener el evento para considerarlo
UpPriceTreshold = 1000 #PrecioMax máximo que debe tener el evento para considerarlo
ScoreTreshold = 10 #Score mínimo del evento para para considerarlo
#Forma de operar el bot
ModoOperativo = '1'
while True:
ModoOperativo = input('1.API Ticketmaster, 2.Archivo: ')
if ModoOperativo == '1' or ModoOperativo == '2': break
#Pregunta fechas para armar la lista
FilePath = "C:/Users/Videla/Documents/Ticket Resale/Chequeo de Eventos/ResponseTM.json"
FirstDay = int(input('Primer día desde dónde buscar eventos en Presale (ej 0=hoy, -7=semana atrás)?'))
LastDay = int(input('Último día hasta donde buscar eventos en Presale (ej, 0=hoy, 7=semana adelante)?'))
today = time.time(); apikey = 'R8ZJ2GjIukrvAfBea1ljwAFgSztZvhHy'; EventList = []
#Determina fechas de análisis
PresaleStartDate = today + FirstDay*86400
PresaleStartDateHuman = strftime('%Y-%m-%d',localtime(PresaleStartDate))
PresaleStartDate = datetime.combine(date.today(), datetime.min.time()) + timedelta(days=FirstDay)
PresaleEndDate = today + LastDay*86400
PresaleEndDateHuman = strftime('%Y-%m-%d',localtime(PresaleEndDate))
PresaleEndDate = datetime.combine(date.today(), datetime.min.time()) + timedelta(days=1+LastDay)
if ModoOperativo == '1':
#Comienza a buscar eventos
for additional_date in range(FirstDay+1,LastDay+5):
OnSaleDate = today + additional_date*86400
OnSaleDate = strftime('%Y-%m-%d',localtime(OnSaleDate))
for page in range(0,6):
calltxt = 'https://app.ticketmaster.com/discovery/v2/events.json?page='+str(page)+'&size=199&onsaleOnStartDate='+OnSaleDate+'&apikey='+apikey
response = requests.get(calltxt).text
response = response.encode("ascii", "ignore").decode("utf-8")
response = json.loads(response)
try: response['_embedded']
except: break
else: response_list = response['_embedded']['events']
EventList.extend(response_list)
print('Events at Ticketmaster',len(EventList))
#Guarda archivo luego de obtener eventos desde Ticketmaster
with open(FilePath, 'w') as f:
json.dump(EventList, f)
# Lee json ya guardado en vez de solicitar la info desde la API de Ticketmaster
if ModoOperativo == '2':
if os.path.exists(FilePath):
f = open(FilePath)
EventList = json.load(f)
f.close()
#Prepara archivo csv para registrar info
if ModoOperativo == '1':
file = "C:/Users/Videla/Documents/Ticket Resale/Chequeo de Eventos/CSVs/Presale from " + PresaleStartDateHuman + ' to ' + PresaleEndDateHuman + ".csv"
else:
file = "C:/Users/Videla/Documents/Ticket Resale/Chequeo de Eventos/CSVs/Presale Events.csv"
if os.path.exists(file): os.remove(file)
LastTitle = ''; LastVenue = ''; LastCity = ''
#Recoge info de cada evento
for Event in EventList:
#Preventa
if not 'presales' in Event["sales"].keys(): continue
PresaleStart = Event["sales"]['presales'][0]['startDateTime']
PresaleStart = datetime.strptime(PresaleStart, "%Y-%m-%dT%H:%M:%SZ") + timedelta(hours=-3)
if PresaleStart < PresaleStartDate or PresaleStart > PresaleEndDate: continue
PresaleStart = PresaleStart.strftime("%m/%d/%Y %H:%M")
PresaleEnd = Event["sales"]['presales'][0]['endDateTime']
PresaleEnd = (datetime.strptime(PresaleEnd, "%Y-%m-%dT%H:%M:%SZ") + timedelta(hours=-3)).strftime("%m/%d/%Y %H:%M")
#Filtro eventos antes de evaluar
if not "_embedded" in Event.keys(): continue
if not "venues" in Event["_embedded"].keys(): continue
if not "country" in Event["_embedded"]["venues"][0].keys(): continue
url = Event["url"]
if not 'ticketmaster' in url and not'livenation' in url: continue
if Event["_embedded"]["venues"][0]["country"]["countryCode"] != 'US': continue
if not "city" in Event["_embedded"]['venues'][0].keys(): continue
Venue = Event["_embedded"]['venues'][0]["name"]; Venue = Venue.replace(",","")
#Detalles del evento
Title = Event["name"]; Title = Title.replace(",","")
EventDate = Event["dates"]['start']['localDate']
try: City = Event["_embedded"]['venues'][0]["city"]["name"] + ' ' + Event["_embedded"]['venues'][0]["state"]["stateCode"]
except: continue
City = City.replace(",","")
if Title==LastTitle and Venue==LastVenue and City==LastCity: continue
LastTitle = Title; LastVenue = Venue; LastCity = City
#Onsale
try: OnSale = Event["sales"]["public"]["startDateTime"]
except: continue
OnSale = (datetime.strptime(OnSale, "%Y-%m-%dT%H:%M:%SZ") + timedelta(hours=-3)).strftime("%m/%d/%Y %H:%M")
#Precios
if "priceRanges" in Event.keys():
try: PriceMax = str(Event["priceRanges"][0]["max"]); PriceMin = str(Event["priceRanges"][0]["min"])
except: continue
if float(PriceMax)<LowPriceTreshold or float(PriceMax)>UpPriceTreshold: continue
else: continue
#Genero
if "subGenre" in Event["classifications"][0].keys():
Genre = Event["classifications"][0]["subGenre"]["name"]; Genre = Genre.replace(",","")
elif "genre" in Event["classifications"][0].keys():
Genre = Event["classifications"][0]["genre"]["name"]; Genre = Genre.replace(",","")
else:
Genre = 'NA'
#Filtra generos
# AllGenres1 = ['Blues','Country','French Rap','Gospel','Indie Folk','Jazz','K-Pop','Latin','Nu-Metal']
# AllGenres2 = ['Pop','R&B','Reggae','Witchstep','Alternative Rock','Funk','Performance Art']
# AllGenres = AllGenres1 + AllGenres2 + ['']
# for EachGenre in AllGenres:
# if Genre == EachGenre: break
# if not EachGenre: continue
#Busco eventos en este venue en Seatgeek
SeatGeekID = 'MzU4OTU1MDl8MTY5NDIxMzk5OC44NjExMDM1'
page = 1; SeatGeekEventList = []
while True:
Seatgeek = 'https://api.seatgeek.com/2/events?per_page=50&q='+Venue+'&page='+str(page)+'&client_id='+SeatGeekID
try: response = requests.get(Seatgeek).json()
except: break
try: response['events']
except: break
SeatGeekEventList.extend(response['events'])
if len(response['events'])<50: break
page += 1
# SeatgeekPath = "C:/Users/Videla/Documents/Ticket Resale/Chequeo de Eventos/ResponseSG.json"
# with open(SeatgeekPath, 'w') as f:
# json.dump(SeatGeekEventList, f)
#Tengo lista de eventos en el venue?
if not SeatGeekEventList: continue
datetime_local = nested_lookup('datetime_local',SeatGeekEventList)
EventOrder = 0
for VenueDate in datetime_local:
Date_study = VenueDate[0:10]
if EventDate == Date_study: break
EventOrder += 1
#Encontré el evento?
if not EventOrder<len(datetime_local): continue
EventFound = SeatGeekEventList[EventOrder]
#Capacidad
capacity = str(EventFound['venue']['capacity'])
if not capacity: capacity = 'NA'
#Seatgeek URL
SeatgeekURL = EventFound['url']
if not SeatgeekURL: SeatgeekURL = 'NA'
#Popularidad del artista
try: PerformerScore = EventFound['performers'][0]['score']*100
except: continue
if PerformerScore < ScoreTreshold: continue
PerformerScore = str(PerformerScore)
#Guarda Archivo
print(Title)
line = PresaleStart+','+PresaleEnd+','+OnSale+','+EventDate+','+Title+','+Venue+','+City+','+Genre+','+PriceMax+','+PriceMin+','+capacity+','+PerformerScore+','+url
Archivador(file,line)
#Pone encabezado al archivo con el listado de ventos
line = 'PresaleStart,PresaleEnd,OnSale,Date,Event,Venue,Place,Genre,PriceMax,PriceMin,Capacity,Score,TM URL,Observation'
Archivador(file,line)