com.neurosys.dao

Interface FreeQuery

All Known Subinterfaces:

AuditDao, BasicCommentDao, CommentDao, ConfigurationDao<K,T,C>, ConfigurationService<K,T,C>, ContentSource<C,CA,CF>, EventsDao<E>, EventsService<E>, GenericDao<T>, GenericObjectDao, HierarchyContentSource<C,CA,CF>, LogisticsDao, OrderDao<O>, PostDao, ProductDao<T>, ProductDao<T>, ProductService<T>, QueryableDao<T>, RatingDao, UserDao<U>

All Known Implementing Classes:

AbstractConfigurationJPADaoImpl, AbstractContentHierarchyDaoImpl, AbstractHierarchyDaoImpl, AbstractQueryableDaoImpl, AuditDaoImpl, CommentDaoImpl, ConfigurationJPADaoImpl, ContentDaoImpl, DefaultConfigurationService, DefaultEventsService, DefaultTransactionService, EcomUserDaoImpl, EventsDaoImpl, GenericDaoImpl, GenericObjectDaoImpl, GenericQueryableDaoImpl, LogisticsDaoImpl, OrderDaoImpl, PostDaoImpl, PostTemplateServiceImpl, ProductDaoImpl, ProductDaoImpl, ProductServiceImpl, ProductTemplateServiceImpl, PromotionDaoImpl, RatingDaoImpl, RegisteredUserLoginDaoImpl, TemplateServiceImpl, UserAttributesDaoImpl, UserDaoImpl

public interface FreeQuery

Allow the ability to freely query without any boiler plate complex API

Author:

Arjun Dhar

Method Summary

Modifier and Type	Method and Description
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.
int	update(String query, boolean isNative, Object... params) An Update query with optional params

Method Detail

query

List query(String ql,
           String dialect,
           Object... params)
    throws Exception

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

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

Page query(String ql,
           String dialect,
           PageInfo pageInfo,
           Object... params)
    throws Exception

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

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

update

int update(String query,
           boolean isNative,
           Object... params)

An Update query with optional params

Parameters:

query - as String

isNative - as boolean, if the query is raw/native or entity based.

params - as List of Object parameters

Returns:

int for number of records updated