com.isotrol.impe3.idx.d6.Drupal6AuditReader Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of impe3-idx-drupal6 Show documentation
There is a newer version: 3.1.1
/**
 * 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 .
 */
package com.isotrol.impe3.idx.d6;


import java.util.HashMap;
import java.util.HashSet;
import java.util.LinkedList;
import java.util.List;
import java.util.Map;
import java.util.Set;

import org.springframework.jdbc.core.namedparam.NamedParameterJdbcDaoSupport;
import org.springframework.transaction.annotation.Transactional;


/**
 * Drupal6 Audit Reader
 */
public class Drupal6AuditReader extends NamedParameterJdbcDaoSupport implements AuditReader {

	/** total default value **/
	private static final int DEFAULT_TOTAL = 100;

	private int total;

	private String sql = "SELECT ID_SEC, ID_ITEM, TIPO, OP FROM log"
		+ " WHERE OP IN(0,1) AND ID_SEC > :checkpoint ORDER BY ID_SEC LIMIT :total";

	/**
	 * Default constructor
	 */
	public Drupal6AuditReader() {
		total = DEFAULT_TOTAL;
	}

	/**
	 * 
	 * @see com.isotrol.impe3.idx.d6.AuditReader#readAuditBatch(java.lang.Object)
	 */
	@Transactional
	public List readAuditBatch(Long checkpoint) {

		final Map map = new HashMap();
		map.put("checkpoint", checkpoint);
		map.put("total", total);

		@SuppressWarnings("unchecked")
		final List list = getNamedParameterJdbcTemplate().query(sql, map, Task.MAPPER);

		return cleanTaskList(list);
	}

	private List cleanTaskList(List original) {
		final List tasks = new LinkedList();
		final Set ids = new HashSet();

		for (int i = original.size() - 1; i >= 0; i--) {
			Task t = original.get(i);
			if (!ids.contains(t.getId())) {
				tasks.add(0, t);
				ids.add(t.getId());
			}
		}

		return tasks;
	}

	public void setTotal(int total) {
		this.total = total;
	}

	public void setSql(String sql) {
		this.sql = sql;
	}
}