/**
* Modifies a record in the Database Server using the provided modify request.
*
* @param request The modify request.
* @return The result of the operation.
* @throws ErrorResultException If the result code indicates that the request failed for some
* reason.
* @throws SQLException If the SQL query has an invalid format.
* @throws NullPointerException If {@code request} was {@code null}, or if a corresponding mapping
* value could not be found in the mapping component.
*/
@Override
public Result modify(final ModifyRequest request) {
Result r;
try {
// Split up the DN the of the request.
final DN DN = request.getName();
final RDN rDN = DN.rdn();
final String filterAttributeName = rDN.getFirstAVA().getAttributeType().getNameOrOID();
final String filterAttributeValue = rDN.getFirstAVA().getAttributeValue().toString();
final RDN OU = DN.parent(1).rdn();
final String OUName = OU.getFirstAVA().getAttributeValue().toString();
final String baseDN = DN.parent(2).toString();
// Search mapping for the corresponding table and column names.
final String tableName = jdbcm.getTableNameFromMapping(baseDN, OUName);
if (tableName == null)
throw new NullPointerException(
"JDBC Error: Could not find matching table name for OU: '"
+ OUName
+ "' in DN: '"
+ baseDN
+ "'. Please check if mapping was succesful.");
final String columnName =
jdbcm.getColumnNameFromMapping(tableName, baseDN, OUName, filterAttributeName);
if (columnName == null)
throw new NullPointerException(
"JDBC Error: Could not find matching column name for attribute: '"
+ filterAttributeName
+ "'. Please check if mapping was succesful.");
// Get attribute and modificationtype for each modification.
// Search mapping for the corresponding column name for the modification attribute.
final List<Modification> modificationList = request.getModifications();
final ListIterator<Modification> listIter = modificationList.listIterator();
String modificationString = "";
while (listIter.hasNext()) {
final Modification modification = listIter.next();
final ModificationType modificationType = modification.getModificationType();
final Attribute modificationAttribute = modification.getAttribute();
final String modificationAttributeName =
modificationAttribute.getAttributeDescription().toString();
final String modificationColumnName =
jdbcm.getColumnNameFromMapping(tableName, baseDN, OUName, modificationAttributeName);
if (modificationColumnName == null)
throw new NullPointerException(
"JDBC Error: Could not find matching column name for attribute: '"
+ modificationAttributeName
+ "'. Please check if mapping was succesful.");
String modificationAttributeValue = "";
if (modificationType == ModificationType.ADD) {
final Iterator<ByteString> iter = modificationAttribute.iterator();
int counter = 0;
while (iter.hasNext()) {
if (counter > 0) modificationAttributeValue = modificationAttributeValue.concat(", ");
modificationAttributeValue = modificationAttributeValue.concat(iter.next().toString());
counter++;
}
final Object classType = jdbcm.getTableColumnDataType(tableName, modificationColumnName);
if (classType == Integer.class)
modificationAttributeValue =
"(CASE WHEN ("
+ modificationColumnName
+ " = 0) THEN ' "
+ modificationAttributeValue
+ "' ELSE concat("
+ modificationColumnName
+ ", ', "
+ modificationAttributeValue
+ "') END)";
else
modificationAttributeValue =
"(CASE WHEN ("
+ modificationColumnName
+ " = 'Default Value') THEN ' "
+ modificationAttributeValue
+ "' ELSE concat("
+ modificationColumnName
+ ", ', "
+ modificationAttributeValue
+ "') END)";
} else if (modificationType == ModificationType.REPLACE) {
final Iterator<ByteString> iter = modificationAttribute.iterator();
while (iter.hasNext()) {
modificationAttributeValue = "'" + iter.next().toString() + "'";
}
} else {
final boolean nullable = jdbcm.getTableColumnNullable(tableName, modificationColumnName);
if (nullable == false)
throw new SQLException("Cannot delete data from not-nullable column.");
final Object classType = jdbcm.getTableColumnDataType(tableName, modificationColumnName);
if (classType == Integer.class)
modificationAttributeValue = "'" + Integer.toString(0) + "'";
else modificationAttributeValue = "'Default Value'";
}
modificationString =
modificationString.concat(
modificationColumnName + "=" + modificationAttributeValue + ", ");
}
modificationString = modificationString.substring(0, modificationString.length() - 2);
// Build the SQL query.
final Statement st = connection.createStatement();
final String sql =
"UPDATE "
+ tableName
+ " SET "
+ modificationString
+ " WHERE "
+ columnName
+ "='"
+ filterAttributeValue
+ "'";
st.executeUpdate(sql);
r = Responses.newResult(ResultCode.SUCCESS);
} catch (SQLException e) {
System.out.println(e.toString());
r = Responses.newResult(ResultCode.OPERATIONS_ERROR);
r.setCause(e);
} catch (NullPointerException e) {
System.out.println(e.toString());
r = Responses.newCompareResult(ResultCode.OPERATIONS_ERROR);
r.setCause(e);
}
return r;
}
