Java tutorial
// license-header java merge-point // // Attention: Generated code! Do not modify by hand! // Generated by: hibernate/SpringHibernateDaoBase.vsl in andromda-spring-cartridge. // package com.algoTrader.entity.security; import com.algoTrader.PrincipalStore; import com.algoTrader.PropertySearch; import com.algoTrader.Search; import com.algoTrader.SearchParameter; import java.security.Principal; import java.util.Collection; import java.util.LinkedHashSet; import java.util.List; import java.util.Set; import org.andromda.spring.PaginationResult; import org.apache.commons.collections.CollectionUtils; import org.apache.commons.collections.Transformer; import org.hibernate.Criteria; import org.hibernate.HibernateException; import org.hibernate.NonUniqueResultException; import org.hibernate.Query; import org.hibernate.ScrollableResults; import org.hibernate.Session; import org.springframework.dao.InvalidDataAccessResourceUsageException; import org.springframework.orm.hibernate3.HibernateCallback; import org.springframework.orm.hibernate3.support.HibernateDaoSupport; /** * <p> * Base Spring DAO Class: is able to create, update, remove, load, and find * objects of type <code>Security</code>. * </p> * * @see Security */ public abstract class SecurityDaoBase extends HibernateDaoSupport implements SecurityDao { /** * {@inheritDoc} */ @Override public Object get(final int transform, final int id) { final Object entity = this.getHibernateTemplate().get(SecurityImpl.class, new Integer(id)); return transformEntity(transform, (Security) entity); } /** * {@inheritDoc} */ @Override public Security get(int id) { return (Security) this.get(TRANSFORM_NONE, id); } /** * {@inheritDoc} */ @Override public Object load(final int transform, final int id) { final Object entity = this.getHibernateTemplate().get(SecurityImpl.class, new Integer(id)); return transformEntity(transform, (Security) entity); } /** * {@inheritDoc} */ @Override public Security load(int id) { return (Security) this.load(TRANSFORM_NONE, id); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public Collection<Security> loadAll() { return (Collection<Security>) this.loadAll(SecurityDao.TRANSFORM_NONE); } /** * {@inheritDoc} */ @Override public Collection<?> loadAll(final int transform) { return this.loadAll(transform, -1, -1); } /** * {@inheritDoc} */ @Override public Collection<?> loadAll(final int pageNumber, final int pageSize) { return this.loadAll(SecurityDao.TRANSFORM_NONE, pageNumber, pageSize); } /** * {@inheritDoc} */ @Override public Collection<?> loadAll(final int transform, final int pageNumber, final int pageSize) { try { final Criteria criteria = this.getSession(false).createCriteria(SecurityImpl.class); if (pageNumber > 0 && pageSize > 0) { criteria.setFirstResult(this.calculateFirstResult(pageNumber, pageSize)); criteria.setMaxResults(pageSize); } final Collection<?> results = criteria.list(); this.transformEntities(transform, results); return results; } catch (HibernateException ex) { throw super.convertHibernateAccessException(ex); } } /** * firstResult = (pageNumber - 1) * pageSize * @param pageNumber * @param pageSize * @return firstResult */ protected int calculateFirstResult(int pageNumber, int pageSize) { int firstResult = 0; if (pageNumber > 0) { firstResult = (pageNumber - 1) * pageSize; } return firstResult; } /** * {@inheritDoc} */ @Override public void update(Security security) { if (security == null) { throw new IllegalArgumentException("Security.update - 'security' can not be null"); } this.getHibernateTemplate().update(security); } /** * {@inheritDoc} */ @Override public void update(final Collection<Security> entities) { if (entities == null) { throw new IllegalArgumentException("Security.update - 'entities' can not be null"); } this.getHibernateTemplate().executeWithNativeSession(new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException { for (Security entity : entities) { update(entity); } return null; } }); } /** * {@inheritDoc} */ @Override public void remove(Security security) { if (security == null) { throw new IllegalArgumentException("Security.remove - 'security' can not be null"); } this.getHibernateTemplate().delete(security); } /** * {@inheritDoc} */ @Override public void remove(int id) { Security entity = this.get(id); if (entity != null) { this.remove(entity); } } /** * {@inheritDoc} */ @Override public void remove(Collection<Security> entities) { if (entities == null) { throw new IllegalArgumentException("Security.remove - 'entities' can not be null"); } this.getHibernateTemplate().deleteAll(entities); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public Security findByIdFetched(int id) { return (Security) this.findByIdFetched(SecurityDao.TRANSFORM_NONE, id); } /** * {@inheritDoc} */ @Override public Object findByIdFetched(final int transform, final int id) { return this.findByIdFetched(transform, "from SecurityImpl as s left join fetch s.underlaying as ul join fetch s.securityFamily as f where s.id = :id ", id); } /** * {@inheritDoc} */ @Override public Security findByIdFetched(final String queryString, final int id) { return (Security) this.findByIdFetched(SecurityDao.TRANSFORM_NONE, queryString, id); } /** * {@inheritDoc} */ @Override @SuppressWarnings("unchecked") public Object findByIdFetched(final int transform, final String queryString, final int id) { try { Query queryObject = super.getSession(false).createQuery(queryString); queryObject.setCacheable(true); queryObject.setParameter("id", new Integer(id)); Set results = new LinkedHashSet(queryObject.list()); Object result = null; if (results.size() > 1) { throw new InvalidDataAccessResourceUsageException( "More than one instance of 'com.algoTrader.entity.security.Security" + "' was found when executing query --> '" + queryString + "'"); } else if (results.size() == 1) { result = results.iterator().next(); } if (transform != TRANSFORM_NONE) { result = transformEntity(transform, (Security) result); } return result; } catch (HibernateException ex) { throw super.convertHibernateAccessException(ex); } } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public Security findByIsin(String isin) { return (Security) this.findByIsin(SecurityDao.TRANSFORM_NONE, isin); } /** * {@inheritDoc} */ @Override public Object findByIsin(final int transform, final String isin) { return this.findByIsin(transform, "from SecurityImpl as s where s.isin = :isin", isin); } /** * {@inheritDoc} */ @Override public Security findByIsin(final String queryString, final String isin) { return (Security) this.findByIsin(SecurityDao.TRANSFORM_NONE, queryString, isin); } /** * {@inheritDoc} */ @Override @SuppressWarnings("unchecked") public Object findByIsin(final int transform, final String queryString, final String isin) { try { Query queryObject = super.getSession(false).createQuery(queryString); queryObject.setCacheable(true); queryObject.setParameter("isin", isin); Set results = new LinkedHashSet(queryObject.list()); Object result = null; if (results.size() > 1) { throw new InvalidDataAccessResourceUsageException( "More than one instance of 'com.algoTrader.entity.security.Security" + "' was found when executing query --> '" + queryString + "'"); } else if (results.size() == 1) { result = results.iterator().next(); } if (transform != TRANSFORM_NONE) { result = transformEntity(transform, (Security) result); } return result; } catch (HibernateException ex) { throw super.convertHibernateAccessException(ex); } } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public Security findByIsinFetched(String isin) { return (Security) this.findByIsinFetched(SecurityDao.TRANSFORM_NONE, isin); } /** * {@inheritDoc} */ @Override public Object findByIsinFetched(final int transform, final String isin) { return this.findByIsinFetched(transform, "from SecurityImpl as s left join fetch s.underlaying as ul join fetch s.securityFamily as f where s.isin = :isin", isin); } /** * {@inheritDoc} */ @Override public Security findByIsinFetched(final String queryString, final String isin) { return (Security) this.findByIsinFetched(SecurityDao.TRANSFORM_NONE, queryString, isin); } /** * {@inheritDoc} */ @Override @SuppressWarnings("unchecked") public Object findByIsinFetched(final int transform, final String queryString, final String isin) { try { Query queryObject = super.getSession(false).createQuery(queryString); queryObject.setCacheable(true); queryObject.setParameter("isin", isin); Set results = new LinkedHashSet(queryObject.list()); Object result = null; if (results.size() > 1) { throw new InvalidDataAccessResourceUsageException( "More than one instance of 'com.algoTrader.entity.security.Security" + "' was found when executing query --> '" + queryString + "'"); } else if (results.size() == 1) { result = results.iterator().next(); } if (transform != TRANSFORM_NONE) { result = transformEntity(transform, (Security) result); } return result; } catch (HibernateException ex) { throw super.convertHibernateAccessException(ex); } } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public Security findBySymbol(String symbol) { return (Security) this.findBySymbol(SecurityDao.TRANSFORM_NONE, symbol); } /** * {@inheritDoc} */ @Override public Object findBySymbol(final int transform, final String symbol) { return this.findBySymbol(transform, "from SecurityImpl as s where s.symbol = :symbol", symbol); } /** * {@inheritDoc} */ @Override public Security findBySymbol(final String queryString, final String symbol) { return (Security) this.findBySymbol(SecurityDao.TRANSFORM_NONE, queryString, symbol); } /** * {@inheritDoc} */ @Override @SuppressWarnings("unchecked") public Object findBySymbol(final int transform, final String queryString, final String symbol) { try { Query queryObject = super.getSession(false).createQuery(queryString); queryObject.setCacheable(true); queryObject.setParameter("symbol", symbol); Set results = new LinkedHashSet(queryObject.list()); Object result = null; if (results.size() > 1) { throw new InvalidDataAccessResourceUsageException( "More than one instance of 'com.algoTrader.entity.security.Security" + "' was found when executing query --> '" + queryString + "'"); } else if (results.size() == 1) { result = results.iterator().next(); } if (transform != TRANSFORM_NONE) { result = transformEntity(transform, (Security) result); } return result; } catch (HibernateException ex) { throw super.convertHibernateAccessException(ex); } } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesInPortfolio() { return (List<Security>) this.findSecuritiesInPortfolio(SecurityDao.TRANSFORM_NONE); } /** * {@inheritDoc} */ @Override public List<?> findSecuritiesInPortfolio(final int transform) { return this.findSecuritiesInPortfolio(transform, -1, -1); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesInPortfolio(final String queryString) { return (List<Security>) this.findSecuritiesInPortfolio(SecurityDao.TRANSFORM_NONE, queryString); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesInPortfolio(final int pageNumber, final int pageSize) { return (List<Security>) this.findSecuritiesInPortfolio(SecurityDao.TRANSFORM_NONE, pageNumber, pageSize); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesInPortfolio(final String queryString, final int pageNumber, final int pageSize) { return (List<Security>) this.findSecuritiesInPortfolio(SecurityDao.TRANSFORM_NONE, queryString, pageNumber, pageSize); } /** * {@inheritDoc} */ @Override public List<?> findSecuritiesInPortfolio(final int transform, final String queryString) { return this.findSecuritiesInPortfolio(transform, queryString, -1, -1); } /** * {@inheritDoc} */ @Override public List<?> findSecuritiesInPortfolio(final int transform, final int pageNumber, final int pageSize) { return this.findSecuritiesInPortfolio(transform, "select s from SecurityImpl as s join fetch s.positions as p where p.quantity != 0 order by s.id", pageNumber, pageSize); } /** * {@inheritDoc} */ @Override @SuppressWarnings("unchecked") public List<?> findSecuritiesInPortfolio(final int transform, final String queryString, int pageNumber, int pageSize) { try { Query queryObject = super.getSession(false).createQuery(queryString); queryObject.setCacheable(true); if (pageNumber > 0 && pageSize > 0) { queryObject.setFirstResult(this.calculateFirstResult(pageNumber, pageSize)); queryObject.setMaxResults(pageSize); } List results = queryObject.list(); transformEntities(transform, results); return results; } catch (HibernateException ex) { throw super.convertHibernateAccessException(ex); } } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesOnWatchlist() { return (List<Security>) this.findSecuritiesOnWatchlist(SecurityDao.TRANSFORM_NONE); } /** * {@inheritDoc} */ @Override public List<?> findSecuritiesOnWatchlist(final int transform) { return this.findSecuritiesOnWatchlist(transform, -1, -1); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesOnWatchlist(final String queryString) { return (List<Security>) this.findSecuritiesOnWatchlist(SecurityDao.TRANSFORM_NONE, queryString); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesOnWatchlist(final int pageNumber, final int pageSize) { return (List<Security>) this.findSecuritiesOnWatchlist(SecurityDao.TRANSFORM_NONE, pageNumber, pageSize); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesOnWatchlist(final String queryString, final int pageNumber, final int pageSize) { return (List<Security>) this.findSecuritiesOnWatchlist(SecurityDao.TRANSFORM_NONE, queryString, pageNumber, pageSize); } /** * {@inheritDoc} */ @Override public List<?> findSecuritiesOnWatchlist(final int transform, final String queryString) { return this.findSecuritiesOnWatchlist(transform, queryString, -1, -1); } /** * {@inheritDoc} */ @Override public List<?> findSecuritiesOnWatchlist(final int transform, final int pageNumber, final int pageSize) { return this.findSecuritiesOnWatchlist(transform, "select distinct s from SecurityImpl as s left join fetch s.securityFamily as f join fetch s.watchListItems as w left join fetch s.positions as p join fetch w.strategy as st where w != null order by s.id", pageNumber, pageSize); } /** * {@inheritDoc} */ @Override @SuppressWarnings("unchecked") public List<?> findSecuritiesOnWatchlist(final int transform, final String queryString, int pageNumber, int pageSize) { try { Query queryObject = super.getSession(false).createQuery(queryString); queryObject.setCacheable(true); if (pageNumber > 0 && pageSize > 0) { queryObject.setFirstResult(this.calculateFirstResult(pageNumber, pageSize)); queryObject.setMaxResults(pageSize); } List results = queryObject.list(); transformEntities(transform, results); return results; } catch (HibernateException ex) { throw super.convertHibernateAccessException(ex); } } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesOnActiveWatchlist() { return (List<Security>) this.findSecuritiesOnActiveWatchlist(SecurityDao.TRANSFORM_NONE); } /** * {@inheritDoc} */ @Override public List<?> findSecuritiesOnActiveWatchlist(final int transform) { return this.findSecuritiesOnActiveWatchlist(transform, -1, -1); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesOnActiveWatchlist(final String queryString) { return (List<Security>) this.findSecuritiesOnActiveWatchlist(SecurityDao.TRANSFORM_NONE, queryString); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesOnActiveWatchlist(final int pageNumber, final int pageSize) { return (List<Security>) this.findSecuritiesOnActiveWatchlist(SecurityDao.TRANSFORM_NONE, pageNumber, pageSize); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public List<Security> findSecuritiesOnActiveWatchlist(final String queryString, final int pageNumber, final int pageSize) { return (List<Security>) this.findSecuritiesOnActiveWatchlist(SecurityDao.TRANSFORM_NONE, queryString, pageNumber, pageSize); } /** * {@inheritDoc} */ @Override public List<?> findSecuritiesOnActiveWatchlist(final int transform, final String queryString) { return this.findSecuritiesOnActiveWatchlist(transform, queryString, -1, -1); } /** * {@inheritDoc} */ @Override public List<?> findSecuritiesOnActiveWatchlist(final int transform, final int pageNumber, final int pageSize) { return this.findSecuritiesOnActiveWatchlist(transform, "select distinct s from SecurityImpl as s left join fetch s.securityFamily as f join fetch s.watchListItems as w left join fetch s.positions as p join fetch w.strategy as st where w.strategy.autoActivate = true order by s.id ", pageNumber, pageSize); } /** * {@inheritDoc} */ @Override @SuppressWarnings("unchecked") public List<?> findSecuritiesOnActiveWatchlist(final int transform, final String queryString, int pageNumber, int pageSize) { try { Query queryObject = super.getSession(false).createQuery(queryString); queryObject.setCacheable(true); if (pageNumber > 0 && pageSize > 0) { queryObject.setFirstResult(this.calculateFirstResult(pageNumber, pageSize)); queryObject.setMaxResults(pageSize); } List results = queryObject.list(); transformEntities(transform, results); return results; } catch (HibernateException ex) { throw super.convertHibernateAccessException(ex); } } /** * Allows transformation of entities into value objects * (or something else for that matter), when the <code>transform</code> * flag is set to one of the constants defined in <code>SecurityDao</code>, please note * that the {@link #TRANSFORM_NONE} constant denotes no transformation, so the entity itself * will be returned. * * If the integer argument value is unknown {@link #TRANSFORM_NONE} is assumed. * * @param transform one of the constants declared in {@link SecurityDao} * @param entity an entity that was found * @return the transformed entity (i.e. new value object, etc) * @see SecurityDao#transformEntity(int, Security) */ public Object transformEntity(final int transform, final Security entity) { Object target = null; if (entity != null) { switch (transform) { case SecurityDao.TRANSFORM_NONE: // fall-through default: target = entity; } } return target; } /** * {@inheritDoc} */ @Override public void transformEntities(final int transform, final Collection<?> entities) { switch (transform) { case SecurityDao.TRANSFORM_NONE: // fall-through default: // do nothing; } } /** * @see SecurityDao#toEntities(Collection) */ public void toEntities(final Collection<?> results) { if (results != null) { CollectionUtils.transform(results, this.ENTITYTRANSFORMER); } } /** * This anonymous transformer is designed to transform report query results * (which result in an array of entities) to {@link Security} * using the Jakarta Commons-Collections Transformation API. */ private Transformer ENTITYTRANSFORMER = new Transformer() { public Object transform(Object input) { Object result = null; if (input instanceof Object[]) { result = toEntity((Object[]) input); } else if (input instanceof Security) { result = input; } return result; } }; /** * @param row * @return Security */ protected Security toEntity(Object[] row) { Security target = null; if (row != null) { final int numberOfObjects = row.length; for (int ctr = 0; ctr < numberOfObjects; ctr++) { final Object object = row[ctr]; if (object instanceof Security) { target = (Security) object; break; } } } return target; } /** * Gets the current <code>principal</code> if one has been set, * otherwise returns <code>null</code>. * * @return the current principal */ protected Principal getPrincipal() { return PrincipalStore.get(); } /** * {@inheritDoc} */ @Override @SuppressWarnings({ "unchecked" }) public PaginationResult search(final int transform, final int pageNumber, final int pageSize, final Search search) { try { search.setPageNumber(pageNumber); search.setPageSize(pageSize); final PropertySearch propertySearch = new PropertySearch(this.getSession(false), SecurityImpl.class, search); final List results = propertySearch.executeAsList(); this.transformEntities(transform, results); return new PaginationResult(results.toArray(new Object[results.size()]), propertySearch.getTotalCount()); } catch (HibernateException ex) { throw super.convertHibernateAccessException(ex); } } /** * {@inheritDoc} */ @Override public PaginationResult search(final int pageNumber, final int pageSize, final Search search) { return this.search(SecurityDao.TRANSFORM_NONE, pageNumber, pageSize, search); } /** * {@inheritDoc} */ @Override public Set<?> search(final int transform, final Search search) { try { final PropertySearch propertySearch = new PropertySearch(this.getSession(false), SecurityImpl.class, search); final Set<?> results = propertySearch.executeAsSet(); this.transformEntities(transform, results); return results; } catch (HibernateException ex) { throw super.convertHibernateAccessException(ex); } } /** * {@inheritDoc} */ @Override @SuppressWarnings("unchecked") public Set<Security> search(final Search search) { return (Set<Security>) this.search(SecurityDao.TRANSFORM_NONE, search); } /** * Executes and returns the given Hibernate queryObject as a {@link PaginationResult} instance. * @param queryObject * @param transform * @param pageNumber * @param pageSize * @return PaginationResult */ @SuppressWarnings({ "unchecked" }) protected PaginationResult getPaginationResult(final Query queryObject, final int transform, int pageNumber, int pageSize) { try { final ScrollableResults scrollableResults = queryObject.scroll(); scrollableResults.last(); int totalCount = scrollableResults.getRowNumber(); totalCount = totalCount >= 0 ? totalCount + 1 : 0; if (pageNumber > 0 && pageSize > 0) { queryObject.setFirstResult(this.calculateFirstResult(pageNumber, pageSize)); queryObject.setMaxResults(pageSize); } // Unchecked transformation because Set object is reused, cannot be strongly typed. Set results = new LinkedHashSet(queryObject.list()); transformEntities(transform, results); return new PaginationResult(results.toArray(new Object[results.size()]), totalCount); } catch (HibernateException ex) { throw super.convertHibernateAccessException(ex); } } /** * {@inheritDoc} */ @Override public Security searchUniqueIsin(final String isin) { final Search search = new Search( new SearchParameter[] { new SearchParameter("isin", isin, SearchParameter.EQUAL_COMPARATOR) }); final Set<Security> searchResult = this.search(search); switch (searchResult.size()) { case 0: return null; case 1: return searchResult.iterator().next(); default: throw new NonUniqueResultException(searchResult.size()); } } /** * {@inheritDoc} */ @Override public Object searchUniqueIsin(final int transform, final String isin) { final Security entity = this.searchUniqueIsin(isin); if (entity == null) { return null; } return transformEntity(transform, entity); } // spring-hibernate-dao-base merge-point }