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

Enclosing interface:
IMySqlSelectQueries

public static interface IMySqlSelectQueries.NonPaged


Field Summary
static java.lang.String QUERY_READ_ASSOCIATION_REIFIER
          query to read the reifier of a construct parameters(1): construct id
static java.lang.String QUERY_READ_ASSOCIATION_SCOPE
          Query to read the scope of a construct parameters(1): the construct id
static java.lang.String QUERY_READ_ASSOCIATION_TYPE
          Query to read the type of a typed construct parameters(1): construct id
static java.lang.String QUERY_READ_ASSOCIATIONS
          Query to read all associations parameters(1): topic map id
static java.lang.String QUERY_READ_ASSOCIATIONS_WITH_SCOPE
          Query to read all associations within a specific type parameters(2): topic map id, scope id
static java.lang.String QUERY_READ_ASSOCIATIONS_WITH_TYPE
          Query to read all associations of a specific type parameters(2): topic map id, type id
static java.lang.String QUERY_READ_ASSOCIATIONS_WITH_TYPE_AND_SCOPE
          Query to read all associations of a specific type and within a specific scope parameters(3): topic map id, type id, scope id
static java.lang.String QUERY_READ_CONSTRUCT
          Query to read a construct by id parameters(1): the construct id
static java.lang.String QUERY_READ_CONSTRUCT_BY_ITEM_IDENTIFIER
          query to read a construct by item-identifier parameters(7): the construct id, the topic map id 6x
static java.lang.String QUERY_READ_EMPTY_SCOPE
           
static java.lang.String QUERY_READ_ITEM_IDENTIFIERS
          Query to read all item-identifiers of a construct parameters(1): construct id
static java.lang.String QUERY_READ_LOCATOR
           
static java.lang.String QUERY_READ_NAME_REIFIER
          query to read the reifier of a construct parameters(1): construct id
static java.lang.String QUERY_READ_NAME_SCOPE
          Query to read the scope of a construct parameters(1): the construct id
static java.lang.String QUERY_READ_NAME_TYPE
          Query to read the type of a typed construct parameters(1): construct id
static java.lang.String QUERY_READ_NAME_VALUE
          Query to read the value of a name, an occurrence or a variant parameters(1): construct id
static java.lang.String QUERY_READ_NAMES
          query to read all names of a topic parameters(1): topic id
static java.lang.String QUERY_READ_NAMES_WITH_SCOPE
          query to read all names of topic by scope parameters(2): topic id, scope id
static java.lang.String QUERY_READ_NAMES_WITH_TYPE
          query to read all names of a topic by type parameters(2): topic id, type id
static java.lang.String QUERY_READ_NAMES_WITH_TYPE_AND_SCOPE
          query to read all names of a topic by type and scope parameters(3): topic id, type id, scope id
static java.lang.String QUERY_READ_OCCURRENCE_DATATYPE
          Query to read the data type of an occurrence or variant parameters(1): construct id
static java.lang.String QUERY_READ_OCCURRENCE_REIFIER
          query to read the reifier of a construct parameters(1): construct id
static java.lang.String QUERY_READ_OCCURRENCE_SCOPE
          Query to read the scope of a construct parameters(1): the construct id
static java.lang.String QUERY_READ_OCCURRENCE_TYPE
          Query to read the type of a typed construct parameters(1): construct id
static java.lang.String QUERY_READ_OCCURRENCE_VALUE
          Query to read the value of a name, an occurrence or a variant parameters(1): construct id
static java.lang.String QUERY_READ_OCCURRENCES
          query to read all occurrences of a topic parameters(1): topic id
static java.lang.String QUERY_READ_OCCURRENCES_WITH_SCOPE
          query to read all occurrences of topic by scope parameters(2): topic id, scope id
static java.lang.String QUERY_READ_OCCURRENCES_WITH_TYPE
          query to read all occurrences of a topic by type parameters(2): topic id, type id
static java.lang.String QUERY_READ_OCCURRENCES_WITH_TYPE_AND_SCOPE
          query to read all occurrences of a topic by type and scope parameters(3): topic id, type id, scope id
static java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS
          Query to read all played associations parameters(2): topic map id, player id
static java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_SCOPE
          Query to read all played associations within a specific scope parameters(3): topic map id, player id, scope id
static java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE
          Query to read all played associations of a specific type parameters(3): topic map id, player id, type id
static java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE_AND_SCOPE
          Query to read all played associations of a specific type and within a specific scope parameters(4): topic map id, player id, type id, scope id
static java.lang.String QUERY_READ_PLAYED_ROLES
          Query to read all played roles parameters(1): player id
static java.lang.String QUERY_READ_PLAYED_ROLES_WITH_TYPE
          Query to read all played roles by type parameters(2): player id, type id
static java.lang.String QUERY_READ_PLAYED_ROLES_WITH_TYPE_AND_ASSOTYPE
          Query to read all played roles by types parameters(3): player id, type id, asso_type
static java.lang.String QUERY_READ_PLAYER
          query to read the player of a role parameters(1): role id
static java.lang.String QUERY_READ_REIFIED
          query to read the reified construct of a topic parameters(1): the reifier id
static java.lang.String QUERY_READ_ROLE_REIFIER
          query to read the reifier of a construct parameters(1): construct id
static java.lang.String QUERY_READ_ROLE_TYPE
          Query to read the type of a typed construct parameters(1): construct id
static java.lang.String QUERY_READ_ROLES
          Query to read all roles parameters(1): association id
static java.lang.String QUERY_READ_ROLES_WITH_TYPE
          Query to read all roles by type parameters(2): association id, type id
static java.lang.String QUERY_READ_ROLESTYPES
          Query to read all roles types parameters(1): association id
static java.lang.String QUERY_READ_SCOPES_BY_THEME
          Query to read the scope object by a collection of themes parameters(4): an array of theme-IDs, boolean-flag matching all, boolean flag exact match, topic map id
static java.lang.String QUERY_READ_SUBJECT_IDENTIFIERS
          Query to read all subject-identifiers of a topic parameters(1): topic id
static java.lang.String QUERY_READ_SUBJECT_LOCATORS
          Query to read all subject-locators of a topic parameters(1): topic id
static java.lang.String QUERY_READ_SUPERTYPES
          Query to read the super types of a topic parameters(1): topic id
static java.lang.String QUERY_READ_THEMES
          Query to read the themes of a scope parameters(1): the scope id
static java.lang.String QUERY_READ_TOPIC_BY_SUBJECT_IDENTIFIER
          query to read a topic by subject-identifier parameters(2):topic map id, the reference
static java.lang.String QUERY_READ_TOPIC_BY_SUBJECT_LOCATOR
          query to read a topic by subject-identifier parameters(2):topic map id, the reference
static java.lang.String QUERY_READ_TOPICMAP
          query to read the topic map parameters(1): topic map base locator
static java.lang.String QUERY_READ_TOPICMAP_REIFIER
          query to read the reifier of a construct parameters(1): construct id
static java.lang.String QUERY_READ_TOPICS
          Query to read all topics parameters(1): topic map id
static java.lang.String QUERY_READ_TOPICS_WITH_TYPE
          Query to read all topics by type parameters(2): topic map id, type id
static java.lang.String QUERY_READ_TYPES
          Query to read the types of a topic parameters(1): topic id
static java.lang.String QUERY_READ_VARIANT_DATATYPE
          Query to read the data type of an occurrence or variant parameters(1): construct id
static java.lang.String QUERY_READ_VARIANT_REIFIER
          query to read the reifier of a construct parameters(1): construct id
static java.lang.String QUERY_READ_VARIANT_SCOPE
          Query to read the scope of a construct parameters(1): the construct id
static java.lang.String QUERY_READ_VARIANT_VALUE
          Query to read the value of a name, an occurrence or a variant parameters(1): construct id
static java.lang.String QUERY_READ_VARIANTS
          query to read all variants of a name parameters(1): name id
static java.lang.String QUERY_READ_VARIANTS_WITH_SCOPE
          query to read all variants of a name by scope parameters(2): name id, scope id
 

Field Detail

QUERY_READ_TOPICMAP

static final java.lang.String QUERY_READ_TOPICMAP
query to read the topic map

parameters(1): topic map base locator

See Also:
Constant Field Values

QUERY_READ_ASSOCIATIONS

static final java.lang.String QUERY_READ_ASSOCIATIONS
Query to read all associations

parameters(1): topic map id

See Also:
Constant Field Values

QUERY_READ_ASSOCIATIONS_WITH_TYPE

static final java.lang.String QUERY_READ_ASSOCIATIONS_WITH_TYPE
Query to read all associations of a specific type

parameters(2): topic map id, type id

See Also:
Constant Field Values

QUERY_READ_ASSOCIATIONS_WITH_SCOPE

static final java.lang.String QUERY_READ_ASSOCIATIONS_WITH_SCOPE
Query to read all associations within a specific type

parameters(2): topic map id, scope id

See Also:
Constant Field Values

QUERY_READ_ASSOCIATIONS_WITH_TYPE_AND_SCOPE

static final java.lang.String QUERY_READ_ASSOCIATIONS_WITH_TYPE_AND_SCOPE
Query to read all associations of a specific type and within a specific scope

parameters(3): topic map id, type id, scope id

See Also:
Constant Field Values

QUERY_READ_PLAYED_ASSOCIATIONS

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

parameters(2): topic map id, player id

See Also:
Constant Field Values

QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE

static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE
Query to read all played associations of a specific type

parameters(3): topic map id, player id, type id

See Also:
Constant Field Values

QUERY_READ_PLAYED_ASSOCIATIONS_WITH_SCOPE

static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_SCOPE
Query to read all played associations within a specific scope

parameters(3): topic map id, player id, scope id

See Also:
Constant Field Values

QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE_AND_SCOPE

static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE_AND_SCOPE
Query to read all played associations of a specific type and within a specific scope

parameters(4): topic map id, player id, type id, scope id

See Also:
Constant Field Values

QUERY_READ_CONSTRUCT

static final java.lang.String QUERY_READ_CONSTRUCT
Query to read a construct by id

parameters(1): the construct id

See Also:
Constant Field Values

QUERY_READ_CONSTRUCT_BY_ITEM_IDENTIFIER

static final java.lang.String QUERY_READ_CONSTRUCT_BY_ITEM_IDENTIFIER
query to read a construct by item-identifier

parameters(7): the construct id, the topic map id 6x

See Also:
Constant Field Values

QUERY_READ_OCCURRENCE_DATATYPE

static final java.lang.String QUERY_READ_OCCURRENCE_DATATYPE
Query to read the data type of an occurrence or variant

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_VARIANT_DATATYPE

static final java.lang.String QUERY_READ_VARIANT_DATATYPE
Query to read the data type of an occurrence or variant

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_ITEM_IDENTIFIERS

static final java.lang.String QUERY_READ_ITEM_IDENTIFIERS
Query to read all item-identifiers of a construct

parameters(1): construct id

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(1): topic id

See Also:
Constant Field Values

QUERY_READ_NAMES_WITH_TYPE

static final java.lang.String QUERY_READ_NAMES_WITH_TYPE
query to read all names of a topic by type

parameters(2): topic id, type id

See Also:
Constant Field Values

QUERY_READ_NAMES_WITH_SCOPE

static final java.lang.String QUERY_READ_NAMES_WITH_SCOPE
query to read all names of topic by scope

parameters(2): topic id, scope id

See Also:
Constant Field Values

QUERY_READ_NAMES_WITH_TYPE_AND_SCOPE

static final java.lang.String QUERY_READ_NAMES_WITH_TYPE_AND_SCOPE
query to read all names of a topic by type and scope

parameters(3): topic id, type id, scope id

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(1): topic id

See Also:
Constant Field Values

QUERY_READ_OCCURRENCES_WITH_TYPE

static final java.lang.String QUERY_READ_OCCURRENCES_WITH_TYPE
query to read all occurrences of a topic by type

parameters(2): topic id, type id

See Also:
Constant Field Values

QUERY_READ_OCCURRENCES_WITH_SCOPE

static final java.lang.String QUERY_READ_OCCURRENCES_WITH_SCOPE
query to read all occurrences of topic by scope

parameters(2): topic id, scope id

See Also:
Constant Field Values

QUERY_READ_OCCURRENCES_WITH_TYPE_AND_SCOPE

static final java.lang.String QUERY_READ_OCCURRENCES_WITH_TYPE_AND_SCOPE
query to read all occurrences of a topic by type and scope

parameters(3): topic id, type id, scope id

See Also:
Constant Field Values

QUERY_READ_PLAYER

static final java.lang.String QUERY_READ_PLAYER
query to read the player of a role

parameters(1): role id

See Also:
Constant Field Values

QUERY_READ_NAME_REIFIER

static final java.lang.String QUERY_READ_NAME_REIFIER
query to read the reifier of a construct

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_OCCURRENCE_REIFIER

static final java.lang.String QUERY_READ_OCCURRENCE_REIFIER
query to read the reifier of a construct

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_VARIANT_REIFIER

static final java.lang.String QUERY_READ_VARIANT_REIFIER
query to read the reifier of a construct

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_ROLE_REIFIER

static final java.lang.String QUERY_READ_ROLE_REIFIER
query to read the reifier of a construct

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_ASSOCIATION_REIFIER

static final java.lang.String QUERY_READ_ASSOCIATION_REIFIER
query to read the reifier of a construct

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_TOPICMAP_REIFIER

static final java.lang.String QUERY_READ_TOPICMAP_REIFIER
query to read the reifier of a construct

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_REIFIED

static final java.lang.String QUERY_READ_REIFIED
query to read the reified construct of a topic

parameters(1): the reifier id

See Also:
Constant Field Values

QUERY_READ_ROLES

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

parameters(1): association id

See Also:
Constant Field Values

QUERY_READ_ROLES_WITH_TYPE

static final java.lang.String QUERY_READ_ROLES_WITH_TYPE
Query to read all roles by type

parameters(2): association id, type id

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(1): player id

See Also:
Constant Field Values

QUERY_READ_PLAYED_ROLES_WITH_TYPE

static final java.lang.String QUERY_READ_PLAYED_ROLES_WITH_TYPE
Query to read all played roles by type

parameters(2): player id, type id

See Also:
Constant Field Values

QUERY_READ_PLAYED_ROLES_WITH_TYPE_AND_ASSOTYPE

static final java.lang.String QUERY_READ_PLAYED_ROLES_WITH_TYPE_AND_ASSOTYPE
Query to read all played roles by types

parameters(3): player id, type id, asso_type

See Also:
Constant Field Values

QUERY_READ_ROLESTYPES

static final java.lang.String QUERY_READ_ROLESTYPES
Query to read all roles types

parameters(1): association id

See Also:
Constant Field Values

QUERY_READ_SUBJECT_IDENTIFIERS

static final java.lang.String QUERY_READ_SUBJECT_IDENTIFIERS
Query to read all subject-identifiers of a topic

parameters(1): topic id

See Also:
Constant Field Values

QUERY_READ_SUBJECT_LOCATORS

static final java.lang.String QUERY_READ_SUBJECT_LOCATORS
Query to read all subject-locators of a topic

parameters(1): topic id

See Also:
Constant Field Values

QUERY_READ_TOPIC_BY_SUBJECT_IDENTIFIER

static final java.lang.String QUERY_READ_TOPIC_BY_SUBJECT_IDENTIFIER
query to read a topic by subject-identifier

parameters(2):topic map id, the reference

See Also:
Constant Field Values

QUERY_READ_TOPIC_BY_SUBJECT_LOCATOR

static final java.lang.String QUERY_READ_TOPIC_BY_SUBJECT_LOCATOR
query to read a topic by subject-identifier

parameters(2):topic map id, the reference

See Also:
Constant Field Values

QUERY_READ_TOPICS

static final java.lang.String QUERY_READ_TOPICS
Query to read all topics

parameters(1): topic map id

See Also:
Constant Field Values

QUERY_READ_TOPICS_WITH_TYPE

static final java.lang.String QUERY_READ_TOPICS_WITH_TYPE
Query to read all topics by type

parameters(2): topic map id, type id

See Also:
Constant Field Values

QUERY_READ_NAME_TYPE

static final java.lang.String QUERY_READ_NAME_TYPE
Query to read the type of a typed construct

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_OCCURRENCE_TYPE

static final java.lang.String QUERY_READ_OCCURRENCE_TYPE
Query to read the type of a typed construct

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_ROLE_TYPE

static final java.lang.String QUERY_READ_ROLE_TYPE
Query to read the type of a typed construct

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_ASSOCIATION_TYPE

static final java.lang.String QUERY_READ_ASSOCIATION_TYPE
Query to read the type of a typed construct

parameters(1): construct id

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(1): topic id

See Also:
Constant Field Values

QUERY_READ_SUPERTYPES

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

parameters(1): topic id

See Also:
Constant Field Values

QUERY_READ_NAME_SCOPE

static final java.lang.String QUERY_READ_NAME_SCOPE
Query to read the scope of a construct

parameters(1): the construct id

See Also:
Constant Field Values

QUERY_READ_OCCURRENCE_SCOPE

static final java.lang.String QUERY_READ_OCCURRENCE_SCOPE
Query to read the scope of a construct

parameters(1): the construct id

See Also:
Constant Field Values

QUERY_READ_VARIANT_SCOPE

static final java.lang.String QUERY_READ_VARIANT_SCOPE
Query to read the scope of a construct

parameters(1): the construct id

See Also:
Constant Field Values

QUERY_READ_ASSOCIATION_SCOPE

static final java.lang.String QUERY_READ_ASSOCIATION_SCOPE
Query to read the scope of a construct

parameters(1): the construct id

See Also:
Constant Field Values

QUERY_READ_THEMES

static final java.lang.String QUERY_READ_THEMES
Query to read the themes of a scope

parameters(1): the scope id

See Also:
Constant Field Values

QUERY_READ_SCOPES_BY_THEME

static final java.lang.String QUERY_READ_SCOPES_BY_THEME
Query to read the scope object by a collection of themes

parameters(4): an array of theme-IDs, boolean-flag matching all, boolean flag exact match, topic map id

See Also:
Constant Field Values

QUERY_READ_EMPTY_SCOPE

static final java.lang.String QUERY_READ_EMPTY_SCOPE
See Also:
Constant Field Values

QUERY_READ_NAME_VALUE

static final java.lang.String QUERY_READ_NAME_VALUE
Query to read the value of a name, an occurrence or a variant

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_OCCURRENCE_VALUE

static final java.lang.String QUERY_READ_OCCURRENCE_VALUE
Query to read the value of a name, an occurrence or a variant

parameters(1): construct id

See Also:
Constant Field Values

QUERY_READ_VARIANT_VALUE

static final java.lang.String QUERY_READ_VARIANT_VALUE
Query to read the value of a name, an occurrence or a variant

parameters(1): construct id

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(1): name id

See Also:
Constant Field Values

QUERY_READ_VARIANTS_WITH_SCOPE

static final java.lang.String QUERY_READ_VARIANTS_WITH_SCOPE
query to read all variants of a name by scope

parameters(2): name id, scope id

See Also:
Constant Field Values

QUERY_READ_LOCATOR

static final java.lang.String QUERY_READ_LOCATOR
See Also:
Constant Field Values