All Downloads are FREE. Search and download functionalities are using the official Maven repository.

fi.foyt.fni.persistence.dao.materials.BinaryDAO Maven / Gradle / Ivy

There is a newer version: 3.3.13
Show newest version
package fi.foyt.fni.persistence.dao.materials;

import javax.persistence.EntityManager;
import javax.persistence.Query;

import fi.foyt.fni.persistence.dao.GenericDAO;
import fi.foyt.fni.persistence.model.materials.Image;
import fi.foyt.fni.persistence.model.users.User;

public class BinaryDAO extends GenericDAO {

  private static final long serialVersionUID = 1L;

	public Long lengthDataByCreator(User creator) {
    // Criteria API does not support "length" operation for byte arrays
    // so we use JPQL queries
    EntityManager entityManager = getEntityManager();
    Query query = entityManager.createQuery("select coalesce(sum(length(data)), 0) from Binary where creator = :creator");
    query.setParameter("creator", creator);
    return (Long) query.getSingleResult();
  }

}




© 2015 - 2025 Weber Informatics LLC | Privacy Policy