Examples of Where

br.com.objectos.comuns.relational.search.Where
@author marcio.endo@objectos.com.br (Marcio Endo)
com.avaje.ebean.annotation.Where
com.datastax.driver.core.querybuilder.Delete.Where
com.datastax.driver.core.querybuilder.Select.Where
com.datastax.driver.core.querybuilder.Update.Where
com.google.gdata.data.extensions.Where
com.googlecode.gql4j.GqlQuery.Where

com.j256.ormlite.stmt.Where

3schools.com/Sql/" >good tutorial of SQL commands.

To create a query which looks up an account by name and password you would do the following:

 QueryBuilder<Account, String> qb = accountDao.queryBuilder(); Where where = qb.where(); // the name field must be equal to "foo" where.eq(Account.NAME_FIELD_NAME, "foo"); // and where.and(); // the password field must be equal to "_secret" where.eq(Account.PASSWORD_FIELD_NAME, "_secret"); PreparedQuery<Account, String> preparedQuery = qb.prepareQuery();

In this example, the SQL query that will be generated will be approximately:

 SELECT * FROM account WHERE (name = 'foo' AND passwd = '_secret')

If you'd rather chain the methods onto one line (like StringBuilder), this can also be written as:

 queryBuilder.where().eq(Account.NAME_FIELD_NAME, "foo").and().eq(Account.PASSWORD_FIELD_NAME, "_secret");

If you'd rather use parens and the like then you can call:

 Where where = queryBuilder.where(); where.and(where.eq(Account.NAME_FIELD_NAME, "foo"), where.eq(Account.PASSWORD_FIELD_NAME, "_secret"));

All three of the above call formats produce the same SQL. For complex queries that mix ANDs and ORs, the last format will be necessary to get the grouping correct. For example, here's a complex query:

 Where where = queryBuilder.where(); where.or(where.and(where.eq(Account.NAME_FIELD_NAME, "foo"), where.eq(Account.PASSWORD_FIELD_NAME, "_secret")), where.and(where.eq(Account.NAME_FIELD_NAME, "bar"), where.eq(Account.PASSWORD_FIELD_NAME, "qwerty")));

This produces the following approximate SQL:

 SELECT * FROM account WHERE ((name = 'foo' AND passwd = '_secret') OR (name = 'bar' AND passwd = 'qwerty'))

@author graywatson

com.pv.mf.db2.impl.Select.Where
com.samskivert.depot.clause.Where
com.taobao.tdhs.client.easy.Where
Where condition @author 文通 @since 11-12-27 下午2:49
org.apache.gora.sql.statement.Where
A WHERE clause in an SQL statement
org.apache.isis.applib.annotation.Where
org.apache.isis.core.metamodel.facets.actions.executed.ExecutedFacet.Where
org.bitbucket.rehei.sparqljava.query.where
org.eclipse.emf.query.statements.WHERE
org.fao.geonet.kernel.rdf.Where
org.hibernate.annotations.Where

Examples of com.pv.mf.db2.impl.Select.Where

            q.getSql());
      Assert.assertArrayEquals(new Object[] {1L}, q.getParameterValues());


      Select sel = builder.select();
      sel.columns(builder.mock().getId(), builder.mock().getUserName());
      Where w = sel.where();
      w.and(builder.mock().getId(), 1L);
      sel.orderBy(builder.mock().getUserName());
      q = sel.buildQuery();
      
      Assert.assertEquals(
               "SELECT user.id,user.userName"

View Full Code Here

Examples of com.pv.mf.db2.impl.Select.Where

            q.getSql());
      Assert.assertArrayEquals(new Object[] {1L}, q.getParameterValues());


      Select sel = builder.select();
      sel.columns(builder.mock().getId(), builder.mock().getUserName());
      Where w = sel.where();
      w.and(builder.mock().getId(), 1L);
      sel.limit(14);
      q = sel.buildQuery();
      
      Assert.assertEquals(
               "SELECT user.id,user.userName"

View Full Code Here

Examples of com.samskivert.depot.clause.Where

     * @return the modified Stat, if any modification took place; or null if the modification had
     * no effect on the stat's data.
     */
    public <T extends Stat> T updateStat (int playerId, StatModifier<T> modifier)
    {
        Where where = new Where(StatRecord.PLAYER_ID, playerId,
                                StatRecord.STAT_CODE, modifier.getType().code());


        for (int ii = 0; ii < MAX_UPDATE_TRIES; ii++) {
            StatRecord record = load(StatRecord.class, where); // TODO: force cache skip on ii > 0
            Stat stat = (record == null) ? modifier.getType().newStat() :

View Full Code Here

Examples of com.taobao.tdhs.client.easy.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());
            }
            List<String> orderByColumn = parseSQL.getOrderByColumn();
            if ((orderByColumn != null && !orderByColumn.isEmpty()) || parseSQL.getSortMethod() != null) {
                throw new TDHSSQLException("can't support orderBy without hint!", parseSQL.getSql());
            }
            OperationStruct firstKey = operation.get(0);
            keys.add(firstKey);
            String firstField = StringUtil.escapeField(firstKey.getColumnName());
            if (firstField == null) {
                throw new TDHSSQLException("error field [" + firstKey.getColumnName() + "]", parseSQL.getSql());
            }
            Where where = query.where().fields(firstField);
            processKey(parseSQL, keys, where);


        }


        for (OperationStruct o : operation) {

View Full Code Here

Examples of org.apache.gora.sql.statement.Where

    requestFields = getFieldsToQuery(requestFields);


    ResultSet resultSet = null;
    PreparedStatement statement = null;
    try {
      Where where = new Where();
      SelectStatement select = new SelectStatement(mapping.getTableName());
      select.setWhere(where);


//      boolean isPrimarySelected = false;
//      for (int i = 0; i < requestFields.length; i++) {
//        if(primaryColumn.getName().equals(primaryColumn)) {
//          isPrimarySelected = true;
//          break;
//        }
//      }
//      if(!isPrimarySelected) {
//        requestFields = StringUtils.append(requestFields, primaryColumn.getName());
//      }


      for (int i = 0; i < requestFields.length; i++) {
        Column column = mapping.getColumn(requestFields[i]);


        select.addToSelectList(column.getName());
      }


      where.equals(primaryColumn.getName(), "?");
      statement = getConnection().prepareStatement(select.toString());


      setObject(statement, 1, key, keySqlType, primaryColumn);


      resultSet = statement.executeQuery();

View Full Code Here

Examples of org.apache.isis.applib.annotation.Where

            if(disabled != null) {
                // same default as in Disabled.when()
                final When disabledWhen = disabled.when!=null?disabled.when: When.ALWAYS;
                props.setProperty("member." + memberName + ".disabled.when", disabledWhen.toString());
                // same default as in Disabled.where()
                final Where disabledWhere = disabled.where!=null?disabled.where: Where.ANYWHERE;
                props.setProperty("member." + memberName + ".disabled.where", disabledWhere.toString());
                // same default as in Disabled.reason()
                final String disabledReason = disabled.reason!=null?disabled.reason: "";
                props.setProperty("member." + memberName + ".disabled.reason", disabledReason);
            }
            final HiddenFacetRepr hidden = memberRepr.hidden;
            if(hidden != null) {
                // same default as in Hidden.when()
                final When hiddenWhen = hidden.when!=null?hidden.when: When.ALWAYS;
                props.setProperty("member." + memberName + ".hidden.when", hiddenWhen.toString());
                // same default as in Hidden.where()
                final Where hiddenWhere = hidden.where!=null?hidden.where: Where.ANYWHERE;
                props.setProperty("member." + memberName + ".hidden.where", hiddenWhere.toString());
            }
            final RenderFacetRepr render = memberRepr.render;
            if(render != null) {
                // same default as in Render.Type.value()
                final Type renderType = render.value!=null?render.value: Render.Type.EAGERLY;

View Full Code Here

Examples of org.apache.isis.applib.annotation.Where

            if(disabled != null) {
                // same default as in Disabled.when()
                final When disabledWhen = disabled.when!=null?disabled.when: When.ALWAYS;
                props.setProperty("member." + memberName + ".disabled.when", disabledWhen.toString());
                // same default as in Disabled.where()
                final Where disabledWhere = disabled.where!=null?disabled.where: Where.ANYWHERE;
                props.setProperty("member." + memberName + ".disabled.where", disabledWhere.toString());
                // same default as in Disabled.reason()
                final String disabledReason = disabled.reason!=null?disabled.reason: "";
                props.setProperty("member." + memberName + ".disabled.reason", disabledReason);
            }
            final HiddenFacetRepr hidden = memberRepr.hidden;
            if(hidden != null) {
                // same default as in Hidden.when()
                final When hiddenWhen = hidden.when!=null?hidden.when: When.ALWAYS;
                props.setProperty("member." + memberName + ".hidden.when", hiddenWhen.toString());
                // same default as in Hidden.where()
                final Where hiddenWhere = hidden.where!=null?hidden.where: Where.ANYWHERE;
                props.setProperty("member." + memberName + ".hidden.where", hiddenWhere.toString());
            }
            final RenderFacetRepr render = memberRepr.render;
            if(render != null) {
                // same default as in Render.Type.value()
                final Type renderType = render.value!=null?render.value: Render.Type.EAGERLY;

View Full Code Here

Examples of org.apache.isis.applib.annotation.Where

            // REVIEW: should provide this rendering context, rather than hardcoding.
            // the net effect currently is that class members annotated with 
            // @Hidden(where=Where.ANYWHERE) or @Disabled(where=Where.ANYWHERE) will indeed
            // be hidden/disabled, but will be visible/enabled (perhaps incorrectly) 
            // for any other value for Where
            final Where where = Where.ANYWHERE;
            
            if (field.isVisible(IsisContext.getAuthenticationSession(), adapter, where).isVetoed()) {
                throw new ForbiddenException(field, ForbiddenException.VISIBLE);
            }
            IsisContext.getPersistenceSession().resolveField(adapter, field);

View Full Code Here

Examples of org.apache.isis.applib.annotation.Where

    }


    public OneToOneAssociation getPropertyThatIsVisibleForIntent(
            final String propertyId, final Intent intent) {


        final Where where = rendererContext.getWhere();


        final ObjectAssociation association;
        try {
            final ObjectSpecification specification = objectAdapter.getSpecification();
            association = specification.getAssociation(propertyId);

View Full Code Here

Examples of org.apache.isis.applib.annotation.Where

    }


    public OneToManyAssociation getCollectionThatIsVisibleForIntent(
            final String collectionId, final Intent intent) {


        final Where where = rendererContext.getWhere();
        final ObjectAssociation association;
        try {
            final ObjectSpecification specification = objectAdapter.getSpecification();
            association = specification.getAssociation(collectionId);
        } catch(Exception ex) {

View Full Code Here

0 1 2 3 4 5 6

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.