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 DH2TableHandler.java53 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 DDB2TableHandler.java58 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 DGenericTableHandler.java85 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 DOracleTableHandler.java112 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 DPostgreSQLTableHandler.java135 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 DMSSQLTableHandler.java73 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 DTableQueries.java158 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