com.archibus.datasource

Class DataStatistics

java.lang.Object

com.archibus.datasource.DataStatistics

public class DataStatistics
extends java.lang.Object

Provides static methods that return aggregated ("statistics") field values, for example:

 SELECT MAX(date_due) FROM cost_tran_recur WHERE ...
 

Most methods apply VPA restrictions for the current user. The exceptions are the getIntWithoutVpa methods that do not apply VPA restrictions and can be used to retrieve the latest value of an auto-numbered primary key. Note that using DataStatistics in the multiple-user environment does not guarantee that the retrieved value is actually the latest, due to possible database concurrency effects.

Constructor Summary

Constructors

Constructor and Description
DataStatistics()

Method Summary

Modifier and Type	Method and Description
static java.util.Date	getDate(java.lang.String table, java.lang.String field, java.lang.String formula)
static java.util.Date	getDate(java.lang.String table, java.lang.String field, java.lang.String formula, com.archibus.datasource.restriction.Restrictions.Restriction.Clause c)
static java.util.Date	getDate(java.lang.String table, java.lang.String field, java.lang.String formula, com.archibus.datasource.restriction.Restrictions.Restriction r) Returns aggregated date value.
static java.util.Date	getDate(java.lang.String table, java.lang.String field, java.lang.String formula, java.lang.String sql)
static double	getDouble(java.lang.String table, java.lang.String field, java.lang.String formula)
static double	getDouble(java.lang.String table, java.lang.String field, java.lang.String formula, com.archibus.datasource.restriction.Restrictions.Restriction.Clause c)
static double	getDouble(java.lang.String table, java.lang.String field, java.lang.String formula, com.archibus.datasource.restriction.Restrictions.Restriction r) Returns aggregated numeric value.
static double	getDouble(java.lang.String table, java.lang.String field, java.lang.String formula, java.lang.String sql)
static int	getInt(java.lang.String table, java.lang.String field, java.lang.String formula)
static int	getInt(java.lang.String table, java.lang.String field, java.lang.String formula, com.archibus.datasource.restriction.Restrictions.Restriction.Clause c)
static int	getInt(java.lang.String table, java.lang.String field, java.lang.String formula, com.archibus.datasource.restriction.Restrictions.Restriction r) Returns aggregated integer value.
static int	getInt(java.lang.String table, java.lang.String field, java.lang.String formula, java.lang.String sql)
static int	getIntWithoutVpa(java.lang.String table, java.lang.String field, java.lang.String formula)
static int	getIntWithoutVpa(java.lang.String table, java.lang.String field, java.lang.String formula, com.archibus.datasource.restriction.Restrictions.Restriction.Clause c)
static int	getIntWithoutVpa(java.lang.String table, java.lang.String field, java.lang.String formula, com.archibus.datasource.restriction.Restrictions.Restriction r) Returns aggregated integer value retrieved without applying per-user VPA restrictions.
static int	getIntWithoutVpa(java.lang.String table, java.lang.String field, java.lang.String formula, java.lang.String sql)
static java.lang.String	getString(java.lang.String table, java.lang.String field, java.lang.String formula)
static java.lang.String	getString(java.lang.String table, java.lang.String field, java.lang.String formula, com.archibus.datasource.restriction.Restrictions.Restriction.Clause c)
static java.lang.String	getString(java.lang.String table, java.lang.String field, java.lang.String formula, com.archibus.datasource.restriction.Restrictions.Restriction r) Returns aggregated text value.
static java.lang.String	getString(java.lang.String table, java.lang.String field, java.lang.String formula, java.lang.String sql)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DataStatistics

public DataStatistics()

Method Detail

getDouble

public static double getDouble(java.lang.String table,
                               java.lang.String field,
                               java.lang.String formula,
                               com.archibus.datasource.restriction.Restrictions.Restriction r)

Returns aggregated numeric value.

Parameters:

table - Base table name.

field - Base field name.

formula - Aggregation formula: min, max, count, sum, avg.

r - Optional restriction clause.

Returns:

Aggregated numeric value.

getDouble

public static double getDouble(java.lang.String table,
                               java.lang.String field,
                               java.lang.String formula,
                               com.archibus.datasource.restriction.Restrictions.Restriction.Clause c)

getDouble

public static double getDouble(java.lang.String table,
                               java.lang.String field,
                               java.lang.String formula,
                               java.lang.String sql)

getDouble

public static double getDouble(java.lang.String table,
                               java.lang.String field,
                               java.lang.String formula)

getInt

public static int getInt(java.lang.String table,
                         java.lang.String field,
                         java.lang.String formula,
                         com.archibus.datasource.restriction.Restrictions.Restriction r)

Returns aggregated integer value.

Parameters:

table - Base table name.

field - Base field name.

formula - Aggregation formula: min, max, count, sum, avg.

r - Optional restriction clause.

Returns:

Aggregated numeric value.

getInt

public static int getInt(java.lang.String table,
                         java.lang.String field,
                         java.lang.String formula,
                         com.archibus.datasource.restriction.Restrictions.Restriction.Clause c)

getInt

public static int getInt(java.lang.String table,
                         java.lang.String field,
                         java.lang.String formula,
                         java.lang.String sql)

getInt

public static int getInt(java.lang.String table,
                         java.lang.String field,
                         java.lang.String formula)

getIntWithoutVpa

public static int getIntWithoutVpa(java.lang.String table,
                                   java.lang.String field,
                                   java.lang.String formula,
                                   com.archibus.datasource.restriction.Restrictions.Restriction r)

Returns aggregated integer value retrieved without applying per-user VPA restrictions.

Parameters:

table - Base table name.

field - Base field name.

formula - Aggregation formula: min, max, count, sum, avg.

r - Optional restriction clause.

Returns:

Aggregated numeric value.

getIntWithoutVpa

public static int getIntWithoutVpa(java.lang.String table,
                                   java.lang.String field,
                                   java.lang.String formula,
                                   com.archibus.datasource.restriction.Restrictions.Restriction.Clause c)

getIntWithoutVpa

public static int getIntWithoutVpa(java.lang.String table,
                                   java.lang.String field,
                                   java.lang.String formula,
                                   java.lang.String sql)

getIntWithoutVpa

public static int getIntWithoutVpa(java.lang.String table,
                                   java.lang.String field,
                                   java.lang.String formula)

getString

public static java.lang.String getString(java.lang.String table,
                                         java.lang.String field,
                                         java.lang.String formula,
                                         com.archibus.datasource.restriction.Restrictions.Restriction r)

Returns aggregated text value.

Parameters:

table - Base table name.

field - Base field name.

formula - Aggregation formula: min, max, count.

r - Optional restriction clause.

Returns:

Aggregated text value.

getString

public static java.lang.String getString(java.lang.String table,
                                         java.lang.String field,
                                         java.lang.String formula,
                                         com.archibus.datasource.restriction.Restrictions.Restriction.Clause c)

getString

public static java.lang.String getString(java.lang.String table,
                                         java.lang.String field,
                                         java.lang.String formula,
                                         java.lang.String sql)

getString

public static java.lang.String getString(java.lang.String table,
                                         java.lang.String field,
                                         java.lang.String formula)

getDate

public static java.util.Date getDate(java.lang.String table,
                                     java.lang.String field,
                                     java.lang.String formula,
                                     com.archibus.datasource.restriction.Restrictions.Restriction r)

Returns aggregated date value.

Parameters:

table - Base table name.

field - Base field name.

formula - Aggregation formula: min, max, count.

r - Optional restriction clause.

Returns:

Aggregated date value.

getDate

public static java.util.Date getDate(java.lang.String table,
                                     java.lang.String field,
                                     java.lang.String formula,
                                     com.archibus.datasource.restriction.Restrictions.Restriction.Clause c)

getDate

public static java.util.Date getDate(java.lang.String table,
                                     java.lang.String field,
                                     java.lang.String formula,
                                     java.lang.String sql)

getDate

public static java.util.Date getDate(java.lang.String table,
                                     java.lang.String field,
                                     java.lang.String formula)