Skills.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2020 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.skills;
 
import java.util.Arrays;
import java.util.HashSet;
import java.util.List;
import java.util.Set;
import java.util.stream.Collectors;
import org.turro.string.Strings;
import org.turro.elephant.db.ElephantPU;
import org.turro.elephant.db.WhereClause;
import org.turro.elephant.entities.db.Skill;
import org.turro.elephant.entities.db.SkillType;
import org.turro.jpa.Dao;
import org.turro.sql.SqlClause;
 
public class Skills {
 
  public static List<Skill> getRootSkillsFrom(String rootFilter, SkillType... types) {
    return getSkillsFrom(rootFilter == null ? "*" : rootFilter, types);
  }
  
  public static List<SkillRoot> getSkillsAsRootFrom(String entityPath, SkillType... types) {
    return getSkillsFrom(entityPath, types).stream().map(s -> new SkillRoot(s)).collect(Collectors.toList());
  }
  
  public static List<Skill> getSkillsFrom(String entityPath, SkillType... types) {
    WhereClause wc = new WhereClause();
    wc.addClause("select s from Skill s");
    wc.addClause("where s.entityPath = :path");
    wc.addNamedValue("path", entityPath);
    if(types != null) {
      wc.addClause("and s.type in (:types)");
      wc.addNamedValue("types", Arrays.asList(types));
    }
    return new ElephantPU().getResultList(Skill.class, wc);
  }
  
  public static List<SkillRoot> getAvailables(String rootFilter, SkillType... types) {
    return getAvailables(rootFilter, false, types);
  }
  
  public static List<SkillRoot> getValidateds(String rootFilter, SkillType... types) {
    return getAvailables(rootFilter, true, types);
  }
  
  public static List<SkillRoot> getAvailables(String rootFilter, boolean validated, SkillType... types) {
    WhereClause wc = new WhereClause();
    wc.addClause("select new org.turro.skills.SkillRoot(s.skill, s.type, count(s))");
    wc.addClause("from Skill s");
    wc.addClause(validated ? "where s.validated = TRUE" : "where 1=1");
    if(!Strings.isBlank(rootFilter)) {
      wc.addClause("and s.entityPath like :root");
      wc.addNamedValue("root", "/" + rootFilter + "/%");
    }
    if(types != null) {
      wc.addClause("and s.type in (:types)");
      wc.addNamedValue("types", Arrays.asList(types));
    }
    wc.addClause("group by s.skill, s.type");
    return new ElephantPU().getResultList(SkillRoot.class, wc);
  }
 
  public static void addSkillFor(String entityPath, Skill skill) {
    Dao dao = new ElephantPU();
    skill.setEntityPath(entityPath);
    dao.saveObject(skill);
  }
  
  public static void setSkillsFor(String entityPath, Set<Skill> skills, SkillType... types) {
    Dao dao = new ElephantPU();
    removeSkillsFor(dao, entityPath, types);
    skills.forEach(s -> s.setEntityPath(entityPath));
    dao.saveCollection(skills);
  }
  
  public static void removeSkillsFor(String entityPath, SkillType... types) {
    removeSkillsFor(new ElephantPU(), entityPath, types);
  }
  
  public static void removeSkillsFor(Dao dao, String entityPath, SkillType... types) {
    WhereClause wc = new WhereClause();
    wc.addClause("delete from Skill s");
    wc.addClause("where s.entityPath = :path");
    wc.addNamedValue("path", entityPath);
    if(types != null) {
      wc.addClause("and s.type in (:types)");
      wc.addNamedValue("types", Arrays.asList(types));
    }
    dao.executeUpdate(wc);
  }
  
  public static void removeSkills(String entityPath) {
    Dao dao = new ElephantPU();
    WhereClause wc = new WhereClause();
    wc.addClause("delete from Skill");
    wc.addClause("where entityPath = :path");
    wc.addNamedValue("path", entityPath);
    dao.executeUpdate(wc);
  }
  
  /* Utils */
  
  public static Set<String> getAllPaths(String root) {
    return new HashSet<>(SqlClause.select("distinct s.entityPath").from("Skill s")
            .where().startsWith("s.entityPath", "/" + root + "/")
            .dao(new ElephantPU())
            .resultList(String.class));
  }
  
  private Skills() {}
  
}