Enhancing custom stat capability

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Enhancing custom stat capability

Postby ApeironD » Mon Dec 19, 2011 7:48 pm

Is there a way to “store” custom stat data into the database from within PT3? Specifically, I would like to “store” a custom stat for each table hand played (i.e. 1, 2, 3, …..). Then retrieve the data in contiguous blocks (n, n+1, N+2, + … , N+k, K the data period length) for further computation. If so then one could possibly create a workspace table or add columns to an approiate existing table (if one exist).
ApeironD
 
Posts: 23
Joined: Tue Aug 31, 2010 12:30 am

Re: Enhancing custom stat capability

Postby WhiteRider » Tue Dec 20, 2011 5:13 am

I'm not sure exactly what you're trying to do, but adding columns to existing tables is not supported - when you change the database structure it can affect how PT3 enters and retrieves data.

If you explain what you're trying to achieve, or an example, then we may be able to suggest an alternative approach.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Enhancing custom stat capability

Postby ApeironD » Thu Dec 22, 2011 12:22 pm

I may be able to accomplish it by using the live_table_history_stat( stat, index) function. First what is the definition of "index"? Is it the hand number (1,2,3,..)? Second may "stat" be a custom stat?
ApeironD
 
Posts: 23
Joined: Tue Aug 31, 2010 12:30 am

Re: Enhancing custom stat capability

Postby kraada » Thu Dec 22, 2011 1:18 pm

There are only certain things that are available.

Can you please explain what you are trying to do? If one of the available options will help you we'll gladly explain what one to use.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Enhancing custom stat capability

Postby ApeironD » Thu Dec 22, 2011 2:07 pm

I would like to know what the terms "stat" and "index" mean in the function live_table_history_stat( stat, index) for two reasons. First, I can not find these terms defined in any of the documentation. Perhaps they are clear to many, but, not me. So, I am at a loss in its possible uses. Second is to determine if it can be used in a current application.

As for the current application. Example: I have a custom stat called "floped 2s" that computes the number of floped 2s when ever I run the report. It is in the "Holdem Cash Sessions" report section. Of course it computes this stat for all hands played in the selected session. When the selected session is live the report returns the value for the last hand imported. I would like to know what some of the stat values were for selected previous hands in a live session (when playing one table). Even if the live_table_history_stat function is not applicable to this application I would still like to have an explaination of how the function works or be directed to documentation or a post where it is well defined.

Thanks for your timely response.
ApeironD
 
Posts: 23
Joined: Tue Aug 31, 2010 12:30 am

Re: Enhancing custom stat capability

Postby ApeironD » Thu Dec 22, 2011 9:08 pm

I have since found a post that describes how the live_table_history_stat( stat, index) function works. So no need for an explanation. I only need to know if it works for a custom stat. Also since the function is also available to "variables" I would assume it can be used for extracting variable history data as well. And if applicable to variables can the function be used with custom variables? Also any suggestions on the example problem would be welcomed.
ApeironD
 
Posts: 23
Joined: Tue Aug 31, 2010 12:30 am

Re: Enhancing custom stat capability

Postby WhiteRider » Fri Dec 23, 2011 5:33 am

"stat" can only be one of the defined terms. See the "Live Stats" section of the Tutorial: Custom Reports and Statistics for more information and a list of available values for "stat".
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Enhancing custom stat capability

Postby ApeironD » Fri Dec 23, 2011 5:17 pm

Thanks for the info. It would be of great use, as well, to retreive each data item in the "processed" hand file for the last 10 hands. This would give maximun capability for the construction of custom stats. No need for a reply. Thanks again.
ApeironD
 
Posts: 23
Joined: Tue Aug 31, 2010 12:30 am


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 16 guests

cron
highfalutin