/** * Licensed to Apereo under one or more contributor license agreements. See the NOTICE file * distributed with this work for additional information regarding copyright ownership. Apereo * licenses this file to you under the Apache License, Version 2.0 (the "License"); you may not use * this file except in compliance with the License. You may obtain a copy of the License at the * following location: * * <p>http://www.apache.org/licenses/LICENSE-2.0 * * <p>Unless required by applicable law or agreed to in writing, software distributed under the * License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either * express or implied. See the License for the specific language governing permissions and * limitations under the License. */ package org.apereo.portal.portlets.sqlquery; import java.io.IOException; import javax.portlet.ActionRequest; import javax.portlet.ActionResponse; import javax.portlet.PortletMode; import javax.portlet.PortletModeException; import javax.portlet.PortletPreferences; import javax.portlet.PortletRequest; import javax.portlet.ReadOnlyException; import javax.portlet.ValidatorException; import org.apache.commons.lang.StringUtils; import org.apereo.portal.jpa.BasePortalJpaDao; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.ModelAttribute; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; /** * Handles CONFIG mode for the SQL query portlet. * */ @Controller @RequestMapping("CONFIG") public class SqlQueryConfigurationController { private String defaultDataSource = BasePortalJpaDao.PERSISTENCE_UNIT_NAME; private String defaultView = "jsp/SqlQuery/results"; @RequestMapping public String getAccountFormView(PortletRequest request, Model model) { model.addAttribute("form", getConfigurationForm(request)); return "jsp/SqlQuery/config"; } @RequestMapping(params = "action=updateConfiguration") public void saveConfiguration( ActionRequest request, ActionResponse response, @ModelAttribute("form") SqlQueryConfigForm form, BindingResult errors, @RequestParam(value = "Save", required = false) String save) throws PortletModeException, IOException, ValidatorException, ReadOnlyException { if (StringUtils.isNotBlank(save)) { PortletPreferences prefs = request.getPreferences(); prefs.setValue( SqlQueryPortletController.DATASOURCE_BEAN_NAME_PARAM_NAME, form.getDataSource()); prefs.setValue(SqlQueryPortletController.SQL_QUERY_PARAM_NAME, form.getSqlQuery()); prefs.setValue(SqlQueryPortletController.VIEW_PARAM_NAME, form.getViewName()); prefs.setValue(SqlQueryPortletController.PREF_CACHE_NAME, form.getCacheName()); prefs.store(); } response.setPortletMode(PortletMode.VIEW); } public SqlQueryConfigForm getConfigurationForm(PortletRequest request) { PortletPreferences prefs = request.getPreferences(); SqlQueryConfigForm form = new SqlQueryConfigForm(); form.setDataSource( prefs.getValue( SqlQueryPortletController.DATASOURCE_BEAN_NAME_PARAM_NAME, defaultDataSource)); form.setViewName(prefs.getValue(SqlQueryPortletController.VIEW_PARAM_NAME, defaultView)); form.setSqlQuery(prefs.getValue(SqlQueryPortletController.SQL_QUERY_PARAM_NAME, "")); form.setCacheName( prefs.getValue( SqlQueryPortletController.PREF_CACHE_NAME, SqlQueryPortletController.DEFAULT_CACHE_NAME)); return form; } }