@Test
public void testSimpleCrossTxnWork() {
Session session1 = injector.getInstance(SessionFactory.class).openSession();
ManagedSessionContext.bind(session1);
HibernateTestEntity entity =
injector
.getInstance(ManualLocalTransactionsWithCustomMatchersTest.TransactionalObject.class)
.runOperationInTxn();
injector
.getInstance(ManualLocalTransactionsWithCustomMatchersTest.TransactionalObject.class)
.runOperationInTxn2();
assert injector.getInstance(Session.class).contains(entity)
: "Session appears to have been closed across txns!";
session1.close();
// try to query them back out
Session session = injector.getInstance(SessionFactory.class).openSession();
assert null
!= session
.createCriteria(HibernateTestEntity.class)
.add(Expression.eq("text", UNIQUE_TEXT))
.uniqueResult();
assert null
!= session
.createCriteria(HibernateTestEntity.class)
.add(Expression.eq("text", UNIQUE_TEXT_2))
.uniqueResult();
session.close();
}
@Override
public TbData getTbData(final Encounter encounter, final Concept question) {
Criteria criteria = getSessionFactory().getCurrentSession().createCriteria(TbData.class);
criteria.add(Expression.eq("encounter", encounter));
criteria.add(Expression.eq("question", question));
return (TbData) criteria.uniqueResult();
}
public String createAnchor(WeblogEntryData entry) throws RollerException {
try {
// Check for uniqueness of anchor
String base = entry.createAnchorBase();
String name = base;
int count = 0;
while (true) {
if (count > 0) {
name = base + count;
}
Session session = ((HibernatePersistenceStrategy) this.strategy).getSession();
Criteria criteria = session.createCriteria(WeblogEntryData.class);
criteria.add(Expression.eq("website", entry.getWebsite()));
criteria.add(Expression.eq("anchor", name));
List results = criteria.list();
if (results.size() < 1) {
break;
} else {
count++;
}
}
return name;
} catch (HibernateException e) {
throw new RollerException(e);
}
}
public boolean isDuplicateWeblogCategoryName(WeblogCategoryData cat) throws RollerException {
// ensure that no sibling categories share the same name
WeblogCategoryData parent =
null == cat.getId() ? (WeblogCategoryData) cat.getNewParent() : cat.getParent();
if (null != parent) // don't worry about root
{
List sameNames;
try {
Session session = ((HibernatePersistenceStrategy) this.strategy).getSession();
Criteria criteria = session.createCriteria(WeblogCategoryAssoc.class);
criteria.createAlias("category", "c");
criteria.add(Expression.eq("c.name", cat.getName()));
criteria.add(Expression.eq("ancestorCategory", parent));
criteria.add(Expression.eq("relation", Assoc.PARENT));
sameNames = criteria.list();
} catch (HibernateException e) {
throw new RollerException(e);
}
if (sameNames.size() > 0) {
return true;
}
}
return false;
}
public List getWeblogEntries(WeblogCategoryData cat, boolean subcats) throws RollerException {
try {
Session session = ((HibernatePersistenceStrategy) this.strategy).getSession();
List entries = new LinkedList();
if (subcats) {
// Get entries in subcategories
Criteria assocsQuery = session.createCriteria(WeblogCategoryAssoc.class);
assocsQuery.add(Expression.eq("ancestorCategory", cat));
Iterator assocs = assocsQuery.list().iterator();
while (assocs.hasNext()) {
WeblogCategoryAssoc assoc = (WeblogCategoryAssoc) assocs.next();
Criteria entriesQuery = session.createCriteria(WeblogEntryData.class);
entriesQuery.add(Expression.eq("category", assoc.getCategory()));
Iterator entryIter = entriesQuery.list().iterator();
while (entryIter.hasNext()) {
WeblogEntryData entry = (WeblogEntryData) entryIter.next();
entries.add(entry);
}
}
}
// Get entries in category
Criteria entriesQuery = session.createCriteria(WeblogEntryData.class);
entriesQuery.add(Expression.eq("category", cat));
Iterator entryIter = entriesQuery.list().iterator();
while (entryIter.hasNext()) {
WeblogEntryData entry = (WeblogEntryData) entryIter.next();
entries.add(entry);
}
return entries;
} catch (HibernateException e) {
throw new RollerException(e);
}
}
public Label findByName(String name, long parent) {
final DetachedCriteria criteria = newCriteria();
criteria.add(Expression.eq("parentId", parent));
criteria.add(Expression.eq("name", name));
final List<Label> labels = findByCriteria(criteria);
return labels.size() > 0 ? labels.get(0) : null;
}
public List getWeblogCategoryChildAssocs(WeblogCategoryData cat) throws RollerException {
try {
Session session = ((HibernatePersistenceStrategy) this.strategy).getSession();
Criteria criteria = session.createCriteria(WeblogCategoryAssoc.class);
criteria.add(Expression.eq("ancestorCategory", cat));
criteria.add(Expression.eq("relation", Assoc.PARENT));
return criteria.list();
} catch (HibernateException e) {
throw new RollerException(e);
}
}
public WeblogEntryData getWeblogEntryByAnchor(WebsiteData website, String anchor)
throws RollerException {
if (website == null) throw new RollerException("Website is null");
if (anchor == null) throw new RollerException("Anchor is null");
// mapping key is combo of weblog + anchor
String mappingKey = website.getHandle() + ":" + anchor;
// check cache first
// NOTE: if we ever allow changing anchors then this needs updating
if (this.entryAnchorToIdMap.containsKey(mappingKey)) {
WeblogEntryData entry = this.getWeblogEntry((String) this.entryAnchorToIdMap.get(mappingKey));
if (entry != null) {
log.debug("entryAnchorToIdMap CACHE HIT - " + mappingKey);
return entry;
} else {
// mapping hit with lookup miss? mapping must be old, remove it
this.entryAnchorToIdMap.remove(mappingKey);
}
}
// cache failed, do lookup
try {
Session session = ((HibernatePersistenceStrategy) this.strategy).getSession();
Criteria criteria = session.createCriteria(WeblogEntryData.class);
criteria.add(
Expression.conjunction()
.add(Expression.eq("website", website))
.add(Expression.eq("anchor", anchor)));
criteria.addOrder(Order.desc("pubTime"));
criteria.setMaxResults(1);
List list = criteria.list();
WeblogEntryData entry = null;
if (list.size() != 0) {
entry = (WeblogEntryData) criteria.uniqueResult();
}
// add mapping to cache
if (entry != null) {
log.debug("entryAnchorToIdMap CACHE MISS - " + mappingKey);
this.entryAnchorToIdMap.put(mappingKey, entry.getId());
}
return entry;
} catch (HibernateException e) {
throw new RollerException(e);
}
}
/** @see SerializedObjectDAO#getAllObjects(Class, boolean) */
@SuppressWarnings("unchecked")
public List<SerializedObject> getAllSerializedObjects(Class<?> type, boolean includeRetired)
throws DAOException {
Criteria c = sessionFactory.getCurrentSession().createCriteria(SerializedObject.class);
c.add(
Expression.or(
Expression.eq("type", type.getName()), Expression.eq("subtype", type.getName())));
if (!includeRetired) {
c.add(Expression.like("retired", false));
}
return (List<SerializedObject>) c.list();
}
/** @see SerializedObjectDAO#getAllObjectsByName(Class, String) */
@SuppressWarnings("unchecked")
public List<SerializedObject> getAllSerializedObjectsByName(
Class<?> type, String name, boolean exactMatchOnly) throws DAOException {
Criteria c = sessionFactory.getCurrentSession().createCriteria(SerializedObject.class);
c.add(
Expression.or(
Expression.eq("type", type.getName()), Expression.eq("subtype", type.getName())));
if (exactMatchOnly) {
c.add(Expression.eq("name", name));
} else {
c.add(Expression.ilike("name", name, MatchMode.ANYWHERE));
}
return (List<SerializedObject>) c.list();
}
public boolean isDescendentOf(WeblogCategoryData child, WeblogCategoryData ancestor)
throws RollerException {
boolean ret = false;
try {
Session session = ((HibernatePersistenceStrategy) this.strategy).getSession();
Criteria criteria = session.createCriteria(WeblogCategoryAssoc.class);
criteria.add(Expression.eq("category", child));
criteria.add(Expression.eq("ancestorCategory", ancestor));
ret = criteria.list().size() > 0;
} catch (HibernateException e) {
throw new RollerException(e);
}
return ret;
}
@Override
public List<?> findSysCompanyUserRel(SysCompanyUserRel object) throws Exception {
if (null == object) {
return super.loadAll(object.getClass());
} else {
DetachedCriteria criteria = DetachedCriteria.forClass(object.getClass());
if (object.getId().getParentUserId() != null && object.getId().getParentUserId() > 0) {
criteria.add(Expression.eq("id.parentUserId", object.getId().getParentUserId()));
}
if (object.getId().getChildUserId() != null && object.getId().getChildUserId() > 0) {
criteria.add(Expression.eq("id.childUserId", object.getId().getChildUserId()));
}
return super.findByCriteria(criteria);
}
}
private void removeWeblogEntryContents(WeblogEntryData entry) throws RollerException {
if (entry == null) {
throw new RollerException("cannot remove null entry");
}
Session session = ((HibernatePersistenceStrategy) this.strategy).getSession();
// remove referers
Criteria refererQuery = session.createCriteria(RefererData.class);
refererQuery.add(Expression.eq("weblogEntry", entry));
List referers = refererQuery.list();
for (Iterator iter = referers.iterator(); iter.hasNext(); ) {
RefererData referer = (RefererData) iter.next();
this.strategy.remove(referer);
}
// remove comments
List comments =
getComments(
null, // website
entry, null, // search String
null, // startDate
null, // endDate
null, // pending
null, // approved
null, // spam
true, // reverse chrono order (not that it matters)
0, // offset
-1); // no limit
Iterator commentsIT = comments.iterator();
while (commentsIT.hasNext()) {
this.strategy.remove((CommentData) commentsIT.next());
}
}
/**
* Adds an <code>Expression</code> to a <code>Criteria</code>.
*
* @param criteria
* @param parameterName
* @param parameterValue
* @param comparatorID
* @param matchMode
*/
private void addExpression(
org.hibernate.Criteria criteria,
String parameterName,
Object parameterValue,
int comparatorID,
org.hibernate.criterion.MatchMode matchMode) {
if (parameterValue != null) {
switch (comparatorID) {
case CriteriaSearchParameter.LIKE_COMPARATOR:
{
if ((matchMode != null) && (parameterValue instanceof String)) {
criteria.add(
org.hibernate.criterion.Expression.like(
parameterName, (String) parameterValue, matchMode));
} else {
criteria.add(org.hibernate.criterion.Expression.like(parameterName, parameterValue));
}
break;
}
case CriteriaSearchParameter.INSENSITIVE_LIKE_COMPARATOR:
{
if ((matchMode != null) && (parameterValue instanceof String)) {
criteria.add(
org.hibernate.criterion.Expression.ilike(
parameterName, (String) parameterValue, matchMode));
} else {
criteria.add(org.hibernate.criterion.Expression.ilike(parameterName, parameterValue));
}
break;
}
case CriteriaSearchParameter.EQUAL_COMPARATOR:
{
criteria.add(org.hibernate.criterion.Expression.eq(parameterName, parameterValue));
break;
}
case CriteriaSearchParameter.GREATER_THAN_OR_EQUAL_COMPARATOR:
{
criteria.add(org.hibernate.criterion.Expression.ge(parameterName, parameterValue));
break;
}
case CriteriaSearchParameter.GREATER_THAN_COMPARATOR:
{
criteria.add(org.hibernate.criterion.Expression.gt(parameterName, parameterValue));
break;
}
case CriteriaSearchParameter.LESS_THAN_OR_EQUAL_COMPARATOR:
{
criteria.add(org.hibernate.criterion.Expression.le(parameterName, parameterValue));
break;
}
case CriteriaSearchParameter.LESS_THAN_COMPARATOR:
{
criteria.add(org.hibernate.criterion.Expression.lt(parameterName, parameterValue));
break;
}
}
} else {
criteria.add(org.hibernate.criterion.Expression.isNull(parameterName));
}
}
@Override
public List<TbData> findTbDataByPatient(final Patient patient) {
Criteria criteria = getSessionFactory().getCurrentSession().createCriteria(TbData.class);
criteria.add(Expression.eq("patient", patient));
criteria.addOrder(Order.asc("encounterDatetime"));
return criteria.list();
}
@Override
public List<TbData> findTbDataByEncounter(final Encounter encounter) {
Criteria criteria = getSessionFactory().getCurrentSession().createCriteria(TbData.class);
criteria.add(Expression.eq("encounter", encounter));
criteria.addOrder(Order.asc("question"));
return criteria.list();
}
public boolean isWeblogCategoryInUse(WeblogCategoryData cat) throws RollerException {
try {
Session session = ((HibernatePersistenceStrategy) this.strategy).getSession();
Criteria criteria = session.createCriteria(WeblogEntryData.class);
criteria.add(Expression.eq("category", cat));
criteria.setMaxResults(1);
int entryCount = criteria.list().size();
if (entryCount > 0) {
return true;
}
Iterator cats = cat.getWeblogCategories().iterator();
while (cats.hasNext()) {
WeblogCategoryData childCat = (WeblogCategoryData) cats.next();
if (childCat.isInUse()) {
return true;
}
}
if (cat.getWebsite().getBloggerCategory().equals(cat)) {
return true;
}
if (cat.getWebsite().getDefaultCategory().equals(cat)) {
return true;
}
return false;
} catch (HibernateException e) {
throw new RollerException(e);
}
}
/**
* @see org.openmrs.api.db.ObsDAO#getAllMimeTypes(boolean)
* @deprecated
*/
@SuppressWarnings("unchecked")
public List<MimeType> getAllMimeTypes(boolean includeRetired) throws DAOException {
Criteria crit = sessionFactory.getCurrentSession().createCriteria(MimeType.class);
if (includeRetired == false) crit.add(Expression.eq("retired", Boolean.FALSE));
return crit.list();
}
public Long getQuantidade(Class<? extends Segurado> klass, String situacao) {
Criteria criteria = HibernateUtil.currentSession().createCriteria(klass);
criteria
.add(Expression.eq("situacao.descricao", situacao))
.setProjection(Projections.rowCount());
return (Long) criteria.uniqueResult();
}
public List<Label> getByExmaple(Label example) {
DetachedCriteria criteria = newCriteria();
if (example.getParentId() != null)
criteria.add(Expression.eq("parentId", example.getParentId()));
if (example.getName() != null)
criteria.add(Expression.ilike("name", example.getName(), MatchMode.START));
criteria.addOrder(Order.asc("name"));
return findByCriteria(criteria);
}
public Assoc getWeblogCategoryParentAssoc(WeblogCategoryData cat) throws RollerException {
try {
Session session = ((HibernatePersistenceStrategy) this.strategy).getSession();
Criteria criteria = session.createCriteria(WeblogCategoryAssoc.class);
criteria.add(Expression.eq("category", cat));
criteria.add(Expression.eq("relation", Assoc.PARENT));
List parents = criteria.list();
if (parents.size() > 1) {
throw new RollerException("ERROR: more than one parent");
} else if (parents.size() == 1) {
return (Assoc) parents.get(0);
} else {
return null;
}
} catch (HibernateException e) {
throw new RollerException(e);
}
}
/** @see SerializedObjectDAO#getSerializedObjectByUuid(String) */
public SerializedObject getSerializedObjectByUuid(String uuid) throws DAOException {
SerializedObject ret = null;
if (uuid != null) {
Criteria c = sessionFactory.getCurrentSession().createCriteria(SerializedObject.class);
c.add(Expression.eq("uuid", uuid));
ret = (SerializedObject) c.uniqueResult();
}
return ret;
}
/** @see org.openmrs.notification.db.AlertDAO#getAlerts(org.openmrs.User, boolean, boolean) */
@SuppressWarnings("unchecked")
public List<Alert> getAlerts(User user, boolean includeRead, boolean includeExpired)
throws DAOException {
log.debug(
"Getting alerts for user "
+ user
+ " read? "
+ includeRead
+ " expired? "
+ includeExpired);
Criteria crit = sessionFactory.getCurrentSession().createCriteria(Alert.class, "alert");
if (user != null && user.getUserId() != null) {
crit.createCriteria("recipients", "recipient");
crit.add(Expression.eq("recipient.recipient", user));
} else {
// getting here means we passed in no user or a blank user.
// a null recipient column means get stuff for the anonymous user
// crit.add(Expression.isNull("recipient.recipient"));
// returning an empty list for now because the above throws an error.
// we may need to remodel how recipients are handled to get anonymous users alerts
return Collections.emptyList();
}
// exclude the expired alerts unless requested
if (includeExpired == false)
crit.add(
Expression.or(
Expression.isNull("dateToExpire"), Expression.gt("dateToExpire", new Date())));
// exclude the read alerts unless requested
if (includeRead == false && (user != null && user.getUserId() != null)) {
crit.add(Expression.eq("alertRead", false));
crit.add(Expression.eq("recipient.alertRead", false));
}
crit.addOrder(Order.desc("dateChanged"));
return crit.list();
}
public static Modelo Obtener(int id) {
Modelo entidad = new Modelo();
try {
Session session = HibernateUtils.getSession();
entidad =
(Modelo) session.createCriteria(Modelo.class).add(Expression.eq("id", id)).uniqueResult();
} catch (Exception ex) {
throw ex;
}
return entidad;
}
/**
* @see
* org.cipres.treebase.domain.study.CitationStatusHome#findStatusByDescription(java.lang.String)
*/
public CitationStatus findStatusByDescription(String pDescription) {
CitationStatus returnVal = null;
Criteria c =
getSession()
.createCriteria(CitationStatus.class)
.add(org.hibernate.criterion.Expression.eq("description", pDescription));
returnVal = (CitationStatus) c.uniqueResult();
return returnVal;
}
public WeblogCategoryData getRootWeblogCategory(WebsiteData website) throws RollerException {
if (website == null) throw new RollerException("website is null");
try {
Session session = ((HibernatePersistenceStrategy) this.strategy).getSession();
Criteria criteria = session.createCriteria(WeblogCategoryAssoc.class);
criteria.createAlias("category", "c");
criteria.add(Expression.eq("c.website", website));
criteria.add(Expression.isNull("ancestorCategory"));
criteria.add(Expression.eq("relation", WeblogCategoryAssoc.PARENT));
criteria.setMaxResults(1);
List list = criteria.list();
return ((WeblogCategoryAssoc) list.get(0)).getCategory();
} catch (HibernateException e) {
throw new RollerException(e);
}
}
public List getWeblogCategories(WebsiteData website) throws RollerException {
if (website == null) throw new RollerException("website is null");
try {
Session session = ((HibernatePersistenceStrategy) this.strategy).getSession();
Criteria criteria = session.createCriteria(WeblogCategoryData.class);
criteria.add(Expression.eq("website", website));
return criteria.list();
} catch (HibernateException e) {
throw new RollerException(e);
}
}
/** @see org.openmrs.api.db.LocationDAO#getAllLocations(boolean) */
@SuppressWarnings("unchecked")
public List<Location> getAllLocations(boolean includeRetired) {
Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Location.class);
if (!includeRetired) {
criteria.add(Expression.eq("retired", false));
} else {
// push retired locations to the end of the returned list
criteria.addOrder(Order.asc("retired"));
}
criteria.addOrder(Order.asc("name"));
return criteria.list();
}
/** @see LocationDAO#getRootLocations(boolean) */
@SuppressWarnings("unchecked")
@Override
public List<Location> getRootLocations(boolean includeRetired) throws DAOException {
Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Location.class);
if (!includeRetired) criteria.add(Expression.eq("retired", false));
criteria.add(Expression.isNull("parentLocation"));
criteria.addOrder(Order.asc("name"));
return criteria.list();
}
/** @see org.openmrs.api.db.LocationDAO#getCountOfLocations(String, Boolean) */
@Override
public Long getCountOfLocations(String nameFragment, Boolean includeRetired) {
Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Location.class);
if (!includeRetired) criteria.add(Expression.eq("retired", false));
if (StringUtils.isNotBlank(nameFragment))
criteria.add(Expression.ilike("name", nameFragment, MatchMode.START));
criteria.setProjection(Projections.rowCount());
return (Long) criteria.uniqueResult();
}