DaoUtil.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2014 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.jpa;
 
import java.util.Collection;
import org.turro.string.Strings;
import org.turro.collections.ItemOf;
import org.turro.collections.SetOf;
import org.turro.elephant.db.WhereClause;
import org.turro.path.Path;
import org.turro.reflection.JSONSerializer;
 
public class DaoUtil {
 
  public static boolean isEmpty(Dao dao, String table) {
    Long count = count(dao, table);
    return count == null || count == 0L;
  }
  
  public static boolean isEmpty(Dao dao, String table, String condition) {
    Long count = count(dao, table, condition);
    return count == null || count == 0L;
  }
  
  public static boolean isEmpty(Dao dao, String table, String condition, Object... pars) {
    Long count = count(dao, table, condition, pars);
    return count == null || count == 0L;
  }
  
  public static Long count(Dao dao, String table) {
    Long count = (Long) dao.getSingleResultOrNull("select count(x) from " + table + " x");
    return count;
  }
  
  public static Long count(Dao dao, String table, String condition) {
    Long count = (Long) dao.getSingleResultOrNull("select count(x) from " + table + " x " + condition);
    return count;
  }
  
  public static Long count(Dao dao, String table, String condition, Object... pars) {
    Long count = (Long) dao.getSingleResultOrNull("select count(x) from " + table + " x " + condition, pars);
    return count;
  }
  
  public static Long count(Dao dao, WhereClause wc) {
    Long count = (Long) dao.getSingleResultOrNull(wc);
    return count;
  }
  
  public static String getInClauseFromPaths(Collection<String> paths, boolean quoted) {
    return getCommaSeparatedValues(new SetOf<String, String>(paths, new ItemOf<String, String>() {
      @Override
      public String getFrom(String e) {
        return getIdentifierFromPath(e);
      }
    }), quoted);
  }
 
  public static String getCommaSeparatedValues(Collection<String> values, boolean quoted) {
    String result = "";
    for(String s : values) {
      if(quoted) s = "\"" + s + "\"";
      result += (String) (Strings.isBlank(result) ? s : "," + s);
    }
    return result;
  }
  
  public static String getIdentifierFromPath(String e) {
    return new Path(e).getNode(1);
  }
 
  public static String getJson(Dao dao, Class javaClass, Object identifier, final JSONSerializer json) {
    final StringBuilder sb = new StringBuilder();
    dao.find(javaClass, identifier, new DaoCallback() {
      @Override
      public void before(Object value) {
      }
      @Override
      public void after(Object oldValue, Object newValue) {
        json.setObject(newValue);
        sb.append(json.toJson());
      }
    });
    return sb.length() > 0 ? sb.toString() : null;
  }
  
  private DaoUtil() {
  }
 
}