com.neurosys.products.dao.jpa

Class ProductDaoImpl<T extends Product>

java.lang.Object

com.neurosys.domain.GenericAware<T>

com.neurosys.dao.jpa.GenericDaoImpl<T>

com.neurosys.dao.jpa.AbstractQueryableDaoImpl<T>

com.neurosys.common.hierarchy.AbstractHierarchyDaoImpl<T>

com.neurosys.products.dao.jpa.ProductDaoImpl<T>

All Implemented Interfaces:

FreeQuery, GenericDao<T>, QueryableDao<T>, ProductDao<T>

Direct Known Subclasses:

ProductDaoImpl

@Transactional
public class ProductDaoImpl<T extends Product>
extends AbstractHierarchyDaoImpl<T>
implements ProductDao<T>

Default MySQL-JPA implementation for ProductDao

Even though written with JPA there are some slight My-SQL bindings like case name of entity/table etc.
TODO: Clean up MySQL related bindings if required in future.

Author:

Arjun Dhar

Field Summary

Fields inherited from class com.neurosys.common.hierarchy.AbstractHierarchyDaoImpl

FILTER_PARENTS, FILTER_PARENTS_IMMEDIATE, relEntitiesDelTransformer

Fields inherited from class com.neurosys.dao.jpa.GenericDaoImpl

em

Fields inherited from class com.neurosys.domain.GenericAware

ct, t

Fields inherited from interface com.neurosys.products.dao.ProductDao

FILTER_PARENTS, FILTER_PARENTS_IMMEDIATE

Constructor Summary

Constructors

Constructor and Description
ProductDaoImpl()
ProductDaoImpl(Class<T> ref)

Method Summary

Modifier and Type	Method and Description
Long	count(Query<T> query) Deprecated.
int	countFilterParents(T parent, boolean immediate) Return number of nodes that are parents under the specified parent Node The parent node must have a valid Product.getId() or HierarchialDomainObject.getHierarchy(); immediate is false.
Long	delete(Collection<Long> ids)
Long	delete(Long id) A special Delete operation on the entity that will remove the entity and related entities based on id.
void	delete(T persistentObject)
void	deleteSubHierarchy(T rootNode)
List<T>	filterParents(T parent, boolean immediate) Return List of nodes that are parents under the specified parent Node The parent node must have a valid Product.getId() or HierarchialDomainObject.getHierarchy(); immediate is false.
List<ProductAlias>	getAliasForProduct(T product) For a given Product (T) derive all its ProductAlias
String	getLastChildHierarchyCode(T parent) Get last childs hierarchy code
protected String	getNativeEntityName(String entityName) Calling parent class Dao methods calls some native DB calls that executes EntityManager.createNativeQuery(String).
List<T>	getParents(T product, boolean includeThis, String DEFAULT_PRODUCT_NAME, QueryOptimizer queryOptimizer) Get parents for the product.
void	init()
boolean	isExistsAsParent(T node) A quick check to see if the current node is a parent
T	load(Object id)
T	load(Object id, Class entityClass) In some situations the DAO represents an Interface or perhaps a parent of the actual Entity./ The exact type of the entity would have to be Supplied.
Page<T>	loadPage(Query<T> query) Load data in paginated fashion.
String	makeSpaceForNodeInParent(T node, T parent, Integer sequence)
void	move(T product, T newParent, Integer sequence)
List	query(String ql, String dialect, Object... params) Execute a raw Query in the native implementation language.
Page	query(String ql, String dialect, PageInfo pageInfo, Object... params) Execute a raw Query in the native implementation language.
ProductAlias	save(ProductAlias alias) This method does a EntityManager.merge(Object) operation If one wants to Insert a new record without merge and using an existing parent object, one may directl hack it via the EntityManager: ProductAlias pa = new ProductAlias(); pa.setProduct(existingP); Product proxyParent = new Product(); proxyParent.setId(p.getParentId()); //Avoid having to query for parent again pa.setParent(proxyParent); em.persist(pa);
ProductAttribute	save(ProductAttribute attrib) Ability to update a single ProductAttribute without updating the whole Product Useful in Ajax situations where we want to save a partial aspect of the product only.
T	save(T product)

Methods inherited from class com.neurosys.common.hierarchy.AbstractHierarchyDaoImpl

convert, delete, delete, deleteSubHierarchy, deleteSubHierarchy, filterParents, getLastChildHierarchyCode, getParents, getPersistTransformer, getRelEntitiesDelTransformer, makeSpaceForNodeInParent, move, setPersistTransformer, setRelEntitiesDelTransformer, shiftHierarchy, verifyHierarchy

Methods inherited from class com.neurosys.dao.jpa.AbstractQueryableDaoImpl

conditionConstruct, ensureRowIsEntity, ensureRowIsEntity, getEntityInstance, getQueryObject, query, query, queryPage, queryPage

Methods inherited from class com.neurosys.dao.jpa.GenericDaoImpl

getEntityManager, paginate, setEntityManager, update

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.neurosys.products.dao.ProductDao

convert

Methods inherited from interface com.neurosys.dao.jpa.QueryableDao

getEntityInstance, query, query, queryPage, queryPage

Methods inherited from interface com.neurosys.dao.FreeQuery

update

Constructor Detail

ProductDaoImpl

public ProductDaoImpl()

ProductDaoImpl

public ProductDaoImpl(Class<T> ref)

Method Detail

getNativeEntityName

protected String getNativeEntityName(String entityName)

Calling parent class Dao methods calls some native DB calls that executes EntityManager.createNativeQuery(String). Which implies the entityName is case sensitive. If not careful can generate an error like Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'needledu_ecom.Product' doesn't exist Keeping name of entity name same as in DB to be safe.

Overrides:

getNativeEntityName in class GenericDaoImpl<T extends Product>

init

@PostConstruct
public void init()

count

@Deprecated
 @Transactional(readOnly=true)
public Long count(Query<T> query)
                                                      throws Exception

Deprecated.

Description copied from class: AbstractQueryableDaoImpl

Execute Query and on Queryable fields only.
If a field is to be search on NULL, then explicitly add the Java field name to the Query.setNullSet(Set)
Also note that beans that do not follow standard java bean naming conventions; on their Queryable fields will face problems.

Specified by:

count in interface QueryableDao<T extends Product>

Overrides:

count in class AbstractQueryableDaoImpl<T extends Product>

Parameters:

query - as Queryable

Throws:

Exception

loadPage

@Transactional(readOnly=true)
public Page<T> loadPage(Query<T> query)

Description copied from interface: ProductDao

Load data in paginated fashion. See the ProductDao for Query related supported Attributes.
the decision to put a a Query param within the Entity Vs a Related attribute is that, the attributes distinctly indicate that the query should consider that param and also, it supports other relations like "LIKE" etc.

An entity-attribute to be considered in a query would imply the closest match to the Object with the same exact values.

Specified by:

loadPage in interface ProductDao<T extends Product>

Overrides:

loadPage in class AbstractHierarchyDaoImpl<T extends Product>

Returns:

delete

@Transactional(readOnly=false)
public Long delete(Long id)

Description copied from interface: GenericDao

A special Delete operation on the entity that will remove the entity and related entities based on id. If the number of records deleted can be determined, that is returned else -1

Specified by:

delete in interface GenericDao<T extends Product>

Overrides:

delete in class GenericDaoImpl<T extends Product>

Returns:

Long

delete

@Transactional(readOnly=false)
public Long delete(Collection<Long> ids)

Specified by:

delete in interface ProductDao<T extends Product>

save

@Transactional(readOnly=false)
public T save(T product)

Specified by:

save in interface GenericDao<T extends Product>

Overrides:

save in class AbstractHierarchyDaoImpl<T extends Product>

move

@Transactional(readOnly=false)
public void move(T product,
                                                T newParent,
                                                Integer sequence)
                                         throws Exception

Specified by:

move in interface ProductDao<T extends Product>

Throws:

Exception

getParents

public List<T> getParents(T product,
                          boolean includeThis,
                          String DEFAULT_PRODUCT_NAME,
                          QueryOptimizer queryOptimizer)

Description copied from interface: ProductDao

Get parents for the product.

Specified by:

getParents in interface ProductDao<T extends Product>

Parameters:

product - as product

DEFAULT_PRODUCT_NAME - as String of the default product name. If empty, then its not included.

queryOptimizer - as QueryOptimizer

Returns:

deleteSubHierarchy

public void deleteSubHierarchy(T rootNode)
                        throws Exception

Specified by:

deleteSubHierarchy in interface ProductDao<T extends Product>

Throws:

Exception

getLastChildHierarchyCode

@Transactional
public String getLastChildHierarchyCode(T parent)

Get last childs hierarchy code

Specified by:

getLastChildHierarchyCode in interface ProductDao<T extends Product>

Returns:

filterParents

@Transactional
public List<T> filterParents(T parent,
                                            boolean immediate)

Return List of nodes that are parents under the specified parent Node
The parent node must have a valid Product.getId() or HierarchialDomainObject.getHierarchy(); immediate is false.

Specified by:

filterParents in interface ProductDao<T extends Product>

Parameters:

parent - as T

immediate - as boolean; if true will fetch only parents immediately under the specified parent

Returns:

List of parent Ids that fit the criteria

countFilterParents

@Transactional
public int countFilterParents(T parent,
                                             boolean immediate)

Return number of nodes that are parents under the specified parent Node
The parent node must have a valid Product.getId() or HierarchialDomainObject.getHierarchy(); immediate is false.

Specified by:

countFilterParents in interface ProductDao<T extends Product>

Parameters:

parent - as T

immediate - as boolean; if true will fetch only parents immediately under the specified parent

Returns:

int

makeSpaceForNodeInParent

@Transactional
public String makeSpaceForNodeInParent(T node,
                                                      T parent,
                                                      Integer sequence)

Specified by:

makeSpaceForNodeInParent in interface ProductDao<T extends Product>

save

@Transactional
public ProductAttribute save(ProductAttribute attrib)

Description copied from interface: ProductDao

Ability to update a single ProductAttribute without updating the whole Product
Useful in Ajax situations where we want to save a partial aspect of the product only.

Specified by:

save in interface ProductDao<T extends Product>

Parameters:

attrib - as ProductAttribute

Returns:

ProductAttribute

save

@Transactional
public ProductAlias save(ProductAlias alias)

This method does a EntityManager.merge(Object) operation
If one wants to Insert a new record without merge and using an existing parent object, one may directl hack it via the EntityManager: ProductAlias pa = new ProductAlias(); pa.setProduct(existingP); Product proxyParent = new Product(); proxyParent.setId(p.getParentId()); //Avoid having to query for parent again pa.setParent(proxyParent); em.persist(pa);

Specified by:

save in interface ProductDao<T extends Product>

Returns:

getAliasForProduct

@Transactional
public List<ProductAlias> getAliasForProduct(T product)

Description copied from interface: ProductDao

For a given Product (T) derive all its ProductAlias

Specified by:

getAliasForProduct in interface ProductDao<T extends Product>

Returns:

TODO: Rename to getAlias(...)

isExistsAsParent

public boolean isExistsAsParent(T node)

Description copied from class: AbstractHierarchyDaoImpl

A quick check to see if the current node is a parent

Specified by:

isExistsAsParent in interface ProductDao<T extends Product>

Overrides:

isExistsAsParent in class AbstractHierarchyDaoImpl<T extends Product>

delete

@Transactional(readOnly=false)
public void delete(T persistentObject)

Specified by:

delete in interface GenericDao<T extends Product>

Overrides:

delete in class GenericDaoImpl<T extends Product>

load

@Transactional(readOnly=true)
public T load(Object id,
                                            Class entityClass)

Description copied from interface: GenericDao

In some situations the DAO represents an Interface or perhaps a parent of the actual Entity./ The exact type of the entity would have to be Supplied.

Specified by:

load in interface GenericDao<T extends Product>

Overrides:

load in class GenericDaoImpl<T extends Product>

Parameters:

id - as Id for Entity

entityClass - as Class of entity

Returns:

load

@Transactional(readOnly=true)
public T load(Object id)

Specified by:

load in interface GenericDao<T extends Product>

Overrides:

load in class GenericDaoImpl<T extends Product>

query

@Transactional(readOnly=true)
public List query(String ql,
                                                String dialect,
                                                Object... params)
                                         throws Exception

Description copied from class: GenericDaoImpl

Execute a raw Query in the native implementation language.
WARNING : Be careful these methods are not called by any service API as it can create a level of direct dependence on the provider/schema.
Dependent on what the implementation layers

Specified by:

query in interface FreeQuery

Overrides:

query in class GenericDaoImpl<T extends Product>

Parameters:

ql - as String in native Schema language

dialect - as String. NULL or empty or "NATIVE" implies NATIVE, "JPA" implies JPA will be used. Additional dialects can be supported but they will be implementation dependent.

params - as Query parameters to the string.
Impl specific:When using params the Query string can refer to them like ?1, ?2 etc

Returns:

List

Throws:

Exception

query

@Transactional(readOnly=true)
public Page query(String ql,
                                                String dialect,
                                                PageInfo pageInfo,
                                                Object... params)
                                         throws Exception

Description copied from class: GenericDaoImpl

Execute a raw Query in the native implementation language.
WARNING : Be careful these methods are not called by any service API as it can create a level of direct dependence on the provider/schema.
Dependent on what the implementation layers

Specified by:

query in interface FreeQuery

Overrides:

query in class GenericDaoImpl<T extends Product>

Parameters:

ql - as String in native Schema language

dialect - as String. NULL or empty or "NATIVE" implies NATIVE, "JPA" implies JPA will be used. Additional dialects can be supported but they will be implementation dependent.

pageInfo - as PageInfo for pagination of result

params - as Query parameters to the string
Impl specific:When using params the Query string can refer to them like ?1, ?2 etc

Returns:

Page

Throws:

Exception