@RequestMapping(value = "/data", method = GET)
@ResponseBody
public Map<String, Object> data(@RequestParam("dsId") JdbcOeDataSource ds, WebRequest request)
throws ErrorMessageException, OeDataSourceAccessException {
JdbcOeDataEntrySource jdes = (JdbcOeDataEntrySource) ds;
DbKeyValMap dbKeyValMap = new DbKeyValMap();
String doNotParseKeys = request.getParameter("doNotParseKeys");
if (doNotParseKeys == null || !doNotParseKeys.equalsIgnoreCase("true")) {
dbKeyValMap = ControllerUtils.parseKeyValueMap(jdes, request.getParameterMap());
}
// retrieve existing record and children
CompleteRecord completeRecord =
jdes.getCompleteRecord(
dbKeyValMap, new ArrayList<String>(jdes.getChildTableMap().keySet()));
Map<String, Object> data =
ControllerUtils.mapDataAndFormatTimeForResponse(
completeRecord.getParentRecord().getValues().keySet(),
completeRecord.getParentRecord().getValues());
// Children
for (ChildRecordSet childRecordSet : completeRecord.getChildrenRecordSets()) {
List<Object> childRecords = new ArrayList<Object>();
for (TableAwareQueryRecord tableAwareQueryRecord : childRecordSet.getChildRecords()) {
childRecords.add(
ControllerUtils.mapDataAndFormatTimeForResponse(
tableAwareQueryRecord.getValues().keySet(), tableAwareQueryRecord.getValues()));
}
data.put(childRecordSet.getChildTableName(), childRecords);
}
return data;
}
@RequestMapping(
value = "/update",
method = {POST, PUT})
@ResponseBody
public Map<String, Object> update(
@RequestParam("dsId") JdbcOeDataSource ds,
WebRequest request,
HttpServletRequest servletRequest)
throws ErrorMessageException, OeDataSourceAccessException, IOException {
JdbcOeDataEntrySource jdes = (JdbcOeDataEntrySource) ds;
// find primary keys for record
DbKeyValMap dbKeyValMap = ControllerUtils.parseKeyValueMap(jdes, request.getParameterMap());
// retrieve existing record and children
CompleteRecord completeRecord =
jdes.getCompleteRecord(
dbKeyValMap, new ArrayList<String>(jdes.getChildTableMap().keySet()));
// Option to only update parameter values on the completeRecord that
// are included as part of the request (when merge parameter is true)
// Defaults to false (nullify parameter values not included on request)
boolean merge = Boolean.valueOf(request.getParameter("merge"));
// parent record's values are replaced with request param values
for (String field : completeRecord.getParentRecord().getValues().keySet()) {
String parameter = request.getParameter(field);
TableAwareQueryRecord parentRecord = completeRecord.getParentRecord();
if (parameter != null) {
parentRecord
.getValues()
.putAll(
ControllerUtils.formatData(
field,
parameter,
parentRecord.getEditDimensions().get(field).getSqlType(),
dbKeyValMap.keySet().contains(field)));
} else if (!merge) {
// NEEDS additional flags for data sources using default input panels
// nullify parameter values on the complete record, if it is an edit dimension
parentRecord.getValues().put(field, null);
}
}
// remove existing children
for (ChildRecordSet childRecordSet : completeRecord.getChildrenRecordSets()) {
childRecordSet.removeAllChildRecords();
}
completeRecord.setChildrenRecordSets(
ControllerUtils.getChildRecordSets(jdes, servletRequest, false));
jdes.updateCompleteRecord(dbKeyValMap, completeRecord);
Map<String, Object> data = data(ds, request); // new HashMap<String, Object>();
data.put("success", true);
return data; // TODO return RESTful response, i.e. data actually updated
}
/**
* Add record to the database with the provided values. Response should be a JSON formatted
* collection with #success and #record fields indicating status of request and generated keys (if
* appropriate) for new record.
*
* @param ds data source to be updated
* @param request request object containing parameters such as data source, field values, etc.
*/
@RequestMapping(
value = "/add",
method = {POST, PUT}) // POST and PUT b/c we're very un-RESTful
@ResponseBody
public Map<String, Object> add(
@RequestParam("dsId") JdbcOeDataSource ds, final HttpServletRequest request)
throws ErrorMessageException, OeDataSourceAccessException, IOException {
JdbcOeDataEntrySource jdes = (JdbcOeDataEntrySource) ds;
Set<String> pks = jdes.getParentTableDetails().getPks();
// get parent dimensions/values
Map<String, Dimension> dimensions = new HashMap<String, Dimension>();
Map<String, Object> values = new HashMap<String, Object>();
for (Dimension dimension : jdes.getEditDimensions()) {
dimensions.put(dimension.getId(), dimension);
// Auto generated, special sql, and pk dimensions are not required on adds
boolean isRequired =
(jdes.getAutoGeneratedDimension(dimension.getId()) == null
&& jdes.getSpecialSqlDimension(dimension.getId()) == null
&& pks.contains(dimension.getId()));
values.putAll(
ControllerUtils.formatData(
dimension.getId(),
request.getParameter(dimension.getId()),
dimension.getSqlType(),
isRequired));
}
CompleteRecord completeRecord =
new CompleteRecord(
new TableAwareQueryRecord(jdes.getTableName(), pks, dimensions, values),
ControllerUtils.getChildRecordSets(jdes, request, true));
return jdes.addCompleteRecord(completeRecord, false);
}
/**
* @param ds data source ID sent on URL
* @param body JSON POST body
*/
@RequestMapping(
value = "/delete",
// FIXME this should obviously be DELETE, but we send an entity body
method = POST)
@ResponseBody
public Map<String, Object> delete(
@RequestParam("dsId") JdbcOeDataSource ds, @RequestBody DeleteRequest body)
throws IOException, ErrorMessageException, OeDataSourceAccessException {
JdbcOeDataEntrySource jdes = (JdbcOeDataEntrySource) ds;
List<DbKeyValMap> pksForDeletion = new ArrayList<DbKeyValMap>();
for (Map<String, String> pks : body.getPkIds()) {
pksForDeletion.add(ControllerUtils.parseKeyValueMap(jdes, pks));
}
jdes.deleteQueryRecords(jdes.getTableName(), pksForDeletion);
// Build/write response
Map<String, Object> data = new HashMap<String, Object>();
data.put("success", true);
return data; // TODO return RESTful response, i.e. data actually deleted
}