public boolean condition(Object value, Validator validator,
String fieldName, Map<String, Object> record, DataSource ds,
RPCManager rpcManager) throws Exception {
Map<String, Object> dbValues = new HashMap<String, Object>();
if (record.get(ds.getPrimaryKey()) != null) {
dbValues = ds.fetchById(record.get(ds.getPrimaryKey()));
}
List<String> fieldsToCheck = new ArrayList<String>();
fieldsToCheck.add(fieldName);
if (validator.getObjectProperty("additionalUniqueField") instanceof String)
fieldsToCheck.add(validator.getProperty("additionalUniqueField"));
else if (validator.getObjectProperty("additionalUniqueField") instanceof List) {
Iterator<String> itr = validator.getListProperty(
"additionalUniqueField").listIterator();
while (itr.hasNext()) {
String additionalColumn = itr.next();
fieldsToCheck.add(additionalColumn);
}
}
List<Criterion> criterions = new ArrayList<Criterion>();
Iterator<String> itr = fieldsToCheck.listIterator();
while (itr.hasNext()) {
String columnToCheck = itr.next();
if (record.containsKey(columnToCheck))
criterions.add(new SimpleCriterion(columnToCheck,
DefaultOperators.Equals, record.get(columnToCheck)));
else
criterions.add(new SimpleCriterion(columnToCheck,
DefaultOperators.Equals, dbValues.get(columnToCheck)));
}
final AdvancedCriteria ac = new AdvancedCriteria(DefaultOperators.And,
criterions.toArray(new Criterion[] {}));
DSRequest request = new DSRequest(ds.getName(), DataSource.OP_FETCH,
rpcManager);
request.setAdvancedCriteria(ac);
DSResponse response = request.execute();
/*
* Now we got the element count with the values. Now two possibilities:
* Add -> We want a 0-count. Update -> We want either a 0-count or the
* same PK as before.
*/
if (response.getTotalRows() == 0) {
return true;
} else if (response.getTotalRows() >= 2) {
return false;
} else {
/*
* Check for changed PK: If no old PK (=Add) and we find a row
* nevertheless, the Add would fail. The good case is handled above
* (at "resp.getTotalRows() == 0").
*/
if (record.get(ds.getPrimaryKey()) == null) {
return false;
}
/* Compare old and new value (in case of an update). */
BigDecimal oldvalue = BigDecimal.valueOf((Long) record.get(ds
.getPrimaryKey()));
BigDecimal newvalue = (BigDecimal) response.getDataMap().get(
ds.getPrimaryKey());
boolean isSameRow = oldvalue.compareTo(newvalue) == 0;
return isSameRow;
}
}
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import com.isomorphic.criteria.AdvancedCriteria;
import com.isomorphic.criteria.Criterion;
import com.isomorphic.criteria.DefaultOperators;
import com.isomorphic.criteria.criterion.SimpleCriterion;
import com.isomorphic.datasource.DSRequest;
import com.isomorphic.datasource.DSResponse;
import com.isomorphic.datasource.DataSource;
import com.isomorphic.datasource.Validator;
import com.isomorphic.log.Logger;
public class ValidatorUniqueManyColumns {
Logger log = new Logger("com.isomorphic." + ValidatorUniqueManyColumns.class.getName());
public boolean condition(Object value, Validator validator, String fieldName, Map<String, Object> record, DataSource ds) throws Exception {
// We have additional values we need to check. These can - but most likely
// are not - in "values".
// Therefore we need to get them from the DB with the current PK.
@SuppressWarnings("unchecked")
Map<String, Object> dbValues = ds.fetchById(record.get(ds.getPrimaryKey()));
// The Multiple Unique Validator can validate uniqueness for one or many
// additional Columns.
// If it is one column, the type is String, otherwise it's List. We unify.
List<String> fieldsToCheck = new ArrayList<String>();
// The field we call the validator for
fieldsToCheck.add(fieldName);
if (validator.getObjectProperty("additionalUniqueField") instanceof String)
fieldsToCheck.add(validator.getProperty("additionalUniqueField"));
else if (validator.getObjectProperty("additionalUniqueField") instanceof List) {
@SuppressWarnings("unchecked")
Iterator<String> itr = validator.getListProperty("additionalUniqueField").listIterator();
while (itr.hasNext()) {
String additionalColumn = itr.next();
fieldsToCheck.add(additionalColumn);
}
}
// Now we have the fieldname to validate as well as all other fieldnames
// We build a list of Criterion that we'll feed to AdvancedCriteria later
// on. The values are taken either from record or from the DB.
ArrayList<Criterion> a = new ArrayList<Criterion>();
Iterator<String> itr = fieldsToCheck.listIterator();
while (itr.hasNext()) {
String columnToCheck = itr.next();
if (record.containsKey(columnToCheck))
// Taken from sent record
a.add(new SimpleCriterion(columnToCheck, DefaultOperators.Equals, record.get(columnToCheck)));
else
// Taken from DB
a.add(new SimpleCriterion(columnToCheck, DefaultOperators.Equals, dbValues.get(columnToCheck)));
}
Criterion[] myArray = new Criterion[a.size()];
final AdvancedCriteria ac = new AdvancedCriteria(DefaultOperators.And, a.toArray(myArray));
DSRequest r = new DSRequest(ds.getName(), DataSource.OP_FETCH) {
{
setAdvancedCriteria(ac);
}
};
DSResponse resp = r.execute();
// Now we got the element count with the values.
// Now two possibilities:
// Add -> We want a 0-count.
// Update -> We want either a 0-count or the same PK as before
if (resp.getTotalRows() == 0)
return true;
else if (resp.getTotalRows() >= 2)
return false;
else {
// Check for changed PK:
// If no old PK (=Add) and we find a row nevertheless, the Add would fail.
// The good case is handled above (at "resp.getTotalRows() == 0")
if (record.get(ds.getPrimaryKey()) == null)
return false;
// Compare old and new value (in case of an update)
BigDecimal oldvalue = BigDecimal.valueOf((Long) record.get(ds.getPrimaryKey()));
@SuppressWarnings("rawtypes")
BigDecimal newvalue = (BigDecimal) ((Map) resp.getRecords().get(0)).get(ds.getPrimaryKey());
boolean isSameRow = oldvalue.compareTo(newvalue) == 0;
return isSameRow;
}
}
};
<field name="POSITION" type="integer" required="true" editorType="SpinnerItem"> <validators> <validator type="serverCustom"> <serverObject lookupStyle="new" className="com.mycompany.myproj.server.worker.validator.ValidatorUniqueManyColumns" /> <additionalUniqueField>TYPE</additionalUniqueField> <errorMessage>Jede Position darf nur einmal vorkommen!</errorMessage> </validator> <validator type="integerRange" min="1" max="100" errorMessage="Bitte Sie eine Position zwischen 1 und 100 aus!" /> </validators> </field>
Leave a comment: