private String loadPropertyValueQuery() { return loadSQLFile("loadPropertyValuesForResource.sql"); }
private String loadRelationPropertyTypeValueQuery() { return loadSQLFile("loadPropertyValuesForResourceTypeRelation.sql"); }
private String loadPropertyTypeValueQuery() {return loadSQLFile("loadPropertyValuesForResourceType.sql"); }
private String loadRelationPropertyValueQuery(String resourceRelationTableName, String resourceRelationFKName) { String template = loadSQLFile("loadPropertyValuesForResourceRelation.sql"); template = String.format(template, resourceRelationTableName, resourceRelationFKName); return template; }
private String loadRelationPropertyDescriptorQuery(String resourceRelationTableName, String resourceRelationFKName) { String template = loadSQLFile("loadPropertyDescriptorsForResource.sql"); template = String.format(template, resourceRelationTableName, resourceRelationFKName, loadPropertyValuesForRelation(resourceRelationTableName, resourceRelationFKName)); return template; }
private String loadPropertyDescriptorQuery() { String template = loadSQLFile("loadPropertyDescriptorsForResource.sql"); //We use consumed rel table as a default (for this case, no relation ids will be provided, therefore property descriptors on relations are not considered) template = String.format(template, CONSUMEDRESRELTABLE, CONSUMEDRESRELFK, loadPropertyValueQuery()); return template; }
public Query getPropertyValueForResourceType(List<Integer> resourceTypeIds, List<Integer> contextIds) { String template = loadSQLFile("loadPropertyDescriptorsForResourceType.sql"); template = String.format(template, loadPropertyTypeValueQuery()); Query query = entityManager.createNativeQuery(template); query.setParameter("loadedFor", Origin.TYPE.name()) .setParameter("resourceTypeIds", resourceTypeIds) .setParameter("contextIds", contextIds) .setParameter("masterResourceTypeIds", Arrays.asList(-1)) ; return query; }
public Query getPropertyValueForResourceTypeRelationQuery(List<Integer> masterResourceTypeIds, List<Integer> relatedResourceTypeIds, List<Integer> contextIds) { String template = loadSQLFile("loadPropertyDescriptorsForResourceType.sql"); template = String.format(template, loadPropertyTypeValuesForRelation()); Query query = entityManager.createNativeQuery(template); query.setParameter("loadedFor", Origin.TYPE_REL.name()) .setParameter("resourceTypeIds", relatedResourceTypeIds) .setParameter("contextIds", contextIds) .setParameter("masterResourceTypeIds", masterResourceTypeIds); return query; }