List of where() Examples

Examples of where()

br.com.objectos.comuns.relational.search.Join.where()
com.adaptrex.core.ext.data.Store.where()
com.atlassian.jira.jql.builder.JqlQueryBuilder.where()
com.baasbox.util.QueryParams.where()
com.boco.bomc.vpn.db.bean.QueryCondition.where()
com.datastax.driver.core.querybuilder.Delete.where()
Adds a WHERE clause to this statement. This is a shorter/more readable version for {@code where().and(clause)}. @param clause the clause to add. @return the where clause of this query to which more clause can be added.
com.datastax.driver.core.querybuilder.Select.where()
Adds a WHERE clause to this statement. This is a shorter/more readable version for {@code where().and(clause)}. @param clause the clause to add. @return the where clause of this query to which more clause can be added.
com.datastax.driver.core.querybuilder.Update.where()
Adds a WHERE clause to this statement. This is a shorter/more readable version for {@code where().and(clause)}. @param clause the clause to add. @return the where clause of this query to which more clause can be added.
com.datastax.driver.core.querybuilder.Update.Assignments.where()
com.mysema.query.jpa.hibernate.HibernateQuery.where()
com.mysema.query.jpa.impl.JPAQuery.where()
com.mysema.query.sql.dml.SQLDeleteClause.where()
com.mysema.query.sql.dml.SQLUpdateClause.where()
com.mysql.clusterj.query.QueryDomainType.where()
com.taobao.tdhs.client.easy.Query.where()
start where condition for index @return Where
com.workingdogs.village.TableDataSet.where()
Sets the value for the SQL portion of the WHERE statement @param where TODO: DOCUMENT ME! @return instance of self @throws DataSetException TODO: DOCUMENT ME!
javax.persistence.criteria.CriteriaDelete.where()
Modify the query to restrict the target of the deletion according to the specified boolean expression. Replaces the previously added restriction(s), if any. @param restriction a simple or compound boolean expression @return the modified query
javax.persistence.criteria.CriteriaQuery.where()
javax.persistence.criteria.CriteriaUpdate.where()
Modify the query to restrict the target of the update according to the specified boolean expression. Replaces the previously added restriction(s), if any. @param restriction a simple or compound boolean expression @return the modified query
javax.persistence.criteria.Subquery.where()
Modify the subquery to restrict the result according to the specified boolean expression. Replaces the previously added restriction(s), if any. This method only overrides the return type of the corresponding AbstractQuery method. @param restriction a simple or compound boolean expression @return the modified subquery
net.sf.domainbeans.operation.annotation.Db.query.where()
nl.giantit.minecraft.database.query.DeleteQuery.where()
org.apache.empire.db.DBCommand.where()
Adds a compare expression to the list of constraints. If another restriction already exists for the same column it will be replaced. @param expr the DBCompareExpr object
org.apache.gora.sql.statement.Delete.where()
org.apache.isis.applib.annotation.Disabled.where()
org.apache.isis.applib.annotation.Hidden.where()
org.apache.isis.core.metamodel.facets.all.hide.HiddenFacet.where()
org.apache.isis.core.metamodel.facets.hide.HiddenFacet.where()
org.apache.isis.core.metamodel.facets.members.disabled.DisabledFacet.where()
org.apache.isis.core.progmodel.facets.members.disabled.DisabledFacet.where()
org.apache.isis.core.progmodel.facets.members.disabled.DisabledFacetAbstract.where()
org.apache.isis.core.progmodel.facets.members.hidden.HiddenFacetAbstract.where()
org.apache.juddi.query.util.DynamicQuery.WHERE()
org.apache.metamodel.query.Query.where()
org.apache.openjpa.jdbc.sql.Select.where()
Add the given where conditions.
org.apache.openjpa.persistence.query.DomainObject.where()
org.apache.openjpa.persistence.query.QueryDefinition.where()
Modifies the query definition to restrict the result of the query according to the specified predicate. Replaces the previously added restriction(s), if any. @param predicate -a simple or compound conditional predicate @return the modified QueryDefinition instance
org.apache.torque.criteria.Criteria.where()
"AND"s Criterion object with the conditions in this Criteria. Equivalent to #and(Criterion) but better to read if this is the first condition to be added to the Criteria. @param criterion A Criterion object. @return A modified Criteria object.
org.beangle.model.query.builder.OqlBuilder.where()
org.jboss.test.deployers.scope.support.TestClassAnnotation.where()
org.nutz.dao.sql.Criteria.where()
org.nutz.dao.util.cri.SimpleCriteria.where()
pt.webdetails.cpf.persistence.Filter.where()

Examples of com.mysema.query.jpa.hibernate.HibernateQuery.where()

  }


  public List<FeedSubscription> findByCategory(User user, FeedCategory category) {
    HibernateQuery query = newQuery().from(sub).where(sub.user.eq(user));
    if (category == null) {
      query.where(sub.category.isNull());
    } else {
      query.where(sub.category.eq(category));
    }
    return initRelations(query.list(sub));
  }

View Full Code Here

Examples of com.mysema.query.jpa.impl.JPAQuery.where()


    @Test
    public void Query() throws ClassNotFoundException, IOException {
        JPAQuery query = new JPAQuery();
        query.from(QCat.cat);
        query.where(serialize(QCat.cat.name.eq("test")));
    }


}

View Full Code Here

Examples of com.mysema.query.sql.dml.SQLDeleteClause.where()

    @Test
    public void Delete_with_SubQuery_exists() {
        QSurvey survey1 = new QSurvey("s1");
        QEmployee employee = new QEmployee("e");
        SQLDeleteClause delete = new SQLDeleteClause(connection, SQLTemplates.DEFAULT,survey1);
        delete.where(survey1.name.eq("XXX"), new SQLSubQuery().from(employee).where(survey1.id.eq(employee.id)).exists());
        assertEquals("delete from SURVEY\n" +
                     "where SURVEY.NAME = ? and exists (select 1\n" +
                     "from EMPLOYEE e\n" +
                     "where SURVEY.ID = e.ID)", delete.toString());
    }

View Full Code Here

Examples of com.mysema.query.sql.dml.SQLUpdateClause.where()

    @Test
    public void Update_Where() {
        SQLUpdateClause updateClause = new SQLUpdateClause(connection,SQLTemplates.DEFAULT,survey);
        updateClause.set(survey.id, 1);
        updateClause.set(survey.name, (String)null);
        updateClause.where(survey.name.eq("XXX"));
        assertEquals("update SURVEY\nset ID = ?, NAME = ?\nwhere SURVEY.NAME = ?", updateClause.toString());
    }


    @Test
    public void Insert() {

View Full Code Here

Examples of com.mysql.clusterj.query.QueryDomainType.where()

        // property name
        PredicateOperand column = dobj.get("eid");
        // compare the column with the parameter
        Predicate compare = column.lessEqual(param);
        // set the where clause into the query 
        dobj.where(compare);
        // create a query instance
        Query query = session.createQuery(dobj);


        // set the parameter values
        query.setParameter("eid", (long)2);

View Full Code Here

Examples of com.taobao.tdhs.client.easy.Query.where()

                                parseSQL.getSql());
                    }


                }
            }
            Where where = query.where().index(index);
            processKey(parseSQL, keys, where);
        } else {
            if (hint != null && StringUtils.isNotBlank(hint.getErrmsg())) {
                logger.warn("TDHS: JDBC hint error:" + hint.getErrmsg() + " , SQL:" + parseSQL.getSql());
            }

View Full Code Here

Examples of com.workingdogs.village.TableDataSet.where()

                if (log.isDebugEnabled())
                {
                    log.debug("BasePeer: whereClause=" + sqlSnippet);
                }


                tds.where(sqlSnippet);
                tds.fetchRecords();


                if (tds.size() > 1 && crit.isSingleRecord())
                {
                    handleMultipleRecords(tds);

View Full Code Here

Examples of com.workingdogs.village.TableDataSet.where()

                if (log.isDebugEnabled())
                {
                    log.debug("BasePeer.doDelete: whereClause=" + sqlSnippet);
                }


                tds.where(sqlSnippet);
                tds.fetchRecords();
                if (tds.size() > 1 && criteria.isSingleRecord())
                {
                    handleMultipleRecords(tds);
                }

View Full Code Here

Examples of com.workingdogs.village.TableDataSet.where()

                if (log.isDebugEnabled())
                {
                    log.debug("BasePeer: whereClause=" + sqlSnippet);
                }


                tds.where(sqlSnippet);
                tds.fetchRecords();


                if (tds.size() > 1 && crit.isSingleRecord())
                {
                    handleMultipleRecords(tds);

View Full Code Here

Examples of javax.persistence.criteria.CriteriaDelete.where()

    
    public void deleteMovie() {
        CriteriaBuilder builder = em.getCriteriaBuilder();
        CriteriaDelete deleteCriteria = builder.createCriteriaDelete(Movie.class);
        Root<Movie> updateRoot = deleteCriteria.from(Movie.class);
        deleteCriteria.where(builder.equal(updateRoot.get(Movie_.name), "The Matrix"));
        Query q = em.createQuery(deleteCriteria);
        q.executeUpdate();
        em.flush();
    }

View Full Code Here

0 1 2 3 4 5 6 7 8

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.