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