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 D | DB2TableHandler.java | 55 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 D | GenericTableHandler.java | 96 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 D | H2TableHandler.java | 50 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 D | MSSQLTableHandler.java | 70 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 D | PostgreSQLTableHandler.java | 131 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 D | OracleTableHandler.java | 74 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 D | TableQueries.java | 57 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