public String makeWhereString(final ModelEntity modelEntity, final List entityConditionParams) { return condition.makeWhereString(modelEntity, entityConditionParams); }
/** * Returns the number of SQL parameters that would be generated for this condition. * * @param modelEntity the entity being queried for (required) * @return the number of SQL parameters. */ public int getParameterCount(ModelEntity modelEntity) { List<EntityConditionParam> paramList = new ArrayList<EntityConditionParam>(); makeWhereString(modelEntity, paramList); return paramList.size(); } }
public String makeWhereString(ModelEntity modelEntity, List entityConditionParams) { // if (Debug.verboseOn()) Debug.logVerbose("makeWhereString for entity " + modelEntity.getEntityName()); StringBuffer whereStringBuffer = new StringBuffer(); if (conditionList != null && conditionList.size() > 0) { for (int i = 0; i < conditionList.size(); i++) { EntityCondition condition = (EntityCondition) conditionList.get(i); whereStringBuffer.append('('); whereStringBuffer.append(condition.makeWhereString(modelEntity, entityConditionParams)); whereStringBuffer.append(')'); if (i < conditionList.size() - 1) { whereStringBuffer.append(' '); whereStringBuffer.append(operator.getCode()); whereStringBuffer.append(' '); } } } return whereStringBuffer.toString(); }
public String makeWhereString(ModelEntity modelEntity, List<? super EntityConditionParam> entityConditionParams) { // if (Debug.verboseOn()) Debug.logVerbose("makeWhereString for entity " + modelEntity.getEntityName()); StringBuilder whereStringBuilder = new StringBuilder(); if (conditionList != null && conditionList.size() > 0) { for (int i = 0; i < conditionList.size(); i++) { EntityCondition condition = conditionList.get(i); whereStringBuilder.append('('); whereStringBuilder.append(condition.makeWhereString(modelEntity, entityConditionParams)); whereStringBuilder.append(')'); if (i < conditionList.size() - 1) { whereStringBuilder.append(' '); whereStringBuilder.append(operator.getCode()); whereStringBuilder.append(' '); } } } return whereStringBuilder.toString(); }
public String makeWhereString(ModelEntity modelEntity, List entityConditionParams) { // if (Debug.verboseOn()) Debug.logVerbose("makeWhereString for entity " + modelEntity.getEntityName()); StringBuffer whereStringBuffer = new StringBuffer(); if (conditionList != null && conditionList.size() > 0) { for (int i = 0; i < conditionList.size(); i++) { EntityCondition condition = (EntityCondition) conditionList.get(i); whereStringBuffer.append('('); whereStringBuffer.append(condition.makeWhereString(modelEntity, entityConditionParams)); whereStringBuffer.append(')'); if (i < conditionList.size() - 1) { whereStringBuffer.append(' '); whereStringBuffer.append(operator.getCode()); whereStringBuffer.append(' '); } } } return whereStringBuffer.toString(); }
private Predicate<GenericValue> getPredicateFor(final EntityCondition entityCondition) { if (entityCondition instanceof EntityFieldMap) { return getPredicateForEntityFieldMap((EntityFieldMap) entityCondition); } if (entityCondition instanceof EntityExpr) { return getPredicateForEntityExpr((EntityExpr) entityCondition); } if (entityCondition instanceof EntityConditionList) { return getPredicateForEntityConditionList((EntityConditionList) entityCondition); } if (entityCondition instanceof EntityWhereString && StringUtils.isEmpty(entityCondition.makeWhereString(null, null))) { return Predicates.alwaysTrue(); } throw new UnsupportedOperationException("Mock cannot yet handle EntityCondition of type " + entityCondition.getClass()); }
String entityCondWhereString = ""; if (whereEntityCondition != null) { entityCondWhereString = whereEntityCondition.makeWhereString(modelEntity, whereEntityConditionParams); entityCondHavingString = havingEntityCondition.makeWhereString(modelEntity, havingEntityConditionParams);
whereStringBuffer.append(((EntityCondition) lhs).makeWhereString(modelEntity, entityConditionParams)); whereStringBuffer.append(") "); whereStringBuffer.append(this.getOperator().toString()); whereStringBuffer.append(" ("); whereStringBuffer.append(((EntityCondition) rhs).makeWhereString(modelEntity, entityConditionParams)); whereStringBuffer.append(')');
whereStringBuilder.append(((EntityCondition) lhs).makeWhereString(modelEntity, entityConditionParams)); whereStringBuilder.append(") "); whereStringBuilder.append(this.getOperator().toString()); whereStringBuilder.append(" ("); whereStringBuilder.append(((EntityCondition) rhs).makeWhereString(modelEntity, entityConditionParams)); whereStringBuilder.append(')');
whereStringBuffer.append(((EntityCondition) lhs).makeWhereString(modelEntity, entityConditionParams)); whereStringBuffer.append(") "); whereStringBuffer.append(this.getOperator().toString()); whereStringBuffer.append(" ("); whereStringBuffer.append(((EntityCondition) rhs).makeWhereString(modelEntity, entityConditionParams)); whereStringBuffer.append(')');
entityCondWhereString = whereEntityCondition.makeWhereString(modelEntity, whereEntityConditionParams); entityCondHavingString = havingEntityCondition.makeWhereString(modelEntity, havingEntityConditionParams);
entityCondWhereString = whereEntityCondition.makeWhereString(modelEntity, whereEntityConditionParams); entityCondHavingString = havingEntityCondition.makeWhereString(modelEntity, havingEntityConditionParams);
public int deleteByCondition(ModelEntity modelEntity, EntityCondition whereCondition) throws GenericEntityException { if (modelEntity == null) { throw new GenericModelException("Could not find ModelEntity record for entityName: " + modelEntity.getEntityName()); } if (modelEntity instanceof ModelViewEntity) { throw new org.ofbiz.core.entity.GenericNotImplementedException("Operation delete not supported yet for view entities"); } String whereClause = ""; final List<EntityConditionParam> whereConditionParams = Lists.newLinkedList(); if (whereCondition != null) { whereClause = " WHERE " + whereCondition.makeWhereString(modelEntity, whereConditionParams); } String sql = "DELETE FROM " + modelEntity.getTableName(datasourceInfo) + whereClause; SQLProcessor sqlP = new AutoCommitSQLProcessor(helperName); int retVal; try { sqlP.prepareStatement(sql); if (whereCondition != null) { for (EntityConditionParam param : whereConditionParams) { SqlJdbcUtil.setValue(sqlP, param.getModelField(), modelEntity.getEntityName(), param.getFieldValue(), modelFieldTypeReader); } } retVal = sqlP.executeUpdate(); } finally { closeSafely(sql, sqlP); } return retVal; }
entityCondWhereString = entityCondition.makeWhereString(modelEntity, whereEntityConditionParams);