Best code snippets using org.hibernate.type.StringType.<init>(Showing top 15 results out of 315)

public void validateTeachingRequestsRollForward(Session toAcadSession, ActionErrors errors){
  if (getRollForwardTeachingRequests().booleanValue()) {
    if (getRollForwardOfferingCoordinatorsSubjectIds() == null || getRollForwardOfferingCoordinatorsSubjectIds().length == 0) {
      errors.add("mustSelectDepartment", new ActionMessage("errors.rollForward.generic", "Teaching Requests", "No subject area selected."));
    } else {
      validateRollForward(errors, toAcadSession, getSessionToRollInstructorDataForwardFrom(), "Teaching Requests",
        TeachingRequestDAO.getInstance().getQuery("select tr from TeachingRequest tr inner join tr.offering.courseOfferings co where co.isControl = true and co.subjectArea.uniqueId in :subjectIds")
        .setParameterList("subjectIds", getRollForwardOfferingCoordinatorsSubjectIds(), new StringType()).list());
    }
  }
}

private void addCriteriaForSiteStatusView(OnmsCriteria criteria, String statusViewName, String statusSite, String rowLabel) {
  View view = m_siteStatusViewConfigDao.getView(statusViewName);
  RowDef rowDef = getRowDef(view, rowLabel);
  Set<String> categoryNames = getCategoryNamesForRowDef(rowDef);
  
  addCriteriaForCategories(criteria, categoryNames.toArray(new String[categoryNames.size()]));
  
  String sql = "{alias}.nodeId in (select nodeId from assets where " + view.getColumnName() + " = ?)";
  criteria.add(Restrictions.sqlRestriction(sql, statusSite, new StringType()));
}

 if(parameter.getValue() instaceof String){
  query.setParameter(parameter.getKey(), parameter.getValue(), new StringType());
} else if (parameter.getValue() instanceof Integer){
  query.setParameter(parameter.getKey(), parameter.getValue(), new IntegerTypeType())
} else if(...)

 Criteria criteria = session.createCriteria(MyTable.class);
criteria.add( 
 Expression.sql(
  "TIME( {alias}.my_date, 'hh:mm:ss') >= :1", 
  dateRangeMin, 
  new StringType()
 )
);

/**
 * @see org.openmrs.api.PersonService#getRelationshipTypes(java.lang.String, java.lang.Boolean)
 * @see org.openmrs.api.db.PersonDAO#getRelationshipTypes(java.lang.String, java.lang.Boolean)
 */
@Override
@SuppressWarnings("unchecked")
public List<RelationshipType> getRelationshipTypes(String relationshipTypeName, Boolean preferred) throws DAOException {
  
  Criteria criteria = sessionFactory.getCurrentSession().createCriteria(RelationshipType.class);
  criteria.add(Restrictions.sqlRestriction("CONCAT(a_Is_To_B, CONCAT('/', b_Is_To_A)) like (?)", relationshipTypeName,
    new StringType()));
  
  if (preferred != null) {
    criteria.add(Restrictions.eq("preferred", preferred));
  }
  
  return criteria.list();
}

  @SuppressWarnings("unchecked")
  private ExtendedTime        getPubAndX              (final String query, final PublishedAssessmentIfc pub, final String secondParam, final String secondParamValue) {
    try{
      HibernateCallback hcb = (Session s) -> {
        Query q = s.getNamedQuery(query);
        q.setParameter(PUBLISHED_ID, pub, new ManyToOneType(null, "org.sakaiproject.tool.assessment.data.dao.assessment.PublishedAssessmentData"));
        q.setParameter(secondParam, secondParamValue, new StringType());
        return q.uniqueResult();
      };

      return (ExtendedTime) getHibernateTemplate().execute(hcb);
    } catch (DataAccessException e) {
      log.error("Failed to get extended time for pub: " + pub.getPublishedAssessmentId() + " and user/group: " + secondParamValue, e);
      return null;
    }
  }
}

@Override
public void visitSql(final SqlRestriction restriction) {
  if (restriction.getParameters() != null && restriction.getParameters().length > 0) {
    // Map our {@link Type} enum values to {@link org.hibernate.type.Type} equivalents 
    org.hibernate.type.Type[] types = Arrays.stream(restriction.getTypes()).map(t -> { 
      switch(t) {
      case FLOAT:
        return new FloatType();
      case INTEGER:
        return new IntegerType();
      case LONG:
        return new LongType();
      case STRING:
        return new StringType();
      case TIMESTAMP:
        return new TimestampType();
      default: 
        throw new UnsupportedOperationException("Unsupported type specified in SqlRestriction");
      }
    }).collect(Collectors.toList()).toArray(new org.hibernate.type.Type[restriction.getTypes().length]);
    m_criterions.add(org.hibernate.criterion.Restrictions.sqlRestriction(restriction.getAttribute(), restriction.getParameters(), types));
  } else {
    m_criterions.add(org.hibernate.criterion.Restrictions.sqlRestriction(restriction.getAttribute()));
  }
}

public org.hibernate.Query setParams(org.hibernate.Query query, Collection<String> excludeOption) {
  for (Map.Entry<String, Map<String, Object>> entry: iParams.entrySet()) {
    if (excludeOption != null && excludeOption.contains(entry.getKey())) continue;
    for (Map.Entry<String, Object> param: entry.getValue().entrySet()) {
      if (param.getValue() instanceof Integer) {
        query.setInteger(param.getKey(), (Integer)param.getValue());
      } else if (param.getValue() instanceof Long) {
        query.setLong(param.getKey(), (Long)param.getValue());
      } else if (param.getValue() instanceof String) {
        query.setString(param.getKey(), (String)param.getValue());
      } else if (param.getValue() instanceof Boolean) {
        query.setBoolean(param.getKey(), (Boolean)param.getValue());
      } else if (param.getValue() instanceof Date) {
        query.setDate(param.getKey(), (Date)param.getValue());
      } else if (param.getValue() instanceof List) {
        List<?> list = (List<?>)param.getValue();
        if (!list.isEmpty() && list.get(0) instanceof Long)
          query.setParameterList(param.getKey(), list, new LongType());
        else if (!list.isEmpty() && list.get(0) instanceof String)
          query.setParameterList(param.getKey(), list, new StringType());
        else
          query.setParameterList(param.getKey(), list);
      } else {
        query.setString(param.getKey(), param.getValue().toString());
      }
    }
  }
  return query;
}

 public List<MessageExtDto> getMessagesForProfile2(Long userProfileId) {
  Query query = getSession().createSQLQuery("  "
      + " select a.*, b.* "
      + " from messageVO AS a "
      + " INNER JOIN ( SELECT max(id) AS id, count(*) AS count FROM messageVO GROUP BY messageConversation_id) as b ON a.id = b.id "
      + " where a.id > 0 "
      + " ")
      .addScalar("id", new LongType())
      .addScalar("message", new StringType())
      ......... your mappings
      .setResultTransformer(Transformers.aliasToBean(MessageExtDto.class));

  List<MessageExtDto> list = query.list();
  return list;
}

"   store t4 ON (t1.idStore = " + idStore + ")\n " +
"group by t1.id")
.addScalar("goodsName", new StringType())
.addScalar("companyName", new StringType())
.addScalar("amountSum", new IntegerType())
.addScalar("priceOneGoods", new DoubleType())

Query query = session.createSQLQuery("select AUDIANCE_NO as audianceno , MSG_BODY as messageBody from SMS_MSG_QUEUE").addScalar("audianceno" , new BigDecimalType()).addScalar("messageBody" , new StringType()).setResultTransformer(Transformers.aliasToBean(AudinceInfo.class));

.addScalar("id", new LongType())
 .addScalar("name", new StringType())

 Criteria criteria = s.createCriteria(User.class);
criteria.add(
  Expression.sql("userName = ? collate Latin1_General_CS_AS_KS_WS", userName, new StringType())
);

/**
 * @see org.openmrs.api.PersonService#getRelationshipTypes(java.lang.String, java.lang.Boolean)
 * @see org.openmrs.api.db.PersonDAO#getRelationshipTypes(java.lang.String, java.lang.Boolean)
 */
@SuppressWarnings("unchecked")
public List<RelationshipType> getRelationshipTypes(String relationshipTypeName, Boolean preferred) throws DAOException {
  
  Criteria criteria = sessionFactory.getCurrentSession().createCriteria(RelationshipType.class);
  criteria.add(Restrictions.sqlRestriction("CONCAT(a_Is_To_B, CONCAT('/', b_Is_To_A)) like (?)", relationshipTypeName,
    new StringType()));
  
  if (preferred != null) {
    criteria.add(Restrictions.eq("preferred", preferred));
  }
  
  return criteria.list();
}

  @SuppressWarnings("unchecked")
  private ExtendedTime        getPubAndX              (final String query, final PublishedAssessmentIfc pub, final String secondParam, final String secondParamValue) {
    try{
      HibernateCallback hcb = (Session s) -> {
        Query q = s.getNamedQuery(query);
        q.setParameter(PUBLISHED_ID, pub, new ManyToOneType(null, "org.sakaiproject.tool.assessment.data.dao.assessment.PublishedAssessmentData"));
        q.setParameter(secondParam, secondParamValue, new StringType());
        return q.uniqueResult();
      };

      return (ExtendedTime) getHibernateTemplate().execute(hcb);
    } catch (DataAccessException e) {
      log.error("Failed to get extended time for pub: " + pub.getPublishedAssessmentId() + " and user/group: " + secondParamValue, e);
      return null;
    }
  }
}