def hist_FD_playerdata(Sport,Url,ContestID):
#player_map = Ugen.excel_mapping('Player Map',1,2)
FD_dict = ast.literal_eval(Uds.parse_html(Url,"FD.playerpicker.allPlayersFullData = ",";"))
todays_date=time.strftime("%Y-%m-%d")
db_data=[]
# print Url
for fd_key in FD_dict:
player_name=FD_dict[fd_key][1]
position=FD_dict[fd_key][0]
FD_Salary=FD_dict[fd_key][5]
FD_FPPG=FD_dict[fd_key][6]
FD_GP=FD_dict[fd_key][7]
db_data=[ContestID,Sport,todays_date,player_name,FD_Salary,FD_FPPG,FD_GP,position]
columns='contestID,Sport,Date,Player,FD_Salary,FD_FPPG,FD_GP,Position'
placeholders = ', '.join(['%s'] * len(db_data))
table='hist_fanduel_data'
#print 'now historizing %s contest#: %d player %s' % (Sport,ContestID,player_name)
dbo.insert_mysql(table,columns,db_data,placeholders)
return
def hist_FD_playerdata(Sport, Url, ContestID):
#player_map = Ugen.excel_mapping('Player Map',1,2)
FD_dict = ast.literal_eval(
Uds.parse_html(Url, "FD.playerpicker.allPlayersFullData = ", ";"))
todays_date = time.strftime("%Y-%m-%d")
db_data = []
# print Url
for fd_key in FD_dict:
player_name = FD_dict[fd_key][1]
position = FD_dict[fd_key][0]
FD_Salary = FD_dict[fd_key][5]
FD_FPPG = FD_dict[fd_key][6]
FD_GP = FD_dict[fd_key][7]
db_data = [
ContestID, Sport, todays_date, player_name, FD_Salary, FD_FPPG,
FD_GP, position
]
columns = 'contestID,Sport,Date,Player,FD_Salary,FD_FPPG,FD_GP,Position'
placeholders = ', '.join(['%s'] * len(db_data))
table = 'hist_fanduel_data'
#print 'now historizing %s contest#: %d player %s' % (Sport,ContestID,player_name)
dbo.insert_mysql(table, columns, db_data, placeholders)
return
def get_FD_playerlist(): #Cole: move this to FD operations
FD_list = ast.literal_eval(Uds.parse_html(Cell('Parameters','cLineUpURL').value,"FD.playerpicker.allPlayersFullData = ",";"))
return FD_list
def get_FD_contests(contest_url): print contest_url FD_contests = ast.literal_eval(Uds.parse_html(contest_url,"FD.playerpicker.teamIdToFixtureCompactString = ",";")) return FD_contests
def get_FD_playerlist(contest_url): FD_list = ast.literal_eval(Uds.parse_html(contest_url,"FD.playerpicker.allPlayersFullData = ",";")) return FD_list
def get_FD_playerlist(): #Cole: move this to FD operations
FD_list = ast.literal_eval(Uds.parse_html(Cell('Parameters','cLineUpURL').value,"FD.playerpicker.allPlayersFullData = ",";"))
return FD_list
