SystemLogModel.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2021 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 java.util.HashSet;
import java.util.List;
import java.util.Optional;
import java.util.Set;
import java.util.stream.Stream;
import org.turro.string.Strings;
import org.turro.elephant.db.ElephantPU;
import org.turro.elephant.entities.db.SystemLog;
import org.turro.jpa.Dao;
import org.turro.path.Path;
import org.turro.sql.SqlClause;
 
public class SystemLogModel {
 
  public long getCountOf(String comment, String entityPath, Date since) {
    return Optional.ofNullable(
            SqlClause.select("sum(counts)").from("SystemLog")
            .where().any()
            .startIf(!Strings.isBlank(comment))
            .and().equal("comment", comment)
            .endIf()
            .startIf(!Strings.isBlank(entityPath))
            .and().equal("entityPath", entityPath)
            .endIf()
            .startIf(since != null)
            .and().greaterOrEqual("dateLog", since)
            .endIf()
            .dao(getDao())
            .singleResult(Long.class))
            .orElse(0L);
  }
  
  public void cleanup(String entityPath) {
    SqlClause.delete("SystemLog")
            .where().group()
            .equal("entityPath", entityPath)
            .or().startsWith("entityPath", entityPath + "/")
            .endGroup()
            .and().notIn("comment", List.of("cleanup", "deleted")) // keep cleanups
            .dao(getDao())
            .execute();
  }
  
  /* Utils */
  
  public static Set<String> getAllPaths(String root) {
    try(Stream<String> stream = SqlClause.select("distinct entityPath").from("SystemLog")
            .where().startsWith("entityPath", "/" + root + "/")
            .and().notIn("comment", List.of("cleanup", "deleted")) // keep cleanups
            .dao(new ElephantPU())
            .stream(String.class)) {
      return new HashSet<>(stream.map(path -> Path.pathFrom(path).getTill(2)).toList());
    }
  }
  
  /* Search */
  
  public SystemLog firstEntry(String entityPath, String comment) {
    return SqlClause.select("l").from("SystemLog l")
            .where().equal("l.comment", comment)
            .and().equal("l.entityPath", entityPath)
            .and("l.dateLog =").sub(
                    SqlClause.select("min(l2.dateLog)").from("SystemLog l2")
                    .where("l2.comment = l.comment")
                    .and("l2.entityPath = l.entityPath")
                    .groupBy("l2.comment, l2.entityPath"))
            .dao(getDao())
            .singleResult(SystemLog.class);
  }
  
  public SystemLog lastEntry(String entityPath, String comment) {
    return SqlClause.select("l").from("SystemLog l")
            .where().equal("l.comment", comment)
            .and().equal("l.entityPath", entityPath)
            .and("l.dateLog =").sub(
                    SqlClause.select("max(l2.dateLog)").from("SystemLog l2")
                    .where("l2.comment = l.comment")
                    .and("l2.entityPath = l.entityPath")
                    .groupBy("l2.comment, l2.entityPath"))
            .dao(getDao())
            .singleResult(SystemLog.class);
  }
  
  /* Dao */
  
  private Dao _dao;
  
  private Dao getDao() {
    if(_dao == null) {
      _dao = new ElephantPU();
    }
    return _dao;
  }
 
}