Total Hands in Tourney DB?

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Total Hands in Tourney DB?

Postby SwizzleStack » Fri Dec 26, 2008 9:30 pm

I'm trying to figure out how many hands I have in an observed hands database.

In the database, would the total number of rows in the tourney_holdem_hand_histories table be the correct number?
SwizzleStack
 
Posts: 26
Joined: Sun Jan 27, 2008 4:24 am

Re: Total Hands in Tourney DB?

Postby kraada » Sat Dec 27, 2008 10:16 am

Assuming you always save the hand histories for your observed hands, yes that should do it. (I assume you know how to figure out how many rows there are in that table; for those that don't who find this thread later: Start --> Programs --> PostgreSQL --> psql to 'template1' (or psql to 'postgres', whichever it says), \l to list databases, \connect DataBaseName to connect to your database, then select count(*) from tourney_holdem_hand_histories; (and that semicolon is needed), and you'd select from holdem_hand_histories for a cash game total.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Total Hands in Tourney DB?

Postby SwizzleStack » Sat Dec 27, 2008 6:42 pm

Thanks. I'd highly recommend DBVisualizer. It's a free tool that makes it easy to see your database as well as write sql queries.
SwizzleStack
 
Posts: 26
Joined: Sun Jan 27, 2008 4:24 am


Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 16 guests