com.isotrol.impe3.nr.audit.jdbc.AuditServiceImpl Maven / Gradle / Ivy
/**
* This file is part of Port@l
* Port@l 3.0 - Portal Engine and Management System
* Copyright (C) 2010 Isotrol, SA. http://www.isotrol.com
*
* Port@l is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* Port@l is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with Port@l. If not, see AUDITTEDCONTENT = new ParameterizedRowMapper() {
public AuditedContent mapRow(ResultSet rs, int rowNum) throws SQLException {
int i=1;
final String contentId = rs.getString(i++);
final UUID contentTypeId = UUID.fromString(rs.getString(i++));
final String locale = rs.getString(i++);
final String indexId = rs.getString(i++);
final String engineString = rs.getString(i++);
final AuditEngineMode engineMode = AuditEngineMode.fromString(engineString);
final String hash = rs.getString(i++);
final String virtualTimeString = rs.getString(i++);
final Long virtualTime;
if (virtualTimeString!=null){
virtualTime = Long.parseLong(virtualTimeString);
} else {
virtualTime = null;
}
final String contentTimeString = rs.getString(i++);
final Long contentTime;
if (contentTimeString!=null){
contentTime = Long.parseLong(contentTimeString);
} else {
contentTime = null;
}
final AuditedContent content = AuditedContent.withVirtualTimeAndHash(contentId, contentTypeId, ImmutableList.of(), locale, indexId,engineMode, hash, virtualTime,contentTime);
return content;
}
};
@Transactional
public Collection getContents(String idIndexador) {
final List contents = getNamedParameterJdbcTemplate().query(sqlSelectContents,
ImmutableMap.of(INDEXID, idIndexador),AUDITTEDCONTENT);
return contents;
}
private String getTimestamp(){
return Long.toString(System.currentTimeMillis());
}
@Transactional
public void registerOperation(AuditTask task) {
String timestamp = getTimestamp();
AuditedContent content=task.getContent();
AuditOperations operation=task.getOp();
String operationCode = operation.toString();
Map parameterMap= Maps.newHashMap();
int i = 0;
parameterMap.put(INDEXID, content.getIndexId());
parameterMap.put(CONTENTID, content.getContentId());
parameterMap.put(CONTENTTYPEID, content.getContentTypeId().toString());
parameterMap.put(LOCALE, content.getLocale());
parameterMap.put(ENGINEMODE, content.getEngineMode().toString());
i = getNamedParameterJdbcTemplate().queryForInt(sqlExistDeleted, parameterMap);
if (i==0){
if (!task.getOp().equals(AuditOperations.DELETE)){
//solamente se verifica en el caso que la operacion no sea borrado.
//para un borrado ya se comprueba con la opcion si existe borrado
final String sqlVerification;
if (AuditValidationMode.VIRTUALTIME.equals(task.getValidationMode()) || content.getHash()==null){
sqlVerification=sqlExistFromVirtualTime;
parameterMap.put(VIRTUALTIME, content.getVirtualTime());
} else if (AuditValidationMode.HASH.equals(task.getValidationMode()) || content.getVirtualTime()==null){
sqlVerification=sqlExistFromHash;
parameterMap.put(HASH, content.getHash());
} else {
sqlVerification=sqlExistFromVirtualTimeAndHash;
parameterMap.put(VIRTUALTIME, content.getVirtualTime());
parameterMap.put(HASH, content.getHash());
}
i = getNamedParameterJdbcTemplate().queryForInt(sqlVerification, parameterMap);
}
if (i==0){
parameterMap= Maps.newHashMap();
Long nextId = getNamedParameterJdbcTemplate().queryForLong(sqlGetSequence, parameterMap);
parameterMap.put(INDEXID, content.getIndexId());
parameterMap.put(ID, nextId);
parameterMap.put(CONTENTID, content.getContentId());
parameterMap.put(CONTENTTYPEID, content.getContentTypeId().toString());
parameterMap.put(OPERATION, operationCode);
parameterMap.put(HASH, content.getHash());
parameterMap.put(VIRTUALTIME, content.getVirtualTime());
parameterMap.put(CONTENTTIME,content.getContentTime());
parameterMap.put(TIME, timestamp);
parameterMap.put(ENGINEMODE, content.getEngineMode().toString());
if (content.getLocale()!=null){
parameterMap.put(LOCALE, content.getLocale());
i = getNamedParameterJdbcTemplate().update(sqlInsert,parameterMap);
if (i==0){
}
for (String cat : content.getcategoriesId()) {
Map parameterMapCat= Maps.newHashMap();
parameterMapCat.put(ID, nextId);
parameterMapCat.put(CATEGORYID, cat);
i = getNamedParameterJdbcTemplate().update(sqlInsertCats,parameterMapCat);
}
i=getNamedParameterJdbcTemplate().update(sqlUpdateValid, parameterMap);
i=getNamedParameterJdbcTemplate().update(sqlupdateSequence, parameterMap);
} else {
List langs = getNamedParameterJdbcTemplate().queryForList(sqlgetLang, parameterMap,String.class);
for (String lang : langs) {
parameterMap.put(LOCALE, lang);
i = getNamedParameterJdbcTemplate().update(sqlInsert,parameterMap);
if (i==0){
}
for (String cat : content.getcategoriesId()) {
Map parameterMapCat= Maps.newHashMap();
parameterMap.put(ID, nextId);
parameterMap.put(CATEGORYID, cat);
i = getNamedParameterJdbcTemplate().update(sqlInsertCats,parameterMapCat);
}
i=getNamedParameterJdbcTemplate().update(sqlUpdateValid, parameterMap);
i=getNamedParameterJdbcTemplate().update(sqlupdateSequence, parameterMap);
nextId = getNamedParameterJdbcTemplate().queryForLong(sqlGetSequence, parameterMap);
}
}
} else {
logger.debug("Operacion ya registrada ");
}
}else{
logger.debug("Operacion sobre contenido borrado ");
}
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy