def put_grand_summary_data(num_players): try: cnx = mysql.connector.connect( user=db_params["username"], password=db_params["password"], database=db_params["database"] ) cur = cnx.cursor() insert_grand_summary = ( "insert into gamesim_grand_summary_data " "(num_players, player_wins_total, player_hands_total, " "hand_type_wins_total, hand_type_hands_total, " "hole_hand_wins_total, hole_hand_hands_total, " "hole_hand_tied_wins_total) values (%(num_players)s, " "%(player_wins_total)s, %(player_hands_total)s, " "%(hand_type_wins_total)s, %(hand_type_hands_total)s, " "%(hole_hand_wins_total)s, %(hole_hand_hands_total)s, " "%(hole_hand_tied_wins_total)s); " ) players, player_wins_total, player_hands_total = th_i.putPlayers( num_players, initialData["players_initial"], initialCounters["player_wins_initial"], initialCounters["player_hands_initial"], ) player_wins_total = json.dumps(player_wins_total) player_hands_total = json.dumps(player_hands_total) hand_type_wins_total = json.dumps(initialCounters["hand_type_wins"]) hand_type_hands_total = json.dumps(initialCounters["hand_type_hands"]) hole_hand_wins_total = json.dumps(initialCounters["hole_hand_wins"]) hole_hand_hands_total = json.dumps(initialCounters["hole_hand_hands"]) hole_hand_tied_wins_total = json.dumps(initialCounters["hole_hand_tied_wins"]) insert_data = { "num_players": str(num_players), "player_wins_total": player_wins_total, "player_hands_total": player_hands_total, "hand_type_wins_total": hand_type_wins_total, "hand_type_hands_total": hand_type_hands_total, "hole_hand_wins_total": hole_hand_wins_total, "hole_hand_hands_total": hole_hand_hands_total, "hole_hand_tied_wins_total": hole_hand_tied_wins_total, } cur.execute(insert_grand_summary, insert_data) cnx.commit() cnx.close except mysql.connector.Error as e: print(e.args[0]) print(e.args[1]) cnx.close return
def put_grand_summary_data(num_players): try: cnx = mysql.connector.connect(user=db_params['username'], password = \ db_params['password'], database= db_params['database']) cur = cnx.cursor() insert_grand_summary = ( "insert into gamesim_grand_summary_data " "(num_players, player_wins_total, player_hands_total, " "hand_type_wins_total, hand_type_hands_total, " "hole_hand_wins_total, hole_hand_hands_total, " "hole_hand_tied_wins_total) values (%(num_players)s, " "%(player_wins_total)s, %(player_hands_total)s, " "%(hand_type_wins_total)s, %(hand_type_hands_total)s, " "%(hole_hand_wins_total)s, %(hole_hand_hands_total)s, " "%(hole_hand_tied_wins_total)s); ") players, player_wins_total, player_hands_total = th_i.putPlayers( \ num_players, initialData['players_initial'], \ initialCounters['player_wins_initial'], \ initialCounters['player_hands_initial']) player_wins_total = json.dumps(player_wins_total) player_hands_total = json.dumps(player_hands_total) hand_type_wins_total = json.dumps(initialCounters['hand_type_wins']) hand_type_hands_total = json.dumps(initialCounters['hand_type_hands']) hole_hand_wins_total = json.dumps(initialCounters['hole_hand_wins']) hole_hand_hands_total = json.dumps(initialCounters['hole_hand_hands']) hole_hand_tied_wins_total = \ json.dumps(initialCounters['hole_hand_tied_wins']) insert_data = {'num_players': str(num_players), 'player_wins_total': \ player_wins_total, 'player_hands_total': player_hands_total, \ 'hand_type_wins_total':hand_type_wins_total, \ 'hand_type_hands_total': hand_type_hands_total, \ 'hole_hand_wins_total': hole_hand_wins_total, \ 'hole_hand_hands_total': hole_hand_hands_total, \ 'hole_hand_tied_wins_total': hole_hand_tied_wins_total} cur.execute(insert_grand_summary, insert_data) cnx.commit() cnx.close except mysql.connector.Error as e: print(e.args[0]) print(e.args[1]) cnx.close return
cnx.commit() cnx.close() except mysql.connector.Error as e: print(e.args[0]) print(e.args[1]) cnx.close() return ############################################################################### ########## Start GameSimulation ######################################### ############################################################################### db_params = {'username':'******', 'password': '******', \ 'database': 'texasholdem_db'} th_i.set_global_sql_variables() delete_loop_status_data() sim_id = int(sys.argv[1]) num_players, num_cpus, num_loops, num_games, sim_dir = \ th_i.getSimulationParameters(sim_id) os.chdir(sim_dir) start1 = time.time() run_time = get_run_time(sim_id) python, childProcess = th_i.get_python_scripts() players, player_wins_total, player_hands_total = th_i.get_initial_players()
cnx.close() return ############################################################################### ######################## Game ############################################## #root_dir = 'C:\\Users\\Larry\\SkyDrive\\Python\\Django\\texasholdem1\\' #app_dir = 'gamesim\\' #sim_script_dir = 'sim_scripts\\' #data_dir = 'data_dir\\' cpuNum = '1' db_params = {'username':'******', 'password': '******', \ 'database': 'texasholdem_db'} th_i.set_global_sql_variables() sim_id = int(sys.argv[1]) numberOfGames, save_game_data = th_i.getSimulationParametersChild(sim_id) Players, Player_Wins, Player_Hands = th_i.get_game_players() CardSuits, CardRanks, CardRankNumbers = th_i.get_cards() HandTypes, HandType_Ranks = th_i.get_hands() HandType_Wins, HandType_Hands = th_i.get_hand_counters() DistinctHoleHands = th_i.get_hole_hands() DistinctHoleHands2_Wins, DistinctHoleHands2_Hands, \ DistinctHoleHands2_TiedWins = th_i.get_hole_hand_counters()
cnx.close() except mysql.connector.Error as e: print(e.args[0]) print(e.args[1]) cnx.close() return ############################################################################### ########## Start GameSimulation ######################################### ############################################################################### db_params = {'username':'******', 'password': '******', \ 'database': 'texasholdem_db'} th_i.set_global_sql_variables() delete_loop_status_data() sim_id = int(sys.argv[1]) num_players, num_cpus, num_loops, num_games, sim_dir = \ th_i.getSimulationParameters(sim_id) os.chdir(sim_dir) start1 = time.time() run_time = get_run_time(sim_id) python, childProcess = th_i.get_python_scripts() players, player_wins_total, player_hands_total = th_i.get_initial_players()