de.topicmapslab.majortom.database.jdbc.mysql.query
Interface IMySqlSelectQueries.Paged

Enclosing interface:
IMySqlSelectQueries

public static interface IMySqlSelectQueries.Paged


Field Summary
static java.lang.String QUERY_READ_NAMES
          query to read all names of a topic parameters(3): topic id, offset, limit
static java.lang.String QUERY_READ_NUMBER_OF_NAMES
          query to read the number of names of a topic parameters(3): topic id, offset, limit
static java.lang.String QUERY_READ_NUMBER_OF_OCCURRENCES
          query to read the number of occurrences of a topic parameters(3): topic id, offset, limit
static java.lang.String QUERY_READ_NUMBER_OF_PLAYED_ASSOCIATIONS
          Query to read the number of played associations parameters(3): player id, offset, limit
static java.lang.String QUERY_READ_NUMBER_OF_PLAYED_ROLES
          Query to read the number of played roles parameters(3): player id,offset, limit
static java.lang.String QUERY_READ_NUMBER_OF_ROLES
          Query to read the number of roles parameters(3): association id,offset, limit
static java.lang.String QUERY_READ_NUMBER_OF_TYPES
          Query to read the number of types of a topic parameters(3): topic id,offset, limit
static java.lang.String QUERY_READ_NUMBER_OF_VARIANTS
          query to read the number of variants of a name parameters(3): name id,offset, limit
static java.lang.String QUERY_READ_OCCURRENCES
          query to read all occurrences of a topic parameters(3): topic id, offset, limit
static java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS
          Query to read all played associations parameters(4): topic map id, player id, offset, limit
static java.lang.String QUERY_READ_PLAYED_ROLES
          Query to read all played roles parameters(3): player id,offset, limit
static java.lang.String QUERY_READ_ROLES
          Query to read all roles parameters(3): association id,offset, limit
static java.lang.String QUERY_READ_TYPES
          Query to read the types of a topic parameters(3): topic id,offset, limit
static java.lang.String QUERY_READ_VARIANTS
          query to read all variants of a name parameters(3): name id,offset, limit
 

Field Detail

QUERY_READ_PLAYED_ASSOCIATIONS

static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS
Query to read all played associations

parameters(4): topic map id, player id, offset, limit

See Also:
Constant Field Values

QUERY_READ_NAMES

static final java.lang.String QUERY_READ_NAMES
query to read all names of a topic

parameters(3): topic id, offset, limit

See Also:
Constant Field Values

QUERY_READ_OCCURRENCES

static final java.lang.String QUERY_READ_OCCURRENCES
query to read all occurrences of a topic

parameters(3): topic id, offset, limit

See Also:
Constant Field Values

QUERY_READ_ROLES

static final java.lang.String QUERY_READ_ROLES
Query to read all roles

parameters(3): association id,offset, limit

See Also:
Constant Field Values

QUERY_READ_PLAYED_ROLES

static final java.lang.String QUERY_READ_PLAYED_ROLES
Query to read all played roles

parameters(3): player id,offset, limit

See Also:
Constant Field Values

QUERY_READ_TYPES

static final java.lang.String QUERY_READ_TYPES
Query to read the types of a topic

parameters(3): topic id,offset, limit

See Also:
Constant Field Values

QUERY_READ_VARIANTS

static final java.lang.String QUERY_READ_VARIANTS
query to read all variants of a name

parameters(3): name id,offset, limit

See Also:
Constant Field Values

QUERY_READ_NUMBER_OF_PLAYED_ASSOCIATIONS

static final java.lang.String QUERY_READ_NUMBER_OF_PLAYED_ASSOCIATIONS
Query to read the number of played associations

parameters(3): player id, offset, limit

See Also:
Constant Field Values

QUERY_READ_NUMBER_OF_NAMES

static final java.lang.String QUERY_READ_NUMBER_OF_NAMES
query to read the number of names of a topic

parameters(3): topic id, offset, limit

See Also:
Constant Field Values

QUERY_READ_NUMBER_OF_OCCURRENCES

static final java.lang.String QUERY_READ_NUMBER_OF_OCCURRENCES
query to read the number of occurrences of a topic

parameters(3): topic id, offset, limit

See Also:
Constant Field Values

QUERY_READ_NUMBER_OF_ROLES

static final java.lang.String QUERY_READ_NUMBER_OF_ROLES
Query to read the number of roles

parameters(3): association id,offset, limit

See Also:
Constant Field Values

QUERY_READ_NUMBER_OF_PLAYED_ROLES

static final java.lang.String QUERY_READ_NUMBER_OF_PLAYED_ROLES
Query to read the number of played roles

parameters(3): player id,offset, limit

See Also:
Constant Field Values

QUERY_READ_NUMBER_OF_TYPES

static final java.lang.String QUERY_READ_NUMBER_OF_TYPES
Query to read the number of types of a topic

parameters(3): topic id,offset, limit

See Also:
Constant Field Values

QUERY_READ_NUMBER_OF_VARIANTS

static final java.lang.String QUERY_READ_NUMBER_OF_VARIANTS
query to read the number of variants of a name

parameters(3): name id,offset, limit

See Also:
Constant Field Values