SQL Queries and HM - Gambling and Poker Software Forum

Two Plus Two Forums Online Poker Sites & Marketplaces Poker Software General Software Discussion

SQL Queries and HM

Post Reply Subscribe

...

07-23-2008 , 08:59 PM

tehDiceman

veteran

Join Date: Oct 2006 Posts: 2,066

anybody running their own SQL queries yet?

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

07-24-2008 , 05:52 AM

BabboonBoy

journeyman

Join Date: Apr 2007 Posts: 274

Everyday, lots of them, but then again I spend time at work using databases. I think you need to be more specific in what you are asking.

Quote

07-24-2008 , 10:17 AM

tehDiceman

veteran

Join Date: Oct 2006 Posts: 2,066

more or less im looking to see what anyone is already running so that i dont have to reinvent the wheel.

if there are none, i can pour over the structure and try to figure it out, i'd rather not go that route just yet.

Quote

11-30-2008 , 11:26 AM

MonkeyLunch

newbie

Join Date: Jul 2005 Posts: 39

I've got SQuirrel SQL Client pointing at my Holdem Manager postgres database and ran a few queries:

-- Find my player_id (there are two, one on UB one on AP after the merge)
select * from players where (playername like 'Mon%' or playername like 'MONKE%')

--hands where I had aces (2 sites UB and AP)
select * from playerhandscashkeycolumns where player_id in (1, 292) and holecardvalue_id = 1

--hands where I had aces and opponent held kings
select * from playerhandscashkeycolumns where player_id not in (1, 292) and pokerhand_id in
(select pokerhand_id from playerhandscashkeycolumns where player_id in (1, 292) and holecardvalue_id = 1)
and holecard1int in (13, 26, 39, 52) and holecard2int in (13, 26, 39, 52)

holecard1int and holecard2int are:
1=ace of d to 13=King of d, 14-26 is clubs, 27-39 hearts, 40-52 spades

Quote

12-02-2008 , 03:14 PM

HaroldT32

old hand

Join Date: Sep 2008 Posts: 1,438

Hi MonkeyLunch,

I posted this in the other thread before i saw this one and I thought I would repost here so you might be able to help, but is there a way for me to export the data as seen under the "sessions" tab into an excel sheet? I want to take all hands from a db with the same # of players, at the same level and strip out every sessions vpip/%wsd/w$sd and a few others, is what I want to do possible?

Quote

12-02-2008 , 03:21 PM

MonkeyLunch

newbie

Join Date: Jul 2005 Posts: 39

Well, I'm not sure about export options for data from within holdem manager itself (at work right now

), but it's certainly possible by writing a query then exporting the results. The problem is understanding the data structure well enough to write your query - the one you suggest is quite a bit more complex than mine. I figured mine out by looking at the data in the database and comparing it with a particular hand I see in holdem mangager, etc.

Quote

02-18-2010 , 03:37 PM

atari2600

journeyman

Join Date: Apr 2008 Posts: 220

Thanks MonkeyLunch, you saved me a bunch of time. I gave more props in the other thread, as well as a link to a blog I wrote about this very subject.

http://forumserver.twoplustwo.com/45...ueries-214388/

-SL

Quote

150% up to $2,000 Welcome Bonus on CoinPoker

Join the action now

Daily Rewards • Splash Pots • CoinRaces

Post Reply Subscribe

...