Searched refs:QueryDefinition (Results 1 - 7 of 7) sorted by relevance

/forgerock/openidm-v4/openidm-repo-jdbc/src/main/java/org/forgerock/openidm/repo/jdbc/impl/
H A DDB2TableHandler.java55 protected Map<QueryDefinition, String> initializeQueryMap() {
56 Map<QueryDefinition, String> result = super.initializeQueryMap();
63 QueryDefinition.READFORUPDATEQUERYSTR,
71 result.put(QueryDefinition.DELETEQUERYSTR, "DELETE FROM " + mainTable + " obj WHERE EXISTS (SELECT 1 FROM " + typeTable + " objtype WHERE obj.objecttypes_id = objtype.id AND objtype.objecttype = ?) AND obj.objectid = ? AND obj.rev = ?");
73 result.put(QueryDefinition.PROPDELETEQUERYSTR, "DELETE FROM " + propertyTable + " WHERE " + mainTableName + "_id = (SELECT obj.id FROM " + mainTable + " obj, " + typeTable + " objtype WHERE obj.objecttypes_id = objtype.id AND objtype.objecttype = ? AND obj.objectid = ?)");
H A DGenericTableHandler.java96 Map<QueryDefinition, String> queryMap;
101 public enum QueryDefinition { enum in class:GenericTableHandler
179 protected Map<QueryDefinition, String> initializeQueryMap() {
180 Map<QueryDefinition, String> result = new EnumMap<QueryDefinition, String>(QueryDefinition.class);
187 result.put(QueryDefinition.CREATETYPEQUERYSTR, "INSERT INTO " + typeTable + " (objecttype) VALUES (?)");
188 result.put(QueryDefinition.READTYPEQUERYSTR, "SELECT id FROM " + typeTable + " objtype WHERE objtype.objecttype = ?");
191 result.put(QueryDefinition.READFORUPDATEQUERYSTR, "SELECT obj.* FROM " + mainTable + " obj INNER JOIN " + typeTable + " objtype ON obj.objecttypes_id = objtype.id AND objtype.objecttype = ? WHERE obj.objectid = ? FOR UPDATE");
192 result.put(QueryDefinition
[all...]
H A DH2TableHandler.java50 protected Map<QueryDefinition, String> initializeQueryMap() {
51 Map<QueryDefinition, String> result = super.initializeQueryMap();
56 result.put(QueryDefinition.PROPDELETEQUERYSTR, "DELETE FROM " + propertyTable + " WHERE " + mainTableName + "_id IN (SELECT obj.id FROM " + mainTable + " obj INNER JOIN " + typeTable + " objtype ON obj.objecttypes_id = objtype.id WHERE objtype.objecttype = ? AND obj.objectid = ?)");
H A DMSSQLTableHandler.java70 protected Map<QueryDefinition, String> initializeQueryMap() {
71 Map<QueryDefinition, String> result = super.initializeQueryMap();
77 QueryDefinition.READFORUPDATEQUERYSTR,
84 result.put(QueryDefinition.UPDATEQUERYSTR,
122 updateStatement = getPreparedStatement(connection, QueryDefinition.UPDATEQUERYSTR);
123 deletePropStatement = getPreparedStatement(connection, QueryDefinition.PROPDELETEQUERYSTR);
H A DPostgreSQLTableHandler.java131 protected Map<QueryDefinition, String> initializeQueryMap() {
132 Map<QueryDefinition, String> result = super.initializeQueryMap();
138 result.put(QueryDefinition.UPDATEQUERYSTR, "UPDATE " + mainTable + " SET objectid = ?, rev = ?, fullobject = ?::json WHERE id = ?");
139 result.put(QueryDefinition.CREATEQUERYSTR, "INSERT INTO " + mainTable + " (objecttypes_id, objectid, rev, fullobject) VALUES (?,?,?,?::json)");
140 result.put(QueryDefinition.DELETEQUERYSTR, "DELETE FROM " + mainTable + " obj USING " + typeTable + " objtype WHERE obj.objecttypes_id = objtype.id AND objtype.objecttype = ? AND obj.objectid = ? AND obj.rev = ?");
141 result.put(QueryDefinition.PROPDELETEQUERYSTR, "DELETE FROM " + propertyTable + " WHERE " + mainTableName + "_id IN (SELECT obj.id FROM " + mainTable + " obj INNER JOIN " + typeTable + " objtype ON obj.objecttypes_id = objtype.id WHERE objtype.objecttype = ? AND obj.objectid = ?)");
H A DOracleTableHandler.java74 createStatement = queries.getPreparedStatement(connection, queryMap.get(QueryDefinition.CREATEQUERYSTR), generatedColumns);
109 protected Map<QueryDefinition, String> initializeQueryMap() {
110 Map<QueryDefinition, String> result = super.initializeQueryMap();
117 result.put(QueryDefinition.DELETEQUERYSTR, "DELETE FROM " + mainTable + " obj WHERE EXISTS (SELECT 1 FROM " + typeTable + " objtype WHERE obj.objecttypes_id = objtype.id AND objtype.objecttype = ?) AND obj.objectid = ? AND obj.rev = ?");
118 result.put(QueryDefinition.PROPDELETEQUERYSTR, "DELETE FROM " + propertyTable + " WHERE " + mainTableName + "_id = (SELECT obj.id FROM " + mainTable + " obj, " + typeTable + " objtype WHERE obj.objecttypes_id = objtype.id AND objtype.objecttype = ? AND obj.objectid = ?)");
/forgerock/openidm-v4/openidm-repo-jdbc/src/main/java/org/forgerock/openidm/repo/jdbc/impl/query/
H A DTableQueries.java57 import org.forgerock.openidm.repo.jdbc.impl.GenericTableHandler.QueryDefinition;
603 JsonValue queriesConfig, JsonValue commandsConfig, Map<QueryDefinition, String> defaultQueryMap) {
632 JsonValue queriesConfig, JsonValue commandsConfig, Map<QueryDefinition, String> defaultQueryMap) {
641 Map<QueryDefinition, String> defaultQueryMap) {
652 queriesConfig.put(ServerConstants.QUERY_ALL_IDS, defaultQueryMap.get(QueryDefinition.QUERYALLIDS));

Completed in 40 milliseconds