@SuppressWarnings("unchecked") public List<MatchedRevision> findRevisionsMatching(final MaterialConfig materialConfig, final String searchString) { return (List<MatchedRevision>) getHibernateTemplate().execute((HibernateCallback) session -> { String sql = "SELECT m.*" + " FROM modifications AS m" + " INNER JOIN materials mat ON mat.id = m.materialId" + " WHERE mat.fingerprint = :finger_print" + " AND (m.revision || ' ' || COALESCE(m.username, '') || ' ' || COALESCE(m.comment, '') LIKE :search_string OR m.pipelineLabel LIKE :search_string)" + " ORDER BY m.id DESC" + " LIMIT 5"; SQLQuery query = session.createSQLQuery(sql); query.addEntity("m", Modification.class); Material material = materialConfigConverter.toMaterial(materialConfig); query.setString("finger_print", material.getFingerprint()); query.setString("search_string", "%" + searchString + "%"); final List<MatchedRevision> list = new ArrayList<>(); for (Modification mod : (List<Modification>) query.list()) { list.add(material.createMatchedRevision(mod, searchString)); } return list; }); }
private Long findLastBuiltModificationId(final Pipeline pipeline, final MaterialInstance materialInstance) { BigInteger result = (BigInteger) getHibernateTemplate().execute((HibernateCallback) session -> { String sql = "SELECT fromRevisionId " + " FROM pipelineMaterialRevisions pmr " + " INNER JOIN pipelines p on p.id = pmr.pipelineId " + " WHERE materialId = ? " + " AND p.name = ? " + " AND pipelineId < ? " + " ORDER BY pmr.id DESC" + " LIMIT 1"; SQLQuery query = session.createSQLQuery(sql); query.setLong(0, materialInstance.getId()); query.setString(1, pipeline.getName()); query.setLong(2, pipeline.getId()); return query.uniqueResult(); }); return result == null ? null : result.longValue(); }
query.setLong(1, modificationId); query.setLong(2, modificationId); query.setString(3, pipelineName); if (!query.list().isEmpty()) { match++;
String queryString= "SELECT TABLE_ID, REGEXP_SUBSTR(TABLE_UID, ?, 1, 3) AS FIRST_COLUMN, REGEXP_SUBSTR(TABLE_UID, ?, 1, 2) AS SECOND_COLUMN, REGEXP_SUBSTR(TABLE_UID, ?, 1, 1) AS THIRD_COLUMN, USERID FROM TABLE_TABLE1 WHERE USERID= ?"; SQLQuery query = getSession().createSQLQuery(queryString); query.setString(0, "[^+]+"); query.setString(1, "[^+]+"); query.setString(2, "[^+]+"); query.setString(3, "abhi");
SQLQuery query = getSession().createSQLQuery(sql); query.setString("value", "Some value with : in it");
@Override public NativeQuery setString(String name, String value) { queryInfo.getParameters().put(name, value); query.setString(name, value); return this; }
public String getResult(String sortOrder){ SQLQuery query = getSession().createSQLQuery("select t from ( select t.id t from t_test t order by t.id=:sortOrder").addScalar("name", Hibernate.STRING); query.setString("sortOrder", sortOrder); return (String)query.uniqueResult(); }
@Override @Transactional public void deleteUserByName(final String name) { getSession().createSQLQuery("delete from OpenL_Users where loginName = :name").setString("name", name).executeUpdate(); }
@Override @Transactional public void deleteUserByName(final String name) { getSession().createSQLQuery("delete from OpenL_Users where loginName = :name").setString("name", name).executeUpdate(); }
@Override @Transactional public void deleteUserByName(final String name) { getSession().createSQLQuery("delete from OpenL_Users where loginName = :name").setString("name", name).executeUpdate(); }
@Override @Transactional public void deleteGroupByName(final String name) { getSession().createSQLQuery("delete from OpenL_Group2Group where includedGroupID = (select id from OpenL_Groups where groupName = :name)").setString("name", name).executeUpdate(); getSession().createSQLQuery("delete from OpenL_Groups where groupName = :name").setString("name", name).executeUpdate(); }
@Override @Transactional public void deleteGroupByName(final String name) { getSession().createSQLQuery("delete from OpenL_Group2Group where includedGroupID = (select id from OpenL_Groups where groupName = :name)").setString("name", name).executeUpdate(); getSession().createSQLQuery("delete from OpenL_Groups where groupName = :name").setString("name", name).executeUpdate(); }
@Override @Transactional public void deleteGroupByName(final String name) { getSession().createSQLQuery("delete from OpenL_Group2Group where includedGroupID = (select id from OpenL_Groups where groupName = :name)").setString("name", name).executeUpdate(); getSession().createSQLQuery("delete from OpenL_Groups where groupName = :name").setString("name", name).executeUpdate(); }
@Override public Item update(ExecutionContext executionContext, Item t) { Session session = getSession(executionContext); preSave(t, session); session.createSQLQuery("update tbl_condition set type=:TYPE WHERE id=:ID AND project_id=:PROJECT_ID") .setString("TYPE", t.condition.conditionType.toString()) .setLong("ID", t.condition.id) .setString("PROJECT_ID", userContext.getProjectId()) .executeUpdate(); session.update(t.condition); session.flush(); session.evict(t.condition); return retrieve(executionContext, Arrays.asList(t.condition.id)).stream().findFirst().get(); }
private void insertUserRole(final String user, final String role) { try { final int nextId = getNextId("user_role"); HibernateUtil.startTransaction(); final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery(SQL[INSERT_USER_ROLE]); sq.setInteger(0, nextId); sq.setString(1, user); sq.setString(2, role); sq.executeUpdate(); HibernateUtil.commitTransaction(); } catch (final Exception e) { HibernateUtil.rollbackTransaction(); } }
private int getRoleId(final String role) { try { HibernateUtil.startTransaction(); final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery("select id from role where rolename = ?"); sq.setString(0, role); final Integer id = (Integer) sq.uniqueResult(); HibernateUtil.commitTransaction(); return id.intValue(); } catch (final Exception e) { HibernateUtil.rollbackTransaction(); throw new NakedObjectRuntimeException(e); } }
private final void setRoles(final AuthenticationRequest request) { try { HibernateUtil.startTransaction(); final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery(SELECT_ROLES_SQL); sq.setString(0, request.getName()); sq.addScalar("rr", Hibernate.STRING); final List<String> roles = sq.list(); HibernateUtil.commitTransaction(); request.setRoles(roles.toArray(new String[roles.size()])); } catch (final Exception e) { HibernateUtil.rollbackTransaction(); throw new NakedObjectRuntimeException(e); } }
private void insertRole(final String role) { try { final int nextId = getNextId("role"); HibernateUtil.startTransaction(); final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery(SQL[INSERT_ROLE]); sq.setInteger(0, nextId); sq.setString(1, role); sq.executeUpdate(); HibernateUtil.commitTransaction(); } catch (final Exception e) { HibernateUtil.rollbackTransaction(); } }