Constant Field Values


Contents
<Unnamed>.*

Extractor
private static final java.lang.String STRING "\r\n"
private static final java.lang.String UTF_8 "UTF-8"

de.topicmapslab.*

de.topicmapslab.majortom.cache.RevisionCache
private static final java.lang.String CHANGESET "dependendChangeset"
private static final java.lang.String FUTURE "futureRevisionRevision"
private static final java.lang.String METADATA "metaData"
private static final java.lang.String PAST "pastRevision"
private static final java.lang.String REVISIONS "dependendRevisions"
private static final java.lang.String TIMESTAMP "lastModification"
private static final java.lang.String TYPE "type"

de.topicmapslab.majortom.core.AssociationImpl
private static final long serialVersionUID -7045605297867030798L

de.topicmapslab.majortom.core.AssociationRoleImpl
private static final long serialVersionUID -7838350394983745862L

de.topicmapslab.majortom.core.ConstructImpl
private static final long serialVersionUID 3425623439923025704L

de.topicmapslab.majortom.core.DataTypeAwareImpl
private static final long serialVersionUID -1549445583958049344L

de.topicmapslab.majortom.core.LocatorImpl
private static final long serialVersionUID -2475883158229059516L
private static final java.lang.String THE_IRI_IS_RELATIVE "The IRI {0} is relative."

de.topicmapslab.majortom.core.NameImpl
private static final long serialVersionUID -1511999973332479713L

de.topicmapslab.majortom.core.OccurrenceImpl
private static final long serialVersionUID 9106360836112918931L

de.topicmapslab.majortom.core.ReifiableImpl
private static final long serialVersionUID -7359295275519843778L

de.topicmapslab.majortom.core.ScopeableImpl
private static final long serialVersionUID -8310691320454140302L

de.topicmapslab.majortom.core.TopicImpl
private static final long serialVersionUID -4379325386936071489L

de.topicmapslab.majortom.core.TopicMapImpl
private static final long serialVersionUID -178217028741481602L

de.topicmapslab.majortom.core.TopicMapSystemFactoryImpl
private static final java.lang.String propertyFile "engine.properties"

de.topicmapslab.majortom.core.VariantImpl
private static final long serialVersionUID -5589243111079475788L

de.topicmapslab.majortom.database.io.exporter.PostGreSqlCTMTopicMapWriter
private static final java.lang.String SELECT_TO_CTM "SELECT to_ctm(?);"

de.topicmapslab.majortom.database.io.importer.PostGreSqlCTMTopicMapReader
private static final java.lang.String NEWLINE "\n"
private static final java.lang.String SELECT_FROM_CTM "SELECT from_ctm(?,?);"
private static final java.lang.String UTF_8 "UTF-8"

de.topicmapslab.majortom.database.jdbc.model.IConnectionProvider
public static final java.lang.String DATABASE_NOT_EXISTS "3D000"
public static final int STATE_DATABASE_IS_EMPTY 0
public static final int STATE_DATABASE_IS_INVALID 1
public static final int STATE_DATABASE_IS_VALID 2

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlConstraintsQueries
public static final java.lang.String QUERY_DUPLICATE_ASSOCIATIONS "SELECT DISTINCT a.id, a.id_reifier FROM roles AS r, associations AS a WHERE 0 IN ( SELECT COUNT (r) FROM ( SELECT id_type , id_player FROM roles WHERE id_parent = r.id_parent EXCEPT SELECT id_type, id_player FROM roles WHERE id_parent = ? ) AS r ) AND r.id_parent <> ? AND r.id_parent = a.id AND a.id_type = ? AND a.id_scope = ?;"
public static final java.lang.String QUERY_DUPLICATE_NAME "SELECT id, id_parent FROM names WHERE id_parent = ? AND id <> ? AND id_type = ? AND value = ? AND id_scope = ?"
public static final java.lang.String QUERY_DUPLICATE_OCCURRENCE "SELECT id, id_parent FROM occurrences WHERE id_parent = ? AND id <> ? AND id_type = ? AND value = ? AND id_datatype IN ( SELECT id FROM locators WHERE reference = ? ) AND id_scope = ?"
public static final java.lang.String QUERY_DUPLICATE_ROLES "SELECT id FROM roles WHERE id_parent = ? AND id_type = ? AND id_player = ?;"
public static final java.lang.String QUERY_DUPLICATE_VARIANTS "SELECT id, id_parent FROM variants WHERE id_parent = ? AND id <> ? AND value = ? AND id_datatype IN ( SELECT id FROM locators WHERE reference = ? ) AND id_scope = ?"
public static final java.lang.String QUERY_MOVE_ITEM_IDENTIFIERS "UPDATE rel_item_identifiers SET id_construct = ? WHERE id_construct = ?;"
public static final java.lang.String QUERY_MOVE_VARIANTS "UPDATE variants SET id_parent = ? WHERE id_parent = ?;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlDeleteQueries
public static final java.lang.String QUERY_CLEAR_TOPICMAP "DELETE FROM rel_item_identifiers WHERE id_construct IN ( SELECT id AS id_construct FROM constructs WHERE id_topicmap = ? OR id = ? );DELETE FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier IN ( SELECT id FROM constructs WHERE id_topicmap = ? ) OR id_notifier = ? );UPDATE topicmaps SET id_reifier = NULL WHERE id = ?; DELETE FROM constructs WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_DELETE_ALL_ITEM_IDENTIFIERS "DELETE FROM rel_item_identifiers WHERE id_construct IN ( SELECT id AS id_construct FROM constructs WHERE id_topicmap = ? OR id = ? );"
public static final java.lang.String QUERY_DELETE_ASSOCIATION "DELETE FROM associations WHERE id = ?; "
public static final java.lang.String QUERY_DELETE_HISTORY "DELETE FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier IN ( SELECT id FROM constructs WHERE id_topicmap = ? ) OR id_notifier = ? );"
public static final java.lang.String QUERY_DELETE_ITEM_IDENTIFIER "DELETE FROM rel_item_identifiers WHERE id_construct = ? and id_locator = ( SELECT id FROM locators WHERE reference = ? )"
public static final java.lang.String QUERY_DELETE_NAME "DELETE FROM names WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_OCCURRENCE "DELETE FROM occurrences WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_ROLE "DELETE FROM roles WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_SUBJECT_IDENTIFIER "DELETE FROM rel_subject_identifiers WHERE id_topic = ? and id_locator = ( SELECT id FROM locators WHERE reference = ? )"
public static final java.lang.String QUERY_DELETE_SUBJECT_LOCATOR "DELETE FROM rel_subject_locators WHERE id_topic = ? and id_locator = ( SELECT id FROM locators WHERE reference = ? )"
public static final java.lang.String QUERY_DELETE_SUPERTYPE "DELETE FROM rel_kind_of WHERE id_subtype = ? AND id_supertype = ?;"
public static final java.lang.String QUERY_DELETE_TOPIC "DELETE FROM topics WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_TOPICMAP " DELETE FROM topicmaps WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_TYPE "DELETE FROM rel_instance_of WHERE id_instance = ? AND id_type = ?;"
public static final java.lang.String QUERY_DELETE_VARIANT "DELETE FROM variants WHERE id = ?;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlDumpQueries
public static final java.lang.String QUERY_DUMP_ASSOCIATION "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_scope, themes, roles, type) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_item_identifiers WHERE id_construct = a.id )), ARRAY[id_type], id_reifier, id_scope, ARRAY( SELECT id_theme FROM rel_themes WHERE id_scope = a.id_scope ), ARRAY( SELECT id FROM roles WHERE id_parent = a.id ), \'a\' FROM associations AS a WHERE id = ?;"
public static final java.lang.String QUERY_DUMP_NAME "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, variants, id_reification, id_scope, themes, value, type) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_item_identifiers WHERE id_construct = n.id )), ARRAY[id_type], ARRAY ( SELECT id FROM variants WHERE id_parent = n.id ), id_reifier, id_scope, ARRAY( SELECT id_theme FROM rel_themes WHERE id_scope = n.id_scope ), value, \'n\' FROM names AS n WHERE id = ?"
public static final java.lang.String QUERY_DUMP_OCCURRENCE "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_scope, themes, value, datatype, type) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_item_identifiers WHERE id_construct = o.id )), ARRAY[id_type], id_reifier, id_scope, ARRAY( SELECT id_theme FROM rel_themes WHERE id_scope = o.id_scope ), value, ( SELECT reference FROM locators WHERE id = o.id_datatype), \'o\' FROM occurrences AS o WHERE id = ?"
public static final java.lang.String QUERY_DUMP_ROLE "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_player, type) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_item_identifiers WHERE id_construct = r.id )), ARRAY[id_type], id_reifier, id_player, \'r\' FROM roles AS r WHERE id = ?"
public static final java.lang.String QUERY_DUMP_TOPIC "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, subjectidentifiers, subjectlocators, types, supertypes, names, occurrences, associations, id_reification, type, bestlabel, bestidentifier) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN ( SELECT id_locator FROM rel_item_identifiers WHERE id_construct = t.id )), ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_subject_identifiers WHERE id_topic = t.id )), ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_subject_locators WHERE id_topic = t.id )), ARRAY ( SELECT id_type FROM rel_instance_of WHERE id_instance = t.id ), ARRAY ( SELECT id_supertype FROM rel_kind_of WHERE id_subtype = t.id ), ARRAY ( SELECT id FROM names WHERE id_parent = t.id ), ARRAY ( SELECT id FROM occurrences WHERE id_parent = t.id ), ARRAY ( SELECT DISTINCT id FROM associations WHERE id IN ( SELECT id_parent FROM roles WHERE id_player = t.id )), (SELECT CASE WHEN ( t.id IN ( SELECT id_reifier FROM reifiables WHERE id_reifier = t.id)) THEN ( SELECT id FROM reifiables WHERE id_reifier = t.id ) ELSE NULL END),\'t\', ?, ? FROM topics AS t WHERE id = ?"
public static final java.lang.String QUERY_DUMP_VARIANT "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, id_reification, id_scope,themes, datatype, value, type) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_item_identifiers WHERE id_construct = v.id )), id_reifier, id_scope, ARRAY( SELECT id_theme FROM rel_themes WHERE id_scope = v.id_scope ), ( SELECT reference FROM locators WHERE id = v.id_datatype), value, \'v\' FROM variants AS v WHERE id = ?"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlIndexQueries.QueryIdentityIndex.NonPaged
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_IDENTIFIER_PATTERN "WITH locs AS ( SELECT id FROM locators WHERE reference ~* ? ), iis AS (SELECT id_construct AS id FROM rel_item_identifiers WHERE id_locator IN ( SELECT id FROM locs ) UNION SELECT id_topic AS id FROM rel_subject_locators WHERE id_locator IN ( SELECT id FROM locs ) UNION SELECT id_topic AS id FROM rel_subject_identifiers WHERE id_locator IN ( SELECT id FROM locs ) )SELECT DISTINCT r.id, r.id_parent, r.other, r.type FROM (SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id FROM iis )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id FROM iis ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id FROM iis ) ) AS r;"
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_ITEM_IDENTIFIER_PATTERN "WITH iis AS ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference ~* ? )SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id_construct FROM iis )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id_construct FROM iis ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id_construct FROM iis );"
public static final java.lang.String QUERY_SELECT_ITEM_IDENTIFIERS "SELECT l.id,l.reference FROM locators AS l, rel_item_identifiers, constructs AS c WHERE ( c.id_topicmap = ? OR c.id = ? ) AND l.id = id_locator AND c.id = id_construct;"
public static final java.lang.String QUERY_SELECT_SUBJECT_IDENTIFIERS "SELECT l.id,l.reference FROM locators AS l, rel_subject_identifiers, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ;"
public static final java.lang.String QUERY_SELECT_SUBJECT_LOCATORS "SELECT l.id,l.reference FROM locators AS l, rel_subject_locators, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_IDENTIFIER_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_identifiers, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND reference ~* ? ;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_LOCATOR_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_locators, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND reference ~* ? ;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlIndexQueries.QueryIdentityIndex.Paged
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_IDENTIFIER_PATTERN "WITH locs AS ( SELECT id FROM locators WHERE reference ~* ? ), iis AS (SELECT id_construct AS id FROM rel_item_identifiers WHERE id_locator IN ( SELECT id FROM locs ) UNION SELECT id_topic AS id FROM rel_subject_locators WHERE id_locator IN ( SELECT id FROM locs ) UNION SELECT id_topic AS id FROM rel_subject_identifiers WHERE id_locator IN ( SELECT id FROM locs ) )SELECT DISTINCT r.id, r.id_parent, r.other, r.type FROM (SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id FROM iis )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id FROM iis ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id FROM iis ) ) AS r ORDER BY r.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_ITEM_IDENTIFIER_PATTERN "WITH iis AS ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference ~* ? )SELECT r.id, r.id_parent, r.other, r.type FROM (SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id_construct FROM iis )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id_construct FROM iis ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id_construct FROM iis ) ) AS r ORDER BY r.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ITEM_IDENTIFIERS "SELECT l.id,l.reference FROM locators AS l, rel_item_identifiers, constructs AS c WHERE ( c.id_topicmap = ? OR c.id = ? ) AND l.id = id_locator AND c.id = id_construct ORDER BY l.reference OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_SUBJECT_IDENTIFIERS "SELECT l.id,l.reference FROM locators AS l, rel_subject_identifiers, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ORDER BY l.reference OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_SUBJECT_LOCATORS "SELECT l.id,l.reference FROM locators AS l, rel_subject_locators, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ORDER BY l.reference OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_IDENTIFIER_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_identifiers, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND reference ~* ? ORDER BY id_topic OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_LOCATOR_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_locators, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND reference ~* ? ORDER BY id_topic OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlIndexQueries.QueryLiteralIndex.NonPaged
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS "SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value = ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_DATATYPE "SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP "SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_topicmap = ? AND value ~* ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value ~* ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP_AND_DATATYPE "SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ~* ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value ~* ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_VALUE "SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_topicmap = ? AND value = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value = ?;"
public static final java.lang.String QUERY_SELECT_DATATYPEAWARES_BY_DATATYPE "SELECT o.id, id_parent, NULL AS other, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT v.id, v.id_parent, n.id_parent AS other, \'v\' AS type FROM variants AS v, locators AS l, names AS n WHERE v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? AND n.id = v.id_parent;"
public static final java.lang.String QUERY_SELECT_NAMES "SELECT id, id_parent FROM names WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_REGEXP "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND value ~* ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_VALUE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND value ILIKE ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATERANGE "SELECT o.id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND ? <= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id ) AND ? >= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id );"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_RANGE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? AND CAST ( value AS double precision ) BETWEEN ? AND ? "
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND value ~* ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ~* ? AND o.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND value ILIKE ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ILIKE ? AND o.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ~* ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ~* ? AND v.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ILIKE ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ILIKE ? AND v.id_datatype = l.id AND l.reference = ? ;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlIndexQueries.QueryLiteralIndex.Paged
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS "SELECT r.id, r.id_parent, r.type FROM ( SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value = ?) AS r ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_DATATYPE "SELECT r.id, r.id_parent, r.type FROM ( SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ?) AS r ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP "SELECT r.id, r.id_parent, r.type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_topicmap = ? AND value ~* ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value ~* ? ) AS r ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP_AND_DATATYPE "SELECT r.id, r.id_parent, r.type FROM ( SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ~* ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value ~* ?) AS r ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_VALUE "SELECT r.id, r.id_parent, r.type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_topicmap = ? AND value = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value = ? ) AS r ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_DATATYPEAWARES_BY_DATATYPE "SELECT r.id, r.id_parent, r.other, r.type FROM ( SELECT o.id, id_parent, NULL AS other, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT v.id, v.id_parent, n.id_parent AS other, \'v\' AS type FROM variants AS v, locators AS l, names AS n WHERE v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? AND n.id = v.id_parent) AS r ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES "SELECT id, id_parent FROM names WHERE id_topicmap = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_REGEXP "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND value ~* ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_VALUE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND value ILIKE ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? ORDER BY o.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATERANGE "SELECT o.id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND ? <= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id ) AND ? >= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id ) ORDER BY o.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_RANGE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? AND CAST ( value AS double precision ) BETWEEN ? AND ? ORDER BY o.id OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND value ~* ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ~* ? AND o.id_datatype = l.id AND l.reference = ? ORDER BY o.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND value ILIKE ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ILIKE ? AND o.id_datatype = l.id AND l.reference = ? ORDER BY o.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ~* ? ORDER BY v.id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ~* ? AND v.id_datatype = l.id AND l.reference = ? ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ILIKE ? ORDER BY v.id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ILIKE ? AND v.id_datatype = l.id AND l.reference = ? ORDER BY v.id OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlIndexQueries.QueryScopeIndex.NonPaged
public static final java.lang.String QUERY_SELECT_ASSOCIATION_SCOPES "SELECT id_scope FROM associations WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATION_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM associations WHERE id_topicmap = ? );"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope = ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? ));"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEME "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES "SELECT id FROM associations AS a WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = a.id_scope AND id_theme IN ( SELECT unnest(?))); "
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES_MATCH_ALL "SELECT id FROM associations AS a WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = a.id_scope ) @> ?; "
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_SCOPE "SELECT id, id_parent, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_scope = ? ;"
public static final java.lang.String QUERY_SELECT_NAME_SCOPES "SELECT id_scope FROM names WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_NAME_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? );"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope = ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? ));"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEME "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? );"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = n.id_scope AND id_theme IN ( SELECT unnest(?)));"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope ) @> ?; "
public static final java.lang.String QUERY_SELECT_OCCURRENCE_SCOPES "SELECT id_scope FROM occurrences WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCE_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM occurrences WHERE id_topicmap = ? );"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope = ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? ));"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEME "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? );"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = o.id_scope AND id_theme IN ( SELECT unnest(?)));"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = o.id_scope ) @> ?; "
public static final java.lang.String QUERY_SELECT_SCOPABLES "SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id_scope = ? UNION SELECT v.id, v.id_parent, n.id_parent AS other, \'v\' AS type FROM variants AS v, names AS n WHERE v.id_scope = ? AND n.id = v.id_parent;"
public static final java.lang.String QUERY_SELECT_SCOPES "SELECT DISTINCT id_scope FROM rel_themes WHERE id_scope IN ( SELECT DISTINCT id_scope FROM scopeables ) AND "
public static final java.lang.String QUERY_SELECT_SCOPES_BY_THEMES_USED "SELECT r.id_scope FROM rel_themes AS r, scopeables AS s, constructs AS c WHERE id_theme = ? AND r.id_scope = s.id_scope AND c.id = s.id;"
public static final java.lang.String QUERY_SELECT_VARIANT_SCOPES "SELECT id_scope FROM variants WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_VARIANT_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM variants WHERE id_topicmap = ? ) OR id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? AND id IN ( SELECT id_parent FROM variants ));"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope = ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope IN ( SELECT unnest ( ? ));"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEME "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( v.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) OR n.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ));"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( v.id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = v.id_scope AND id_theme IN ( SELECT unnest(?)) ) OR n.id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = n.id_scope AND id_theme IN ( SELECT unnest(?)) )); "
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES_MATCH_ALL "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope ) || ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = v.id_scope ) @> ?; "

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlIndexQueries.QueryScopeIndex.Paged
public static final java.lang.String QUERY_SELECT_ASSOCIATION_SCOPES "SELECT id_scope FROM associations WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATION_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM associations WHERE id_topicmap = ? ) ORDER BY id_theme OFFSET ? LIMIT ?; ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? )) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEME "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES "SELECT id FROM associations AS a WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = a.id_scope AND id_theme IN ( SELECT unnest(?))) ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES_MATCH_ALL "SELECT id FROM associations AS a WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = a.id_scope ) @> ? ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_SCOPE "SELECT r.id, r.id_parent, r.type FROM ( SELECT id, id_parent, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_scope = ? ) AS r ORDER BY r OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAME_SCOPES "SELECT id_scope FROM names WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAME_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? ) ORDER BY id_theme OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? )) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEME "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = n.id_scope AND id_theme IN ( SELECT unnest(?))) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope ) @> ? ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_OCCURRENCE_SCOPES "SELECT id_scope FROM occurrences WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCE_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM occurrences WHERE id_topicmap = ? ) ORDER BY id_theme OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? )) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEME "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = o.id_scope AND id_theme IN ( SELECT unnest(?))) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = o.id_scope ) @> ? ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_SCOPABLES "SELECT r.id, r.id_parent, r.other, r.type FROM ( SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id_scope = ? UNION SELECT v.id, v.id_parent, n.id_parent AS other, \'v\' AS type FROM variants AS v, names AS n WHERE v.id_scope = ? AND n.id = v.id_parent ) AS r ORDER BY r.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANT_SCOPES "SELECT id_scope FROM variants WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANT_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM variants WHERE id_topicmap = ? ) OR id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? AND id IN ( SELECT id_parent FROM variants )) ORDER BY id_theme OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope = ? ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope IN ( SELECT unnest ( ? )) ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEME "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( v.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) OR n.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? )) ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( v.id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = v.id_scope AND id_theme IN ( SELECT unnest(?)) ) OR n.id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = n.id_scope AND id_theme IN ( SELECT unnest(?)) )) ORDER BY v.id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES_MATCH_ALL "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope ) || ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = v.id_scope ) @> ? ORDER BY v.id OFFSET ? LIMIT ?; "

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlIndexQueries.QuerySupertypeSubtypeIndex.NonPaged
public static final java.lang.String QUERY_SELECT_DIRECT_SUBTYPES "SELECT id_subtype AS id FROM rel_kind_of WHERE id_supertype = ?;"
public static final java.lang.String QUERY_SELECT_DIRECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of WHERE id_subtype = ?;"
public static final java.lang.String QUERY_SELECT_SUBTYPES "SELECT id_subtype FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_SUBTYPES_OF_TOPIC "SELECT id_subtype AS id FROM rel_kind_of WHERE id_supertype = ?;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES_OF_TOPIC "SELECT id_supertype AS id FROM rel_kind_of WHERE id_subtype = ?"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUBTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_supertype FROM rel_kind_of ) AND id_parent = ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUPERTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_subtype FROM rel_kind_of ) AND id_parent = ?;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlIndexQueries.QuerySupertypeSubtypeIndex.Paged
public static final java.lang.String QUERY_SELECT_DIRECT_SUBTYPES "SELECT id_subtype AS id FROM rel_kind_of WHERE id_supertype = ? ORDER BY id_subtype OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_DIRECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of WHERE id_subtype = ? ORDER BY id_supertype OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NUMBER_OF_TOPICS_WITHOUT_SUPERTYPES "SELECT COUNT(id) AS number FROM topics WHERE id NOT IN ( SELECT id_subtype FROM rel_kind_of ) AND id_parent = ?;"
public static final java.lang.String QUERY_SELECT_SUBTYPES "SELECT id_subtype FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ? ORDER BY id_subtype OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ? ORDER BY id_supertype OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUBTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_supertype FROM rel_kind_of ) AND id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUPERTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_subtype FROM rel_kind_of ) AND id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlIndexQueries.QueryTypeInstanceIndex.NonPaged
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONTYPES "SELECT DISTINCT id_type FROM associations WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPE "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type = ? ) AS u;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPES "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type IN ( SELECT unnest( ? ) ) UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type IN ( SELECT unnest( ? ) ) ) AS u;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICTYPES "SELECT DISTINCT id_type FROM ( SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? UNION SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ) AS u;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_NAMETYPES "SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCETYPES "SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPE "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPES "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_ROLETYPES "SELECT DISTINCT id_type FROM roles WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPE "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND ( %SUBQUERY% ) "
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES_MATCHES_ALL "SELECT DISTINCT id_instance FROM rel_instance_of AS r, topics WHERE id = id_instance AND id_topicmap = ? AND ARRAY ( SELECT id_type FROM rel_instance_of AS r2 WHERE r.id_instance = r2.id_instance ) @> CAST ( ARRAY[ %ARRAY%] AS bigint[] ) "
public static final java.lang.String QUERY_SELECT_TOPIC_WITHOUT_TYPE "SELECT id FROM topics WHERE id_topicmap = ? AND NOT id IN ( SELECT id_instance FROM rel_instance_of ) "
public static final java.lang.String QUERY_SELECT_TOPICTYPES "SELECT DISTINCT id_type FROM rel_instance_of, topics WHERE id_topicmap = ? AND id = id_type AND id_instance IN ( SELECT id FROM topics AS t WHERE t.id = id_instance );"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlIndexQueries.QueryTypeInstanceIndex.Paged
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONTYPES "SELECT DISTINCT id_type FROM associations WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPE "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type = ? ) AS u ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPES "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type IN ( SELECT unnest( ? ) ) UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type IN ( SELECT unnest( ? ) ) ) AS u ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICTYPES "SELECT DISTINCT id_type FROM ( SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? UNION SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ) AS u ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMETYPES "SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCETYPES "SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPE "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPES "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ROLETYPES "SELECT DISTINCT id_type FROM roles WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPE "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND id_type = ? ORDER BY id_instance OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND ( %SUBQUERY% ) ORDER BY id_instance OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES_MATCHES_ALL "SELECT DISTINCT id_instance FROM rel_instance_of AS r, topics WHERE id = id_instance AND id_topicmap = ? AND ARRAY ( SELECT id_type FROM rel_instance_of AS r2 WHERE r.id_instance = r2.id_instance ) @> CAST ( ARRAY[ %ARRAY%] AS bigint[] ) ORDER BY id_instance OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_TOPIC_WITHOUT_TYPE "SELECT id FROM topics WHERE id_topicmap = ? AND NOT id IN ( SELECT id_instance FROM rel_instance_of ) ORDER BY id OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_TOPICTYPES "SELECT DISTINCT id_type FROM rel_instance_of, topics WHERE id_topicmap = ? AND id = id_type AND id_instance IN ( SELECT id FROM topics AS t WHERE t.id = id_instance ) ORDER BY id_type OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlInsertQueries
public static final java.lang.String QUERY_CREATE_ASSOCIATION "INSERT INTO associations(id_topicmap, id_parent, id_type) VALUES (?,?,?);"
public static final java.lang.String QUERY_CREATE_ASSOCIATION_WITH_SCOPE "INSERT INTO associations(id_topicmap, id_parent, id_type, id_scope) VALUES (?,?,?,?);"
public static final java.lang.String QUERY_CREATE_LOCATOR "INSERT INTO locators (reference) VALUES (?);"
public static final java.lang.String QUERY_CREATE_NAME "INSERT INTO names (id_topicmap, id_parent, id_type, value) VALUES (?,?,?,?);"
public static final java.lang.String QUERY_CREATE_NAME_WITH_SCOPE "INSERT INTO names (id_topicmap, id_parent, id_type, value, id_scope) VALUES (?,?,?,?,?);"
public static final java.lang.String QUERY_CREATE_OCCURRENCE "INSERT INTO occurrences (id_topicmap, id_parent, id_type, value, id_datatype) SELECT ?,?,?,?, l.id FROM locators AS l WHERE l.reference LIKE ?;"
public static final java.lang.String QUERY_CREATE_OCCURRENCE_WITH_SCOPE "INSERT INTO occurrences (id_topicmap, id_parent, id_type, value, id_datatype, id_scope) SELECT ?,?,?,?,id,? FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_CREATE_ROLE "INSERT INTO roles(id_topicmap, id_parent, id_type, id_player) VALUES (?,?,?,?)"
public static final java.lang.String QUERY_CREATE_SCOPE "INSERT INTO scopes(id_topicmap) VALUES (?)"
public static final java.lang.String QUERY_CREATE_TOPIC "INSERT INTO topics(id_topicmap, id_parent) VALUES (?,?);"
public static final java.lang.String QUERY_CREATE_TOPICMAP "INSERT INTO topicmaps (id_base_locator) SELECT id FROM locators WHERE reference = ? AND NOT EXISTS ( SELECT tm.id FROM topicmaps AS tm, locators AS l WHERE l.reference LIKE ? AND l.id = tm.id_base_locator); "
public static final java.lang.String QUERY_CREATE_VARIANT "INSERT INTO variants (id_topicmap, id_parent, value, id_datatype, id_scope) SELECT ?,?,?,id,? FROM locators WHERE reference LIKE ?;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlQueries
public static final java.lang.String SNIPPET_CREATE_TOPIC_IF_SUBJECT_IDENTIFIER_NOT_EXISTS "INSERT INTO topics(id_topicmap,id_parent) SELECT ?,? WHERE NOT EXISTS (SELECT t.id, l.id FROM topics AS t, locators AS l, rel_subject_identifiers as r WHERE reference = ? AND l.id = r.id_locator AND r.id_topic = t.id);"
public static final java.lang.String SNIPPET_CREATE_TOPICMAP_IF_NOT_EXISTS "INSERT INTO topicmaps (id_base_locator) SELECT id FROM locators WHERE reference = ? AND NOT EXISTS ( SELECT tm.id FROM topicmaps AS tm, locators AS l WHERE l.reference LIKE ? AND l.id = tm.id_base_locator); "

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlRevisionQueries
public static final java.lang.String QUERY_CREATE_CHANGESET "INSERT INTO changesets(id_revision,type,id_notifier, newValue, oldValue,`time`) VALUES(?,?,?,?,?,now())"
public static final java.lang.String QUERY_CREATE_METADATA "INSERT INTO metadata(id_revision, `key`, `value`) VALUES (?,?,?);"
public static final java.lang.String QUERY_CREATE_REVISION "INSERT INTO revisions(`time`, id_topicmap, type) VALUES(now(),?, ?)"
public static final java.lang.String QUERY_CREATE_TAG "INSERT INTO tags(tag, time) VALUES (?,?);"
public static final java.lang.String QUERY_MODIFY_METADATA "UPDATE metadata SET value = ? WHERE id_revision = ? AND key = ?;"
public static final java.lang.String QUERY_MODIFY_TAG "UPDATE tags SET time = ? WHERE tag = ?;"
public static final java.lang.String QUERY_READ_CHANGESET "SELECT type, id_notifier, newValue, oldValue FROM changesets WHERE id_revision = ?;"
public static final java.lang.String QUERY_READ_CHANGESETS_BY_ASSOCIATIONTYPE "WITH ids AS ( SELECT id FROM associations WHERE id_type = ? ) SELECT id_revision, type, id_notifier, newValue, oldValue FROM changesets WHERE id_notifier IN ( SELECT id FROM ids ) OR oldValue IN ( SELECT CAST ( id AS character varying ) FROM ids ) OR newValue IN ( SELECT CAST ( id AS character varying ) FROM ids ) ORDER BY id ASC;"
public static final java.lang.String QUERY_READ_CHANGESETS_BY_TOPIC "SELECT id_revision, type, id_notifier, newValue, oldValue FROM changesets WHERE id_notifier = ? OR oldValue = ? OR newValue = ? ORDER BY id ASC;"
public static final java.lang.String QUERY_READ_FIRST_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? ORDER BY id ASC LIMIT 1;"
public static final java.lang.String QUERY_READ_FUTURE_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? AND id > ? ORDER BY id ASC LIMIT 1;"
public static final java.lang.String QUERY_READ_HISTORY "SELECT * FROM history WHERE id = ?;"
public static final java.lang.String QUERY_READ_LAST_MODIFICATION "SELECT time FROM revisions WHERE id_topicmap = ? ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_LAST_MODIFICATION_OF_TOPIC "SELECT time FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier = ? OR oldValue = ? OR newValue = ? ) ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_LAST_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? ORDER BY id DESC LIMIT 1;"
public static final java.lang.String QUERY_READ_METADATA "SELECT key, value FROM metadata WHERE id_revision = ?;"
public static final java.lang.String QUERY_READ_METADATA_BY_KEY "SELECT value FROM metadata WHERE id_revision = ? AND key = ?;"
public static final java.lang.String QUERY_READ_PAST_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? AND id < ? ORDER BY id DESC LIMIT 1;"
public static final java.lang.String QUERY_READ_REVISION_BY_TAG "SELECT id FROM revisions WHERE id_topicmap = ? AND time <= ( SELECT time FROM tags WHERE tag = ? ) ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_REVISION_BY_TIMESTAMP "SELECT id FROM revisions WHERE id_topicmap = ? AND time <= ? ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_REVISIONS_BY_ASSOCIATIONTYPE "WITH ids AS ( SELECT id FROM associations WHERE id_type = ? ) SELECT id FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier IN ( SELECT id FROM ids ) OR oldValue IN ( SELECT CAST ( id AS character varying ) FROM ids ) OR newValue IN ( SELECT CAST ( id AS character varying ) FROM ids ) ) ORDER BY id ASC ;"
public static final java.lang.String QUERY_READ_REVISIONS_BY_TOPIC "SELECT id FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier = ? OR oldValue = ? OR newValue = ? ) ORDER BY id ASC ;"
public static final java.lang.String QUERY_READ_TIMESTAMP "SELECT time FROM revisions WHERE id = ?;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlSelectQueries.NonPaged
public static final java.lang.String QUERY_READ_ASSOCIATION_REIFIER "SELECT id_reifier FROM associations WHERE id = ?"
public static final java.lang.String QUERY_READ_ASSOCIATION_SCOPE "SELECT DISTINCT id_scope FROM associations WHERE id = ?"
public static final java.lang.String QUERY_READ_ASSOCIATION_TYPE "SELECT id_type FROM associations WHERE id = ?"
public static final java.lang.String QUERY_READ_ASSOCIATIONS "SELECT id FROM associations WHERE id_topicmap = ? "
public static final java.lang.String QUERY_READ_ASSOCIATIONS_WITH_SCOPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope = ? "
public static final java.lang.String QUERY_READ_ASSOCIATIONS_WITH_TYPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ? "
public static final java.lang.String QUERY_READ_ASSOCIATIONS_WITH_TYPE_AND_SCOPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ? AND id_scope = ? "
public static final java.lang.String QUERY_READ_CONSTRUCT "WITH iis AS ( SELECT id FROM constructs WHERE id = ? )SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id FROM iis ) UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id FROM iis ) UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id FROM iis ) UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id FROM iis ) UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id FROM iis ) AND v.id_parent = n.id UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id FROM iis ) UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id FROM iis );"
public static final java.lang.String QUERY_READ_CONSTRUCT_BY_ITEM_IDENTIFIER "SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? );"
public static final java.lang.String QUERY_READ_EMPTY_SCOPE "SELECT id FROM scopes WHERE id NOT IN ( SELECT DISTINCT id_scope FROM rel_themes ) AND id_topicmap = ?"
public static final java.lang.String QUERY_READ_ITEM_IDENTIFIERS "SELECT l.id, reference FROM locators AS l, rel_item_identifiers AS r WHERE r.id_construct = ? AND r.id_locator = l.id"
public static final java.lang.String QUERY_READ_LOCATOR "SELECT id FROM locators WHERE reference = ?; "
public static final java.lang.String QUERY_READ_NAME_REIFIER "SELECT id_reifier FROM names WHERE id = ?"
public static final java.lang.String QUERY_READ_NAME_SCOPE "SELECT DISTINCT id_scope FROM names WHERE id = ?"
public static final java.lang.String QUERY_READ_NAME_TYPE "SELECT id_type FROM names AS ty WHERE id = ?"
public static final java.lang.String QUERY_READ_NAME_VALUE "SELECT DISTINCT value FROM names WHERE id = ?"
public static final java.lang.String QUERY_READ_NAMES "SELECT id FROM names WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_NAMES_WITH_SCOPE "SELECT id FROM names WHERE id_parent = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_NAMES_WITH_TYPE "SELECT id FROM names WHERE id_parent = ? AND id_type = ?"
public static final java.lang.String QUERY_READ_NAMES_WITH_TYPE_AND_SCOPE "SELECT id FROM names WHERE id_parent = ? AND id_type = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_OCCURRENCE_DATATYPE "SELECT l.id, reference FROM locators AS l, occurrences AS d WHERE d.id_datatype = l.id AND d.id = ?"
public static final java.lang.String QUERY_READ_OCCURRENCE_REIFIER "SELECT id_reifier FROM occurrences WHERE id = ?"
public static final java.lang.String QUERY_READ_OCCURRENCE_SCOPE "SELECT DISTINCT id_scope FROM occurrences WHERE id = ?"
public static final java.lang.String QUERY_READ_OCCURRENCE_TYPE "SELECT id_type FROM occurrences WHERE id = ?"
public static final java.lang.String QUERY_READ_OCCURRENCE_VALUE "SELECT DISTINCT value FROM occurrences WHERE id = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES "SELECT id FROM occurrences WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES_WITH_SCOPE "SELECT id FROM occurrences WHERE id_parent = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES_WITH_TYPE "SELECT id FROM occurrences WHERE id_parent = ? AND id_type = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES_WITH_TYPE_AND_SCOPE "SELECT id FROM occurrences WHERE id_parent = ? AND id_type = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_SCOPE "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id AND a.id_scope = ?"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id AND a.id_type = ?"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE_AND_SCOPE "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id AND a.id_type = ? AND a.id_scope = ?"
public static final java.lang.String QUERY_READ_PLAYED_ROLES "SELECT id, id_parent FROM roles WHERE id_player = ? "
public static final java.lang.String QUERY_READ_PLAYED_ROLES_WITH_TYPE "SELECT id, id_parent FROM roles WHERE id_player = ? AND id_type = ? "
public static final java.lang.String QUERY_READ_PLAYED_ROLES_WITH_TYPE_AND_ASSOTYPE "SELECT r.id, r.id_parent FROM roles AS r, associations AS a WHERE r.id_player = ? AND r.id_type = ? AND r.id_parent = a.id AND a.id_type = ? "
public static final java.lang.String QUERY_READ_PLAYER "SELECT id_player FROM roles WHERE id = ?"
public static final java.lang.String QUERY_READ_REIFIED "SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id_reifier = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id_reifier = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id_reifier = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id_reifier = ? AND v.id_parent = n.id UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id_reifier = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id_reifier = ?;"
public static final java.lang.String QUERY_READ_ROLE_REIFIER "SELECT id_reifier FROM roles WHERE id = ?"
public static final java.lang.String QUERY_READ_ROLE_TYPE "SELECT id_type FROM roles WHERE id = ?"
public static final java.lang.String QUERY_READ_ROLES "SELECT id FROM roles WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_ROLES_WITH_TYPE "SELECT id FROM roles WHERE id_parent = ? AND id_type = ? "
public static final java.lang.String QUERY_READ_ROLESTYPES "SELECT DISTINCT id_type FROM roles WHERE id_parent = ? "
public static final java.lang.String QUERY_READ_SCOPES_BY_THEME "SELECT DISTINCT id_scope FROM rel_themes AS r WHERE id_theme = ? AND ? IN ( SELECT COUNT(*) FROM rel_themes WHERE id_scope = r.id_scope GROUP BY id_scope );"
public static final java.lang.String QUERY_READ_SUBJECT_IDENTIFIERS "SELECT reference FROM locators AS l, rel_subject_identifiers AS r, topics AS t WHERE r.id_topic = ? AND r.id_locator = l.id AND t.id = r.id_topic"
public static final java.lang.String QUERY_READ_SUBJECT_LOCATORS "SELECT l.id,reference FROM locators AS l, rel_subject_locators AS r , topics AS t WHERE r.id_topic = ? AND r.id_locator = l.id AND t.id = r.id_topic"
public static final java.lang.String QUERY_READ_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of WHERE id_subtype = ?"
public static final java.lang.String QUERY_READ_THEMES "SELECT DISTINCT id_theme FROM rel_themes WHERE id_scope = ?"
public static final java.lang.String QUERY_READ_TOPIC_BY_SUBJECT_IDENTIFIER " SELECT t.id FROM topics AS t, locators AS l, rel_subject_identifiers as r WHERE id_topicmap = ? AND reference = ? AND l.id = r.id_locator AND r.id_topic = t.id;"
public static final java.lang.String QUERY_READ_TOPIC_BY_SUBJECT_LOCATOR " SELECT t.id FROM topics AS t, locators AS l, rel_subject_locators as r WHERE id_topicmap = ? AND reference = ? AND l.id = r.id_locator AND r.id_topic = t.id;"
public static final java.lang.String QUERY_READ_TOPICMAP "SELECT tm.id FROM topicmaps AS tm, locators AS l WHERE l.reference = ? AND l.id = tm.id_base_locator;"
public static final java.lang.String QUERY_READ_TOPICMAP_REIFIER "SELECT id_reifier FROM topicmaps WHERE id = ?"
public static final java.lang.String QUERY_READ_TOPICS "SELECT id FROM topics WHERE id_topicmap = ?"
public static final java.lang.String QUERY_READ_TOPICS_WITH_TYPE "SELECT id_instance FROM rel_instance_of AS r, topics AS t WHERE id_instance = t.id AND id_type IN ( SELECT id FROM topics WHERE id = ? )"
public static final java.lang.String QUERY_READ_TYPES "SELECT id_type FROM rel_instance_of WHERE id_instance = ?"
public static final java.lang.String QUERY_READ_VARIANT_DATATYPE "SELECT l.id, reference FROM locators AS l, variants AS d WHERE d.id_datatype = l.id AND d.id = ?"
public static final java.lang.String QUERY_READ_VARIANT_REIFIER "SELECT id_reifier FROM variants WHERE id = ?"
public static final java.lang.String QUERY_READ_VARIANT_SCOPE "SELECT DISTINCT id_scope FROM variants WHERE id = ?"
public static final java.lang.String QUERY_READ_VARIANT_VALUE "SELECT DISTINCT value FROM variants WHERE id = ?"
public static final java.lang.String QUERY_READ_VARIANTS "SELECT id FROM variants WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_VARIANTS_WITH_SCOPE "SELECT id FROM variants WHERE id_parent = ? AND id_scope = ?"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlSelectQueries.Paged
public static final java.lang.String QUERY_READ_NAMES "SELECT id FROM names WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_NAMES "SELECT COUNT(id) AS number FROM names WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_OCCURRENCES "SELECT COUNT(id) AS number FROM occurrences WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_PLAYED_ASSOCIATIONS "SELECT DISTINCT COUNT(a.id) AS number FROM associations AS a, roles AS r WHERE r.id_player = ? AND r.id_parent = a.id;"
public static final java.lang.String QUERY_READ_NUMBER_OF_PLAYED_ROLES "SELECT COUNT(id) AS number FROM roles WHERE id_player = ?"
public static final java.lang.String QUERY_READ_NUMBER_OF_ROLES "SELECT COUNT(id) AS number FROM roles WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_TYPES "SELECT COUNT(id_type) AS number FROM rel_instance_of WHERE id_instance = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_VARIANTS "SELECT COUNT(id) AS number FROM variants WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_OCCURRENCES "SELECT id FROM occurrences WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id ORDER BY a.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_PLAYED_ROLES "SELECT id, id_parent FROM roles WHERE id_player = ? ORDER BY id OFFSET ? LIMIT ?"
public static final java.lang.String QUERY_READ_ROLES "SELECT id FROM roles WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_TYPES "SELECT id_type FROM rel_instance_of WHERE id_instance = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_VARIANTS "SELECT id FROM variants WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlUpdateQueries
public static final java.lang.String QUERY_ADD_ITEM_IDENTIFIER "INSERT INTO rel_item_identifiers(id_construct, id_locator) SELECT ? , id FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_ADD_SUBJECT_IDENTIFIER "INSERT INTO rel_subject_identifiers(id_topic, id_locator) SELECT ? , id FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_ADD_SUBJECT_LOCATOR "INSERT INTO rel_subject_locators(id_topic, id_locator) SELECT ? , id FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_ADD_THEME "INSERT INTO rel_themes(id_scope, id_theme) VALUES (?,?);"
public static final java.lang.String QUERY_MODIFY_ASSOCIATION_REIFIER "UPDATE associations SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_ASSOCIATION_SCOPE "UPDATE associations SET id_scope = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_ASSOCIATION_TYPE "UPDATE associations SET id_type = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_NAME_REIFIER "UPDATE names SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_NAME_SCOPE "UPDATE names SET id_scope = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_NAME_TYPE "UPDATE names SET id_type = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_OCCURRENCE_REIFIER "UPDATE occurrences SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_OCCURRENCE_SCOPE "UPDATE occurrences SET id_scope = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_OCCURRENCE_TYPE "UPDATE occurrences SET id_type = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_PLAYER "UPDATE roles SET id_player = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_ROLE_REIFIER "UPDATE roles SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_ROLE_TYPE "UPDATE roles SET id_type = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_SUPERTYPES "INSERT INTO rel_kind_of(id_subtype, id_supertype) SELECT ?,? WHERE NOT EXISTS ( SELECT id_subtype, id_supertype FROM rel_kind_of WHERE id_subtype = ? AND id_supertype = ? );"
public static final java.lang.String QUERY_MODIFY_TOPICMAP_REIFIER "UPDATE topicmaps SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_TYPES "INSERT INTO rel_instance_of(id_instance, id_type) SELECT ?,? WHERE NOT EXISTS ( SELECT id_instance, id_type FROM rel_instance_of WHERE id_instance = ? AND id_type = ? );"
public static final java.lang.String QUERY_MODIFY_VALUE "UPDATE literals SET value = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_VALUE_WITH_DATATYPE "UPDATE literals SET value = ? WHERE id = ?;UPDATE datatypeawares SET id_datatype = ( SELECT id FROM locators WHERE reference LIKE ? ) WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_VARIANT_REIFIER "UPDATE variants SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_VARIANT_SCOPE "UPDATE variants SET id_scope = ? WHERE id = ?;"

de.topicmapslab.majortom.database.jdbc.mysql.query.IMySqlUpdateQueries.QueryMerge
public static final java.lang.String QUERY_MERGE_TOPIC "UPDATE rel_kind_of SET id_subtype = ? WHERE id_subtype = ?;UPDATE rel_kind_of SET id_supertype = ? WHERE id_supertype = ?;UPDATE rel_instance_of SET id_instance = ? WHERE id_instance = ?;UPDATE rel_instance_of SET id_type = ? WHERE id_type = ?;UPDATE rel_themes SET id_theme = ? WHERE id_theme = ?;UPDATE typeables SET id_type = ? WHERE id_type = ?;UPDATE reifiables SET id_reifier = ? WHERE id_reifier = ?;UPDATE rel_item_identifiers SET id_construct = ? WHERE id_construct = ?;UPDATE rel_subject_identifiers SET id_topic = ? WHERE id_topic = ?;UPDATE rel_subject_locators SET id_topic = ? WHERE id_topic = ?;UPDATE roles SET id_player = ? WHERE id_player = ?;UPDATE constructs SET id_parent = ? WHERE id_parent = ?;DELETE FROM topics WHERE id = ?;"

de.topicmapslab.majortom.database.jdbc.postgres.base.BasePostGreSqlConnectionProvider
private static final java.lang.String ORG_POSTGRESQL_DRIVER "org.postgresql.Driver"
private static final java.lang.String POSTGRESQL "postgresql"

de.topicmapslab.majortom.database.jdbc.postgres.optimized.query.IPostGreSqlIndexQueries.QueryScopeIndex
public static final java.lang.String QUERY_SELECT_SCOPES_BY_THEMES_USED "SELECT r.id, ARRAY ( SELECT id_theme FROM rel_themes WHERE id_scope = r.id ) AS themes FROM ( SELECT unnest(scope_by_themes(?,?,?,?)) AS id INTERSECT SELECT id_scope AS id FROM scopeables ) AS r;"

de.topicmapslab.majortom.database.jdbc.postgres.optimized.query.IPostGreSqlIndexQueries.QuerySupertypeSubtypeIndex.NonPaged
public static final java.lang.String QUERY_SELECT_SUBTYPES_OF_TOPIC "SELECT unnest(transitive_subtypes(?)) AS id;"
public static final java.lang.String QUERY_SELECT_SUBTYPES_OF_TOPICS "SELECT unnest(transitive_subtypes(?,?)) AS id;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES_OF_TOPIC "SELECT unnest(transitive_supertypes(?)) AS id;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES_OF_TOPICS "SELECT unnest(transitive_supertypes(?,?)) AS id;"

de.topicmapslab.majortom.database.jdbc.postgres.optimized.query.IPostGreSqlIndexQueries.QuerySupertypeSubtypeIndex.Paged
public static final java.lang.String QUERY_SELECT_SUBTYPES_OF_TOPIC "SELECT unnest(transitive_subtypes(?)) AS id ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_SUBTYPES_OF_TOPICS "SELECT unnest(transitive_subtypes(?,?)) AS id ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES_OF_TOPIC "SELECT unnest(transitive_supertypes(?)) AS id ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES_OF_TOPICS "SELECT unnest(transitive_supertypes(?,?)) AS id ORDER BY id OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.postgres.optimized.query.IPostGreSqlIndexQueries.QueryTransitiveTypeInstanceIndex.NonPaged
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPE "SELECT id FROM associations WHERE id_type IN ( SELECT unnest(types_and_subtypes(?))) ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPE "SELECT id, id_parent FROM names WHERE id_type IN ( SELECT unnest(types_and_subtypes(?)));"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPE "SELECT id, id_parent FROM occurrences WHERE id_type IN ( SELECT unnest(types_and_subtypes(?)));"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPE "SELECT id, id_parent FROM roles WHERE id_type IN ( SELECT unnest(types_and_subtypes(?)));"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_TYPE "SELECT id_instance AS id FROM rel_instance_of, topics WHERE id = id_instance AND id_type IN ( SELECT unnest(types_and_subtypes(?)));"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_TYPES "SELECT unnest(topics_by_type_transitive(?,?)) AS id;"

de.topicmapslab.majortom.database.jdbc.postgres.optimized.query.IPostGreSqlIndexQueries.QueryTransitiveTypeInstanceIndex.Paged
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPE "SELECT id FROM associations WHERE id_type IN ( SELECT unnest(types_and_subtypes(?))) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPE "SELECT id, id_parent FROM names WHERE id_type IN ( SELECT unnest(types_and_subtypes(?))) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPE "SELECT id, id_parent FROM occurrences WHERE id_type IN ( SELECT unnest(types_and_subtypes(?))) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPE "SELECT id, id_parent FROM roles WHERE id_type IN ( SELECT unnest(types_and_subtypes(?))) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_TYPE "SELECT id_instance AS id FROM rel_instance_of, topics WHERE id = id_instance AND id_type IN ( SELECT unnest(types_and_subtypes(?))) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_TYPES "SELECT unnest(topics_by_type_transitive(?,?)) AS id ORDER BY id OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.postgres.optimized.query.IPostGreSqlPerformQueries
public static final java.lang.String PERFORM_MERGE_TOPICS "SELECT merge_topics(?,?);"
public static final java.lang.String PERFORM_REMOVE_DUPLICATE_TOPIC_CONTENT "SELECT remove_duplicate_topiccontent(?,?);"
public static final java.lang.String PERFORM_REMOVE_DUPLICATES "SELECT remove_duplicates(?);"

de.topicmapslab.majortom.database.jdbc.postgres.optimized.query.IPostGreSqlSelectQueries.NonPaged
public static final java.lang.String QUERY_READ_BEST_LABEL "SELECT best_label(?,?);"
public static final java.lang.String QUERY_READ_BEST_LABEL_WITH_THEME "SELECT best_label(?,?,?,?);"
public static final java.lang.String QUERY_READ_SCOPES_BY_THEMES "SELECT r.id, ARRAY ( SELECT id_theme FROM rel_themes WHERE id_scope = r.id ) AS themes FROM ( SELECT unnest(scope_by_themes(?,?,?,?)) AS id ) AS r;"
public static final java.lang.String QUERY_READ_SUPERTYPES "SELECT unnest(transitive_supertypes(?)) AS id;"

de.topicmapslab.majortom.database.jdbc.postgres.optimized.query.IPostGreSqlSelectQueries.Paged
public static final java.lang.String QUERY_READ_SUPERTYPES "SELECT unnest(transitive_supertypes(?)) AS id OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99ConstraintsQueries
public static final java.lang.String QUERY_DUPLICATE_ASSOCIATIONS "WITH tmp AS ( SELECT id_type, id_player, id_parent FROM roles WHERE id_topicmap = ? )SELECT DISTINCT a.id, a.id_reifier FROM tmp AS r, associations AS a WHERE 0 IN ( SELECT COUNT (r2) FROM ( SELECT id_type , id_player FROM roles WHERE id_parent = r.id_parent EXCEPT SELECT id_type, id_player FROM roles WHERE id_parent = ? ) AS r2 ) AND r.id_parent <> ? AND r.id_parent = a.id AND a.id_type = ? AND a.id_scope = ?;"
public static final java.lang.String QUERY_DUPLICATE_NAME "SELECT id, id_parent FROM names WHERE id_parent = ? AND id <> ? AND id_type = ? AND value = ? AND id_scope = ?"
public static final java.lang.String QUERY_DUPLICATE_OCCURRENCE "SELECT id, id_parent FROM occurrences WHERE id_parent = ? AND id <> ? AND id_type = ? AND value = ? AND id_datatype IN ( SELECT id FROM locators WHERE reference = ? ) AND id_scope = ?"
public static final java.lang.String QUERY_DUPLICATE_ROLES "SELECT id FROM roles WHERE id_parent = ? AND id_type = ? AND id_player = ?;"
public static final java.lang.String QUERY_DUPLICATE_VARIANTS "SELECT id, id_parent FROM variants WHERE id_parent = ? AND id <> ? AND value = ? AND id_datatype IN ( SELECT id FROM locators WHERE reference = ? ) AND id_scope = ?"
public static final java.lang.String QUERY_MOVE_ITEM_IDENTIFIERS "UPDATE rel_item_identifiers SET id_construct = ? WHERE id_construct = ?;"
public static final java.lang.String QUERY_MOVE_VARIANTS "UPDATE variants SET id_parent = ? WHERE id_parent = ?;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99DeleteQueries
public static final java.lang.String QUERY_CLEAR_TOPICMAP "DELETE FROM rel_item_identifiers WHERE id_construct IN ( SELECT id FROM constructs WHERE id_topicmap = ? OR id = ? );DELETE FROM revisions WHERE id_topicmap = ? ;UPDATE topicmaps SET id_reifier = NULL WHERE id = ?; DELETE FROM constructs WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_DELETE_ALL_ITEM_IDENTIFIERS "DELETE FROM rel_item_identifiers WHERE id_construct IN ( SELECT id FROM constructs WHERE id_topicmap = ? OR id = ? );"
public static final java.lang.String QUERY_DELETE_ASSOCIATION "DELETE FROM associations WHERE id = ?; "
public static final java.lang.String QUERY_DELETE_HISTORY "DELETE FROM revisions WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_DELETE_ITEM_IDENTIFIER "DELETE FROM rel_item_identifiers WHERE id_construct = ? and id_locator = ( SELECT id FROM locators WHERE reference = ? )"
public static final java.lang.String QUERY_DELETE_NAME "DELETE FROM names WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_OCCURRENCE "DELETE FROM occurrences WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_ROLE "DELETE FROM roles WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_SUBJECT_IDENTIFIER "DELETE FROM rel_subject_identifiers WHERE id_topic = ? and id_locator = ( SELECT id FROM locators WHERE reference = ? )"
public static final java.lang.String QUERY_DELETE_SUBJECT_LOCATOR "DELETE FROM rel_subject_locators WHERE id_topic = ? and id_locator = ( SELECT id FROM locators WHERE reference = ? )"
public static final java.lang.String QUERY_DELETE_SUPERTYPE "DELETE FROM rel_kind_of WHERE id_subtype = ? AND id_supertype = ?;"
public static final java.lang.String QUERY_DELETE_TOPIC "DELETE FROM topics WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_TOPICMAP "DELETE FROM rel_item_identifiers WHERE id_construct IN ( SELECT id FROM constructs WHERE id_topicmap = ? OR id = ? );DELETE FROM revisions WHERE id_topicmap = ? ;DELETE FROM topicmaps WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_TYPE "DELETE FROM rel_instance_of WHERE id_instance = ? AND id_type = ?;"
public static final java.lang.String QUERY_DELETE_VARIANT "DELETE FROM variants WHERE id = ?;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99DumpQueries
public static final java.lang.String QUERY_DUMP_ASSOCIATION "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_scope, themes, roles, type) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_item_identifiers WHERE id_construct = a.id )), ARRAY[id_type], id_reifier, id_scope, ARRAY( SELECT id_theme FROM rel_themes WHERE id_scope = a.id_scope ), ARRAY( SELECT id FROM roles WHERE id_parent = a.id ), \'a\' FROM associations AS a WHERE id = ?;"
public static final java.lang.String QUERY_DUMP_NAME "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, variants, id_reification, id_scope, themes, value, type) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_item_identifiers WHERE id_construct = n.id )), ARRAY[id_type], ARRAY ( SELECT id FROM variants WHERE id_parent = n.id ), id_reifier, id_scope, ARRAY( SELECT id_theme FROM rel_themes WHERE id_scope = n.id_scope ), value, \'n\' FROM names AS n WHERE id = ?"
public static final java.lang.String QUERY_DUMP_OCCURRENCE "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_scope, themes, value, datatype, type) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_item_identifiers WHERE id_construct = o.id )), ARRAY[id_type], id_reifier, id_scope, ARRAY( SELECT id_theme FROM rel_themes WHERE id_scope = o.id_scope ), value, ( SELECT reference FROM locators WHERE id = o.id_datatype), \'o\' FROM occurrences AS o WHERE id = ?"
public static final java.lang.String QUERY_DUMP_ROLE "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_player, type) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_item_identifiers WHERE id_construct = r.id )), ARRAY[id_type], id_reifier, id_player, \'r\' FROM roles AS r WHERE id = ?"
public static final java.lang.String QUERY_DUMP_TOPIC "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, subjectidentifiers, subjectlocators, types, supertypes, names, occurrences, associations, id_reification, type, bestlabel, bestidentifier) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN ( SELECT id_locator FROM rel_item_identifiers WHERE id_construct = t.id )), ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_subject_identifiers WHERE id_topic = t.id )), ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_subject_locators WHERE id_topic = t.id )), ARRAY ( SELECT id_type FROM rel_instance_of WHERE id_instance = t.id ), ARRAY ( SELECT id_supertype FROM rel_kind_of WHERE id_subtype = t.id ), ARRAY ( SELECT id FROM names WHERE id_parent = t.id ), ARRAY ( SELECT id FROM occurrences WHERE id_parent = t.id ), ARRAY ( SELECT DISTINCT id FROM associations WHERE id IN ( SELECT id_parent FROM roles WHERE id_player = t.id )), (SELECT CASE WHEN ( t.id IN ( SELECT id_reifier FROM reifiables WHERE id_reifier = t.id)) THEN ( SELECT id FROM reifiables WHERE id_reifier = t.id ) ELSE NULL END),\'t\', ?, ? FROM topics AS t WHERE id = ?"
public static final java.lang.String QUERY_DUMP_VARIANT "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, id_reification, id_scope,themes, datatype, value, type) SELECT id_topicmap, ?, id, id_parent, ARRAY ( SELECT reference FROM locators WHERE id IN (SELECT id_locator FROM rel_item_identifiers WHERE id_construct = v.id )), id_reifier, id_scope, ARRAY( SELECT id_theme FROM rel_themes WHERE id_scope = v.id_scope ), ( SELECT reference FROM locators WHERE id = v.id_datatype), value, \'v\' FROM variants AS v WHERE id = ?"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99IndexQueries.QueryIdentityIndex.NonPaged
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_IDENTIFIER_PATTERN "WITH locs AS ( SELECT id FROM locators WHERE reference ~* ? ), iis AS (SELECT id_construct AS id FROM rel_item_identifiers WHERE id_locator IN ( SELECT id FROM locs ) UNION SELECT id_topic AS id FROM rel_subject_locators WHERE id_locator IN ( SELECT id FROM locs ) UNION SELECT id_topic AS id FROM rel_subject_identifiers WHERE id_locator IN ( SELECT id FROM locs ) )SELECT DISTINCT r.id, r.id_parent, r.other, r.type FROM (SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id FROM iis )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id FROM iis ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id FROM iis ) ) AS r;"
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_ITEM_IDENTIFIER_PATTERN "WITH iis AS ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference ~* ? )SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id_construct FROM iis )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id_construct FROM iis ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id_construct FROM iis );"
public static final java.lang.String QUERY_SELECT_ITEM_IDENTIFIERS "SELECT l.id,l.reference FROM locators AS l, rel_item_identifiers, constructs AS c WHERE ( c.id_topicmap = ? OR c.id = ? ) AND l.id = id_locator AND c.id = id_construct;"
public static final java.lang.String QUERY_SELECT_SUBJECT_IDENTIFIERS "SELECT l.id,l.reference FROM locators AS l, rel_subject_identifiers, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ;"
public static final java.lang.String QUERY_SELECT_SUBJECT_LOCATORS "SELECT l.id,l.reference FROM locators AS l, rel_subject_locators, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_IDENTIFIER_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_identifiers, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND reference ~* ? ;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_LOCATOR_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_locators, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND reference ~* ? ;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99IndexQueries.QueryIdentityIndex.Paged
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_IDENTIFIER_PATTERN "WITH locs AS ( SELECT id FROM locators WHERE reference ~* ? ), iis AS (SELECT id_construct AS id FROM rel_item_identifiers WHERE id_locator IN ( SELECT id FROM locs ) UNION SELECT id_topic AS id FROM rel_subject_locators WHERE id_locator IN ( SELECT id FROM locs ) UNION SELECT id_topic AS id FROM rel_subject_identifiers WHERE id_locator IN ( SELECT id FROM locs ) )SELECT DISTINCT r.id, r.id_parent, r.other, r.type FROM (SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id FROM iis )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id FROM iis ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id FROM iis ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id FROM iis ) ) AS r ORDER BY r.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_ITEM_IDENTIFIER_PATTERN "WITH iis AS ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference ~* ? )SELECT r.id, r.id_parent, r.other, r.type FROM (SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id_construct FROM iis )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id_construct FROM iis ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id_construct FROM iis ) ) AS r ORDER BY r.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ITEM_IDENTIFIERS "SELECT l.id,l.reference FROM locators AS l, rel_item_identifiers, constructs AS c WHERE ( c.id_topicmap = ? OR c.id = ? ) AND l.id = id_locator AND c.id = id_construct ORDER BY l.reference OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_SUBJECT_IDENTIFIERS "SELECT l.id,l.reference FROM locators AS l, rel_subject_identifiers, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ORDER BY l.reference OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_SUBJECT_LOCATORS "SELECT l.id,l.reference FROM locators AS l, rel_subject_locators, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ORDER BY l.reference OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_IDENTIFIER_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_identifiers, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND reference ~* ? ORDER BY id_topic OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_LOCATOR_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_locators, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND reference ~* ? ORDER BY id_topic OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99IndexQueries.QueryLiteralIndex.NonPaged
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS "SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value = ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_DATATYPE "SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP "SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_topicmap = ? AND value ~* ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value ~* ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP_AND_DATATYPE "SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ~* ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value ~* ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_VALUE "SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_topicmap = ? AND value = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value = ?;"
public static final java.lang.String QUERY_SELECT_DATATYPEAWARES_BY_DATATYPE "SELECT o.id, id_parent, NULL AS other, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT v.id, v.id_parent, n.id_parent AS other, \'v\' AS type FROM variants AS v, locators AS l, names AS n WHERE v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? AND n.id = v.id_parent;"
public static final java.lang.String QUERY_SELECT_NAMES "SELECT id, id_parent FROM names WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_REGEXP "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND value ~* ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_VALUE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND value ILIKE ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATERANGE "SELECT o.id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND ? <= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id ) AND ? >= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id );"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_RANGE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? AND CAST ( value AS double precision ) BETWEEN ? AND ? "
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND value ~* ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ~* ? AND o.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND value ILIKE ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ILIKE ? AND o.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ~* ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ~* ? AND v.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ILIKE ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ILIKE ? AND v.id_datatype = l.id AND l.reference = ? ;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99IndexQueries.QueryLiteralIndex.Paged
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS "SELECT r.id, r.id_parent, r.type, r.value FROM ( SELECT o.id, id_parent, \'o\' AS type, value FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type, value FROM names WHERE id_topicmap = ? AND value = ?) AS r ORDER BY r.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_DATATYPE "SELECT r.id, r.id_parent, r.type, r.value FROM ( SELECT o.id, id_parent, \'o\' AS type, value FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type, value FROM names WHERE id_topicmap = ?) AS r ORDER BY r.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP "SELECT r.id, r.id_parent, r.type, r.value FROM ( SELECT id, id_parent, \'o\' AS type, value FROM occurrences WHERE id_topicmap = ? AND value ~* ? UNION SELECT id, id_parent, \'n\' AS type, value FROM names WHERE id_topicmap = ? AND value ~* ? ) AS r ORDER BY r.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP_AND_DATATYPE "SELECT r.id, r.id_parent, r.type, r.value FROM ( SELECT o.id, id_parent, \'o\' AS type, value FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ~* ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type, value FROM names WHERE id_topicmap = ? AND value ~* ?) AS r ORDER BY r.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_VALUE "SELECT r.id, r.id_parent, r.type, r.value FROM ( SELECT id, id_parent, \'o\' AS type, value FROM occurrences WHERE id_topicmap = ? AND value = ? UNION SELECT id, id_parent, \'n\' AS type, value FROM names WHERE id_topicmap = ? AND value = ? ) AS r ORDER BY r.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_DATATYPEAWARES_BY_DATATYPE "SELECT r.id, r.id_parent, r.other, r.type, r.value FROM ( SELECT o.id, id_parent, NULL AS other, \'o\' AS type, o.value FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT v.id, v.id_parent, n.id_parent AS other, \'v\' AS type, v.value FROM variants AS v, locators AS l, names AS n WHERE v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? AND n.id = v.id_parent) AS r ORDER BY r.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES "SELECT id, id_parent FROM names WHERE id_topicmap = ? ORDER BY value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_REGEXP "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND value ~* ? ORDER BY value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_VALUE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND value ILIKE ? ORDER BY value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? ORDER BY value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? ORDER BY o.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATERANGE "SELECT o.id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND ? <= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id ) AND ? >= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id ) ORDER BY o.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_RANGE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? AND CAST ( value AS double precision ) BETWEEN ? AND ? ORDER BY o.value OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND value ~* ? ORDER BY value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ~* ? AND o.id_datatype = l.id AND l.reference = ? ORDER BY o.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND value ILIKE ? ORDER BY value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value ILIKE ? AND o.id_datatype = l.id AND l.reference = ? ORDER BY o.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? ORDER BY v.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? ORDER BY v.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ~* ? ORDER BY v.value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ~* ? AND v.id_datatype = l.id AND l.reference = ? ORDER BY v.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ILIKE ? ORDER BY v.value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.value ILIKE ? AND v.id_datatype = l.id AND l.reference = ? ORDER BY v.value OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99IndexQueries.QueryScopeIndex.NonPaged
public static final java.lang.String QUERY_SELECT_ASSOCIATION_SCOPES "SELECT id_scope FROM associations WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATION_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM associations WHERE id_topicmap = ? );"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope = ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? ));"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEME "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES "SELECT id FROM associations AS a WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = a.id_scope AND id_theme IN ( SELECT unnest(?))); "
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES_MATCH_ALL "SELECT id FROM associations AS a WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = a.id_scope ) @> ?; "
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_SCOPE "SELECT id, id_parent, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_scope = ? ;"
public static final java.lang.String QUERY_SELECT_NAME_SCOPES "SELECT id_scope FROM names WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_NAME_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? );"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope = ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? ));"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEME "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? );"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = n.id_scope AND id_theme IN ( SELECT unnest(?)));"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope ) @> ?; "
public static final java.lang.String QUERY_SELECT_OCCURRENCE_SCOPES "SELECT id_scope FROM occurrences WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCE_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM occurrences WHERE id_topicmap = ? );"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope = ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? ));"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEME "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? );"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = o.id_scope AND id_theme IN ( SELECT unnest(?)));"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = o.id_scope ) @> ?; "
public static final java.lang.String QUERY_SELECT_SCOPABLES "SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id_scope = ? UNION SELECT v.id, v.id_parent, n.id_parent AS other, \'v\' AS type FROM variants AS v, names AS n WHERE v.id_scope = ? AND n.id = v.id_parent;"
public static final java.lang.String QUERY_SELECT_SCOPES "SELECT DISTINCT id_scope FROM rel_themes WHERE id_scope IN ( SELECT DISTINCT id_scope FROM scopeables ) AND "
public static final java.lang.String QUERY_SELECT_SCOPES_BY_THEMES_USED "SELECT r.id_scope FROM rel_themes AS r, scopeables AS s, constructs AS c WHERE id_theme = ? AND r.id_scope = s.id_scope AND c.id = s.id;"
public static final java.lang.String QUERY_SELECT_VARIANT_SCOPES "SELECT id_scope FROM variants WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_VARIANT_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM variants WHERE id_topicmap = ? ) OR id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? AND id IN ( SELECT id_parent FROM variants ));"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope = ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope IN ( SELECT unnest ( ? ));"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEME "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( v.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) OR n.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ));"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( v.id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = v.id_scope AND id_theme IN ( SELECT unnest(?)) ) OR n.id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = n.id_scope AND id_theme IN ( SELECT unnest(?)) )); "
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES_MATCH_ALL "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope ) || ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = v.id_scope ) @> ?; "

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99IndexQueries.QueryScopeIndex.Paged
public static final java.lang.String QUERY_SELECT_ASSOCIATION_SCOPES "SELECT id_scope FROM associations WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATION_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM associations WHERE id_topicmap = ? ) ORDER BY id_theme OFFSET ? LIMIT ?; ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? )) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEME "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES "SELECT id FROM associations AS a WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = a.id_scope AND id_theme IN ( SELECT unnest(?))) ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES_MATCH_ALL "SELECT id FROM associations AS a WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = a.id_scope ) @> ? ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_SCOPE "SELECT r.id, r.id_parent, r.type FROM ( SELECT id, id_parent, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_scope = ? ) AS r ORDER BY r OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAME_SCOPES "SELECT id_scope FROM names WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAME_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? ) ORDER BY id_theme OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? )) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEME "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = n.id_scope AND id_theme IN ( SELECT unnest(?))) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope ) @> ? ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_OCCURRENCE_SCOPES "SELECT id_scope FROM occurrences WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCE_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM occurrences WHERE id_topicmap = ? ) ORDER BY id_theme OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( SELECT unnest ( ? )) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEME "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = o.id_scope AND id_theme IN ( SELECT unnest(?))) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = o.id_scope ) @> ? ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_SCOPABLES "SELECT r.id, r.id_parent, r.other, r.type FROM ( SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id_scope = ? UNION SELECT v.id, v.id_parent, n.id_parent AS other, \'v\' AS type FROM variants AS v, names AS n WHERE v.id_scope = ? AND n.id = v.id_parent ) AS r ORDER BY r.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANT_SCOPES "SELECT id_scope FROM variants WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANT_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM variants WHERE id_topicmap = ? ) OR id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? AND id IN ( SELECT id_parent FROM variants )) ORDER BY id_theme OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope = ? ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope IN ( SELECT unnest ( ? )) ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEME "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( v.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) OR n.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? )) ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( v.id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = v.id_scope AND id_theme IN ( SELECT unnest(?)) ) OR n.id_scope IN ( SELECT DISTINCT r.id_scope FROM rel_themes AS r WHERE r.id_scope = n.id_scope AND id_theme IN ( SELECT unnest(?)) )) ORDER BY v.id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES_MATCH_ALL "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope ) || ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = v.id_scope ) @> ? ORDER BY v.id OFFSET ? LIMIT ?; "

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99IndexQueries.QuerySupertypeSubtypeIndex.NonPaged
public static final java.lang.String QUERY_SELECT_DIRECT_SUBTYPES "SELECT id_subtype AS id FROM rel_kind_of WHERE id_supertype = ? UNION SELECT DISTINCT id_player AS id FROM roles WHERE id_parent IN ( SELECT id FROM associations AS a WHERE a.id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype-subtype\' ) AND a.id IN ( SELECT id_parent FROM roles WHERE id_player = ? AND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype\' )))\tAND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/subtype\' );"
public static final java.lang.String QUERY_SELECT_DIRECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of WHERE id_subtype = ? UNION SELECT DISTINCT id_player AS id FROM roles WHERE id_parent IN ( SELECT id FROM associations AS a WHERE a.id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype-subtype\' ) AND a.id IN ( SELECT id_parent FROM roles WHERE id_player = ? AND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/subtype\' )))\tAND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype\' );"
public static final java.lang.String QUERY_SELECT_SUBTYPES "SELECT id_subtype FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ? UNION SELECT DISTINCT id_player AS id_subtype FROM roles WHERE id_parent IN ( SELECT id FROM associations AS a WHERE a.id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype-subtype\' ))\tAND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/subtype\' ) AND id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ? UNION SELECT DISTINCT id_player AS id_subtype FROM roles WHERE id_parent IN ( SELECT id FROM associations AS a WHERE a.id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype-subtype\' ))\tAND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype\' ) AND id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUBTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_supertype FROM rel_kind_of ) AND id_parent = ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUPERTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_subtype FROM rel_kind_of ) AND id_parent = ?;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99IndexQueries.QuerySupertypeSubtypeIndex.Paged
public static final java.lang.String QUERY_SELECT_DIRECT_SUBTYPES "SELECT id_subtype AS id FROM rel_kind_of WHERE id_supertype = ? UNION SELECT DISTINCT id_player AS id FROM roles WHERE id_parent IN ( SELECT id FROM associations AS a WHERE a.id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype-subtype\' ) AND a.id IN ( SELECT id_parent FROM roles WHERE id_player = ? AND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype\' )))\tAND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/subtype\' ) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_DIRECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of WHERE id_subtype = ? UNION SELECT DISTINCT id_player AS id_supertype FROM roles WHERE id_parent IN ( SELECT id FROM associations AS a WHERE a.id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype-subtype\' ) AND a.id IN ( SELECT id_parent FROM roles WHERE id_player = ? AND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/subtype\' )))\tAND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype\' ) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NUMBER_OF_TOPICS_WITHOUT_SUPERTYPES "SELECT COUNT(id) AS number FROM topics WHERE id NOT IN ( SELECT id_subtype FROM rel_kind_of ) AND id_parent = ?;"
public static final java.lang.String QUERY_SELECT_SUBTYPES "SELECT id_subtype FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ? UNION SELECT DISTINCT id_player AS id_subtype FROM roles WHERE id_parent IN ( SELECT id FROM associations AS a WHERE a.id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype-subtype\' ))\tAND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/subtype\' ) AND id_topicmap = ? ORDER BY id_subtype OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ? UNION SELECT DISTINCT id_player AS id FROM roles WHERE id_parent IN ( SELECT id FROM associations AS a WHERE a.id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype-subtype\' ))\tAND id_type IN ( SELECT id_topic FROM rel_subject_identifiers AS r, locators AS l WHERE l.id = r.id_locator AND l.reference = \'http://psi.topicmaps.org/iso13250/model/supertype\' ) AND id_topicmap = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUBTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_supertype FROM rel_kind_of ) AND id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUPERTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_subtype FROM rel_kind_of ) AND id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99IndexQueries.QueryTypeInstanceIndex.NonPaged
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONTYPES "SELECT DISTINCT id_type FROM associations WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPE "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type = ? ) AS u;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPES "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type IN ( SELECT unnest( ? ) ) UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type IN ( SELECT unnest( ? ) ) ) AS u;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICTYPES "SELECT DISTINCT id_type FROM ( SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? UNION SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ) AS u;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_NAMETYPES "SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCETYPES "SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPE "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPES "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_ROLETYPES "SELECT DISTINCT id_type FROM roles WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPE "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND ( %SUBQUERY% ) "
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES_MATCHES_ALL "SELECT DISTINCT id_instance FROM rel_instance_of AS r, topics WHERE id = id_instance AND id_topicmap = ? AND ARRAY ( SELECT id_type FROM rel_instance_of AS r2 WHERE r.id_instance = r2.id_instance ) @> CAST ( ARRAY[ %ARRAY%] AS bigint[] ) "
public static final java.lang.String QUERY_SELECT_TOPIC_WITHOUT_TYPE "SELECT id FROM topics WHERE id_topicmap = ? AND NOT id IN ( SELECT id_instance FROM rel_instance_of ) "
public static final java.lang.String QUERY_SELECT_TOPICTYPES "SELECT DISTINCT id_type FROM rel_instance_of, topics WHERE id_topicmap = ? AND id = id_type AND id_instance IN ( SELECT id FROM topics AS t WHERE t.id = id_instance );"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99IndexQueries.QueryTypeInstanceIndex.Paged
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONTYPES "SELECT DISTINCT id_type FROM associations WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPE "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type = ? ) AS u ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPES "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type IN ( SELECT unnest( ? ) ) UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type IN ( SELECT unnest( ? ) ) ) AS u ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICTYPES "SELECT DISTINCT id_type FROM ( SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? UNION SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ) AS u ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMETYPES "SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCETYPES "SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPE "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPES "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type IN ( SELECT unnest( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ROLETYPES "SELECT DISTINCT id_type FROM roles WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPE "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND id_type = ? ORDER BY id_instance OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND ( %SUBQUERY% ) ORDER BY id_instance OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES_MATCHES_ALL "SELECT DISTINCT id_instance FROM rel_instance_of AS r, topics WHERE id = id_instance AND id_topicmap = ? AND ARRAY ( SELECT id_type FROM rel_instance_of AS r2 WHERE r.id_instance = r2.id_instance ) @> CAST ( ARRAY[ %ARRAY%] AS bigint[] ) ORDER BY id_instance OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_TOPIC_WITHOUT_TYPE "SELECT id FROM topics WHERE id_topicmap = ? AND NOT id IN ( SELECT id_instance FROM rel_instance_of ) ORDER BY id OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_TOPICTYPES "SELECT DISTINCT id_type FROM rel_instance_of, topics WHERE id_topicmap = ? AND id = id_type AND id_instance IN ( SELECT id FROM topics AS t WHERE t.id = id_instance ) ORDER BY id_type OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99InsertQueries
public static final java.lang.String QUERY_CREATE_ASSOCIATION "INSERT INTO associations(id_topicmap, id_parent, id_type) VALUES (?,?,?);"
public static final java.lang.String QUERY_CREATE_ASSOCIATION_WITH_SCOPE "INSERT INTO associations(id_topicmap, id_parent, id_type, id_scope) VALUES (?,?,?,?);"
public static final java.lang.String QUERY_CREATE_LOCATOR "INSERT INTO locators (reference) SELECT ? WHERE NOT EXISTS (SELECT id FROM locators WHERE reference = ?);"
public static final java.lang.String QUERY_CREATE_NAME "INSERT INTO names (id_topicmap, id_parent, id_type, value) VALUES (?,?,?,?);"
public static final java.lang.String QUERY_CREATE_NAME_WITH_SCOPE "INSERT INTO names (id_topicmap, id_parent, id_type, value, id_scope) VALUES (?,?,?,?,?);"
public static final java.lang.String QUERY_CREATE_OCCURRENCE "INSERT INTO locators (reference) SELECT ? WHERE NOT EXISTS (SELECT id FROM locators WHERE reference = ?);INSERT INTO occurrences (id_topicmap, id_parent, id_type, value, id_datatype) SELECT ?,?,?,?, l.id FROM locators AS l WHERE l.reference LIKE ?;"
public static final java.lang.String QUERY_CREATE_OCCURRENCE_WITH_SCOPE "INSERT INTO locators (reference) SELECT ? WHERE NOT EXISTS (SELECT id FROM locators WHERE reference = ?);INSERT INTO occurrences (id_topicmap, id_parent, id_type, value, id_datatype, id_scope) SELECT ?,?,?,?,id,? FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_CREATE_ROLE "INSERT INTO roles(id_topicmap, id_parent, id_type, id_player) VALUES (?,?,?,?)"
public static final java.lang.String QUERY_CREATE_SCOPE "INSERT INTO scopes(id_topicmap) VALUES (?)"
public static final java.lang.String QUERY_CREATE_TOPIC "INSERT INTO topics(id_topicmap, id_parent) VALUES (?,?);"
public static final java.lang.String QUERY_CREATE_TOPICMAP "INSERT INTO locators (reference) SELECT ? WHERE NOT EXISTS (SELECT id FROM locators WHERE reference = ?);INSERT INTO topicmaps (id_base_locator) SELECT id FROM locators WHERE reference = ? AND NOT EXISTS ( SELECT tm.id FROM topicmaps AS tm, locators AS l WHERE l.reference LIKE ? AND l.id = tm.id_base_locator); "
public static final java.lang.String QUERY_CREATE_VARIANT "INSERT INTO locators (reference) SELECT ? WHERE NOT EXISTS (SELECT id FROM locators WHERE reference = ?);INSERT INTO variants (id_topicmap, id_parent, value, id_datatype, id_scope) SELECT ?,?,?,id,? FROM locators WHERE reference LIKE ?;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99Queries
public static final java.lang.String SNIPPET_CREATE_LOCATOR_IF_NOT_EXISTS "INSERT INTO locators (reference) SELECT ? WHERE NOT EXISTS (SELECT id FROM locators WHERE reference = ?);"
public static final java.lang.String SNIPPET_CREATE_TOPIC_IF_SUBJECT_IDENTIFIER_NOT_EXISTS "INSERT INTO topics(id_topicmap,id_parent) SELECT ?,? WHERE NOT EXISTS (SELECT t.id, l.id FROM topics AS t, locators AS l, rel_subject_identifiers as r WHERE reference = ? AND l.id = r.id_locator AND r.id_topic = t.id);"
public static final java.lang.String SNIPPET_CREATE_TOPICMAP_IF_NOT_EXISTS "INSERT INTO topicmaps (id_base_locator) SELECT id FROM locators WHERE reference = ? AND NOT EXISTS ( SELECT tm.id FROM topicmaps AS tm, locators AS l WHERE l.reference LIKE ? AND l.id = tm.id_base_locator); "

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99RevisionQueries
public static final java.lang.String QUERY_CREATE_CHANGESET "INSERT INTO changesets(id_revision,type,id_notifier, newValue, oldValue,time) VALUES(?,?,?,?,?,now())"
public static final java.lang.String QUERY_CREATE_METADATA "INSERT INTO metadata(id_revision, key, value) VALUES (?,?,?);"
public static final java.lang.String QUERY_CREATE_REVISION "INSERT INTO revisions(time, id_topicmap, type) VALUES(now(),?,?)"
public static final java.lang.String QUERY_CREATE_TAG "INSERT INTO tags(tag, time) VALUES (?,?);"
public static final java.lang.String QUERY_MODIFY_METADATA "UPDATE metadata SET value = ? WHERE id_revision = ? AND key = ?;"
public static final java.lang.String QUERY_MODIFY_TAG "UPDATE tags SET time = ? WHERE tag = ?;"
public static final java.lang.String QUERY_READ_CHANGESET "SELECT type, id_notifier, newValue, oldValue FROM changesets WHERE id_revision = ? ORDER BY time;"
public static final java.lang.String QUERY_READ_CHANGESETS_BY_ASSOCIATIONTYPE "WITH ids AS ( SELECT id FROM associations WHERE id_type = ? UNION SELECT id FROM roles WHERE id IN ( SELECT id FROM associations WHERE id_type = ? ) ) SELECT id_revision, type, id_notifier, newValue, oldValue FROM changesets WHERE id_notifier IN ( SELECT id FROM ids ) OR oldValue IN ( SELECT CAST ( id AS character varying ) FROM ids ) OR newValue IN ( SELECT CAST ( id AS character varying ) FROM ids ) ORDER BY time ASC;"
public static final java.lang.String QUERY_READ_CHANGESETS_BY_TOPIC "SELECT id_revision, type, id_notifier, newValue, oldValue FROM changesets WHERE id_notifier = ? OR oldValue = ? OR newValue = ? OR id_notifier IN ( SELECT id FROM constructs WHERE id_parent = ? ) ORDER BY time ASC;"
public static final java.lang.String QUERY_READ_CHANGESETTYPE "SELECT type FROM revisions WHERE id = ?;"
public static final java.lang.String QUERY_READ_FIRST_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? ORDER BY id ASC LIMIT 1;"
public static final java.lang.String QUERY_READ_FUTURE_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? AND id > ? ORDER BY id ASC LIMIT 1;"
public static final java.lang.String QUERY_READ_HISTORY "SELECT * FROM history WHERE id = ?;"
public static final java.lang.String QUERY_READ_LAST_MODIFICATION "SELECT time FROM revisions WHERE id_topicmap = ? ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_LAST_MODIFICATION_OF_TOPIC "SELECT time FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier = ? OR oldValue = ? OR newValue = ? ) ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_LAST_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? ORDER BY id DESC LIMIT 1;"
public static final java.lang.String QUERY_READ_METADATA "SELECT key, value FROM metadata WHERE id_revision = ?;"
public static final java.lang.String QUERY_READ_METADATA_BY_KEY "SELECT value FROM metadata WHERE id_revision = ? AND key = ?;"
public static final java.lang.String QUERY_READ_PAST_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? AND id < ? ORDER BY id DESC LIMIT 1;"
public static final java.lang.String QUERY_READ_REVISION_BY_TAG "SELECT id FROM revisions WHERE id_topicmap = ? AND time <= ( SELECT time FROM tags WHERE tag = ? ) ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_REVISION_BY_TIMESTAMP "SELECT id FROM revisions WHERE id_topicmap = ? AND time <= ? ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_REVISIONS_BY_ASSOCIATIONTYPE "WITH ids AS ( SELECT id FROM associations WHERE id_type = ? UNION SELECT id FROM roles WHERE id IN ( SELECT id FROM associations WHERE id_type = ? ) ) SELECT id FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier IN ( SELECT id FROM ids ) OR oldValue IN ( SELECT CAST ( id AS character varying ) FROM ids ) OR newValue IN ( SELECT CAST ( id AS character varying ) FROM ids ) ) ORDER BY time ASC ;"
public static final java.lang.String QUERY_READ_REVISIONS_BY_TOPIC "SELECT id FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier = ? OR oldValue = ? OR newValue = ? OR id_notifier IN ( SELECT id FROM constructs WHERE id_parent = ? ) ) ORDER BY time ASC ;"
public static final java.lang.String QUERY_READ_TIMESTAMP "SELECT time FROM revisions WHERE id = ?;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99SelectQueries.NonPaged
public static final java.lang.String QUERY_READ_ASSOCIATIONS "SELECT id FROM associations WHERE id_topicmap = ? "
public static final java.lang.String QUERY_READ_ASSOCIATIONS_WITH_TYPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ? "
public static final java.lang.String QUERY_READ_ASSOCIATIONS_WITH_TYPE_AND_SCOPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ? AND id_scope = ? "
public static final java.lang.String QUERY_READ_CONSTRUCT "WITH iis AS ( SELECT id FROM constructs WHERE id = ? )SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id FROM iis ) UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id FROM iis ) UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id FROM iis ) UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id FROM iis ) UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id FROM iis ) AND v.id_parent = n.id UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id FROM iis ) UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id FROM iis );"
public static final java.lang.String QUERY_READ_CONSTRUCT_BY_ITEM_IDENTIFIER "WITH iis AS ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? )SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id_construct FROM iis )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id_construct FROM iis ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id_construct FROM iis ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id_construct FROM iis );"
public static final java.lang.String QUERY_READ_DATATYPE "SELECT l.id, reference FROM locators AS l, datatypeawares AS d WHERE d.id_datatype = l.id AND d.id = ?"
public static final java.lang.String QUERY_READ_EMPTY_SCOPE "SELECT id FROM scopes WHERE id NOT IN ( SELECT DISTINCT id_scope FROM rel_themes ) AND id_topicmap = ?"
public static final java.lang.String QUERY_READ_ITEM_IDENTIFIERS "SELECT l.id,reference FROM locators AS l, rel_item_identifiers AS r WHERE r.id_construct = ? AND r.id_locator = l.id"
public static final java.lang.String QUERY_READ_LOCATORS "SELECT l.id , reference FROM topicmaps AS tm, locators AS l WHERE id_base_locator = l.id"
public static final java.lang.String QUERY_READ_NAMES "SELECT id FROM names WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_NAMES_WITH_SCOPE "SELECT id FROM names WHERE id_parent = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_NAMES_WITH_TYPE "SELECT id FROM names WHERE id_parent = ? AND id_type = ?"
public static final java.lang.String QUERY_READ_NAMES_WITH_TYPE_AND_SCOPE "SELECT id FROM names WHERE id_parent = ? AND id_type = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES "SELECT id FROM occurrences WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES_WITH_SCOPE "SELECT id FROM occurrences WHERE id_parent = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES_WITH_TYPE "SELECT id FROM occurrences WHERE id_parent = ? AND id_type = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES_WITH_TYPE_AND_SCOPE "SELECT id FROM occurrences WHERE id_parent = ? AND id_type = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_SCOPE "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id AND a.id_scope = ?"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id AND a.id_type = ?"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE_AND_SCOPE "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id AND a.id_type = ? AND a.id_scope = ?"
public static final java.lang.String QUERY_READ_PLAYED_ROLES "SELECT id, id_parent FROM roles WHERE id_player = ? "
public static final java.lang.String QUERY_READ_PLAYED_ROLES_WITH_TYPE "SELECT id, id_parent FROM roles WHERE id_player = ? AND id_type = ? "
public static final java.lang.String QUERY_READ_PLAYED_ROLES_WITH_TYPE_AND_ASSOTYPE "SELECT r.id, r.id_parent FROM roles AS r, associations AS a WHERE r.id_player = ? AND r.id_type = ? AND r.id_parent = a.id AND a.id_type = ? "
public static final java.lang.String QUERY_READ_PLAYER "SELECT id_player FROM roles WHERE id = ?"
public static final java.lang.String QUERY_READ_REIFIED "WITH ids AS ( SELECT id FROM reifiables WHERE id_reifier = ? )SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id FROM ids ) UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id FROM ids ) UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id FROM ids ) UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id FROM ids ) AND v.id_parent = n.id UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id FROM ids ) UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id FROM ids );"
public static final java.lang.String QUERY_READ_REIFIER "SELECT id_reifier FROM reifiables WHERE id = ?"
public static final java.lang.String QUERY_READ_ROLES "SELECT id FROM roles WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_ROLES_WITH_TYPE "SELECT id FROM roles WHERE id_parent = ? AND id_type = ? "
public static final java.lang.String QUERY_READ_ROLESTYPES "SELECT DISTINCT id_type FROM roles WHERE id_parent = ? "
public static final java.lang.String QUERY_READ_SCOPE "SELECT DISTINCT id_scope FROM scopeables WHERE id = ?"
public static final java.lang.String QUERY_READ_SCOPES_BY_THEME "SELECT DISTINCT id_scope FROM rel_themes AS r WHERE id_theme = ? AND ? IN ( SELECT count ( id_theme ) FROM rel_themes WHERE id_scope = r.id_scope );"
public static final java.lang.String QUERY_READ_SCOPES_BY_THEMES "SELECT DISTINCT id_scope FROM rel_themes AS r WHERE ( SELECT ARRAY( SELECT id_theme FROM rel_themes WHERE id_scope = r.id_scope ) ) @> ? AND ? IN ( SELECT count( id_theme ) FROM rel_themes WHERE id_scope = r.id_scope );"
public static final java.lang.String QUERY_READ_SUBJECT_IDENTIFIERS "SELECT l.id,reference FROM locators AS l, rel_subject_identifiers AS r, topics AS t WHERE r.id_topic = ? AND r.id_locator = l.id AND t.id = r.id_topic"
public static final java.lang.String QUERY_READ_SUBJECT_LOCATORS "SELECT l.id,reference FROM locators AS l, rel_subject_locators AS r , topics AS t WHERE r.id_topic = ? AND r.id_locator = l.id AND t.id = r.id_topic"
public static final java.lang.String QUERY_READ_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of WHERE id_subtype = ?"
public static final java.lang.String QUERY_READ_THEMES "SELECT DISTINCT id_theme FROM rel_themes WHERE id_scope = ?"
public static final java.lang.String QUERY_READ_TOPIC_BY_SUBJECT_IDENTIFIER " SELECT t.id FROM topics AS t, locators AS l, rel_subject_identifiers as r WHERE id_topicmap = ? AND reference = ? AND l.id = r.id_locator AND r.id_topic = t.id;"
public static final java.lang.String QUERY_READ_TOPIC_BY_SUBJECT_LOCATOR " SELECT t.id FROM topics AS t, locators AS l, rel_subject_locators as r WHERE id_topicmap = ? AND reference = ? AND l.id = r.id_locator AND r.id_topic = t.id;"
public static final java.lang.String QUERY_READ_TOPICMAP "SELECT tm.id FROM topicmaps AS tm, locators AS l WHERE l.reference = ? AND l.id = tm.id_base_locator;"
public static final java.lang.String QUERY_READ_TOPICS "SELECT id FROM topics WHERE id_topicmap = ?"
public static final java.lang.String QUERY_READ_TOPICS_WITH_TYPE "SELECT id_instance FROM rel_instance_of AS r, topics AS t WHERE id_instance = t.id AND id_type IN ( SELECT id FROM topics WHERE id = ? )"
public static final java.lang.String QUERY_READ_TYPE "SELECT id_type FROM typeables WHERE id = ?"
public static final java.lang.String QUERY_READ_TYPES "SELECT id_type FROM rel_instance_of WHERE id_instance = ?"
public static final java.lang.String QUERY_READ_VALUE "SELECT DISTINCT value FROM literals WHERE id = ?"
public static final java.lang.String QUERY_READ_VARIANTS "SELECT id FROM variants WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_VARIANTS_WITH_SCOPE "SELECT id FROM variants WHERE id_parent = ? AND id_scope = ?"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99SelectQueries.Paged
public static final java.lang.String QUERY_READ_NAMES "SELECT id FROM names WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_NAMES "SELECT COUNT(id) AS number FROM names WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_OCCURRENCES "SELECT COUNT(id) AS number FROM occurrences WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_PLAYED_ASSOCIATIONS "SELECT DISTINCT COUNT(a.id) AS number FROM associations AS a, roles AS r WHERE r.id_player = ? AND r.id_parent = a.id;"
public static final java.lang.String QUERY_READ_NUMBER_OF_PLAYED_ROLES "SELECT COUNT(id) AS number FROM roles WHERE id_player = ?"
public static final java.lang.String QUERY_READ_NUMBER_OF_ROLES "SELECT COUNT(id) AS number FROM roles WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_TYPES "SELECT COUNT(id_type) AS number FROM rel_instance_of WHERE id_instance = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_VARIANTS "SELECT COUNT(id) AS number FROM variants WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_OCCURRENCES "SELECT id FROM occurrences WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id ORDER BY a.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_PLAYED_ROLES "SELECT id, id_parent FROM roles WHERE id_player = ? ORDER BY id OFFSET ? LIMIT ?"
public static final java.lang.String QUERY_READ_ROLES "SELECT id FROM roles WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_TYPES "SELECT id_type FROM rel_instance_of WHERE id_instance = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_VARIANTS "SELECT id FROM variants WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99UpdateQueries
public static final java.lang.String QUERY_ADD_ITEM_IDENTIFIER "INSERT INTO locators (reference) SELECT ? WHERE NOT EXISTS (SELECT id FROM locators WHERE reference = ?);INSERT INTO rel_item_identifiers(id_construct, id_locator) SELECT ? , id FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_ADD_SUBJECT_IDENTIFIER "INSERT INTO locators (reference) SELECT ? WHERE NOT EXISTS (SELECT id FROM locators WHERE reference = ?);INSERT INTO rel_subject_identifiers(id_topic, id_locator) SELECT ? , id FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_ADD_SUBJECT_LOCATOR "INSERT INTO locators (reference) SELECT ? WHERE NOT EXISTS (SELECT id FROM locators WHERE reference = ?);INSERT INTO rel_subject_locators(id_topic, id_locator) SELECT ? , id FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_ADD_THEME "INSERT INTO rel_themes(id_scope, id_theme) VALUES (?,?);"
public static final java.lang.String QUERY_MODIFY_PLAYER "UPDATE roles SET id_player = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_REIFIER "UPDATE reifiables SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_SCOPE "UPDATE scopeables SET id_scope = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_SUPERTYPES "INSERT INTO rel_kind_of(id_subtype, id_supertype) SELECT ?,? WHERE NOT EXISTS ( SELECT id_subtype, id_supertype FROM rel_kind_of WHERE id_subtype = ? AND id_supertype = ? );"
public static final java.lang.String QUERY_MODIFY_TYPE "UPDATE typeables SET id_type = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_TYPES "INSERT INTO rel_instance_of(id_instance, id_type) SELECT ?,? WHERE NOT EXISTS ( SELECT id_instance, id_type FROM rel_instance_of WHERE id_instance = ? AND id_type = ? );"
public static final java.lang.String QUERY_MODIFY_VALUE "UPDATE literals SET value = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_VALUE_WITH_DATATYPE "UPDATE literals SET value = ? WHERE id = ?;INSERT INTO locators (reference) SELECT ? WHERE NOT EXISTS (SELECT id FROM locators WHERE reference = ?);UPDATE datatypeawares SET id_datatype = ( SELECT id FROM locators WHERE reference LIKE ? ) WHERE id = ?;"

de.topicmapslab.majortom.database.jdbc.postgres.sql99.query.ISql99UpdateQueries.QueryMerge
public static final java.lang.String QUERY_MERGE_TOPIC "UPDATE rel_kind_of SET id_subtype = ? WHERE id_subtype = ?;UPDATE rel_kind_of SET id_supertype = ? WHERE id_supertype = ?;UPDATE rel_instance_of SET id_instance = ? WHERE id_instance = ?;UPDATE rel_instance_of SET id_type = ? WHERE id_type = ?;UPDATE rel_themes SET id_theme = ? WHERE id_theme = ?;UPDATE typeables SET id_type = ? WHERE id_type = ?;UPDATE reifiables SET id_reifier = ? WHERE id_reifier = ?;UPDATE rel_item_identifiers SET id_construct = ? WHERE id_construct = ?;UPDATE rel_subject_identifiers SET id_topic = ? WHERE id_topic = ?;UPDATE rel_subject_locators SET id_topic = ? WHERE id_topic = ?;UPDATE roles SET id_player = ? WHERE id_player = ?;UPDATE constructs SET id_parent = ? WHERE id_parent = ?;DELETE FROM topics WHERE id = ?;"

de.topicmapslab.majortom.database.jdbc.rdbms.RDBMSQueryProcessor
private static final java.lang.String ID_PREFIX "id:"
private static final java.lang.String ITEMIDENTIFIER_PREFIX "ii:"
private static final java.lang.String SUBJECTIDENTIFIER_PREFIX "si:"
private static final java.lang.String SUBJECTLOCATOR_PREFIX "sl:"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IConstraintsQueries
public static final java.lang.String QUERY_DUPLICATE_ASSOCIATIONS "SELECT DISTINCT a.id, a.id_reifier FROM roles AS r, associations AS a WHERE NOT EXISTS ( SELECT id_type, id_player FROM roles as r2 WHERE r2.id_parent = r.id_parent EXCEPT SELECT id_type, id_player FROM roles AS r3 WHERE r3.id_parent = ? ) AND r.id_parent <> ? AND r.id_parent = a.id AND a.id_type = ? AND a.id_scope = ?;"
public static final java.lang.String QUERY_DUPLICATE_NAME "SELECT id, id_parent FROM names WHERE id_parent = ? AND id <> ? AND id_type = ? AND value = ? AND id_scope = ?"
public static final java.lang.String QUERY_DUPLICATE_OCCURRENCE "SELECT id, id_parent FROM occurrences WHERE id_parent = ? AND id <> ? AND id_type = ? AND value = ? AND id_datatype IN ( SELECT id FROM locators WHERE reference = ? ) AND id_scope = ?"
public static final java.lang.String QUERY_DUPLICATE_ROLES "SELECT id FROM roles WHERE id_parent = ? AND id_type = ? AND id_player = ?;"
public static final java.lang.String QUERY_DUPLICATE_VARIANTS "SELECT id, id_parent FROM variants WHERE id_parent = ? AND id <> ? AND value = ? AND id_datatype IN ( SELECT id FROM locators WHERE reference = ? ) AND id_scope = ?"
public static final java.lang.String QUERY_MOVE_ITEM_IDENTIFIERS "UPDATE rel_item_identifiers SET id_construct = ? WHERE id_construct = ?;"
public static final java.lang.String QUERY_MOVE_VARIANTS "UPDATE variants SET id_parent = ? WHERE id_parent = ?;"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IDeleteQueries
public static final java.lang.String QUERY_CLEAR_TOPICMAP "DELETE FROM constructs WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_DELETE_ALL_HISTORYENTRIES "DELETE FROM history WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_DELETE_ALL_ITEM_IDENTIFIERS "DELETE FROM rel_item_identifiers WHERE id_construct IN ( SELECT id_construct FROM (SELECT id AS id_construct FROM topics WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_construct FROM associations WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_construct FROM roles WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_construct FROM occurrences WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_construct FROM names WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_construct FROM scopes WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_construct FROM variants WHERE id_topicmap = ? OR id = ? );"
public static final java.lang.String QUERY_DELETE_ALL_REVISIONS "DELETE FROM revisions WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_DELETE_ALL_SCOPE "DELETE FROM scopes WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_DELETE_ALL_THEMES "DELETE FROM rel_themes WHERE id_scope IN ( SELECT id FROM scopes WHERE id_topicmap = ?);"
public static final java.lang.String QUERY_DELETE_ASSOCIATION "DELETE FROM associations WHERE id = ?; "
public static final java.lang.String QUERY_DELETE_HISTORY "DELETE FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier IN ( SELECT id AS id_notifier FROM topics WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_notifier FROM associations WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_notifier FROM roles WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_notifier FROM occurrences WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_notifier FROM names WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_notifier FROM scopes WHERE id_topicmap = ? OR id = ? UNION SELECT id AS id_notifier FROM variants WHERE id_topicmap = ? OR id = ? ) OR id_notifier = ? );"
public static final java.lang.String QUERY_DELETE_ITEM_IDENTIFIER "DELETE FROM rel_item_identifiers WHERE id_construct = ? and id_locator = ( SELECT id FROM locators WHERE reference = ? )"
public static final java.lang.String QUERY_DELETE_NAME "DELETE FROM names WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_OCCURRENCE "DELETE FROM occurrences WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_ROLE "DELETE FROM roles WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_SCOPE "DELETE FROM scopes WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_SUBJECT_IDENTIFIER "DELETE FROM rel_subject_identifiers WHERE id_topic = ? and id_locator = ( SELECT id FROM locators WHERE reference = ? )"
public static final java.lang.String QUERY_DELETE_SUBJECT_LOCATOR "DELETE FROM rel_subject_locators WHERE id_topic = ? and id_locator = ( SELECT id FROM locators WHERE reference = ? )"
public static final java.lang.String QUERY_DELETE_SUPERTYPE "DELETE FROM rel_kind_of WHERE id_subtype = ? AND id_supertype = ?;"
public static final java.lang.String QUERY_DELETE_THEMES_OF_SCOPE "DELETE FROM rel_themes WHERE id_scope = ?;"
public static final java.lang.String QUERY_DELETE_TOPIC "DELETE FROM topics WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_TOPICMAP "DELETE FROM topicmaps WHERE id = ?;"
public static final java.lang.String QUERY_DELETE_TYPE "DELETE FROM rel_instance_of WHERE id_instance = ? AND id_type = ?;"
public static final java.lang.String QUERY_DELETE_VARIANT "DELETE FROM variants WHERE id = ?;"
public static final java.lang.String QUERY_UNSET_TOPICMAP_REIFIER "UPDATE topicmaps SET id_reifier = NULL WHERE id = ?;"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IDumpQueries
public static final java.lang.String QUERY_DUMP_ASSOCIATION "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_scope, themes, roles, type) SELECT id_topicmap, ?, id, id_parent, ?, id_type, id_reifier, id_scope, ?, ?, \'a\' FROM associations AS a WHERE id = ?;"
public static final java.lang.String QUERY_DUMP_ASSOCIATION_INSERT_INTO_HISTORY "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_scope, themes, roles, type) VALUES(?,?,?,?,?,?,?,?,?,?,\'t\')"
public static final java.lang.String QUERY_DUMP_ASSOCIATION_SELECT "SELECT id_topicmap, id, id_parent, id_type, id_reifier, id_scope FROM associations WHERE id = ?;"
public static final java.lang.String QUERY_DUMP_NAME "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, variants, id_reification, id_scope, themes, value, type) SELECT id_topicmap, ?, id, id_parent, ?, id_type, ?, id_reifier, id_scope, ?, value, \'n\' FROM names AS n WHERE id = ?"
public static final java.lang.String QUERY_DUMP_NAME_INSERT_INTO_HISTORY "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, variants, id_reification, id_scope, themes, value, type) VALUES(?,?,?,?,?,?,?,?,?,?,?,\'n\')"
public static final java.lang.String QUERY_DUMP_NAME_SELECT "SELECT id_topicmap, id, id_parent, id_type, id_reifier, id_scope, value FROM names AS n WHERE id = ?"
public static final java.lang.String QUERY_DUMP_OCCURRENCE "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_scope, themes, value, datatype, type) SELECT id_topicmap, ?, id, id_parent, ?,id_type, id_reifier, id_scope, ?,value, (SELECT reference FROM locators WHERE id = ?),\'o\' FROM occurrences AS o WHERE id = ?"
public static final java.lang.String QUERY_DUMP_OCCURRENCE_INSERT_INTO_HISTORY "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_scope, themes, value, datatype, type) VALUES(?,?,?,?,?,?,?,?,?,?,(SELECT reference FROM locators WHERE id = ?),\'o\')"
public static final java.lang.String QUERY_DUMP_OCCURRENCE_SELECT "SELECT id_topicmap, id, id_parent, id_type, id_reifier, id_scope, value FROM occurrences WHERE id = ?"
public static final java.lang.String QUERY_DUMP_ROLE "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_player, type) SELECT id_topicmap, ?, id, id_parent, ?, id_type, id_reifier, id_player, \'r\' FROM roles AS r WHERE id = ?"
public static final java.lang.String QUERY_DUMP_ROLE_INSERT_INTO_HISTORY "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, types, id_reification, id_player, type) VALUES(?,?,?,?,?,?,?,?,\'r\')"
public static final java.lang.String QUERY_DUMP_ROLE_SELECT "SELECT id_topicmap, id, id_parent, id_type, id_reifier, id_player FROM roles WHERE id = ?"
public static final java.lang.String QUERY_DUMP_TOPIC "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, subjectidentifiers, subjectlocators, types, supertypes, names, occurrences, associations, id_reification, type, bestlabel) SELECT id_topicmap, ?, id, id_parent, ?,?,?,?,?,?,?,?,?,\'t\', ? FROM topics AS t WHERE id = ?"
public static final java.lang.String QUERY_DUMP_TOPIC_INSERT_INTO_HISTORY "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, subjectidentifiers, subjectlocators, types, supertypes, names, occurrences, associations, id_reification, type, bestlabel, bestidentifier) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,\'t\',?,?)"
public static final java.lang.String QUERY_DUMP_TOPIC_SELECT "SELECT id_topicmap, id, id_parent FROM topics WHERE id = ?"
public static final java.lang.String QUERY_DUMP_VARIANT "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, id_reification, id_scope,themes, datatype, value, type) SELECT id_topicmap, ?, id, id_parent, ?, id_reifier, id_scope, ?, (SELECT reference FROM locators WHERE id = ?), value, \'v\' FROM variants AS v WHERE id = ?"
public static final java.lang.String QUERY_DUMP_VARIANT_INSERT_INTO_HISTORY "INSERT INTO history(id_topicmap, id_revision, id, id_parent, itemidentifiers, id_reification, id_scope,themes, datatype, value, type) VALUES(?,?,?,?,?,?,?,?,(SELECT reference FROM locators WHERE id = ?),?,\'v\')"
public static final java.lang.String QUERY_DUMP_VARIANT_SELECT "SELECT id_topicmap, id, id_parent, id_reifier, id_scope, value FROM variants WHERE id = ?"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IIndexQueries.QueryIdentityIndex.NonPaged
public static final java.lang.String QUERY_SELECT_CONSTRUCT_IDENTIFIERS_BY_PATTERN "WITH locs AS ( SELECT id FROM locators WHERE REGEXP_MATCHES(reference, ?) ) SELECT id FROM ( SELECT id_construct AS id FROM rel_item_identifiers WHERE id_locator IN ( SELECT id FROM locs ) UNION SELECT id_topic AS id FROM rel_subject_locators WHERE id_locator IN ( SELECT id FROM locs ) UNION SELECT id_topic AS id FROM rel_subject_identifiers WHERE id_locator IN ( SELECT id FROM locs ));"
public static final java.lang.String QUERY_SELECT_CONSTRUCT_ITEM_IDENTIFIER_BY_PATTERN "SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND REGEXP_MATCHES(reference, ?) ;"
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_IDENTIFIER_PATTERN "SELECT DISTINCT r.id, r.id_parent, r.other, r.type FROM (SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( UNNEST(?) )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( UNNEST(?) ) AND v.id_parent = n.id AND v.id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( UNNEST(?) ) ) AS r;"
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_ITEM_IDENTIFIER_PATTERN "SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( UNNEST(?) )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( UNNEST(?) ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( UNNEST(?) );"
public static final java.lang.String QUERY_SELECT_ITEM_IDENTIFIERS "WITH constructs(id, id_topicmap) AS (SELECT id, id_topicmap FROM topicmaps UNION SELECT id, id_topicmap FROM topics UNION SELECT id, id_topicmap FROM associations UNION SELECT id, id_topicmap FROM roles UNION SELECT id, id_topicmap FROM occurrences UNION SELECT id, id_topicmap FROM names UNION SELECT id, id_topicmap FROM variants UNION SELECT id, id_topicmap FROM scopes ) SELECT l.id,l.reference FROM locators AS l, rel_item_identifiers, constructs AS c WHERE ( c.id_topicmap = ? OR c.id = ? ) AND l.id = id_locator AND c.id = id_construct;"
public static final java.lang.String QUERY_SELECT_SUBJECT_IDENTIFIERS "SELECT l.id,l.reference FROM locators AS l, rel_subject_identifiers, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ;"
public static final java.lang.String QUERY_SELECT_SUBJECT_LOCATORS "SELECT l.id,l.reference FROM locators AS l, rel_subject_locators, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_IDENTIFIER_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_identifiers, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND REGEXP_MATCHES(reference, ?);"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_LOCATOR_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_locators, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND REGEXP_MATCHES(reference, ?);"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IIndexQueries.QueryIdentityIndex.Paged
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_IDENTIFIER_PATTERN "SELECT DISTINCT r.id, r.id_parent, r.other, r.type FROM (SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( UNNEST(?) )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN (UNNEST(?) ) AND v.id_parent = n.id AND v.id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( UNNEST(?) ) ) AS r ORDER BY r.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CONSTRUCTS_BY_ITEM_IDENTIFIER_PATTERN "SELECT r.id, r.id_parent, r.other, r.type FROM (SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( UNNEST(?) )AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( UNNEST(?) ) AND v.id_parent = n.id AND v.id_topicmap = ?UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( UNNEST(?) ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( UNNEST(?) ) ) AS r ORDER BY r.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ITEM_IDENTIFIERS "WITH constructs(id, id_topicmap) AS (SELECT id, id_topicmap FROM topicmaps UNION SELECT id, id_topicmap FROM topics UNION SELECT id, id_topicmap FROM associations UNION SELECT id, id_topicmap FROM roles UNION SELECT id, id_topicmap FROM occurrences UNION SELECT id, id_topicmap FROM names UNION SELECT id, id_topicmap FROM variants UNION SELECT id, id_topicmap FROM scopes ) SELECT l.id,l.reference FROM locators AS l, rel_item_identifiers, constructs AS c WHERE ( c.id_topicmap = ? OR c.id = ? ) AND l.id = id_locator AND c.id = id_construct ORDER BY l.reference OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_SUBJECT_IDENTIFIERS "SELECT l.id,l.reference FROM locators AS l, rel_subject_identifiers, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ORDER BY l.reference OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_SUBJECT_LOCATORS "SELECT l.id,l.reference FROM locators AS l, rel_subject_locators, topics AS t WHERE t.id_topicmap = ? AND l.id = id_locator AND t.id = id_topic ORDER BY l.reference OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_IDENTIFIER_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_identifiers, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND REGEXP_MATCHES(reference, ?) ORDER BY id_topic OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_BY_SUBJECT_LOCATOR_PATTERN "SELECT id_topic FROM topics AS t, rel_subject_locators, locators AS l WHERE t.id_topicmap = ? AND id_topic = t.id AND l.id = id_locator AND REGEXP_MATCHES(reference, ?) ORDER BY id_topic OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IIndexQueries.QueryLiteralIndex.NonPaged
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS "SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value = ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_DATATYPE "SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP "SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?) UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?);"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP_AND_DATATYPE "SELECT o.id, id_parent, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?) AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?);"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_VALUE "SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_topicmap = ? AND value = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_topicmap = ? AND value = ?;"
public static final java.lang.String QUERY_SELECT_DATATYPEAWARES_BY_DATATYPE "SELECT o.id, id_parent, NULL AS other, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT v.id, v.id_parent, n.id_parent AS other, \'v\' AS type FROM variants AS v, locators AS l, names AS n WHERE v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? AND n.id = v.id_parent;"
public static final java.lang.String QUERY_SELECT_NAMES "SELECT id, id_parent FROM names WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_REGEXP "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?);"
public static final java.lang.String QUERY_SELECT_NAMES_BY_VALUE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND ILIKE(value, ?) ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATERANGE "SELECT o.id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND ? <= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id ) AND ? >= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id );"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_RANGE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? AND CAST ( value AS double precision ) BETWEEN ? AND ? "
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?);"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?) AND o.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND ILIKE(value, ?) ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND ILIKE(value, ?) AND o.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND REGEXP_MATCHES(v.value, ?) ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND REGEXP_MATCHES(v.value, ?) AND v.id_datatype = l.id AND l.reference = ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ILIKE(v.value, ?) ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ILIKE(v.value, ?) AND v.id_datatype = l.id AND l.reference = ? ;"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IIndexQueries.QueryLiteralIndex.Paged
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS "SELECT r.id, r.id_parent, r.type FROM ( SELECT o.id, id_parent, value, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND value = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, value, \'n\' AS type FROM names WHERE id_topicmap = ? AND value = ?) AS r ORDER BY value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_DATATYPE "SELECT r.id, r.id_parent, r.type FROM ( SELECT o.id, id_parent, value, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, value, \'n\' AS type FROM names WHERE id_topicmap = ?) AS r ORDER BY value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP "SELECT r.id, r.id_parent, r.type FROM ( SELECT id, id_parent, value, \'o\' AS type FROM occurrences WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?) UNION SELECT id, id_parent, value, \'n\' AS type FROM names WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?) ) AS r ORDER BY value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_REGEXP_AND_DATATYPE "SELECT r.id, r.id_parent, r.type FROM ( SELECT o.id, id_parent, value, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?) AND o.id_datatype = l.id AND l.reference = ? UNION SELECT id, id_parent, value, \'n\' AS type FROM names WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?)) AS r ORDER BY value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_VALUE "SELECT r.id, r.id_parent, r.type FROM ( SELECT id, id_parent, value, \'o\' AS type FROM occurrences WHERE id_topicmap = ? AND value = ? UNION SELECT id, id_parent, value, \'n\' AS type FROM names WHERE id_topicmap = ? AND value = ? ) AS r ORDER BY value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_DATATYPEAWARES_BY_DATATYPE "SELECT r.id, r.id_parent, r.other, r.type FROM ( SELECT o.id, id_parent, value, NULL AS other, \'o\' AS type FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? UNION SELECT v.id, v.id_parent, v.value, n.id_parent AS other, \'v\' AS type FROM variants AS v, locators AS l, names AS n WHERE v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? AND n.id = v.id_parent) AS r ORDER BY value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES "SELECT id, id_parent FROM names WHERE id_topicmap = ? ORDER BY value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_REGEXP "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?) ORDER BY value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_VALUE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND ILIKE(value, ?) ORDER BY value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? ORDER BY value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? ORDER BY o.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_DATERANGE "SELECT o.id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND ? <= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id ) AND ? >= ( SELECT CASE WHEN ( o2.id = o.id AND o2.id_datatype = l2.id AND ( l2.reference = \'http://www.w3.org/2001/XMLSchema#dateTime\' OR l2.reference = \'http://www.w3.org/2001/XMLSchema#date\' ) ) THEN ( CAST( value AS timestamp with time zone )) ELSE NULL END FROM occurrences AS o2, locators AS l2 WHERE o.id = o2.id AND o2.id_datatype = l2.id ) ORDER BY o.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_RANGE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND o.id_datatype = l.id AND l.reference = ? AND CAST ( value AS double precision ) BETWEEN ? AND ? ORDER BY o.value OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?) ORDER BY value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_REGEXP_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND REGEXP_MATCHES(value, ?) AND o.id_datatype = l.id AND l.reference = ? ORDER BY o.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND ILIKE(value, ?) ORDER BY value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_VALUE_AND_DATATYPE "SELECT o.id, id_parent FROM occurrences AS o, locators AS l WHERE id_topicmap = ? AND ILIKE(value, ?) AND o.id_datatype = l.id AND l.reference = ? ORDER BY o.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? ORDER BY v.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_datatype = l.id AND l.reference = ? ORDER BY v.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND REGEXP_MATCHES(v.value, ?) ORDER BY v.value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_REGEXP_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND REGEXP_MATCHES(v.value, ?) ? AND v.id_datatype = l.id AND l.reference = ? ORDER BY v.value OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ILIKE(v.value, ?) ORDER BY v.value OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_VALUE_AND_DATATYPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n, locators AS l WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ILIKE(v.value, ?) AND v.id_datatype = l.id AND l.reference = ? ORDER BY v.value OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IIndexQueries.QueryScopeIndex.NonPaged
public static final java.lang.String QUERY_SELECT_ASSOCIATION_SCOPES "SELECT id_scope FROM associations WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATION_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM associations WHERE id_topicmap = ? );"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope = ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( UNNEST ( ? ));"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEME "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES "SELECT id FROM associations AS a WHERE id_topicmap = ? AND CONTAINS_ANY(?, ARRAY(SELECT id_theme FROM rel_themes WHERE id_scope = a.id_scope)); "
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES_MATCH_ALL "SELECT id FROM associations AS a WHERE id_topicmap = ? AND IS_SUBSET(?, ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = a.id_scope )); "
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_SCOPE "SELECT id, id_parent, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_scope = ? ;"
public static final java.lang.String QUERY_SELECT_NAME_SCOPES "SELECT id_scope FROM names WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_NAME_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? );"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope = ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( UNNEST ( ? ));"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEME "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? );"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND CONTAINS_ANY(?, ARRAY(SELECT id_theme FROM rel_themes WHERE id_scope = n.id_scope));"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND IS_SUBSET(?, ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope )); "
public static final java.lang.String QUERY_SELECT_OCCURRENCE_SCOPES "SELECT id_scope FROM occurrences WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCE_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM occurrences WHERE id_topicmap = ? );"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope = ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( UNNEST ( ? ));"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEME "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? );"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND CONTAINS_ANY(?, ARRAY(SELECT id_theme FROM rel_themes WHERE id_scope = o.id_scope));"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND IS_SUBSET(?, ARRAY ( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = o.id_scope )); "
public static final java.lang.String QUERY_SELECT_SCOPABLES "SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id_scope = ? UNION SELECT v.id, v.id_parent, n.id_parent AS other, \'v\' AS type FROM variants AS v, names AS n WHERE v.id_scope = ? AND n.id = v.id_parent;"
public static final java.lang.String QUERY_SELECT_SCOPES_BY_THEMES_USED "SELECT r.id_scope FROM rel_themes AS r, scopeables AS s, constructs AS c WHERE id_theme = ? AND r.id_scope = s.id_scope AND c.id = s.id;"
public static final java.lang.String QUERY_SELECT_VARIANT_SCOPES "SELECT id_scope FROM variants WHERE id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_VARIANT_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM variants WHERE id_topicmap = ? ) OR id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? AND id IN ( SELECT id_parent FROM variants ));"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope = ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope IN ( UNNEST ( ? ));"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEME "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( v.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) OR n.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ));"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND CONTAINS_ANY(?, ARRAY(SELECT id_theme FROM rel_themes WHERE id_scope = v.id_scope) || ARRAY(SELECT id_theme FROM rel_themes WHERE id_scope = n.id_scope)); "
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES_MATCH_ALL "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( IS_SUBSET(?, ARRAY(SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope ) || ARRAY( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = v.id_scope )) ); "

de.topicmapslab.majortom.database.jdbc.rdbms.query.IIndexQueries.QueryScopeIndex.Paged
public static final java.lang.String QUERY_SELECT_ASSOCIATION_SCOPES "SELECT id_scope FROM associations WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATION_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM associations WHERE id_topicmap = ? ) ORDER BY id_theme OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_SCOPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( UNNEST ( ? )) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEME "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES "SELECT id FROM associations AS a WHERE id_topicmap = ? AND CONTAINS_ANY(?, ARRAY(SELECT id_theme FROM rel_themes WHERE id_scope = a.id_scope)) ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_THEMES_MATCH_ALL "SELECT id FROM associations AS a WHERE id_topicmap = ? AND (IS_SUBSET(?, ARRAY( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = a.id_scope ))) ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_SCOPE "SELECT r.id, r.id_parent, r.type FROM ( SELECT id, id_parent, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_scope = ? ) AS r ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAME_SCOPES "SELECT id_scope FROM names WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAME_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? ) ORDER BY id_theme OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_SCOPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( UNNEST ( ? )) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEME "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND CONTAINS_ANY(?, ARRAY(SELECT id_theme FROM rel_themes WHERE id_scope = n.id_scope)) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM names AS n WHERE id_topicmap = ? AND ( IS_SUBSET(?, ARRAY( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope ))) ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_OCCURRENCE_SCOPES "SELECT id_scope FROM occurrences WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCE_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM occurrences WHERE id_topicmap = ? ) ORDER BY id_theme OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_SCOPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( UNNEST ( ? )) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEME "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND CONTAINS_ANY(?, ARRAY(SELECT id_theme FROM rel_themes WHERE id_scope = o.id_scope)) ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_THEMES_MATCH_ALL "SELECT id, id_parent FROM occurrences AS o WHERE id_topicmap = ? AND (IS_SUBSET(?, ARRAY( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = o.id_scope ))) ORDER BY id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_SCOPABLES "SELECT r.id, r.id_parent, r.other, r.type FROM ( SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id_scope = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id_scope = ? UNION SELECT v.id, v.id_parent, n.id_parent AS other, \'v\' AS type FROM variants AS v, names AS n WHERE v.id_scope = ? AND n.id = v.id_parent ) AS r ORDER BY r.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANT_SCOPES "SELECT id_scope FROM variants WHERE id_topicmap = ? ORDER BY id_scope OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANT_THEMES "SELECT id_theme FROM rel_themes WHERE id_scope IN ( SELECT id_scope FROM variants WHERE id_topicmap = ? ) OR id_scope IN ( SELECT id_scope FROM names WHERE id_topicmap = ? AND id IN ( SELECT id_parent FROM variants )) ORDER BY id_theme OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPE "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope = ? ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_SCOPES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id_scope IN ( UNNEST ( ? )) ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEME "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( v.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? ) OR n.id_scope IN ( SELECT id_scope FROM rel_themes WHERE id_theme = ? )) ORDER BY v.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND CONTAINS_ANY(?, ARRAY(SELECT id_theme FROM rel_themes WHERE id_scope = v.id_scope) || ARRAY(SELECT id_theme FROM rel_themes WHERE id_scope = n.id_scope)) ORDER BY v.id OFFSET ? LIMIT ?; "
public static final java.lang.String QUERY_SELECT_VARIANTS_BY_THEMES_MATCH_ALL "SELECT v.id, v.id_parent, n.id_parent FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND ( IS_SUBSET(?, ARRAY(SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = n.id_scope ) || ARRAY( SELECT id_theme FROM rel_themes AS r WHERE r.id_scope = v.id_scope ))) ORDER BY v.id OFFSET ? LIMIT ?; "

de.topicmapslab.majortom.database.jdbc.rdbms.query.IIndexQueries.QuerySupertypeSubtypeIndex.NonPaged
public static final java.lang.String QUERY_SELECT_DIRECT_SUBTYPES "SELECT id_subtype AS id FROM rel_kind_of WHERE id_supertype = ?;"
public static final java.lang.String QUERY_SELECT_DIRECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of WHERE id_subtype = ?;"
public static final java.lang.String QUERY_SELECT_SUBTYPES "SELECT id_subtype FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_SUBTYPES_OF_TOPIC "SELECT id_subtype AS id FROM rel_kind_of WHERE id_supertype = ?;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ?;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES_OF_TOPIC "SELECT id_supertype AS id FROM rel_kind_of WHERE id_subtype = ?"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUBTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_supertype FROM rel_kind_of ) AND id_parent = ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUPERTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_subtype FROM rel_kind_of ) AND id_parent = ?;"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IIndexQueries.QuerySupertypeSubtypeIndex.Paged
public static final java.lang.String QUERY_SELECT_DIRECT_SUBTYPES "SELECT id_subtype AS id FROM rel_kind_of WHERE id_supertype = ? ORDER BY id_subtype OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_DIRECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of WHERE id_subtype = ? ORDER BY id_supertype OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NUMBER_OF_TOPICS_WITHOUT_SUPERTYPES "SELECT COUNT(id) AS number FROM topics WHERE id NOT IN ( SELECT id_subtype FROM rel_kind_of ) AND id_parent = ?;"
public static final java.lang.String QUERY_SELECT_SUBTYPES "SELECT id_subtype FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ? ORDER BY id_subtype OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of, topics WHERE id = id_subtype AND id_topicmap = ? ORDER BY id_supertype OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUBTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_supertype FROM rel_kind_of ) AND id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPICS_WITHOUT_SUPERTYPES "SELECT id FROM topics WHERE id NOT IN ( SELECT id_subtype FROM rel_kind_of ) AND id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IIndexQueries.QueryTypeInstanceIndex.NonPaged
public static final java.lang.String QUERY_SELECT_ALL_TOPICS_BY_TYPE "SELECT DISTINCT id_instance FROM rel_instance_of WHERE id_type = ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_type IN ( unnest( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONTYPES "SELECT DISTINCT id_type FROM associations WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPE "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type = ? ) AS u;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPES "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type IN ( UNNEST( ? ) ) UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type IN ( UNNEST( ? ) ) ) AS u;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICTYPES "SELECT DISTINCT id_type FROM ( SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? UNION SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ) AS u;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type IN ( UNNEST( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_NAMETYPES "SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type IN ( UNNEST( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCETYPES "SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPE "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPES "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type IN ( UNNEST( ? ) ) ;"
public static final java.lang.String QUERY_SELECT_ROLETYPES "SELECT DISTINCT id_type FROM roles WHERE id_topicmap = ? ;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPE "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND id_type = ? ;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND id_type IN ( UNNEST( ? ) ) "
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES_MATCHES_ALL "SELECT DISTINCT id_instance FROM rel_instance_of AS r, topics WHERE topics.id = r.id_instance AND topics.id_topicmap = ? AND IS_SUBSET(?, ARRAY(SELECT id_type FROM rel_instance_of AS r2 WHERE r.id_instance = r2.id_instance)) ORDER BY id_instance"
public static final java.lang.String QUERY_SELECT_TOPIC_WITHOUT_TYPE "SELECT id FROM topics WHERE id_topicmap = ? AND NOT id IN ( SELECT id_instance FROM rel_instance_of ) "
public static final java.lang.String QUERY_SELECT_TOPICTYPES "SELECT DISTINCT id_type FROM rel_instance_of, topics WHERE id_topicmap = ? AND id = id_type AND id_instance IN ( SELECT id FROM topics AS t WHERE t.id = id_instance );"
public static final java.lang.String QUERY_SELECT_TYPES_MATCHES_ALL "SELECT DISTINCT id_type FROM rel_instance_of WHERE id_instance IN (UNNEST(?))"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IIndexQueries.QueryTypeInstanceIndex.Paged
public static final java.lang.String QUERY_SELECT_ALL_TOPICS_BY_TYPE "SELECT DISTINCT id_instance FROM rel_instance_of WHERE id_type = ? OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONS_BY_TYPES "SELECT id FROM associations WHERE id_topicmap = ? AND id_type IN ( UNNEST( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ASSOCIATIONTYPES "SELECT DISTINCT id_type FROM associations WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPE "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type = ? UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type = ? ) AS u ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICS_BY_TYPES "SELECT id, id_parent, type FROM ( SELECT id, id_parent, \'o\' AS type FROM occurrences WHERE id_type IN ( UNNEST( ? ) ) UNION SELECT id, id_parent, \'n\' AS type FROM names WHERE id_type IN ( UNNEST( ? ) ) ) AS u ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_CHARACTERISTICTYPES "SELECT DISTINCT id_type FROM ( SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? UNION SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ) AS u ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPE "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMES_BY_TYPES "SELECT id, id_parent FROM names WHERE id_topicmap = ? AND id_type IN ( UNNEST( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_NAMETYPES "SELECT DISTINCT id_type FROM names WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPE "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCES_BY_TYPES "SELECT id, id_parent FROM occurrences WHERE id_topicmap = ? AND id_type IN ( UNNEST( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_OCCURRENCETYPES "SELECT DISTINCT id_type FROM occurrences WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPE "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type = ? ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ROLES_BY_TYPES "SELECT id, id_parent FROM roles WHERE id_topicmap = ? AND id_type IN ( UNNEST( ? ) ) ORDER BY id OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_ROLETYPES "SELECT DISTINCT id_type FROM roles WHERE id_topicmap = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPE "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND id_type = ? ORDER BY id_instance OFFSET ? LIMIT ? ;"
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES "SELECT id_instance FROM rel_instance_of, topics WHERE id = id_instance AND id_topicmap = ? AND id_type IN ( UNNEST( ? ) ) ORDER BY id_instance OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_TOPIC_BY_TYPES_MATCHES_ALL "SELECT DISTINCT id_instance FROM rel_instance_of AS r, topics WHERE topics.id = r.id_instance AND topics.id_topicmap = ? AND (IS_SUBSET(?, ARRAY(SELECT id_type FROM rel_instance_of AS r2 WHERE r.id_instance = r2.id_instance))) ORDER BY id_instance OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_TOPIC_WITHOUT_TYPE "SELECT id FROM topics WHERE id_topicmap = ? AND NOT id IN ( SELECT id_instance FROM rel_instance_of ) ORDER BY id OFFSET ? LIMIT ? "
public static final java.lang.String QUERY_SELECT_TOPICTYPES "SELECT DISTINCT id_type FROM rel_instance_of, topics WHERE id_topicmap = ? AND id = id_type AND id_instance IN ( SELECT id FROM topics AS t WHERE t.id = id_instance ) ORDER BY id_type OFFSET ? LIMIT ?;"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IInsertQueries
public static final java.lang.String QUERY_CREATE_ASSOCIATION "INSERT INTO associations(id_topicmap, id_parent, id_type) VALUES (?,?,?);"
public static final java.lang.String QUERY_CREATE_ASSOCIATION_WITH_SCOPE "INSERT INTO associations(id_topicmap, id_parent, id_type, id_scope) VALUES (?,?,?,?);"
public static final java.lang.String QUERY_CREATE_LOCATOR "INSERT INTO locators (reference) VALUES (?);"
public static final java.lang.String QUERY_CREATE_NAME "INSERT INTO names (id_topicmap, id_parent, id_type, value) VALUES (?,?,?,?);"
public static final java.lang.String QUERY_CREATE_NAME_WITH_SCOPE "INSERT INTO names (id_topicmap, id_parent, id_type, value, id_scope) VALUES (?,?,?,?,?);"
public static final java.lang.String QUERY_CREATE_OCCURRENCE "INSERT INTO occurrences (id_topicmap, id_parent, id_type, value, id_datatype) SELECT ?,?,?,?,l.id FROM locators AS l WHERE l.reference LIKE ?;"
public static final java.lang.String QUERY_CREATE_OCCURRENCE_WITH_SCOPE "INSERT INTO occurrences (id_topicmap, id_parent, id_type, value, id_datatype, id_scope) SELECT ?,?,?,?,id,? FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_CREATE_ROLE "INSERT INTO roles(id_topicmap, id_parent, id_type, id_player) VALUES (?,?,?,?)"
public static final java.lang.String QUERY_CREATE_SCOPE "INSERT INTO scopes(id_topicmap) VALUES (?)"
public static final java.lang.String QUERY_CREATE_TOPIC "INSERT INTO topics(id_topicmap, id_parent) VALUES (?,?);"
public static final java.lang.String QUERY_CREATE_TOPICMAP "INSERT INTO topicmaps (id_base_locator) SELECT id FROM locators WHERE reference = ? AND NOT EXISTS ( SELECT tm.id FROM topicmaps AS tm, locators AS l WHERE l.reference LIKE ? AND l.id = tm.id_base_locator); "
public static final java.lang.String QUERY_CREATE_VARIANT "INSERT INTO variants (id_topicmap, id_parent, value, id_datatype, id_scope) SELECT ?,?,?,id,? FROM locators WHERE reference LIKE ?;"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IQueries
public static final java.lang.String SNIPPET_CREATE_TOPIC_IF_SUBJECT_IDENTIFIER_NOT_EXISTS "INSERT INTO topics(id_topicmap,id_parent) VALUES( ?,? ) WHERE NOT EXISTS (SELECT t.id, l.id FROM topics AS t, locators AS l, rel_subject_identifiers as r WHERE reference = ? AND l.id = r.id_locator AND r.id_topic = t.id);"
public static final java.lang.String SNIPPET_CREATE_TOPICMAP_IF_NOT_EXISTS "INSERT INTO topicmaps (id_base_locator) SELECT id FROM locators WHERE reference = ? AND NOT EXISTS ( SELECT tm.id FROM topicmaps AS tm, locators AS l WHERE l.reference LIKE ? AND l.id = tm.id_base_locator); "

de.topicmapslab.majortom.database.jdbc.rdbms.query.IRevisionQueries
public static final java.lang.String QUERY_CREATE_CHANGESET "INSERT INTO changesets(id_revision,type,id_notifier, newValue, oldValue, time) VALUES(?,?,?,?,?,now())"
public static final java.lang.String QUERY_CREATE_METADATA "INSERT INTO metadata(id_revision, key, value) VALUES (?,?,?);"
public static final java.lang.String QUERY_CREATE_REVISION "INSERT INTO revisions(time, id_topicmap, type) VALUES(now(),?, ?)"
public static final java.lang.String QUERY_CREATE_TAG "INSERT INTO tags(tag, time) VALUES (?,?);"
public static final java.lang.String QUERY_MODIFY_METADATA "UPDATE metadata SET value = ? WHERE id_revision = ? AND key = ?;"
public static final java.lang.String QUERY_MODIFY_TAG "UPDATE tags SET time = ? WHERE tag = ?;"
public static final java.lang.String QUERY_READ_CHANGESET "SELECT type, id_notifier, newValue, oldValue FROM changesets WHERE id_revision = ? ORDER BY id ASC;"
public static final java.lang.String QUERY_READ_CHANGESETS_BY_ASSOCIATIONTYPE "WITH ids AS ( SELECT id FROM associations WHERE id_type = ? ) SELECT id_revision, type, id_notifier, newValue, oldValue FROM changesets WHERE id_notifier IN ( SELECT id FROM ids ) OR oldValue IN ( SELECT CAST ( id AS character varying(256) ) FROM ids ) OR newValue IN ( SELECT CAST ( id AS character varying(256) ) FROM ids ) ORDER BY id ASC;"
public static final java.lang.String QUERY_READ_CHANGESETS_BY_TOPIC "SELECT id_revision, type, id_notifier, newValue, oldValue FROM changesets WHERE id_notifier = ? OR oldValue = ? OR newValue = ? ORDER BY id ASC;"
public static final java.lang.String QUERY_READ_CHANGESETTYPE "SELECT type FROM revisions WHERE id = ?;"
public static final java.lang.String QUERY_READ_FIRST_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? ORDER BY id ASC LIMIT 1;"
public static final java.lang.String QUERY_READ_FUTURE_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? AND id > ? ORDER BY id ASC LIMIT 1;"
public static final java.lang.String QUERY_READ_HISTORY "SELECT * FROM history WHERE id = ?;"
public static final java.lang.String QUERY_READ_LAST_MODIFICATION "SELECT time FROM revisions WHERE id_topicmap = ? ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_LAST_MODIFICATION_OF_TOPIC "SELECT time FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier = ? OR oldValue = ? OR newValue = ? ) ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_LAST_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? ORDER BY id DESC LIMIT 1;"
public static final java.lang.String QUERY_READ_METADATA "SELECT key, value FROM metadata WHERE id_revision = ?;"
public static final java.lang.String QUERY_READ_METADATA_BY_KEY "SELECT value FROM metadata WHERE id_revision = ? AND key = ?;"
public static final java.lang.String QUERY_READ_PAST_REVISION "SELECT id FROM revisions WHERE id_topicmap = ? AND id < ? ORDER BY id DESC LIMIT 1;"
public static final java.lang.String QUERY_READ_REVISION_BY_TAG "SELECT id FROM revisions WHERE id_topicmap = ? AND time <= ( SELECT time FROM tags WHERE tag = ? ) ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_REVISION_BY_TIMESTAMP "SELECT id FROM revisions WHERE id_topicmap = ? AND time <= ? ORDER BY time DESC LIMIT 1"
public static final java.lang.String QUERY_READ_REVISIONS_BY_ASSOCIATIONTYPE "WITH ids AS ( SELECT id FROM associations WHERE id_type = ? ) SELECT id FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier IN ( SELECT id FROM ids ) OR oldValue IN ( SELECT CAST ( id AS character varying(256) ) FROM ids ) OR newValue IN ( SELECT CAST ( id AS character varying(256) ) FROM ids ) ) ORDER BY id ASC ;"
public static final java.lang.String QUERY_READ_REVISIONS_BY_TOPIC "SELECT id FROM revisions WHERE id IN ( SELECT id_revision FROM changesets WHERE id_notifier = ? OR oldValue = ? OR newValue = ? ) ORDER BY id ASC ;"
public static final java.lang.String QUERY_READ_TIMESTAMP "SELECT time FROM revisions WHERE id = ?;"

de.topicmapslab.majortom.database.jdbc.rdbms.query.ISelectQueries.NonPaged
public static final java.lang.String QUERY_READ_ASSOCIATION_REIFIER "SELECT id_reifier FROM associations WHERE id = ?"
public static final java.lang.String QUERY_READ_ASSOCIATION_SCOPE "SELECT DISTINCT id_scope FROM associations WHERE id = ?"
public static final java.lang.String QUERY_READ_ASSOCIATION_TYPE "SELECT id_type FROM associations WHERE id = ?"
public static final java.lang.String QUERY_READ_ASSOCIATIONS "SELECT id FROM associations WHERE id_topicmap = ? "
public static final java.lang.String QUERY_READ_ASSOCIATIONS_WITH_SCOPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_scope = ? "
public static final java.lang.String QUERY_READ_ASSOCIATIONS_WITH_TYPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ? "
public static final java.lang.String QUERY_READ_ASSOCIATIONS_WITH_TYPE_AND_SCOPE "SELECT id FROM associations WHERE id_topicmap = ? AND id_type = ? AND id_scope = ? "
public static final java.lang.String QUERY_READ_CONSTRUCT "SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id = ? AND v.id_parent = n.id UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id = ?;"
public static final java.lang.String QUERY_READ_CONSTRUCT_BY_ITEM_IDENTIFIER "SELECT id, id_parent, 0 AS other, \'t\' AS type FROM topics WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? ) AND id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? ) AND id_topicmap = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? ) AND v.id_parent = n.id AND v.id_topicmap = ? UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? ) AND id_topicmap = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? );"
public static final java.lang.String QUERY_READ_CONSTRUCT_BY_ITEM_IDENTIFIER_STD "SELECT id, id_parent, 0 AS other, \'%TYPE%\' AS type FROM %COLUMN% WHERE id_topicmap = ? AND id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? );"
public static final java.lang.String QUERY_READ_CONSTRUCT_BY_ITEM_IDENTIFIER_VARIANT "SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id_parent = n.id AND v.id_topicmap = ? AND v.id IN ( SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ? );"
public static final java.lang.String QUERY_READ_CONSTRUCT_ID_BY_ITEM_IDENTIFIER "SELECT id_construct FROM rel_item_identifiers, locators WHERE id = id_locator AND reference = ?;"
public static final java.lang.String QUERY_READ_CONSTRUCT_STD "SELECT id, id_parent, 0 AS other, \'%TYPE%\' AS type FROM %COLUMN% WHERE id = ?"
public static final java.lang.String QUERY_READ_CONSTRUCT_VARIANT "SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id = ? AND v.id_parent = n.id;"
public static final java.lang.String QUERY_READ_EMPTY_SCOPE "SELECT id FROM scopes WHERE id NOT IN ( SELECT DISTINCT id_scope FROM rel_themes ) AND id_topicmap = ?"
public static final java.lang.String QUERY_READ_ITEM_IDENTIFIERS "SELECT l.id, l.reference FROM locators AS l, rel_item_identifiers AS r WHERE r.id_construct = ? AND r.id_locator = l.id"
public static final java.lang.String QUERY_READ_LOCATOR "SELECT id FROM locators WHERE reference = ?; "
public static final java.lang.String QUERY_READ_LOCATORS "SELECT l.id , reference FROM topicmaps AS tm, locators AS l WHERE id_base_locator = l.id"
public static final java.lang.String QUERY_READ_NAME_REIFIER "SELECT id_reifier FROM names WHERE id = ?"
public static final java.lang.String QUERY_READ_NAME_SCOPE "SELECT DISTINCT id_scope FROM names WHERE id = ?"
public static final java.lang.String QUERY_READ_NAME_TYPE "SELECT id_type FROM names AS ty WHERE id = ?"
public static final java.lang.String QUERY_READ_NAME_VALUE "SELECT DISTINCT value FROM names WHERE id = ?"
public static final java.lang.String QUERY_READ_NAMES "SELECT id FROM names WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_NAMES_WITH_SCOPE "SELECT id FROM names WHERE id_parent = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_NAMES_WITH_TYPE "SELECT id FROM names WHERE id_parent = ? AND id_type = ?"
public static final java.lang.String QUERY_READ_NAMES_WITH_TYPE_AND_SCOPE "SELECT id FROM names WHERE id_parent = ? AND id_type = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_OCCURRENCE_DATATYPE "SELECT l.id, l.reference FROM locators AS l, occurrences AS d WHERE d.id_datatype = l.id AND d.id = ?"
public static final java.lang.String QUERY_READ_OCCURRENCE_REIFIER "SELECT id_reifier FROM occurrences WHERE id = ?"
public static final java.lang.String QUERY_READ_OCCURRENCE_SCOPE "SELECT DISTINCT id_scope FROM occurrences WHERE id = ?"
public static final java.lang.String QUERY_READ_OCCURRENCE_TYPE "SELECT id_type FROM occurrences WHERE id = ?"
public static final java.lang.String QUERY_READ_OCCURRENCE_VALUE "SELECT DISTINCT value FROM occurrences WHERE id = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES "SELECT id FROM occurrences WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES_WITH_SCOPE "SELECT id FROM occurrences WHERE id_parent = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES_WITH_TYPE "SELECT id FROM occurrences WHERE id_parent = ? AND id_type = ?"
public static final java.lang.String QUERY_READ_OCCURRENCES_WITH_TYPE_AND_SCOPE "SELECT id FROM occurrences WHERE id_parent = ? AND id_type = ? AND id_scope = ?"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_SCOPE "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id AND a.id_scope = ?"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id AND a.id_type = ?"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS_WITH_TYPE_AND_SCOPE "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id AND a.id_type = ? AND a.id_scope = ?"
public static final java.lang.String QUERY_READ_PLAYED_ROLES "SELECT id, id_parent FROM roles WHERE id_player = ? "
public static final java.lang.String QUERY_READ_PLAYED_ROLES_WITH_TYPE "SELECT id, id_parent FROM roles WHERE id_player = ? AND id_type = ? "
public static final java.lang.String QUERY_READ_PLAYED_ROLES_WITH_TYPE_AND_ASSOTYPE "SELECT r.id, r.id_parent FROM roles AS r, associations AS a WHERE r.id_player = ? AND r.id_type = ? AND r.id_parent = a.id AND a.id_type = ? "
public static final java.lang.String QUERY_READ_PLAYER "SELECT id_player FROM roles WHERE id = ?"
public static final java.lang.String QUERY_READ_REIFIED "SELECT id, id_parent, 0 AS other, \'a\' AS type FROM associations WHERE id_reifier = ? UNION SELECT id, id_parent, 0 AS other, \'n\' AS type FROM names WHERE id_reifier = ? UNION SELECT id, id_parent, 0 AS other, \'o\' AS type FROM occurrences WHERE id_reifier = ? UNION SELECT v.id, v.id_parent, n.id_parent, \'v\' AS type FROM variants AS v, names AS n WHERE v.id_reifier = ? AND v.id_parent = n.id UNION SELECT id, id_parent, 0 AS other, \'r\' AS type FROM roles WHERE id_reifier = ? UNION SELECT id, 0 AS id_parent, 0 AS other, \'tm\' AS type FROM topicmaps WHERE id_reifier = ?;"
public static final java.lang.String QUERY_READ_ROLE_REIFIER "SELECT id_reifier FROM roles WHERE id = ?"
public static final java.lang.String QUERY_READ_ROLE_TYPE "SELECT id_type FROM roles WHERE id = ?"
public static final java.lang.String QUERY_READ_ROLES "SELECT id FROM roles WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_ROLES_WITH_TYPE "SELECT id FROM roles WHERE id_parent = ? AND id_type = ? "
public static final java.lang.String QUERY_READ_ROLESTYPES "SELECT DISTINCT id_type FROM roles WHERE id_parent = ? "
public static final java.lang.String QUERY_READ_SCOPES_BY_THEME "SELECT DISTINCT id_scope FROM rel_themes AS r WHERE id_theme = ? AND ? IN ( SELECT count ( id_theme ) FROM rel_themes WHERE id_scope = r.id_scope );"
public static final java.lang.String QUERY_READ_SUBJECT_IDENTIFIERS "SELECT l.id,reference FROM locators AS l, rel_subject_identifiers AS r, topics AS t WHERE r.id_topic = ? AND r.id_locator = l.id AND t.id = r.id_topic"
public static final java.lang.String QUERY_READ_SUBJECT_LOCATORS "SELECT l.id,reference FROM locators AS l, rel_subject_locators AS r , topics AS t WHERE r.id_topic = ? AND r.id_locator = l.id AND t.id = r.id_topic"
public static final java.lang.String QUERY_READ_SUPERTYPES "SELECT id_supertype AS id FROM rel_kind_of WHERE id_subtype = ?"
public static final java.lang.String QUERY_READ_THEMES "SELECT DISTINCT id_theme FROM rel_themes WHERE id_scope = ?"
public static final java.lang.String QUERY_READ_TOPIC_BY_SUBJECT_IDENTIFIER " SELECT t.id FROM topics AS t, locators AS l, rel_subject_identifiers as r WHERE id_topicmap = ? AND reference = ? AND l.id = r.id_locator AND r.id_topic = t.id;"
public static final java.lang.String QUERY_READ_TOPIC_BY_SUBJECT_LOCATOR " SELECT t.id FROM topics AS t, locators AS l, rel_subject_locators as r WHERE id_topicmap = ? AND reference = ? AND l.id = r.id_locator AND r.id_topic = t.id;"
public static final java.lang.String QUERY_READ_TOPICMAP "SELECT tm.id FROM topicmaps AS tm, locators AS l WHERE l.reference = ? AND l.id = tm.id_base_locator;"
public static final java.lang.String QUERY_READ_TOPICMAP_REIFIER "SELECT id_reifier FROM topicmaps WHERE id = ?"
public static final java.lang.String QUERY_READ_TOPICS "SELECT id FROM topics WHERE id_topicmap = ?"
public static final java.lang.String QUERY_READ_TOPICS_WITH_TYPE "SELECT id_instance FROM rel_instance_of AS r, topics AS t WHERE id_instance = t.id AND id_type IN ( SELECT id FROM topics WHERE id = ? )"
public static final java.lang.String QUERY_READ_TYPES "SELECT id_type FROM rel_instance_of WHERE id_instance = ?"
public static final java.lang.String QUERY_READ_USED_SCOPES_BY_THEME "SELECT DISTINCT id_scope FROM rel_themes AS r WHERE id_theme = ? AND id_scope IN (SELECT id_scope FROM names UNION SELECT id_scope FROM variants UNION SELECT id_scope FROM occurrences UNION SELECT id_scope FROM associations) ;"
public static final java.lang.String QUERY_READ_VARIANT_DATATYPE "SELECT l.id,reference FROM locators AS l, variants AS d WHERE d.id_datatype = l.id AND d.id = ?"
public static final java.lang.String QUERY_READ_VARIANT_REIFIER "SELECT id_reifier FROM variants WHERE id = ?"
public static final java.lang.String QUERY_READ_VARIANT_SCOPE "SELECT DISTINCT id_scope FROM variants WHERE id = ?"
public static final java.lang.String QUERY_READ_VARIANT_VALUE "SELECT DISTINCT value FROM variants WHERE id = ?"
public static final java.lang.String QUERY_READ_VARIANTS "SELECT id FROM variants WHERE id_parent = ?"
public static final java.lang.String QUERY_READ_VARIANTS_WITH_SCOPE "SELECT id FROM variants WHERE id_parent = ? AND id_scope = ?"

de.topicmapslab.majortom.database.jdbc.rdbms.query.ISelectQueries.Paged
public static final java.lang.String QUERY_READ_ASSOCIATIONS "SELECT id FROM associations WHERE id_topicmap = ? ORDER BY id OFFSET ? LIMIT ?"
public static final java.lang.String QUERY_READ_NAMES "SELECT id FROM names WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_ASSOCIATIONS "SELECT COUNT(id) FROM associations WHERE id_topicmap= ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_NAMES "SELECT COUNT(id) AS number FROM names WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_OCCURRENCES "SELECT COUNT(id) AS number FROM occurrences WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_PLAYED_ASSOCIATIONS "SELECT DISTINCT COUNT(a.id) AS number FROM associations AS a, roles AS r WHERE r.id_player = ? AND r.id_parent = a.id;"
public static final java.lang.String QUERY_READ_NUMBER_OF_PLAYED_ROLES "SELECT COUNT(id) AS number FROM roles WHERE id_player = ?"
public static final java.lang.String QUERY_READ_NUMBER_OF_ROLES "SELECT COUNT(id) AS number FROM roles WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_TOPICS "SELECT COUNT(id) FROM topics WHERE id_topicmap= ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_TYPES "SELECT COUNT(id_type) AS number FROM rel_instance_of WHERE id_instance = ?;"
public static final java.lang.String QUERY_READ_NUMBER_OF_VARIANTS "SELECT COUNT(id) AS number FROM variants WHERE id_parent = ?;"
public static final java.lang.String QUERY_READ_OCCURRENCES "SELECT id FROM occurrences WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_PLAYED_ASSOCIATIONS "SELECT DISTINCT a.id FROM associations AS a, roles AS r WHERE a.id_topicmap = ? AND r.id_player = ? AND r.id_parent = a.id ORDER BY a.id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_PLAYED_ROLES "SELECT id, id_parent FROM roles WHERE id_player = ? ORDER BY id OFFSET ? LIMIT ?"
public static final java.lang.String QUERY_READ_ROLES "SELECT id FROM roles WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_TOPICS "SELECT id FROM topics WHERE id_topicmap = ? ORDER BY id OFFSET ? LIMIT ?"
public static final java.lang.String QUERY_READ_TYPES "SELECT id_type FROM rel_instance_of WHERE id_instance = ? ORDER BY id_type OFFSET ? LIMIT ?;"
public static final java.lang.String QUERY_READ_VARIANTS "SELECT id FROM variants WHERE id_parent = ? ORDER BY id OFFSET ? LIMIT ?"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IUpdateQueries
public static final java.lang.String QUERY_ADD_ITEM_IDENTIFIER "INSERT INTO rel_item_identifiers(id_construct, id_locator) SELECT ? , id FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_ADD_SUBJECT_IDENTIFIER "INSERT INTO rel_subject_identifiers(id_topic, id_locator) SELECT ? , id FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_ADD_SUBJECT_LOCATOR "INSERT INTO rel_subject_locators(id_topic, id_locator) SELECT ? , id FROM locators WHERE reference LIKE ?;"
public static final java.lang.String QUERY_ADD_THEME "INSERT INTO rel_themes(id_scope, id_theme) VALUES (?,?);"
public static final java.lang.String QUERY_MODIFY_ASSOCIATION_REIFIER "UPDATE associations SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_ASSOCIATION_SCOPE "UPDATE associations SET id_scope = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_ASSOCIATION_TYPE "UPDATE associations SET id_type = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_NAME_REIFIER "UPDATE names SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_NAME_SCOPE "UPDATE names SET id_scope = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_NAME_TYPE "UPDATE names SET id_type = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_NAME_VALUE "UPDATE names set value = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_OCCURRENCE_REIFIER "UPDATE occurrences SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_OCCURRENCE_SCOPE "UPDATE occurrences SET id_scope = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_OCCURRENCE_TYPE "UPDATE occurrences SET id_type = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_OCCURRENCE_VALUE_WITH_DATATYPE "UPDATE occurrences set value = ?, id_datatype = ( SELECT id FROM locators WHERE reference LIKE ? ) WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_PLAYER "UPDATE roles SET id_player = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_ROLE_REIFIER "UPDATE roles SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_ROLE_TYPE "UPDATE roles SET id_type = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_SUPERTYPES "INSERT INTO rel_kind_of(id_subtype, id_supertype) VALUES (?,?) WHERE NOT EXISTS ( SELECT id_subtype, id_supertype FROM rel_kind_of WHERE id_subtype = ? AND id_supertype = ? );"
public static final java.lang.String QUERY_MODIFY_SUPERTYPES_INSERT "INSERT INTO rel_kind_of VALUES(?,?);"
public static final java.lang.String QUERY_MODIFY_SUPERTYPES_SELECT "SELECT * FROM rel_kind_of WHERE id_subtype = ? AND id_supertype = ?;"
public static final java.lang.String QUERY_MODIFY_TOPICMAP_REIFIER "UPDATE topicmaps SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_TYPES "INSERT INTO rel_instance_of(id_instance, id_type) VALUES(?,?);"
public static final java.lang.String QUERY_MODIFY_VALUE "UPDATE literals SET value = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_VALUE_WITH_DATATYPE "UPDATE literals SET value = ? WHERE id = ?;UPDATE datatypeawares SET id_datatype = ( SELECT id FROM locators WHERE reference LIKE ? ) WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_VARIANT_REIFIER "UPDATE variants SET id_reifier = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_VARIANT_SCOPE "UPDATE variants SET id_scope = ? WHERE id = ?;"
public static final java.lang.String QUERY_MODIFY_VARIANT_VALUE_WITH_DATATYPE "UPDATE variants set value = ?, id_datatype = ( SELECT id FROM locators WHERE reference LIKE ? ) WHERE id = ?;"

de.topicmapslab.majortom.database.jdbc.rdbms.query.IUpdateQueries.QueryMerge
public static final java.lang.String QUERY_DELETE_TOPIC "DELETE FROM topics WHERE id = ?;"
public static final java.lang.String QUERY_MERGE_TOPIC " UPDATE rel_kind_of SET id_subtype = ? WHERE id_subtype = ?; UPDATE rel_kind_of SET id_supertype = ? WHERE id_supertype = ?; UPDATE rel_instance_of SET id_instance = ? WHERE id_instance = ?; UPDATE rel_instance_of SET id_type = ? WHERE id_type = ?; UPDATE rel_themes SET id_theme = ? WHERE id_theme = ?; UPDATE names SET id_type = ? WHERE id_type = ?; UPDATE occurrences SET id_type = ? WHERE id_type = ?; UPDATE associations SET id_type = ? WHERE id_type = ?; UPDATE roles SET id_type = ? WHERE id_type = ?; UPDATE names SET id_reifier = ? WHERE id_reifier = ?; UPDATE roles SET id_reifier = ? WHERE id_reifier = ?; UPDATE associations SET id_reifier = ? WHERE id_reifier = ?; UPDATE occurrences SET id_reifier = ? WHERE id_reifier = ?; UPDATE rel_item_identifiers SET id_construct = ? WHERE id_construct = ?; UPDATE rel_subject_identifiers SET id_topic = ? WHERE id_topic = ?; UPDATE rel_subject_locators SET id_topic = ? WHERE id_topic = ?; UPDATE roles SET id_player = ? WHERE id_player = ?; UPDATE variants SET id_parent = ? WHERE id_parent = ?; UPDATE scopes SET id_parent = ? WHERE id_parent = ?; UPDATE names SET id_parent = ? WHERE id_parent = ?; UPDATE topics SET id_parent = ? WHERE id_parent = ?; UPDATE associations SET id_parent = ? WHERE id_parent = ?; UPDATE roles SET id_parent = ? WHERE id_parent = ?; UPDATE occurrences SET id_parent = ? WHERE id_parent = ?; DELETE FROM topics WHERE id = ?; "
public static final java.lang.String QUERY_UPDATE_ASSOCIATIONS_PARENT "UPDATE associations SET id_parent = ? WHERE id_parent = ?;"
public static final java.lang.String QUERY_UPDATE_ASSOCIATIONS_REIFIER "UPDATE associations SET id_reifier = ? WHERE id_reifier = ?;"
public static final java.lang.String QUERY_UPDATE_ASSOCIATIONS_TYPE "UPDATE associations SET id_type = ? WHERE id_type = ?;"
public static final java.lang.String QUERY_UPDATE_INSTANCE_OF_INSTANCE "UPDATE rel_instance_of SET id_instance = ? WHERE id_instance = ?;"
public static final java.lang.String QUERY_UPDATE_INSTANCE_OF_TYPE "UPDATE rel_instance_of SET id_type = ? WHERE id_type = ?;"
public static final java.lang.String QUERY_UPDATE_ITEM_IDENTIFIERS "UPDATE rel_item_identifiers SET id_construct = ? WHERE id_construct = ?;"
public static final java.lang.String QUERY_UPDATE_KIND_OF_SUBTYPE "UPDATE rel_kind_of SET id_subtype = ? WHERE id_subtype = ?;"
public static final java.lang.String QUERY_UPDATE_KIND_OF_SUPERTYPE "UPDATE rel_kind_of SET id_supertype = ? WHERE id_supertype = ?;"
public static final java.lang.String QUERY_UPDATE_NAMES_PARENT "UPDATE names SET id_parent = ? WHERE id_parent = ?;"
public static final java.lang.String QUERY_UPDATE_NAMES_REIFIER "UPDATE names SET id_reifier = ? WHERE id_reifier = ?;"
public static final java.lang.String QUERY_UPDATE_NAMES_TYPE "UPDATE names SET id_type = ? WHERE id_type = ?;"
public static final java.lang.String QUERY_UPDATE_OCCURRENCES_PARENT "UPDATE occurrences SET id_parent = ? WHERE id_parent = ?;"
public static final java.lang.String QUERY_UPDATE_OCCURRENCES_REIFIER "UPDATE occurrences SET id_reifier = ? WHERE id_reifier = ?;"
public static final java.lang.String QUERY_UPDATE_OCCURRENCES_TYPE "UPDATE occurrences SET id_type = ? WHERE id_type = ?;"
public static final java.lang.String QUERY_UPDATE_ROLES_PLAYER "UPDATE roles SET id_player = ? WHERE id_player = ?;"
public static final java.lang.String QUERY_UPDATE_ROLES_REIFIER "UPDATE roles SET id_reifier = ? WHERE id_reifier = ?;"
public static final java.lang.String QUERY_UPDATE_ROLES_TYPE "UPDATE roles SET id_type = ? WHERE id_type = ?;"
public static final java.lang.String QUERY_UPDATE_SUBJECT_IDENTIFIERS "UPDATE rel_subject_identifiers SET id_topic = ? WHERE id_topic = ?;"
public static final java.lang.String QUERY_UPDATE_SUBJECT_LOCATORS "UPDATE rel_subject_locators SET id_topic = ? WHERE id_topic = ?;"
public static final java.lang.String QUERY_UPDATE_THEMES "UPDATE rel_themes SET id_theme = ? WHERE id_theme = ?;"
public static final java.lang.String QUERY_UPDATE_VARIANTS_PARENT "UPDATE variants SET id_parent = ? WHERE id_parent = ?;"

de.topicmapslab.majortom.database.readonly.JdbcReadOnlyAssociation
private static final long serialVersionUID 1L

de.topicmapslab.majortom.database.readonly.JdbcReadOnlyAssociationRole
private static final long serialVersionUID 1L

de.topicmapslab.majortom.database.readonly.JdbcReadOnlyName
private static final long serialVersionUID 1L

de.topicmapslab.majortom.database.readonly.JdbcReadOnlyOccurrence
private static final long serialVersionUID 1L

de.topicmapslab.majortom.database.readonly.JdbcReadOnlyTopic
private static final long serialVersionUID 1L

de.topicmapslab.majortom.database.readonly.JdbcReadOnlyVariant
private static final long serialVersionUID 1L

de.topicmapslab.majortom.database.store.JdbcIdentity
private static final long serialVersionUID 1L

de.topicmapslab.majortom.database.store.JdbcTopicMapStore
private static final java.lang.String MESSAGE_SESSION_CANNOT_BE_CLOSED "Session cannot be closed!"

de.topicmapslab.majortom.database.store.JdbcTopicMapStoreProperty
public static final java.lang.String DATABASE_HOST "de.topicmapslab.majortom.jdbc.host"
public static final java.lang.String DATABASE_NAME "de.topicmapslab.majortom.jdbc.database"
public static final java.lang.String DATABASE_PASSWORD "de.topicmapslab.majortom.jdbc.password"
public static final java.lang.String DATABASE_USER "de.topicmapslab.majortom.jdbc.user"
private static final java.lang.String JDBC_PREFIX "de.topicmapslab.majortom.jdbc"
public static final java.lang.String POOL_CONNECTION_COUNT "de.topicmapslab.majortom.jdbc.pool.count"
public static final java.lang.String SQL_DIALECT "de.topicmapslab.majortom.jdbc.dialect"

de.topicmapslab.majortom.database.transaction.InMemoryTransaction
private static final long serialVersionUID -8470350200554982763L

de.topicmapslab.majortom.database.transaction.TransactionTopicMapStore
private static final java.lang.String ID_PREFIX "id:"
protected static final java.lang.String ITEMIDENTIFIER_PREFIX "ii:"
protected static final java.lang.String SUBJECTIDENTIFIER_PREFIX "si:"
protected static final java.lang.String SUBJECTLOCATOR_PREFIX "sl:"

de.topicmapslab.majortom.importer.IDatabasePropertiesConstants
public static final java.lang.String DATABASE "database"
public static final java.lang.String HOST "host"
public static final java.lang.String PASSWORD "password"
public static final java.lang.String PORT "port"
public static final java.lang.String USERNAME "username"

de.topicmapslab.majortom.importer.file.FileWriterMapHandler
private static final java.lang.String NULL "NULL"
private static final java.lang.String PLACEHOLDER "{0}"
private static final java.lang.String UTF_8 "UTF-8"

de.topicmapslab.majortom.importer.file.PSQLTask
private static final java.lang.String ARG_PIPE "<"
private static final java.lang.String ARG_QUIET "-q"
private static final java.lang.String CMD_EXE "cmd.exe"
private static final java.lang.String COMMAND "/C"
private static final java.lang.String OS_NAME "os.name"
private static final java.lang.String PGPASSWORD "PGPASSWORD"
private static final java.lang.String PSQL "psql"
private static final java.lang.String SLASH "/"
private static final java.lang.String WINDOWS "windows"

de.topicmapslab.majortom.importer.file.QUERY
public static final java.lang.String AKO "INSERT INTO rel_kind_of(id_supertype, id_subtype) VALUES ({0},{1});\r\n"
public static final java.lang.String ASSOCIATION "INSERT INTO associations(id_topicmap, id_parent, id, id_type, id_scope, id_reifier) VALUES ({0},{1},{2},{3},{4},{5});\r\n"
public static final java.lang.String CURRVAL "SELECT nextval(\'seq_construct_id\'::regclass), nextval(\'seq_locator_id\'::regclass), nextval(\'seq_scope_id\'::regclass);"
public static final java.lang.String II "INSERT INTO rel_item_identifiers(id_construct, id_locator) VALUES ({0},{1});\r\n"
public static final java.lang.String ISA "INSERT INTO rel_instance_of(id_type, id_instance) VALUES ({0},{1});\r\n"
public static final java.lang.String LOCATOR "INSERT INTO locators (id, reference) VALUES ({0},E\'\'{1}\'\');\r\n"
public static final java.lang.String MERGE "UPDATE rel_kind_of SET id_subtype = {0} WHERE id_subtype = {1}; \r\nUPDATE rel_kind_of SET id_supertype = {2} WHERE id_supertype = {3}; \r\nUPDATE rel_instance_of SET id_instance = {4} WHERE id_instance = {5}; \r\nUPDATE rel_instance_of SET id_type = {6} WHERE id_type = {7}; \r\nUPDATE rel_themes SET id_theme = {8} WHERE id_theme = {9}; \r\nUPDATE typeables SET id_type = {10} WHERE id_type = {11}; \r\nUPDATE reifiables SET id_reifier = {12} WHERE id_reifier = {13}; \r\nUPDATE rel_item_identifiers SET id_construct = {14} WHERE id_construct = {15}; \r\nUPDATE rel_subject_identifiers SET id_topic = {16} WHERE id_topic = {17}; \r\nUPDATE rel_subject_locators SET id_topic = {18} WHERE id_topic = {19}; \r\nUPDATE roles SET id_player = {20} WHERE id_player = {21}; \r\nUPDATE constructs SET id_parent = {22} WHERE id_parent = {23};DELETE FROM topics WHERE id = {24}; \r\n"
public static final java.lang.String NAME "INSERT INTO names(id_topicmap, id_parent, id, id_type, value, id_scope, id_reifier) VALUES ({0},{1},{2},{3},E\'\'{4}\'\',{5},{6});\r\n"
public static final java.lang.String OCCURRENCE "INSERT INTO occurrences(id_topicmap, id_parent, id, id_type, value, id_datatype, id_scope, id_reifier) VALUES ({0},{1},{2},{3},E\'\'{4}\'\',{5}, {6},{7});\r\n"
public static final java.lang.String ROLE "INSERT INTO roles(id_topicmap, id_parent, id, id_type, id_player, id_reifier) VALUES ({0},{1},{2},{3},{4},{5});\r\n"
public static final java.lang.String SCOPE "INSERT INTO scopes(id_topicmap, id) VALUES ({0},{1});\r\n"
public static final java.lang.String SELECT_AKO "SELECT id_supertype, id_subtype FROM rel_kind_of WHERE id_supertype IN ( SELECT id FROM topics WHERE id_topicmap = {0})"
public static final java.lang.String SELECT_ASSOCIATION "SELECT id_topicmap,id, id_type, id_scope, id_reifier FROM associations WHERE id_topicmap = {0}"
public static final java.lang.String SELECT_II "SELECT id_construct, id_locator FROM rel_item_identifiers WHERE id_construct IN ( SELECT id FROM constructs WHERE id_topicmap = {0})"
public static final java.lang.String SELECT_ISA "SELECT id_type, id_instance FROM rel_instance_of WHERE id_type IN ( SELECT id FROM topics WHERE id_topicmap = {0})"
public static final java.lang.String SELECT_LOCATOR "SELECT id, reference FROM locators"
public static final java.lang.String SELECT_NAME "SELECT id_topicmap, id_parent, id, id_type, value, id_scope, id_reifier FROM names WHERE id_topicmap = {0}"
public static final java.lang.String SELECT_OCCURRENCE "SELECT id_topicmap, id_parent, id, id_type, value, id_datatype, id_scope, id_reifier FROM occurrences WHERE id_topicmap = {0}"
public static final java.lang.String SELECT_ROLE "SELECT id_topicmap, id_parent, id, id_type, id_player, id_reifier FROM roles WHERE id_topicmap = {0}"
public static final java.lang.String SELECT_SCOPE "SELECT id, ARRAY(SELECT id_theme FROM rel_themes WHERE id_scope = s.id) FROM scopes AS s WHERE id IN ( SELECT id_scope FROM scopeables WHERE id_topicmap = {0})"
public static final java.lang.String SELECT_SI "SELECT id_topic, id_locator FROM rel_subject_identifiers WHERE id_topic IN ( SELECT id FROM topics WHERE id_topicmap = {0})"
public static final java.lang.String SELECT_SL "SELECT id_topic, id_locator FROM rel_subject_locators WHERE id_topic IN ( SELECT id FROM topics WHERE id_topicmap = {0})"
public static final java.lang.String SELECT_VARIANT "SELECT id_topicmap, id_parent, id, value, id_datatype, id_scope, id_reifier FROM variants WHERE id_topicmap = {0}"
public static final java.lang.String SETVAL "SELECT setval(\'\'seq_construct_id\'\'::regclass, {0}), setval(\'\'seq_locator_id\'\'::regclass, {1}) , setval(\'\'seq_scope_id\'\'::regclass,{2});"
public static final java.lang.String SI "INSERT INTO rel_subject_identifiers(id_topic, id_locator) VALUES ({0},{1});\r\n"
public static final java.lang.String SL "INSERT INTO rel_subject_locators(id_topic, id_locator) VALUES ({0},{1});\r\n"
public static final java.lang.String THEME "INSERT INTO rel_themes(id_scope, id_theme) VALUES ({0},{1});\r\n"
public static final java.lang.String TOPIC "INSERT INTO topics(id_topicmap, id_parent, id) VALUES ({0},{1},{2});\r\n"
public static final java.lang.String VARIANT "INSERT INTO variants(id_topicmap, id_parent, id, value, id_datatype, id_scope, id_reifier) VALUES ({0},{1},{2},E\'\'{3}\'\',{4},{5},{6});\r\n"

de.topicmapslab.majortom.inmemory.store.HighQualityRandom
private static final long serialVersionUID 1L

de.topicmapslab.majortom.inmemory.store.InMemoryIdentity
private static final long serialVersionUID 1L

de.topicmapslab.majortom.inmemory.store.InMemoryTopicMapStore
private static final java.lang.String ID_PREFIX "id:"
protected static final java.lang.String ITEMIDENTIFIER_PREFIX "ii:"
protected static final java.lang.String SUBJECTIDENTIFIER_PREFIX "si:"
protected static final java.lang.String SUBJECTLOCATOR_PREFIX "sl:"

de.topicmapslab.majortom.inmemory.store.SignatureStore
private static final java.lang.String ASSOCIATION_SIGNATURE "{0}({1})@{2}"
private static final java.lang.String NAME_SIGNATURE "{0}:-{1}:{2}{3}"
private static final java.lang.String OCCURRENCE_SIGNATURE "{0}:{1}:{2}{3}{4}"
private static final java.lang.String ROLE_SIGNATURE "{0}:{1}"
private static final java.lang.String VARIANT_SIGNATURE "{0}:{1}{2}{3}"

de.topicmapslab.majortom.inmemory.store.revision.readonly.InMemoryReadOnlyAssociation
private static final long serialVersionUID 1L

de.topicmapslab.majortom.inmemory.store.revision.readonly.InMemoryReadOnlyAssociationRole
private static final long serialVersionUID 1L

de.topicmapslab.majortom.inmemory.store.revision.readonly.InMemoryReadOnlyName
private static final long serialVersionUID 1L

de.topicmapslab.majortom.inmemory.store.revision.readonly.InMemoryReadOnlyOccurrence
private static final long serialVersionUID 1L

de.topicmapslab.majortom.inmemory.store.revision.readonly.InMemoryReadOnlyTopic
private static final long serialVersionUID 1L

de.topicmapslab.majortom.inmemory.store.revision.readonly.InMemoryReadOnlyVariant
private static final long serialVersionUID 1L

de.topicmapslab.majortom.inmemory.transaction.InMemoryTransaction
private static final long serialVersionUID 1L

de.topicmapslab.majortom.io.de.topicmapslab.majortom.io.XMLC14NWriter
private static final char _NL 10

de.topicmapslab.majortom.memory.importer.test.CXTMTests
private static final java.lang.String pathToCXTMTestSuite "/home/ch/workspace/cxtm-tests-0.4/"

de.topicmapslab.majortom.redis.store.IRedisTopicMapStoreProperty
public static final java.lang.String REDIS_DATABASE "de.topicmapslab.majortom.redis.database"
public static final java.lang.String REDIS_HOST "de.topicmapslab.majortom.redis.host"
public static final java.lang.String REDIS_PASSWORD "de.topicmapslab.majortom.redis.password"
public static final java.lang.String REDIS_PORT "de.topicmapslab.majortom.redis.port"
public static final java.lang.String REDIS_PREFIX "de.topicmapslab.majortom.redis"

de.topicmapslab.majortom.redis.store.RedisStoreIdentity
private static final long serialVersionUID 1L

de.topicmapslab.majortom.redis.store.RedisTopicMapStore
public static final java.lang.String ASSOCIATION "a"
public static final java.lang.String ASSOCIATION_OF_TOPICMAP "associations"
public static final java.lang.String CHARACTERISTICS "c"
public static final java.lang.String COLON ":"
public static final java.lang.String DATATYPE "d"
public static final java.lang.String EMPTY_SCOPE_ID "s:0"
public static final java.lang.String HASHPOSTFIX "h"
public static final java.lang.String IN_SCOPE ":is"
public static final java.lang.String INSTANCES "i"
public static final java.lang.String ITEM_IDENTIFIER "ii"
public static final java.lang.String LOCATORS "l:"
public static final java.lang.String NAME "n"
public static final java.lang.String OCCURRENCE "o"
public static final java.lang.String PARENT "^"
public static final java.lang.String PLAYED_ASSOCIATION "pa"
public static final java.lang.String PLAYED_ROLE "pr"
public static final java.lang.String PLAYER "p"
public static final java.lang.String REIFIED "~"
public static final java.lang.String REIFIER "~"
public static final java.lang.String ROLE "r"
public static final java.lang.String ROLES_BY_ASSOCTYPE "rba"
public static final java.lang.String SCOPE "s"
public static final java.lang.String SCOPE_COLON "s:"
public static final java.lang.String SCOPED_ASSOCIATIONS "sa"
public static final java.lang.String SCOPED_CHARACTERISTICS "sc"
public static final java.lang.String SCOPED_NAMES "sn"
public static final java.lang.String SCOPED_OCCURRENCES "so"
public static final java.lang.String SCOPED_VARIANTS "sv"
public static final java.lang.String STAR "*"
public static final java.lang.String SUBJECT_IDENTIFIER "si"
public static final java.lang.String SUBJECT_LOCATOR "sl"
public static final java.lang.String SUBTYPES "sb"
public static final java.lang.String SUPERTYPES "sp"
public static final java.lang.String TOPIC "t"
public static final java.lang.String TOPICMAP "topicmap:"
public static final java.lang.String TOPICS_OF_TOPICMAP "topics"
public static final java.lang.String TYPE "t"
public static final java.lang.String TYPED_ASSOCIATIONS "ta"
public static final java.lang.String TYPED_CHARACTERISTICS "tc"
public static final java.lang.String TYPED_NAMES "tn"
public static final java.lang.String TYPED_OCCURRENCES "to"
public static final java.lang.String TYPED_ROLES "tr"
public static final java.lang.String TYPES "t"
public static final java.lang.String VALUE "v"
public static final java.lang.String VARIANT "y"

de.topicmapslab.majortom.redis.store.index.RedisIdentityIndex
private static final java.lang.String INDEX_IS_CLOSED "Index is closed!"
private static final java.lang.String NULL_IS_AN_INVALID_LOCATOR "null is an invalid locator"
private static final java.lang.String NULL_IS_AN_INVALID_REGEX "null is an invalid regex"

de.topicmapslab.majortom.redis.store.index.RedisLiteralIndex
private static final java.lang.String INDEX_IS_CLOSED "Index is closed!"
private static final java.lang.String NULL_IS_AN_INVALID_VALUE "null is an invalid value"
private static final java.lang.String NULL_IS_AN_INVALID_VALUE_AND_OR_DATATYPE "null is an invalid value and/or datatype"

de.topicmapslab.majortom.redis.util.RedisHandler
private static final java.lang.String AUTO_INCREMENT_KEY "id"

de.topicmapslab.majortom.revision.core.ReadOnlyAssociation
private static final long serialVersionUID 357038401235689887L

de.topicmapslab.majortom.revision.core.ReadOnlyAssociationRole
private static final long serialVersionUID -5884008938129512777L

de.topicmapslab.majortom.revision.core.ReadOnlyConstruct
private static final long serialVersionUID -1867711896100911001L

de.topicmapslab.majortom.revision.core.ReadOnlyDatatypeAware
private static final long serialVersionUID -4773239352132505678L

de.topicmapslab.majortom.revision.core.ReadOnlyName
private static final long serialVersionUID 6247793655024874694L

de.topicmapslab.majortom.revision.core.ReadOnlyOccurrence
private static final long serialVersionUID 7622385720655993107L

de.topicmapslab.majortom.revision.core.ReadOnlyReifiable
private static final long serialVersionUID 4210842121389259750L

de.topicmapslab.majortom.revision.core.ReadOnlyScopable
private static final long serialVersionUID 7905827035691626710L

de.topicmapslab.majortom.revision.core.ReadOnlyTopic
private static final long serialVersionUID 8392859869889486513L

de.topicmapslab.majortom.revision.core.ReadOnlyVariant
private static final long serialVersionUID 886824371721326354L

de.topicmapslab.majortom.store.TopicMapStoreProperty
public static final java.lang.String INITIAL_COLLECTION_CAPACITY "de.topicmapslab.majortom.collection.capacity"
public static final java.lang.String MAP_IMPLEMENTATION_CLASS "de.topicmapslab.majortom.collection.map"
public static final java.lang.String PREFIX "de.topicmapslab.majortom"
public static final java.lang.String SET_IMPLEMENTATION_CLASS "de.topicmapslab.majortom.collection.set"
public static final java.lang.String THREADPOOL_MAXIMUM "de.topicmapslab.majortom.threadpool.maximum"
public static final java.lang.String TOPICMAPSTORE_CLASS "de.topicmapslab.majortom.topicmapstore.class"

de.topicmapslab.majortom.tests.MaJorToMTestCase
protected static final java.lang.String BASE "http://psi.majortom.test/newTopicMap"

de.topicmapslab.majortom.transaction.TransactionImpl
private static final long serialVersionUID 1L

de.topicmapslab.majortom.util.BestLabelUtils
private static final java.lang.String ID_PREFIX "id:"
protected static final java.lang.String ITEMIDENTIFIER_PREFIX "ii:"
protected static final java.lang.String SUBJECTIDENTIFIER_PREFIX "si:"
protected static final java.lang.String SUBJECTLOCATOR_PREFIX "sl:"

de.topicmapslab.majortom.util.FeatureStrings
public static final java.lang.String AUTOMATIC_MERGING "http://tmapi.org/features/automerge"
public static final java.lang.String CONCURRENT_COLLECTIONS "de.topicmapslab.majortom.collection.concurrent"
public static final java.lang.String CONSTRAINTS "de.topicmapslab.majortom.constraints"
public static final java.lang.String DELETION_CONSTRAINTS "de.topicmapslab.majortom.constraints.deletion"
public static final java.lang.String DELETION_CONSTRAINTS_REIFICATION "de.topicmapslab.majortom.constraints.deletion.reification"
public static final java.lang.String ENABLE_CACHING "de.topicmapslab.majortom.topicmapstore.caching"
public static final java.lang.String LOCATOR_ADDRESS_NOTATION_FEATURE_URI_NOTATION "http://tmapi.org/features/notation/URI/"
public static final java.lang.String LOCATOR_ADDRESS_NOTATION_FEATURES "http://tmapi.org/features/notation/"
private static final java.lang.String MAJORTOM_PREFIX "de.topicmapslab.majortom"
public static final java.lang.String MERGING_SUPPORT_FEATURE_BY_TOPIC_NAME "http://tmapi.org/features/merge/byTopicName/"
public static final java.lang.String MERGING_SUPPORT_FEATURES "http://tmapi.org/features/merge/"
public static final java.lang.String READ_ONLY_SYSTEM "http://tmapi.org/features/readOnly"
public static final java.lang.String SUPPORT_HISTORY "de.topicmapslab.majortom.topicmapstore.history"
public static final java.lang.String SUPPORT_TRANSACTION "de.topicmapslab.majortom.topicmapstore.transaction"
public static final java.lang.String TOPIC_MAPS_MODEL_FEATURE_XTM_1_0_MODEL "http://tmapi.org/features/model/xtm1.0/"
public static final java.lang.String TOPIC_MAPS_MODEL_FEATURE_XTM_1_1_MODEL "http://tmapi.org/features/model/xtm1.1/"
public static final java.lang.String TOPIC_MAPS_MODEL_FEATURES "http://tmapi.org/features/model/"
public static final java.lang.String TOPIC_MAPS_SUPERTYPE_SUBTYPE_ASSOCIATION "http://tmapi.org/features/supertype-subtype-associations"
public static final java.lang.String TOPIC_MAPS_TYPE_INSTANCE_ASSOCIATION "http://tmapi.org/features/type-instance-associations"

de.topicmapslab.majortom.util.XmlSchemeDatatypes
private static final java.lang.String COLON ":"