SystemLogAccumulator.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2022 Lluis Turró Cutiller <http://www.turro.org/>
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program 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 Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
 
package org.turro.log;
 
import java.util.Date;
import org.amic.util.date.CheckDate;
import org.turro.elephant.db.ElephantPU;
import org.turro.elephant.entities.db.SystemLog;
import org.turro.jpa.Dao;
import org.turro.sql.SqlClause;
import org.turro.string.Words;
 
public class SystemLogAccumulator implements Runnable {
  
  private static final int MAX_YEARS = 5;
  private final Dao dao;
  
  public static void accumulate() {
    SystemLogAccumulator accumulator = new SystemLogAccumulator(new ElephantPU());
    new Thread(accumulator, "ElephantLog accumulator").start();
  }
 
  public SystemLogAccumulator(Dao dao) {
    this.dao = dao;
  }
  
/*
  @Id private Date dateLog;
  @Id private SystemLogType logType;
  @Id private String generatorPath;
  @Id private String entityPath;
  private String generatorName;
  private String entityName;
  private String comment;
  private int count;
  private byte[] data;
  */
  
  @Override
  public void run() {
    Date until = new CheckDate().addYears(-MAX_YEARS).getDate();
    ensureCounts();
    SqlClause.select(Words.csv("l.logType").add("l.generatorPath").add("l.entityPath")
                          .add("l.generatorName").add("l.entityName").add("l.comment")
                          .add("sum(l.counts)").add("max(l.dateLog)").toString())
            .from("SystemLog l")
            .where().smallerOrEqual("l.dateLog", until)
            .groupBy(Words.csv("l.logType").add("l.generatorPath").add("l.entityPath")
                          .add("l.generatorName").add("l.entityName").add("l.comment").toString())
            .dao(dao)
            .resultList(Object[].class).forEach(c -> {
              SystemLog sl = new SystemLog();
              sl.setLogType((SystemLogType) c[0]);
              sl.setGeneratorPath((String) c[1]);
              sl.setEntityPath((String) c[2]);
              sl.setGeneratorName((String) c[3]);
              sl.setEntityName((String) c[4]);
              sl.setComment((String) c[5]);
              sl.setCounts((int)(long) c[6]);
              sl.setDateLog(until);
              sl.setData(getDataFrom(sl, (Date) c[7]));
              dao.saveObject(sl);
            });
    SqlClause.delete("SystemLog").where().smaller("logDate", until);
  }
 
  private void ensureCounts() {
    SqlClause.select(Words.csv("l.logType").add("l.generatorPath").add("l.entityPath")
                          .add("l.generatorName").add("l.entityName").add("l.comment")
                          .add("min(l.dateLog)").toString())
            .from("SystemLog l")
            .groupBy(Words.csv("l.logType").add("l.generatorPath").add("l.entityPath")
                          .add("l.generatorName").add("l.entityName").add("l.comment").toString())
            .dao(dao)
            .resultList(Object[].class).forEach(c -> {
              SqlClause.update("SystemLog")
                      .set("counts", 1)
                      .where().equal("logType", (SystemLogType) c[0])
                      .and().equal("generatorPath", (String) c[1])
                      .and().equal("entityPath", (String) c[2])
                      .and().equal("generatorName", (String) c[3])
                      .and().equal("entityName", (String) c[4])
                      .and().equal("comment", (String) c[5])
                      .and().greater("dateLog", (Date) c[6])
                      .dao(dao)
                      .execute();
            });
    /*
    SqlClause.update("SystemLog sl")
            .set("sl.counts", 1)
            .where("sl.dateLog >").sub(
                    SqlClause.select("min(l.dateLog)").from("SystemLog l")
                    .where("l.logType = sl.logType")
                    .and("l.generatorPath = sl.generatorPath")
                    .and("l.entityPath = sl.entityPath")
                    .and("l.generatorName = sl.generatorName")
                    .and("l.entityName = sl.entityName")
                    .and("l.comment = sl.comment")
                    .groupBy(Words.csv("l.logType").add("l.generatorPath").add("l.entityPath")
                          .add("l.generatorName").add("l.entityName").add("l.comment").toString()))
            .dao(dao)
            .execute();
    */
    SqlClause.update("SystemLog")
            .set("counts", 1)
            .where().smallerOrEqual("counts", 0)
            .dao(dao)
            .execute();
  }
 
  private byte[] getDataFrom(SystemLog sl, Date date) {
    return SqlClause.select("l.data")
            .from("SystemLog l")
            .where().equal("l.dateLog", date)
            .and().equal("l.logType", sl.getLogType())
            .and().equal("l.generatorPath", sl.getGeneratorPath())
            .and().equal("l.entityPath", sl.getEntityPath())
            .and().equal("l.generatorName", sl.getGeneratorName())
            .and().equal("l.entityName", sl.getEntityName())
            .and().equal("l.comment", sl.getComment())
            .dao(dao)
            .singleResult(byte[].class);
  }
 
}