holdem_cache Table

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

holdem_cache Table

Postby winneronline » Sun Nov 09, 2008 11:45 am

Hi there.

I have a few questions.
What exactly is it stored in this table of the DB? Checking the DB with pgAdmin I understand that it contains almost every column needed to create every stat. The things that I want to know are the following :
1) Is this table updated only when I run the "Update Cache" from the DB Housekeeping in side PT3?
2) Does PT3's hud combine info stored at this table with all new imported hands info stored at other tables to produce the real result?
3) If i wanted to create my own hud, how could I know eg that {holdem_cache.cnt_f_check} is the result of checking the {holdem_hand_player_statistics.flg_f_check} value of X hands?
winneronline
 
Posts: 11
Joined: Fri Jan 25, 2008 3:44 pm

Re: holdem_cache Table

Postby kraada » Sun Nov 09, 2008 11:53 am

(1) Yes.
(2) Yes.
(3) You'd create your HUD using whatever statistics you have available; if you create a new statistic you'll need to update the cache so that the cache has whatever it needs for the new stat you're using. You don't really need to know what it's accessing in the cache.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: holdem_cache Table

Postby winneronline » Sun Nov 09, 2008 12:05 pm

Thanks mate.
winneronline
 
Posts: 11
Joined: Fri Jan 25, 2008 3:44 pm

Re: holdem_cache Table

Postby kraada » Mon Nov 10, 2008 9:57 am

No problem, if there's anything else I can help with, please feel free to ask.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 4 guests