/** * @see org.openmrs.api.db.PersonDAO#getSavedPersonAttributeTypeName(org.openmrs.PersonAttributeType) */ @Override public String getSavedPersonAttributeTypeName(PersonAttributeType personAttributeType) { SQLQuery sql = sessionFactory.getCurrentSession().createSQLQuery( "select name from person_attribute_type where person_attribute_type_id = :personAttributeTypeId"); sql.setInteger("personAttributeTypeId", personAttributeType.getId()); return (String) sql.uniqueResult(); }
/** * @see org.openmrs.api.db.PatientDAO#getAllergyStatus(org.openmrs.Patient) */ //@Override @Override public String getAllergyStatus(Patient patient) { return (String) sessionFactory.getCurrentSession().createSQLQuery( "select allergy_status from patient where patient_id = :patientId").setInteger("patientId", patient.getPatientId()).uniqueResult(); }
/** * @see org.openmrs.api.db.ConceptDAO#getSavedConceptDatatype(org.openmrs.Concept) */ @Override public ConceptDatatype getSavedConceptDatatype(Concept concept) { SQLQuery sql = sessionFactory.getCurrentSession().createSQLQuery( "select datatype.* from " + "concept_datatype datatype, " + "concept concept " + "where " + "datatype.concept_datatype_id = concept.datatype_id " + "and concept.concept_id=:conceptId") .addEntity(ConceptDatatype.class); sql.setInteger("conceptId", concept.getConceptId()); return (ConceptDatatype) sql.uniqueResult(); }
/** * @see org.openmrs.api.db.PatientDAO#saveAllergies(org.openmrs.Patient, * org.openmrsallergyapi.Allergies) */ @Override public Allergies saveAllergies(Patient patient, Allergies allergies) { sessionFactory.getCurrentSession().createSQLQuery( "update patient set allergy_status = :allergyStatus where patient_id = :patientId") .setInteger("patientId", patient.getPatientId()) .setString("allergyStatus", allergies.getAllergyStatus()) .executeUpdate(); for (Allergy allergy : allergies) { sessionFactory.getCurrentSession().save(allergy); } return allergies; }
/** * @see org.openmrs.api.db.EncounterDAO#getSavedEncounterDatetime(org.openmrs.Encounter) */ @Override public Date getSavedEncounterDatetime(Encounter encounter) { //Usages of this method currently are internal and don't require a flush //Otherwise we end up with premature flushes of Immutable types like Obs //that are associated to the encounter before we void and replace them Session session = sessionFactory.getCurrentSession(); FlushMode flushMode = session.getFlushMode(); session.setFlushMode(FlushMode.MANUAL); try { SQLQuery sql = session .createSQLQuery("select encounter_datetime from encounter where encounter_id = :encounterId"); sql.setInteger("encounterId", encounter.getEncounterId()); return (Date) sql.uniqueResult(); } finally { session.setFlushMode(flushMode); } }
/** * @see org.openmrs.api.db.ObsDAO#getSavedStatus(org.openmrs.Obs) */ @Override public Obs.Status getSavedStatus(Obs obs) { // avoid premature flushes when this internal method is called from inside a service method Session session = sessionFactory.getCurrentSession(); FlushMode flushMode = session.getFlushMode(); session.setFlushMode(FlushMode.MANUAL); try { SQLQuery sql = session.createSQLQuery("select status from obs where obs_id = :obsId"); sql.setInteger("obsId", obs.getObsId()); return Obs.Status.valueOf((String) sql.uniqueResult()); } finally { session.setFlushMode(flushMode); } }
/** * @see org.openmrs.api.db.EncounterDAO#getSavedEncounterLocation(org.openmrs.Encounter) */ @Override public Location getSavedEncounterLocation(Encounter encounter) { Session session = sessionFactory.getCurrentSession(); FlushMode flushMode = session.getFlushMode(); session.setFlushMode(FlushMode.MANUAL); try { SQLQuery sql = session.createSQLQuery("select location_id from encounter where encounter_id = :encounterId"); sql.setInteger("encounterId", encounter.getEncounterId()); return Context.getLocationService().getLocation((Integer) sql.uniqueResult()); } finally { session.setFlushMode(flushMode); } }
.addScalar("password", StandardBasicTypes.STRING).setInteger(0, candidateUser.getUserId()) .uniqueResult(); "salt", StandardBasicTypes.STRING).setInteger(0, candidateUser.getUserId()).uniqueResult();
String query = "select schema.procedure_name(:param1)"; SQLQuery sqlquery = sessionFactory.getCurrentSession().createSQLQuery(query); sqlquery.setInteger("param1", "this is first parameter"); sqlQuery.list();
@SuppressWarnings("unchecked") public List<Integer> getUsersByPersonAttribute(Integer personAttributeTypeId, String personAttributeValue) { Session session = sessionFactory.getCurrentSession(); return (List<Integer>) session .createSQLQuery( "select u.user_id from person p inner join users u on u.user_id = p.person_id " + "inner join person_attribute a on p.person_id = a.person_id " + "where a.voided = false and p.voided = false and u.voided = false " + "and a.person_attribute_type_id = :typeId and a.value = :value group by u.user_id") .setInteger("typeId", personAttributeTypeId).setString("value", personAttributeValue).list(); }
public int updateSomeParameter(String tableName, String idColumnName, int id, String parameterColumnName, Object newParameterValue) { String sql = "UPDATE " + tableName + " SET " + parameterColumnName + " = :new_value WHERE " + idColumnName + " = :id"; SQLQuery query = session.createSQLQuery(sql); query.setInteger("id", id); query.setParameter("new_value", newParameterValue); return query.executeUpdate(); }
private boolean learn(final String role, final String key, final Integer flag) { if (isMatch(role, key, flag)) { return true; } try { final int permissionId = getNextId(); final int roleId = getRoleId(role); HibernateUtil.startTransaction(); final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery(flag == null ? noFlagInsert : flagInsert); sq.setInteger(0, permissionId); sq.setInteger(1, roleId); sq.setString(2, key); if (flag != null) { sq.setInteger(3, flag.intValue()); } sq.executeUpdate(); HibernateUtil.commitTransaction(); } catch (final Exception e) { HibernateUtil.rollbackTransaction(); throw new NakedObjectRuntimeException(e); } return true; }
+ "(select surfaceLocationId from Finding where scanId = :scanId) " + "order by path") .setInteger("scanId", scanId).list();
private void insertPermission(final String role, final String permission, final Integer flag) { try { final int nextId = getNextId("permissions"); HibernateUtil.startTransaction(); final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery(SQL[INSERT_PERMISSION]); sq.setInteger(0, nextId); sq.setString(1, role); sq.setString(2, permission); if (flag == null) { sq.setParameter(3, null, Hibernate.INTEGER); } else { sq.setInteger(3, flag.intValue()); } sq.executeUpdate(); HibernateUtil.commitTransaction(); } catch (final Exception e) { HibernateUtil.rollbackTransaction(); } }
private boolean isMatch(final String role, final String key, final Integer flag) { try { HibernateUtil.startTransaction(); final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery(flag == null ? noFlagMatch : flagMatch); sq.setString(0, role); sq.setString(1, key); if (flag != null) { sq.setInteger(2, flag.intValue()); } final Number count = (Number) sq.uniqueResult(); HibernateUtil.commitTransaction(); return count != null && count.intValue() > 0; } 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(); } }
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 void insertUser(final String username, final String password) { try { final int nextId = getNextId("user"); HibernateUtil.startTransaction(); final SQLQuery sq = HibernateUtil.getCurrentSession().createSQLQuery(SQL[INSERT_USER]); sq.setInteger(0, nextId); sq.setString(1, username); sq.setString(2, databaseAuthenticator.generateHash(password)); sq.setBoolean(3, false); sq.executeUpdate(); HibernateUtil.commitTransaction(); } catch (final Exception e) { HibernateUtil.rollbackTransaction(); } }