Open Side Menu Go to the Top

07-23-2008 , 08:59 PM
anybody running their own SQL queries yet?
SQL Queries and HM Quote
SQL Queries and HM
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
SQL Queries and HM
07-24-2008 , 05:52 AM
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.
SQL Queries and HM Quote
07-24-2008 , 10:17 AM
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.
SQL Queries and HM Quote
11-30-2008 , 11:26 AM
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
SQL Queries and HM Quote
12-02-2008 , 03:14 PM
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?
SQL Queries and HM Quote
12-02-2008 , 03:21 PM
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.
SQL Queries and HM Quote
02-18-2010 , 03:37 PM
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
SQL Queries and HM Quote
SQL Queries and HM
150% up to $2,000 Welcome Bonus on CoinPoker
Join the action now
Daily Rewards • Splash Pots • CoinRaces
SQL Queries and HM

      
m