UsualUsages.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2011 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.usual;
 
import java.util.List;
import javax.persistence.NoResultException;
import org.turro.string.Strings;
import org.turro.contacts.Usually;
import org.turro.contacts.db.ContactsPU;
import org.turro.jpa.Dao;
 
public class UsualUsages {
 
  public static Usually addUsage(String path) {
    if(!Strings.isBlank(path)) {
      if(path.length() > 255) {
        path = path.substring(0, 255);
      }
      if(path.endsWith(":null")) {
        path = path.substring(0, path.length() - 4);
      }
      Dao dao = new ContactsPU();
      Usually u = null;
      try {
        u = (Usually) dao.getSingleResult(
                "select u from Usually as u " +
                "where u.path = ?",
                new Object[] {
                  path
                });
        u.setUsages(u.getUsages() + 1L);
        u = dao.saveObject(u);
      } catch(NoResultException ex) {
        u = new Usually();
        u.setPath(path);
        u.setUsages(1L);
        u = dao.saveObject(u);
      }
      return u;
    }
    return null;
  }
 
  public static Usually getUsage(String path) {
    if(!Strings.isBlank(path)) {
      if(path.length() > 255) {
        path = path.substring(0, 255);
      }
      Dao dao = new ContactsPU();
      try {
        return (Usually) dao.getSingleResult(
                "select u from Usually as u " +
                "where u.path = ?",
                new Object[] {
                  path
                });
      } catch(NoResultException ex) {}
    }
    return null;
  }
 
  public static long getUsageCount(String path) {
    Usually u = getUsage(path);
    return u == null ? 0 : u.getUsages();
  }
 
  public static Usually getMostUsed(String path) {
    if(!Strings.isBlank(path)) {
      if(path.length() > 255) {
        path = path.substring(0, 255);
      }
      Dao dao = new ContactsPU();
      try {
        List<Usually> l = dao.getResultList(
                "select u from Usually as u " +
                "where u.path like ? " +
                "and u.usages = (" +
                " select max(u2.usages) from Usually as u2 " +
                " where u2.path like ? " +
                ")",
                new Object[] {
                  path + "%", path + "%"
                });
        if(!l.isEmpty()) {
          return l.get(0);
        }
      } catch(NoResultException ex) {}
    }
    return null;
  }
 
  public static String getMostUsedvalue(String path) {
    Usually u = getMostUsed(path);
    return u == null ? null : u.getPath().substring(path.length());
  }
 
  public static void clearUsuals(String path) {
    if(!Strings.isBlank(path)) {
      if(path.length() > 255) {
        path = path.substring(0, 255);
      }
      Dao dao = new ContactsPU();
      dao.executeUpdate(
              "delete from Usually " +
              "where path like ?",
              new Object[] {
                path + "%"
              });
    }
  }
 
  private UsualUsages() {
  }
 
}