@Test public void testIgnoreCaseCriteria() { User user1 = new User(1, "Chris"); User user2 = new User(2, "Steve"); doInHibernate( this::sessionFactory, session -> { session.save(user1); session.save(user2); } ); doInHibernate( this::sessionFactory, session -> { Criteria criteria = session.createCriteria(User.class); criteria.add(Restrictions.eq("name", user1.getName().toLowerCase()).ignoreCase()); assertEquals(1, criteria.list().size()); } ); }
Restrictions.like( "text", pattern ).ignoreCase() ).list();
.add( Restrictions.eq( "integer", f.getInteger() ) ) .add( Restrictions.eqProperty("integer", "integer") ) .add( Restrictions.like( "string", f.getString().toUpperCase(Locale.ROOT) ).ignoreCase() ) .add( Restrictions.in( "boolean", f.getBoolean(), f.getBoolean() ) ) .setFetchMode("foo", FetchMode.JOIN)
/** * @see org.openmrs.api.UserService#getUserByEmail(java.lang.String) */ @Override @SuppressWarnings("unchecked") public User getUserByEmail(String email) { return (User) sessionFactory.getCurrentSession().createCriteria(User.class).add(Restrictions.eq("email", email).ignoreCase()).uniqueResult(); }
/** * @see org.openmrs.api.db.AdministrationDAO#getGlobalPropertyObject(java.lang.String) */ @Override public GlobalProperty getGlobalPropertyObject(String propertyName) { if (isDatabaseStringComparisonCaseSensitive()) { Criteria criteria = sessionFactory.getCurrentSession().createCriteria(GlobalProperty.class); return (GlobalProperty) criteria.add(Restrictions.eq(PROPERTY, propertyName).ignoreCase()) .uniqueResult(); } else { return (GlobalProperty) sessionFactory.getCurrentSession().get(GlobalProperty.class, propertyName); } }
/** * @see org.openmrs.api.db.ConceptDAO#getDrugs(java.lang.String, org.openmrs.Concept, boolean) */ @Override @SuppressWarnings("unchecked") public List<Drug> getDrugs(String drugName, Concept concept, boolean includeRetired) throws DAOException { Criteria searchCriteria = sessionFactory.getCurrentSession().createCriteria(Drug.class, "drug"); if (!includeRetired) { searchCriteria.add(Restrictions.eq("drug.retired", false)); } if (concept != null) { searchCriteria.add(Restrictions.eq("drug.concept", concept)); } if (drugName != null) { SimpleExpression eq = Restrictions.eq("drug.name", drugName); if (Context.getAdministrationService().isDatabaseStringComparisonCaseSensitive()) { eq = eq.ignoreCase(); } searchCriteria.add(eq); } return (List<Drug>) searchCriteria.list(); }
criteria.add(Restrictions.eq("term.code", code).ignoreCase()); } else { criteria.add(Restrictions.eq("term.code", code)); criteria.add(Restrictions.or(Restrictions.eq("source.name", sourceName).ignoreCase(), Restrictions.eq( "source.hl7Code", sourceName).ignoreCase())); } else { criteria.add(Restrictions.or(Restrictions.eq("source.name", sourceName), Restrictions.eq("source.hl7Code",
private Criterion getCriterionForShortName(String name, boolean includeVoided) { Criterion criterion = Restrictions.disjunction().add( Restrictions.conjunction().add(Restrictions.isNotNull("name.givenName")).add( Restrictions.eq("name.givenName", name).ignoreCase())).add( Restrictions.conjunction().add(Restrictions.isNotNull("name.middleName")).add( Restrictions.eq("name.middleName", name).ignoreCase())).add( Restrictions.conjunction().add(Restrictions.isNotNull("name.familyName")).add( Restrictions.eq("name.familyName", name).ignoreCase())).add( Restrictions.conjunction().add(Restrictions.isNotNull("name.familyName2")).add( Restrictions.eq("name.familyName2", name).ignoreCase())); if (!includeVoided) { return Restrictions.conjunction().add(Restrictions.eq("name.voided", false)).add(criterion); } return criterion; }
.getLocale().getLanguage())))); if (Context.getAdministrationService().isDatabaseStringComparisonCaseSensitive()) { criteria.add(Restrictions.eq("name", name.getName()).ignoreCase()); } else { criteria.add(Restrictions.eq("name", name.getName()));
SimpleExpression matchIdentifier = Restrictions.eq("ids.identifier", identifier); if (Context.getAdministrationService().isDatabaseStringComparisonCaseSensitive()) { matchIdentifier.ignoreCase();
private Criteria getCriteriaByPropertyName( String propertyName, String value, boolean ignoreCase ) { Criteria criteria = getSession().createCriteria( entityClass ); SimpleExpression restriction = Restrictions.eq( propertyName, value ); if ( ignoreCase ) { restriction.ignoreCase(); } criteria.add( restriction ); return criteria; } }
@Override public Role retrieveByNameIgnoreCase(String name) { return (Role) getActiveRoleCriteria() .add(Restrictions.eq("displayName", name).ignoreCase()) .uniqueResult(); }
private void addCaseInsensitivePropertyMatch(Criteria criteria, Set<String> fields) { Disjunction disjunction = Restrictions.disjunction(); for (String field : fields) { disjunction.add(Restrictions.eq("name", field).ignoreCase()); } criteria.add(disjunction); }
private void addCaseInsensitivePropertyMatch(Criteria criteria, Set<String> fields) { Disjunction disjunction = Restrictions.disjunction(); for (String field: fields) { disjunction.add(Restrictions.eq("name", field).ignoreCase()); } criteria.add(disjunction); }
@Override public ChannelVulnerability retrieveByCode(ChannelType channelType, String code) { return (ChannelVulnerability) sessionFactory.getCurrentSession() .createCriteria(ChannelVulnerability.class) .add( Restrictions.eq("code", code).ignoreCase() ) .add( Restrictions.eq("channelType", channelType) ) .setMaxResults(1) .uniqueResult(); }
@Override public T retrieveByNameIgnoreCase(String name) { return (T) getSession() .createCriteria(getClassReference()) .add(Restrictions.eq("name", name).ignoreCase()) .uniqueResult(); }
@Override public Report retrieveByNameIgnoreCase(String name) { return (Report) sessionFactory.getCurrentSession() .createCriteria(getClassReference()) .add(Restrictions.eq("displayName", name).ignoreCase()) .uniqueResult(); }
@Override public Collection<CollectionSequence> retrieve(ExecutionContext executionContext, String name) { Session session = getSession(executionContext); // we can use the base criteria, just add on the name restriction. Criteria criteria = createThisObjectsBaseCriteria(session); criteria.add(Restrictions.eq("name", name).ignoreCase()); List<CollectionSequence> items = criteria.list(); evict(session, items); forceLazyInitializedPropsToNull(items); return items; }
/** * @inheritDoc */ public List<T> getByShortlabelOrAcLike( String searchString ) { return getSession().createCriteria( getEntityClass() ).addOrder( Order.asc( "shortLabel" ) ) .add( Restrictions.or( Restrictions.like( "ac", searchString ).ignoreCase(), Restrictions.like( "shortLabel", searchString ).ignoreCase() ) ).list(); }
/** * @inheritDoc */ public List<T> getByShortlabelOrAcLike(String searchString) { return getSession().createCriteria(getEntityClass()).addOrder(Order.asc("shortLabel")) .add(Restrictions.or( Restrictions.like("ac", searchString).ignoreCase(), Restrictions.like("shortLabel", searchString).ignoreCase())).list(); }