Here are the examples of the java api org.hibernate.Session.createCriteria() taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
245 Examples
19
Source : UserDaoImpl.java
with MIT License
from zhangjikai
with MIT License
from zhangjikai
@Override
public Pager<User> listUserByPage(int pageNo, int pageSize) {
Session session = sessionFactory.getCurrentSession();
Criteria criteria = session.createCriteria(User.clreplaced);
long recordTotal = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).longValue();
criteria.setProjection(null);
criteria.addOrder(Order.desc("registerDate"));
criteria.setFirstResult((pageNo - 1) * pageSize);
criteria.setMaxResults(pageSize);
List<User> results = criteria.list();
return new Pager<User>(pageSize, pageNo, recordTotal, results);
}
19
Source : CollectDaoImpl.java
with MIT License
from zhangjikai
with MIT License
from zhangjikai
@Override
public Pager<Collect> listCollectsByUser(int userId, int pageNo, int pageSize) {
Session session = sessionFactory.getCurrentSession();
Criteria criteria = session.createCriteria(Collect.clreplaced);
criteria.add(Restrictions.eq("userId", userId));
long recordTotal = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).longValue();
criteria.setProjection(null);
criteria.addOrder(Order.desc("collectDate"));
criteria.setFirstResult((pageNo - 1) * pageSize);
criteria.setMaxResults(pageSize);
List<Collect> results = criteria.list();
return new Pager<Collect>(pageSize, pageNo, recordTotal, results);
}
19
Source : BookDaoImpl.java
with MIT License
from zhangjikai
with MIT License
from zhangjikai
public Pager<Book> showBookByClickTimes(int pageNo, int pageSize) {
Session session = sessionFactory.getCurrentSession();
Criteria criteria = session.createCriteria(Book.clreplaced);
long recordTotal = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).longValue();
criteria.setProjection(null);
criteria.addOrder(Order.desc("clickTimes"));
criteria.setFirstResult((pageNo - 1) * pageSize);
criteria.setMaxResults(pageSize);
List<Book> results = criteria.list();
Pager<Book> page = new Pager<Book>(pageSize, pageNo, recordTotal, results);
return page;
}
19
Source : BookDaoImpl.java
with MIT License
from zhangjikai
with MIT License
from zhangjikai
@Override
public Pager<Book> showBookByStyle(String style, int pageNo, int pageSize) {
Session session = sessionFactory.getCurrentSession();
Criteria criteria = session.createCriteria(Book.clreplaced);
criteria.add(Restrictions.eq("bookStyle", style));
long recordTotal = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).longValue();
criteria.setProjection(null);
criteria.addOrder(Order.desc("clickTimes"));
criteria.setFirstResult((pageNo - 1) * pageSize);
criteria.setMaxResults(pageSize);
List<Book> results = criteria.list();
Pager<Book> page = new Pager<Book>(pageSize, pageNo, recordTotal, results);
return page;
}
19
Source : BookDaoImpl.java
with MIT License
from zhangjikai
with MIT License
from zhangjikai
@Override
public Pager<Book> showBookByDynasty(String dynasty, int pageNo, int pageSize) {
System.out.println("-----执行到BookDaoImpl");
Session session = sessionFactory.getCurrentSession();
Criteria criteria = session.createCriteria(Book.clreplaced);
criteria.add(Restrictions.eq("dynasty", dynasty));
long recordTotal = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).longValue();
criteria.setProjection(null);
criteria.addOrder(Order.desc("clickTimes"));
criteria.setFirstResult((pageNo - 1) * pageSize);
criteria.setMaxResults(pageSize);
List<Book> results = criteria.list();
Pager<Book> page = new Pager<Book>(pageSize, pageNo, recordTotal, results);
return page;
}
19
Source : ProcessVariableQueryImpl.java
with Apache License 2.0
from youseries
with Apache License 2.0
from youseries
public Criteria getCriteria(Session session, boolean queryCount) {
Criteria criteria = session.createCriteria(Variable.clreplaced);
buildCriteria(criteria, queryCount);
return criteria;
}
19
Source : ProcessQueryImpl.java
with Apache License 2.0
from youseries
with Apache License 2.0
from youseries
public Criteria getCriteria(Session session, boolean queryCount) {
Criteria criteria = session.createCriteria(ProcessDefinition.clreplaced);
buildCriteria(criteria, queryCount);
return criteria;
}
19
Source : ProcessInstanceQueryImpl.java
with Apache License 2.0
from youseries
with Apache License 2.0
from youseries
public Criteria getCriteria(Session session, boolean queryCount) {
Criteria criteria = session.createCriteria(ProcessInstance.clreplaced);
buildCriteria(criteria, queryCount);
return criteria;
}
19
Source : HistoryTaskQueryImpl.java
with Apache License 2.0
from youseries
with Apache License 2.0
from youseries
public Criteria getCriteria(Session session, boolean queryCount) {
Criteria criteria = session.createCriteria(HistoryTask.clreplaced);
buildCriteria(criteria, queryCount);
return criteria;
}
19
Source : HistoryProcessVariableQueryImpl.java
with Apache License 2.0
from youseries
with Apache License 2.0
from youseries
public Criteria getCriteria(Session session, boolean queryCount) {
Criteria criteria = session.createCriteria(HistoryVariable.clreplaced);
buildCriteria(criteria, queryCount);
return criteria;
}
19
Source : HistoryProcessInstanceQueryImpl.java
with Apache License 2.0
from youseries
with Apache License 2.0
from youseries
public Criteria getCriteria(Session session, boolean queryCount) {
Criteria criteria = session.createCriteria(HistoryProcessInstance.clreplaced);
buildCriteria(criteria, queryCount);
return criteria;
}
19
Source : SchemaDAOImpl.java
with Apache License 2.0
from yahoo
with Apache License 2.0
from yahoo
@Override
public Schema fetchByName(Session session, String name) {
Criteria criteria = session.createCriteria(this.getEnreplacedyClreplaced());
criteria.add(Restrictions.eq("schemaName", name));
return (Schema) criteria.uniqueResult();
}
19
Source : PipelineDAOImpl.java
with Apache License 2.0
from yahoo
with Apache License 2.0
from yahoo
/**
* Fetch pipeline by name.
*/
@Override
public Pipeline fetchByName(Session session, String name) {
Criteria criteria = session.createCriteria(this.getEnreplacedyClreplaced());
criteria.add(Restrictions.eq("pipelineName", name));
Pipeline pipeline = (Pipeline) criteria.uniqueResult();
if (pipeline != null) {
Hibernate.initialize(pipeline.getProjections());
}
return pipeline;
}
19
Source : FunnelGroupDAOImpl.java
with Apache License 2.0
from yahoo
with Apache License 2.0
from yahoo
/**
* Fetch funnel group by name.
*/
@Override
public FunnelGroup fetchByName(Session session, String name) {
Criteria criteria = session.createCriteria(this.getEnreplacedyClreplaced());
criteria.add(Restrictions.eq("funnelGroupName", name));
FunnelGroup funnelGroup = (FunnelGroup) criteria.uniqueResult();
if (funnelGroup != null) {
Hibernate.initialize(funnelGroup.getProjections());
Hibernate.initialize(funnelGroup.getPipelines());
}
return funnelGroup;
}
19
Source : FieldKeyDAOImpl.java
with Apache License 2.0
from yahoo
with Apache License 2.0
from yahoo
/**
* Get field enreplacedy by several names.
*/
public FieldKey fetchBySchemaNameFieldIdKeyName(Session session, String schemaName, long fieldId, String keyName) {
Criteria criteria = session.createCriteria(this.getEnreplacedyClreplaced());
criteria.add(Restrictions.eq("schemaName", schemaName));
criteria.add(Restrictions.eq("fieldId", fieldId));
criteria.add(Restrictions.eq("keyName", keyName));
return (FieldKey) criteria.uniqueResult();
}
19
Source : FieldKeyDAOImpl.java
with Apache License 2.0
from yahoo
with Apache License 2.0
from yahoo
/**
* Get field enreplacedy by composite key.
*/
public FieldKey fetchByCompositeKey(Session session, String schemaName, long fieldId, long fieldKeyId) {
Criteria criteria = session.createCriteria(this.getEnreplacedyClreplaced());
criteria.add(Restrictions.eq("schemaName", schemaName));
criteria.add(Restrictions.eq("fieldId", fieldId));
criteria.add(Restrictions.eq("keyId", fieldKeyId));
return (FieldKey) criteria.uniqueResult();
}
19
Source : FieldDAOImpl.java
with Apache License 2.0
from yahoo
with Apache License 2.0
from yahoo
/**
* Get field enreplacedy by composite key.
*/
public Field fetchByCompositeKey(Session session, String schemaName, long fieldId) {
Criteria criteria = session.createCriteria(this.getEnreplacedyClreplaced());
criteria.add(Restrictions.eq("schemaName", schemaName));
criteria.add(Restrictions.eq("fieldId", fieldId));
return (Field) criteria.uniqueResult();
}
19
Source : FieldDAOImpl.java
with Apache License 2.0
from yahoo
with Apache License 2.0
from yahoo
/**
* Get field enreplacedy by schema.
*/
public List<Field> fetchBySchemaName(Session session, String schemaName) {
Criteria criteria = session.createCriteria(this.getEnreplacedyClreplaced());
criteria.add(Restrictions.eq("schemaName", schemaName));
return criteria.list();
}
19
Source : FieldDAOImpl.java
with Apache License 2.0
from yahoo
with Apache License 2.0
from yahoo
/**
* Get field enreplacedy by several names.
*/
public Field fetchBySchemaNameFieldName(Session session, String schemaName, String fieldName) {
Criteria criteria = session.createCriteria(this.getEnreplacedyClreplaced());
criteria.add(Restrictions.eq("schemaName", schemaName));
criteria.add(Restrictions.eq("fieldName", fieldName));
return (Field) criteria.uniqueResult();
}
19
Source : CounterMatrixDaoImpl.java
with Apache License 2.0
from tmobile
with Apache License 2.0
from tmobile
private Criteria createCriteriaMatrixTrend(final int envId, Session session, String platform) {
Calendar c = Calendar.getInstance();
c.add(Calendar.HOUR, HOURS_TO_ADD);
Criteria counterCriteria = session.createCriteria(CounterEnreplacedy.clreplaced, "counter");
counterCriteria.addOrder(Order.asc("counter.position"));
Criteria envCounCriteria = counterCriteria.createCriteria("counter.envCounter", "ec");
if (platform != null && !platform.equalsIgnoreCase("All")) {
envCounCriteria.add(Restrictions.eq("ec.platform", platform));
}
Criteria metricCriteria = envCounCriteria.createCriteria("ec.countMetric", "counterMetric");
counterCriteria.add(Restrictions.eq("counter.delInd", 0));
if (envId != 0) {
Criteria environmentCriteria = envCounCriteria.createCriteria("ec.environment", "environment");
environmentCriteria.add(Restrictions.eq("environment.environmentId", envId));
} else {
envCounCriteria.add(Restrictions.isNull("environmentId"));
}
metricCriteria.add(Restrictions.gt("counterMetric.metricDate", c.getTime()));
metricCriteria.addOrder(Order.asc("counterMetric.metricDate"));
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.property("counter.counterId"));
projectionList.add(Projections.sum("counterMetric.metricVal"));
projectionList.add(Projections.count("counter.counterId"));
projectionList.add(Projections.max("ec.environment.environmentId"));
projectionList.add(Projections.groupProperty("counter.counterId"));
projectionList.add(Projections.groupProperty("counterMetric.metricDate"));
counterCriteria.setProjection(projectionList);
return counterCriteria;
}
19
Source : CounterMatrixDaoImpl.java
with Apache License 2.0
from tmobile
with Apache License 2.0
from tmobile
/**
* Function to create criteria for CounterEnreplacedy clreplaced
* @param envId
* @param session
* @param platform
* @return Criteria
*/
private Criteria createCounterCriteria(final int envId, Session session, String platform) {
DetachedCriteria counterSubquery = DetachedCriteria.forClreplaced(CounterMetricEnreplacedy.clreplaced, "cm").setProjection(Property.forName("metricDate").max());
Criteria counterCriteria = session.createCriteria(CounterEnreplacedy.clreplaced, "counter");
counterCriteria.addOrder(Order.asc("counter.position"));
Criteria envCounCriteria = counterCriteria.createCriteria("counter.envCounter", "ec");
if (platform != null && !platform.equalsIgnoreCase("All")) {
envCounCriteria.add(Restrictions.eq("ec.platform", platform));
}
Criteria metricCriteria = envCounCriteria.createCriteria("ec.countMetric", "counterMetric");
counterSubquery.add(Property.forName("ec.envCounterId").eqProperty("cm.envCounterId"));
metricCriteria.add(Subqueries.propertyEq("counterMetric.metricDate", counterSubquery));
// metricCriteria.add(Restrictions.le("counterMetric.metricDate", new Date()));
counterCriteria.add(Restrictions.eq("counter.delInd", 0));
if (envId != 0) {
envCounCriteria.add(Restrictions.eq("environmentId", envId));
} else {
envCounCriteria.add(Restrictions.isNull("environmentId"));
}
counterCriteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENreplacedY);
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.max("counter.counterName"));
projectionList.add(Projections.max("counterMetric.metricDate"));
projectionList.add(Projections.sum("counterMetric.metricVal"));
projectionList.add(Projections.max("counter.position"));
projectionList.add(Projections.property("counter.counterId"));
projectionList.add(Projections.groupProperty("counter.counterId"));
counterCriteria.setProjection(projectionList);
return counterCriteria;
}
19
Source : HibernateScheduledGitPollDao.java
with Mozilla Public License 2.0
from secdec
with Mozilla Public License 2.0
from secdec
@Override
public ScheduledGitPoll loadByApplication(Application application) {
Session session = sessionFactory.getCurrentSession();
Criteria criteria = session.createCriteria(ScheduledGitPoll.clreplaced);
criteria.add(Restrictions.eq("active", true));
criteria.add(Restrictions.eq("application", application));
return (ScheduledGitPoll) criteria.uniqueResult();
}
19
Source : HibernateApplicationVersionDao.java
with Mozilla Public License 2.0
from secdec
with Mozilla Public License 2.0
from secdec
@Override
public Map<String, Object> getAllVersionsByAppId(List<Integer> appIds) {
Session session = sessionFactory.getCurrentSession();
Criteria criteria = session.createCriteria(Application.clreplaced);
criteria.add(Restrictions.eq("active", true));
criteria.createAlias("versions", "version");
if (appIds != null)
criteria.add(Restrictions.in("id", appIds));
List<Application> applications = (List<Application>) criteria.list();
Map<String, Object> map = CollectionUtils.map();
for (Application application : applications) {
map.put(application.getOrganization().getName() + " / " + application.getName(), application.getVersions());
}
return map;
}
19
Source : ClientDAOImpl.java
with MIT License
from ria-ee
with MIT License
from ria-ee
/**
* Returns the information system certificates of the specified client.
* @param session the session
* @param id the client identifier
* @return the information system certificates of the specified client
*/
public List<CertificateType> getIsCerts(Session session, ClientId id) {
Criteria criteria = session.createCriteria(ClientType.clreplaced);
criteria.createCriteria("identifier").add(Example.create(id));
ClientType client = findOne(criteria);
if (client != null) {
return client.getIsCert();
}
return emptyList();
}
19
Source : ClientDAOImpl.java
with MIT License
from ria-ee
with MIT License
from ria-ee
/**
* Returns the client for the given client identifier.
* @param session the session
* @param id the client identifier
* @return the client
*/
public ClientType getClient(Session session, ClientId id) {
Criteria criteria = session.createCriteria(ClientType.clreplaced);
criteria.createCriteria("identifier").add(Example.create(id));
return findOne(criteria);
}
19
Source : GlobalPropertyDAO.java
with Apache License 2.0
from olacabs
with Apache License 2.0
from olacabs
@Override
public Set<GlobalPropertyDomain> search(final String name, final String propertyType) {
final Session session = sessionFactory.getCurrentSession();
final Criteria criteria = session.createCriteria(GlobalPropertyDomain.clreplaced);
criteria.add(Restrictions.eq("deleted", false));
if (!Strings.isNullOrEmpty(name)) {
criteria.add(Restrictions.eq("name", name));
}
if (!Strings.isNullOrEmpty(propertyType)) {
criteria.add(Restrictions.eq("type", propertyType));
}
return Sets.newHashSet(super.list(criteria));
}
19
Source : ComputationDAO.java
with Apache License 2.0
from olacabs
with Apache License 2.0
from olacabs
@Override
public Set<ComputationDomain> search(final String tenant, final String name, final Integer version) {
final Session session = sessionFactory.getCurrentSession();
final Criteria criteria = session.createCriteria(ComputationDomain.clreplaced);
criteria.add(Restrictions.eq("deleted", false));
criteria.addOrder(Order.desc("version"));
if (!Strings.isNullOrEmpty(tenant)) {
criteria.add(Restrictions.eq("tenant", tenant));
}
if (!Strings.isNullOrEmpty(name)) {
criteria.add(Restrictions.eq("name", name));
}
if (version != null) {
criteria.add(Restrictions.eq("version", version));
}
final Set<ComputationDomain> result = Sets.newHashSet();
result.addAll(super.list(criteria));
return result;
}
19
Source : ComponentDAO.java
with Apache License 2.0
from olacabs
with Apache License 2.0
from olacabs
@Override
public Set<ComponentDomain> search(final String namespace, final String name, final String version) {
final Session session = sessionFactory.getCurrentSession();
final Criteria criteria = session.createCriteria(ComponentDomain.clreplaced);
criteria.add(Restrictions.eq("deleted", false));
if (!Strings.isNullOrEmpty(namespace)) {
criteria.add(Restrictions.eq("namespace", namespace));
}
if (!Strings.isNullOrEmpty(name)) {
criteria.add(Restrictions.eq("name", name));
}
if (!Strings.isNullOrEmpty(version)) {
criteria.add(Restrictions.eq("version", version));
}
final Set<ComponentDomain> result = Sets.newHashSet();
result.addAll(super.list(criteria));
return result;
}
19
Source : ApplicationDAO.java
with Apache License 2.0
from olacabs
with Apache License 2.0
from olacabs
@Override
public Set<ApplicationDomain> search(final String appName, final String tenant) {
final Session session = sessionFactory.getCurrentSession();
final Criteria criteria = session.createCriteria(ApplicationDomain.clreplaced);
if (!Strings.isNullOrEmpty(appName)) {
criteria.add(Restrictions.eq("name", appName));
}
if (!Strings.isNullOrEmpty(tenant)) {
criteria.add(Restrictions.eq("tenant", tenant));
}
return Sets.newHashSet(super.list(criteria));
}
19
Source : SearchWsEventByName.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiWsEvent.clreplaced);
if (eventName != null && !eventName.isEmpty()) {
c.add(Restrictions.eq("eventName", eventName));
}
return c;
}
19
Source : SearchWordByName.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlWord.clreplaced);
c.setProjection(Projections.projectionList().add(Projections.property("wordId"), "wordId").add(Projections.property("word"), "word")).setResultTransformer(Transformers.aliasToBean(SbiGlWord.clreplaced));
if (word != null && !word.isEmpty()) {
c.add(Restrictions.eq("word", word).ignoreCase());
}
return c;
}
19
Source : SearchWordAttrByWordId.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiUdpValue.clreplaced);
c.add(Restrictions.eq("referenceId", wordId));
return c;
}
19
Source : SearchWord.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlWord.clreplaced);
c.addOrder(Order.asc("word"));
c.setProjection(Projections.projectionList().add(Projections.property("wordId"), "wordId").add(Projections.property("word"), "word")).setResultTransformer(Transformers.aliasToBean(SbiGlWord.clreplaced));
if (page != null && item_per_page != null) {
c.setFirstResult((page - 1) * item_per_page);
c.setMaxResults(item_per_page);
}
return c;
}
19
Source : SearchWlistByContentId.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlWlist.clreplaced);
c.add(Restrictions.eq("content.contentId", contentId));
return c;
}
19
Source : SearchtWlistByGlossaryIdAndWordId.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
if (glossaryId == null || wordId == null) {
logger.debug("SearchtWlistByGlossaryIdAndWordId, glossaryId or wordId =null");
return null;
}
Criteria c = session.createCriteria(SbiGlWlist.clreplaced, "wlist");
c.createAlias("wlist.content", "contentWl");
c.createAlias("contentWl.glossary", "glossaryWl");
c.createAlias("word", "wordWl");
c.add(Restrictions.eq("glossaryWl.glossaryId", glossaryId));
c.add(Restrictions.eq("wordWl.wordId", wordId));
return c;
}
19
Source : SearchListMetaTableWlist.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlTableWlist.clreplaced, "dwlist");
if (metaTableId != null) {
c.createAlias("dwlist.word", "wordWl");
c.add(Restrictions.eq("dwlist.id.tableId", metaTableId));
}
// c.addOrder(Order.asc("word"));
return c;
}
19
Source : SearchListMetaBnessClsWlist.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlBnessClsWlist.clreplaced, "dwlist");
if (metaBnessClsId != null) {
c.createAlias("dwlist.word", "wordWl");
c.add(Restrictions.eq("dwlist.id.bcId", metaBnessClsId));
}
// c.addOrder(Order.asc("word"));
return c;
}
19
Source : SearchListDocWlist.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlDocWlist.clreplaced, "dwlist");
if (iddoc != null) {
c.createAlias("dwlist.word", "wordWl");
c.add(Restrictions.eq("id.doreplacedentId", iddoc));
}
// c.addOrder(Order.asc("word"));
return c;
}
19
Source : SearchListDataSetWlist.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlDataSetWlist.clreplaced, "dwlist");
if (iddoc != null) {
c.createAlias("dwlist.word", "wordWl");
c.add(Restrictions.eq("dwlist.id.datasetId", iddoc));
if (organiz != null) {
c.add(Restrictions.eq("dwlist.id.organization", organiz));
}
}
// c.addOrder(Order.asc("word"));
return c;
}
19
Source : SearchContentsByName.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlContents.clreplaced);
c.setProjection(Projections.projectionList().add(Projections.property("contentId"), "contentId").add(Projections.property("contentNm"), "contentNm")).setResultTransformer(Transformers.aliasToBean(SbiGlContents.clreplaced));
if (cont != null && !cont.isEmpty()) {
c.add(Restrictions.eq("contentNm", cont).ignoreCase());
}
return c;
}
19
Source : loadMetaTableWlistByMetaTableAndWord.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlTableWlist.clreplaced);
c.add(Restrictions.eq("id.tableId", metaTableId));
c.add(Restrictions.eq("id.wordId", word_id));
c.add(Restrictions.eq("id.column_name", column));
return c;
}
19
Source : loadMetaBnessClassWlistByMetaBcAndWord.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlBnessClsWlist.clreplaced);
c.add(Restrictions.eq("id.bcId", metaBcId));
c.add(Restrictions.eq("id.wordId", word_id));
c.add(Restrictions.eq("id.column_name", column));
return c;
}
19
Source : loadDocWlistByDocumentAndWord.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlDocWlist.clreplaced);
c.add(Restrictions.eq("id.doreplacedentId", doc_id));
c.add(Restrictions.eq("id.wordId", word_id));
return c;
}
19
Source : loadDataSetWlistByDatasetAndWordAndColumn.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlDataSetWlist.clreplaced);
c.add(Restrictions.eq("id.datasetId", datasetId));
c.add(Restrictions.eq("id.wordId", word_id));
c.add(Restrictions.eq("id.column_name", column));
return c;
}
19
Source : loadDataSetWlistByDataset.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlDataSetWlist.clreplaced);
c.add(Restrictions.eq("id.datasetId", datasetId));
c.add(Restrictions.eq("id.organization", organization));
return c;
}
19
Source : loadContentsParent.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlContents.clreplaced, "cont");
// Criteria c = session.createCriteria(SbiGlWlist.clreplaced,"wlist");
c.createAlias("cont.parent", "par");
c.add(Restrictions.eq("cont.contentId", cont_id));
return c;
}
19
Source : loadBnessClsWlistFromArray.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public Criteria evaluate(Session session) {
Criteria c = session.createCriteria(SbiGlBnessClsWlist.clreplaced, "bnwl");
c.createAlias("bnwl.word", "worddreplaced");
// c.createAlias("bnwl.bness_cls", "bness_clsreplaced");
c.add(Restrictions.eq("bnwl.bness_cls.bcId", id));
if (column != null && column.compareTo("null") != 0) {
c.add(Restrictions.eq("bnwl.column_name", column));
}
return c;
}
19
Source : DataSourceDAOHibImpl.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
private SbiDataSource loadSbiDataSourceWriteDefault(Session aSession) {
Criterion labelCriterrion = Expression.eq("writeDefault", true);
Criteria criteria = aSession.createCriteria(SbiDataSource.clreplaced);
criteria.add(labelCriterrion);
SbiDataSource hibDataSource = (SbiDataSource) criteria.uniqueResult();
logger.debug("Hibernate datasource write default found in session: " + hibDataSource);
return hibDataSource;
}
19
Source : SbiDataSetDAOImpl.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public SbiDataSet loadSbiDataSetByIdAndOrganiz(Integer id, String organiz, Session session) {
SbiDataSet sbiDataSet = null;
try {
Criteria c = session.createCriteria(SbiDataSet.clreplaced);
c.addOrder(Order.asc("label"));
c.add(Restrictions.eq("id.dsId", id));
if (organiz != null) {
c.add(Restrictions.eq("id.organization", organiz));
}
onlyActive(c);
sbiDataSet = (SbiDataSet) c.uniqueResult();
initialize(sbiDataSet);
} catch (Exception e) {
throw new SpagoBIDAOException("An unexpected error occured while loading datasets", e);
} finally {
logger.debug("OUT");
}
return sbiDataSet;
}
19
Source : CalendarDAOImpl.java
with GNU Affero General Public License v3.0
from KnowageLabs
with GNU Affero General Public License v3.0
from KnowageLabs
@Override
public List<CalendarConfiguration> loadCalendarDays(Integer calId, Session session) {
return session.createCriteria(CalendarConfiguration.clreplaced).add(Restrictions.eq("calendarId", calId)).addOrder(Order.asc("timeId")).list();
}
See More Examples