Open Side Menu Go to the Top
Register
Hand history into MYSQL database. Hand history into MYSQL database.

09-13-2015 , 10:36 AM
How do I enter a hand history into a mysql database?
I am planning to write a hud for five card draw, but at the moment I am lol bad

This is how a hand history looks from poker stars. I changed the screenname of the players to player 1 and so on.

PokerStars Hand #abignumber: 5 Card Draw Limit ($0.25/$0.50 USD) - 2015/08/08 0:07:29 CET [2015/08/07 18:07:29 ET]
Table 'Alrami V' 6-max Seat #2 is the button
Seat 1: Player1 ($9.04 in chips)
Seat 2: Player2 ($4.61 in chips)
Seat 3: Player3 ($66.69 in chips)
Seat 4: Hero ($5 in chips)
Seat 5: Player5 ($13.68 in chips)
Seat 6: Player6 ($3.10 in chips)
Player3: posts small blind $0.10
Hero: posts big blind $0.25
*** DEALING HANDS ***
Dealt to Hero [Ts 3c 3d Tc 8s]
Player5: calls $0.25
Player6: calls $0.25
Player1: folds
Player2: folds
Player3: folds
Hero: raises $0.25 to $0.50
Player5: calls $0.25
Player6: calls $0.25
Hero: discards 1 card [8s]
Dealt to Hero [Ts 3c 3d Tc] [2s]
Player5: discards 1 card
Player6: discards 1 card
Hero: checks
Player5: checks
Player6: bets $0.50
Hero: folds
Player5: calls $0.50
*** SHOW DOWN ***
Player6: shows [9h Th Jc Kh Qh] (a straight, Nine to King)
Player5: mucks hand
RAFULIK collected $2.48 from pot
*** SUMMARY ***
Total pot $2.60 | Rake $0.12
Seat 1: Player1 folded before the Draw (didn't bet)
Seat 2: Player2 (button) folded before the Draw (didn't bet)
Seat 3: Player3(small blind) folded before the Draw
Seat 4: Hero (big blind) folded after the Draw
Seat 5: Player5 [8h 8d 5s 6d 5c]
Seat 6: Player6 showed [9h Th Jc Kh Qh] and won ($2.48) with a straight, Nine to King



But how do I get it into some tables? It needs to be automated. I know a little bit c#, python and sql
Hand history into MYSQL database. Quote
09-13-2015 , 07:43 PM
You can look at http://fpdb.wikidot.com/ and see what they are doing. They use Python.
Hand history into MYSQL database. Quote
09-14-2015 , 05:52 PM
I hear Python has some decent GUI libraries nowadays, just write a script that scans your hand history folder however often you want to update, parse files that have been touched since the last scan writing to the db and update an overlay that stays on top of all applications whenever Poker Stars is the frontmost app and hides when it's not, rendering relevant data from the db. If this is just an exercise you should probably just keep all the data in RAM at first until you get the rest working, then figure out how to read and write from a db.
Hand history into MYSQL database. Quote
09-14-2015 , 05:53 PM
I looked, I even have fpdb downloaded. But I can't find the source code. I can read the fpdb bat file, but there is an exe file that I can't read.
Hand history into MYSQL database. Quote
09-14-2015 , 06:03 PM
I personally, would parse the hand history into a Json Schema before putting any data into the database.
Hand history into MYSQL database. Quote
09-19-2015 , 02:32 PM
Quote:
Originally Posted by iosys
I personally, would parse the hand history into a Json Schema before putting any data into the database.
+1
Hand history into MYSQL database. Quote

      
m