/*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF 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
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* 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.apache.openmeetings.data.basic.dao;
import java.lang.reflect.Constructor;
import java.util.Arrays;
import java.util.Date;
import java.util.LinkedHashMap;
import java.util.List;
import javax.annotation.Resource;
import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.PersistenceException;
import javax.persistence.TypedQuery;
import org.apache.openmeetings.OpenmeetingsVariables;
import org.apache.openmeetings.data.IDataProviderDao;
import org.apache.openmeetings.data.beans.basic.SearchResult;
import org.apache.openmeetings.data.user.dao.UsersDao;
import org.apache.openmeetings.persistence.beans.basic.Configuration;
import org.apache.openmeetings.remote.red5.ScopeApplicationAdapter;
import org.apache.openmeetings.utils.DaoHelper;
import org.apache.openmeetings.utils.mappings.CastMapToObject;
import org.red5.logging.Red5LoggerFactory;
import org.slf4j.Logger;
import org.springframework.transaction.annotation.Transactional;
/**
* Insert/update/Delete on {@link Configuration}<br/>
* <br/>
* It provides basic mechanism to get a Conf Key:<br/>
* {@link #getConfValue(String, Class, String)} <br/>
* <br/>
* <b> {@link #get(String)} is deprecated!</b>
*
* @author swagner
*
*/
@Transactional
public class ConfigurationDao implements IDataProviderDao<Configuration> {
private static final Logger log = Red5LoggerFactory.getLogger(
ConfigurationDao.class, OpenmeetingsVariables.webAppRootKey);
public static final String DEFAULT_APP_NAME = "OpenMeetings";
public final static String[] searchFields = {"conf_key", "conf_value"};
@PersistenceContext
private EntityManager em;
@Resource(name = "usersDao")
private UsersDao usersDao;
/**
* @deprecated Dao's are not the place to store session variables, also
* updates to the key won't update this variable
*/
@Deprecated
private String appName = null;
/**
* @param confKey
* @return
*/
public Configuration get(String confKey) {
try {
TypedQuery<Configuration> query = em.createNamedQuery(
"getConfigurationByKey", Configuration.class);
query.setParameter("conf_key", confKey);
List<Configuration> configs = query.getResultList();
if (configs != null && configs.size() > 0) {
return configs.get(0);
}
} catch (Exception ex2) {
log.error("[getConfKey]: ", ex2);
}
return null;
}
public List<Configuration> getConfKeys(String... keys) {
try {
TypedQuery<Configuration> query = em.createNamedQuery(
"getConfigurationsByKeys", Configuration.class);
query.setParameter("conf_keys", Arrays.asList(keys));
return query.getResultList();
} catch (Exception ex2) {
log.error("[getConfKey]: ", ex2);
}
return null;
}
/**
* Return a object using a custom type and a default value if the key is not
* present
*
* Example: Integer my_key = getConfValue("my_key", Integer.class, "15");
*
* @param confKey
* @param typeObject
* @param defaultValue
* @return
*/
public <T> T getConfValue(String confKey, Class<T> typeObject,
String defaultValue) {
try {
Configuration conf_reminder = get(confKey);
if (conf_reminder == null) {
log.warn("Could not find key in configuration CONF_KEY: " + confKey);
if (defaultValue == null) {
return null;
}
} else {
// Use the custom value as default value
defaultValue = conf_reminder.getConf_value();
}
// Either this can be directly assigned or try to find a constructor
// that handles it
if (typeObject.isAssignableFrom(defaultValue.getClass())) {
return typeObject.cast(defaultValue);
}
Constructor<T> c = typeObject.getConstructor(defaultValue
.getClass());
return c.newInstance(defaultValue);
} catch (Exception err) {
log.error(
"cannot be cast to return type, you have misconfigured your configuration CONF_KEY: "
+ confKey, err);
return null;
}
}
public SearchResult<Configuration> getAllConf(int start, int max,
String orderby, boolean asc) {
try {
SearchResult<Configuration> sresult = new SearchResult<Configuration>();
sresult.setRecords(this.selectMaxFromConfigurations());
sresult.setResult(this.getConfigurations(start, max, orderby, asc));
sresult.setObjectName(Configuration.class.getName());
return sresult;
} catch (Exception ex2) {
log.error("[getAllConf]: ", ex2);
}
return null;
}
public List<Configuration> getConfigurations(int start, int max,
String orderby, boolean asc) {
try {
String query = "SELECT c FROM Configuration c " //
+ "LEFT JOIN FETCH c.user " //
+ "WHERE c.deleted = false " //
+ "ORDER BY " + orderby;
if (asc) {
query += " ASC";
} else {
query += " DESC";
}
TypedQuery<Configuration> q = em.createQuery(query,
Configuration.class);
q.setFirstResult(start);
q.setMaxResults(max);
return q.getResultList();
} catch (Exception ex2) {
log.error("[getConfigurations]", ex2);
}
return null;
}
/**
*
* @return
*/
public Long selectMaxFromConfigurations() {
try {
log.debug("selectMaxFromConfigurations ");
// get all users
TypedQuery<Long> query = em
.createQuery(
"select count(c.configuration_id) from Configuration c where c.deleted = false",
Long.class);
List<Long> ll = query.getResultList();
log.debug("selectMaxFromConfigurations" + ll.get(0));
return ll.get(0);
} catch (Exception ex2) {
log.error("[selectMaxFromConfigurations] ", ex2);
}
return null;
}
public String addConfByKey(String confKey, String confValue, Long userId,
String comment) {
String ret = "Add Configuration";
Configuration configuration = new Configuration();
configuration.setConf_key(confKey);
configuration.setConf_value(confValue);
configuration.setStarttime(new Date());
configuration.setDeleted(false);
configuration.setComment(comment);
if (userId != null)
configuration.setUser(usersDao.get(userId));
try {
configuration = em.merge(configuration);
ret = "Erfolgreich";
} catch (Exception ex2) {
log.error("[addConfByKey]: ", ex2);
}
return ret;
}
public Long saveOrUpdateConfiguration(LinkedHashMap<String, ?> values,
Long userId) {
try {
Configuration conf = (Configuration) CastMapToObject.getInstance()
.castByGivenObject(values, Configuration.class);
if (conf.getConfiguration_id().equals(null)
|| conf.getConfiguration_id() == 0
|| conf.getConfiguration_id() == 0L) {
conf.setConfiguration_id(null);
conf.setStarttime(new Date());
conf.setDeleted(false);
return this.addConfig(conf);
} else {
Configuration conf2 = this.get(conf.getConfiguration_id());
conf2.setComment(conf.getComment());
conf2.setConf_key(conf.getConf_key());
conf2.setConf_value(conf.getConf_value());
conf2.setUser(usersDao.get(userId));
conf2.setDeleted(false);
conf2.setUpdatetime(new Date());
return this.updateConfig(conf2);
}
} catch (Exception ex2) {
log.error("[updateConfByUID]: ", ex2);
}
return new Long(-1);
}
public Long addConfig(Configuration conf) {
try {
conf = em.merge(conf);
Long configuration_id = conf.getConfiguration_id();
return configuration_id;
} catch (Exception ex2) {
log.error("[updateConfByUID]: ", ex2);
}
return new Long(-1);
}
public Long updateConfig(Configuration conf) {
try {
if (conf.getConfiguration_id() == null
|| conf.getConfiguration_id() == 0
|| conf.getConfiguration_id() == 0L) {
em.persist(conf);
} else {
if (!em.contains(conf)) {
conf = em.merge(conf);
}
}
if ("crypt_ClassName".equals(conf.getConf_key())) {
ScopeApplicationAdapter.configKeyCryptClassName = conf
.getConf_value();
} else if ("show.whiteboard.draw.status".equals(conf.getConf_key())) {
ScopeApplicationAdapter.whiteboardDrawStatus = "1".equals(conf
.getConf_value());
}
return conf.getConfiguration_id();
} catch (Exception ex2) {
log.error("[updateConfByUID]: ", ex2);
}
return new Long(-1);
}
public Long deleteConfByConfiguration(LinkedHashMap<String, ?> values,
Long users_id) {
try {
Configuration conf = (Configuration) CastMapToObject.getInstance()
.castByGivenObject(values, Configuration.class);
conf.setUser(usersDao.get(users_id));
conf.setUpdatetime(new Date());
conf.setDeleted(true);
Configuration conf2 = this.get(conf.getConfiguration_id());
conf2.setComment(conf.getComment());
conf2.setConf_key(conf.getConf_key());
conf2.setConf_value(conf.getConf_value());
conf2.setUser(usersDao.get(users_id));
conf2.setDeleted(true);
conf2.setUpdatetime(new Date());
this.updateConfig(conf2);
return new Long(1);
} catch (Exception ex2) {
log.error("[deleteConfByUID]: ", ex2);
}
return new Long(-1);
}
public String getAppName() {
if (appName == null) {
appName = getConfValue("application.name", String.class,
ConfigurationDao.DEFAULT_APP_NAME);
}
return appName;
}
public Configuration get(long id) {
try {
if (id <= 0) {
return null;
}
return em
.createNamedQuery("getConfigurationById",
Configuration.class)
.setParameter("configuration_id", id).getSingleResult();
} catch (PersistenceException ex) {
log.error("Could not find id " + id, ex);
}
return null;
}
public List<Configuration> get(int start, int count) {
TypedQuery<Configuration> q = em.createNamedQuery(
"getNondeletedConfiguration", Configuration.class);
q.setFirstResult(start);
q.setMaxResults(count);
return q.getResultList();
}
public List<Configuration> get(String search, int start, int count, String sort) {
TypedQuery<Configuration> q = em.createQuery(DaoHelper.getSearchQuery("Configuration", "c", search, true, false, sort, searchFields), Configuration.class);
q.setFirstResult(start);
q.setMaxResults(count);
return q.getResultList();
}
public long count() {
return selectMaxFromConfigurations();
}
public long count(String search) {
TypedQuery<Long> q = em.createQuery(DaoHelper.getSearchQuery("Configuration", "c", search, true, true, null, searchFields), Long.class);
return q.getSingleResult();
}
public Configuration update(Configuration entity, Long userId) {
String key = entity.getConf_key();
String value = entity.getConf_value();
if (entity.getConfiguration_id() == null
|| entity.getConfiguration_id() <= 0) {
entity.setStarttime(new Date());
entity.setDeleted(false);
this.updateConfig(entity);
} else {
if (userId != null) {
entity.setUser(usersDao.get(userId));
}
entity.setDeleted(false);
entity.setUpdatetime(new Date());
this.updateConfig(entity);
}
if ("crypt_ClassName".equals(key)) {
ScopeApplicationAdapter.configKeyCryptClassName = value;
} else if ("show.whiteboard.draw.status".equals(key)) {
ScopeApplicationAdapter.whiteboardDrawStatus = "1".equals(value);
} else if ("application.name".equals(key)) {
appName = value;
}
//TODO ensure entity returned is updated
return entity;
}
public void delete(Configuration entity, Long userId) {
if (userId != null) {
entity.setUser(usersDao.get(userId));
}
entity.setDeleted(true);
entity.setUpdatetime(new Date());
this.updateConfig(entity);
}
}