@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 }