Searched refs:mainTableName (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 | H2TableHandler.java | 53 String mainTable = dbSchemaName == null ? mainTableName : dbSchemaName + "." + mainTableName; 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 | DB2TableHandler.java | 58 String mainTable = dbSchemaName == null ? mainTableName : dbSchemaName + "." + mainTableName; 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 | 85 final String mainTableName; field in class:GenericTableHandler 139 this.mainTableName = cfg.mainTableName; 154 queries = new TableQueries(this, mainTableName, propTableName, dbSchemaName, getSearchableLength(), new GenericQueryResultMapper()); 183 String mainTable = dbSchemaName == null ? mainTableName : dbSchemaName + "." + mainTableName; 198 deleteQueryStr = "DELETE FROM " + dbSchemaName + "." + mainTableName + " obj WHERE EXISTS (SELECT 1 FROM " + dbSchemaName + ".objecttypes objtype WHERE obj.objecttypes_id = objtype.id AND objtype.objecttype = ?) AND obj.objectid = ? AND obj.rev = ?"; 202 result.put(QueryDefinition.PROPCREATEQUERYSTR, "INSERT INTO " + propertyTable + " ( " + mainTableName + "_id, propkey, proptype, propvalue) VALUES (?,?,?,?)"); 203 result.put(QueryDefinition.PROPDELETEQUERYSTR, "DELETE prop FROM " + propertyTable + " prop INNER JOIN " + mainTable + " obj ON prop." + mainTableName + "_id = obj.id INNER JOIN " + typeTable + " objtype ON obj.objecttypes_id = objtype.id WHERE objtype.objecttype = ? AND obj.objectid = ?"); 663 return "Generic handler mapped to [" + mainTableName 804 public String mainTableName; field in class:GenericTableConfig 848 public String mainTableName; field in class:GenericPropertiesConfig [all...] |
H A D | OracleTableHandler.java | 112 String mainTable = dbSchemaName == null ? mainTableName : dbSchemaName + "." + mainTableName; 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 = ?)");
|
H A D | PostgreSQLTableHandler.java | 135 String mainTable = dbSchemaName == null ? mainTableName : dbSchemaName + "." + mainTableName; 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 | MSSQLTableHandler.java | 73 String mainTable = dbSchemaName == null ? mainTableName : dbSchemaName + "." + mainTableName;
|
/forgerock/openidm-v4/openidm-repo-jdbc/src/main/java/org/forgerock/openidm/repo/jdbc/impl/query/ |
H A D | TableQueries.java | 158 final String mainTableName; field in class:TableQueries 173 * @param mainTableName 179 public TableQueries(TableHandler tableHandler, String mainTableName, String propTableName, String dbSchemaName, int maxPropLen, argument 182 this.mainTableName = mainTableName; 451 replacements.put("_mainTable", mainTableName); 605 replacements.put("_mainTable", mainTableName);
|
Completed in 27 milliseconds