/** * <p>Retrieve entity from DB by given ID.</p> * @param <T> entity type * @param pEntityClass entity class * @param pId ID * @return entity or null * @throws Exception - an exception **/ @Override public final <T> T retrieveEntityById( final Class<T> pEntityClass, final Object pId) throws Exception { String query = evalSqlSelect(pEntityClass, pId); return retrieveEntity(pEntityClass, query); }
/** * <p>Refresh entity from DB.</p> * @param <T> entity type * @param pAddParam additional param, e.g. already retrieved TableSql * @param pEntity entity * @return entity or null * @throws Exception - an exception **/ @Override public final <T> T retrieveEntity(final Map<String, Object> pAddParam, final T pEntity) throws Exception { String query = evalSqlSelect(pAddParam, pEntity.getClass()); pAddParam.put("isOnlyId", Boolean.TRUE); ColumnsValues columnsValues = evalColumnsValues(pAddParam, pEntity); pAddParam.remove("isOnlyId"); String whereStr = evalWhereId(pEntity, columnsValues); @SuppressWarnings("unchecked") Class<T> entityClass = (Class<T>) pEntity.getClass(); return retrieveEntity(pAddParam, entityClass, query + " where " + whereStr); }
/** * <p>Retrieve entity from DB by given query conditions. * The first record in recordset will be used.</p> * @param <T> entity type * @param pEntityClass entity class * @param pQueryConditions e.g. "WHERE name='U1' ORDER BY id" * @return entity or null * @throws Exception - an exception **/ @Override public final <T> T retrieveEntityWithConditions( final Class<T> pEntityClass, final String pQueryConditions) throws Exception { String query = evalSqlSelect(pEntityClass); if (pQueryConditions == null) { throw new ExceptionWithCode(ExceptionWithCode.WRONG_PARAMETER, "param_null_not_accepted"); } return retrieveEntity(pEntityClass, query + " " + pQueryConditions + ";\n"); }
/** * <p>Retrieve entity from DB by given query conditions. * The first record in record-set will be returned.</p> * @param <T> entity type * @param pAddParam additional param, e.g. already retrieved TableSql * @param pEntityClass entity class * @param pQueryConditions Not NULL e.g. "where name='U1' ORDER BY id" * or "" that means without filter/order * @return entity or null * @throws Exception - an exception **/ @Override public final <T> T retrieveEntityWithConditions( final Map<String, Object> pAddParam, final Class<T> pEntityClass, final String pQueryConditions) throws Exception { if (pQueryConditions == null) { throw new ExceptionWithCode(ExceptionWithCode.WRONG_PARAMETER, "param_null_not_accepted"); } String query = evalSqlSelect(pAddParam, pEntityClass); return retrieveEntity(pAddParam, pEntityClass, query + " " + pQueryConditions + ";\n"); }
if (recordSet.moveToFirst()) { do { result.add(retrieveEntity(pEntityClass, recordSet)); } while (recordSet.moveToNext());
if (recordSet.moveToFirst()) { do { result.add(retrieveEntity(pEntityClass, recordSet)); } while (recordSet.moveToNext());
/** * <p>Retrieve a list of all entities.</p> * @param <T> - type of business object, * @param pEntityClass entity class * @return list of all business objects or empty list, not null * @throws Exception - an exception */ @Override public final <T> List<T> retrieveList( final Class<T> pEntityClass) throws Exception { List<T> result = new ArrayList<T>(); IRecordSet<RS> recordSet = null; try { String query = evalSqlSelect(pEntityClass) + ";\n"; recordSet = getSrvDatabase().retrieveRecords(query); if (recordSet.moveToFirst()) { do { result.add(retrieveEntity(pEntityClass, recordSet)); } while (recordSet.moveToNext()); } } finally { if (recordSet != null) { recordSet.close(); } } return result; }
if (recordSet.moveToFirst()) { do { result.add(retrieveEntity(pEntityClass, recordSet)); } while (recordSet.moveToNext());
/** * <p>Refresh entity from DB by its ID.</p> * @param <T> entity type * @param pAddParam additional param * @param pEntityClass entity class * @param pItsId entity ID * @return entity or null * @throws Exception - an exception **/ @Override public final <T> T retrieveEntityById(final Map<String, Object> pAddParam, final Class<T> pEntityClass, final Object pItsId) throws Exception { String query = evalSqlSelect(pAddParam, pEntityClass); @SuppressWarnings("unchecked") IFactorySimple<T> facEn = (IFactorySimple<T>) this.entitiesFactoriesFatory .lazyGet(pAddParam, pEntityClass); T entity = facEn.create(pAddParam); @SuppressWarnings("unchecked") IFillerObjectFields<T> filler = (IFillerObjectFields<T>) this.fctFillersObjectFields.lazyGet(pAddParam, pEntityClass); String idFldName = this.tablesMap .get(pEntityClass.getSimpleName()).getIdFieldName(); filler.fill(pAddParam, entity, pItsId, idFldName); pAddParam.put("isOnlyId", Boolean.TRUE); ColumnsValues columnsValues = evalColumnsValues(pAddParam, entity); pAddParam.remove("isOnlyId"); String whereId = evalWhereId(entity, columnsValues); return retrieveEntity(pAddParam, pEntityClass, query + " where " + whereId + ";\n"); }
/** * <p>Retrieve entity from DB.</p> * @param <T> entity type * @param pEntityClass entity class * @param pQuery SELECT statement * @return entity or null * @throws Exception - an exception **/ @Override public final <T> T retrieveEntity( final Class<T> pEntityClass, final String pQuery) throws Exception { T entity = null; IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(pQuery); if (recordSet.moveToFirst()) { entity = retrieveEntity(pEntityClass, recordSet); } } finally { if (recordSet != null) { recordSet.close(); } } return entity; }
/** * <p>Retrieve entity from DB.</p> * @param <T> entity type * @param pAddParam additional param, e.g. already retrieved TableSql * @param pEntityClass entity class * @param pQuery SELECT statement * @return entity or null * @throws Exception - an exception **/ public final <T> T retrieveEntity(final Map<String, Object> pAddParam, final Class<T> pEntityClass, final String pQuery) throws Exception { T entity = null; IRecordSet<RS> recordSet = null; try { recordSet = getSrvDatabase().retrieveRecords(pQuery); if (recordSet.moveToFirst()) { entity = retrieveEntity(pAddParam, pEntityClass, recordSet); } } finally { if (recordSet != null) { recordSet.close(); } } return entity; }
if (recordSet.moveToFirst()) { do { result.add(retrieveEntity(pAddParam, pEntityClass, recordSet)); } while (recordSet.moveToNext());
final Map<String, Object> pAddParam, final T pEntity, final IRequestData pRequestData) throws Exception { T entity = this.srvOrm.retrieveEntity(pAddParam, pEntity); entity.setIsNew(false); pRequestData.setAttribute("entity", entity);
if (recordSet.moveToFirst()) { do { result.add(retrieveEntity(pAddParam, pEntityClass, recordSet)); } while (recordSet.moveToNext());
if (recordSet.moveToFirst()) { do { result.add(retrieveEntity(pEntityClass, recordSet)); } while (recordSet.moveToNext());
if (recordSet.moveToFirst()) { do { result.add(retrieveEntity(pEntityClass, recordSet)); } while (recordSet.moveToNext());
/** * <p>Process entity request.</p> * @param pAddParam additional param, e.g. return this line's * document in "nextEntity" for farther process * @param pRequestData Request Data * @param pEntity Entity to process * @return Entity processed for farther process or null * @throws Exception - an exception **/ @Override public final T process( final Map<String, Object> pAddParam, final T pEntity, final IRequestData pRequestData) throws Exception { T entity = this.srvOrm.retrieveEntity(pAddParam, pEntity); entity.setIsNew(true); entity.setItsId(null); pRequestData.setAttribute("entity", entity); pRequestData.setAttribute("mngUvds", this.mngUvdSettings); pRequestData.setAttribute("srvOrm", this.srvOrm); pRequestData.setAttribute("srvDate", this.srvDate); pRequestData.setAttribute("hldCnvFtfsNames", this.fieldConverterNamesHolder); pRequestData.setAttribute("fctCnvFtfs", this.convertersFieldsFatory); return entity; }
/** * <p>Process entity request.</p> * @param pAddParam additional param, e.g. return this line's * document in "nextEntity" for farther process * @param pRequestData Request Data * @param pEntity Entity to process * @return Entity processed for farther process or null * @throws Exception - an exception **/ @Override public final PurchaseReturnLine process( final Map<String, Object> pAddParam, final PurchaseReturnLine pEntityPb, final IRequestData pRequestData) throws Exception { PurchaseReturnLine entity = this.prcAccEntityPbCopy .process(pAddParam, pEntityPb, pRequestData); entity.setItsOwner(this.prcAccEntityPbCopy .getSrvOrm().retrieveEntity(pAddParam, entity.getItsOwner())); entity.setPurchaseInvoiceLine(null); entity.setPurchInvLnAppearance(null); entity.setItsQuantity(BigDecimal.ZERO); entity.setItsTotal(BigDecimal.ZERO); entity.setTotalTaxes(BigDecimal.ZERO); entity.setSubtotal(BigDecimal.ZERO); entity.setTaxesDescription(null); return entity; }
.getFor(drawed.getClass(), fldIdName); setterId.invoke(drawed, dies.getSourceId()); drawed = srvOrm.retrieveEntity(pAddParam, drawed); drawed.setTheRest(drawed.getTheRest().add(dies.getItsQuantity())); srvOrm.updateEntity(pAddParam, drawed);
/** * <p>Process entity request.</p> * @param pAddParam additional param, e.g. return this line's * document in "nextEntity" for farther process * @param pRequestData Request Data * @param pEntity Entity to process * @return Entity processed for farther process or null * @throws Exception - an exception **/ @Override public final T process( final Map<String, Object> pAddParam, final T pEntity, final IRequestData pRequestData) throws Exception { T entity = this.srvOrm.retrieveEntity(pAddParam, pEntity); entity.setIsNew(true); entity.setItsId(null); entity.setIdBirth(null); entity.setIdDatabaseBirth(this.srvOrm.getIdDatabase()); pRequestData.setAttribute("entity", entity); pRequestData.setAttribute("mngUvds", this.mngUvdSettings); pRequestData.setAttribute("srvOrm", this.srvOrm); pRequestData.setAttribute("srvDate", this.srvDate); pRequestData.setAttribute("hldCnvFtfsNames", this.fieldConverterNamesHolder); pRequestData.setAttribute("fctCnvFtfs", this.convertersFieldsFatory); return entity; }