Examples of com.sun.jdo.spi.persistence.support.sqlstore.RetrieveDesc.addConstraint()

Package com.sun.jdo.spi.persistence.support.sqlstore

Class com.sun.jdo.spi.persistence.support.sqlstore.RetrieveDesc

Examples of com.sun.jdo.spi.persistence.support.sqlstore.RetrieveDesc.addConstraint()

com.sun.jdo.spi.persistence.support.sqlstore.RetrieveDesc.addConstraint()
Adds a constraint on the persistent field specified by name. The valid values for operation are defined in ActionDesc. The parameter value specifies the constraint value.
By default, multiple constraints are implicitly ANDed together. If the applications want to OR together the constraints, it can explicitly add OP_OR constraints. For example, to OR together two constraints, an application can do the following:
```
 addConstraint("field1", ActionDesc.OP_EQ, "field1Value"); addConstraint("field2", ActionDesc.OP_EQ, "field2Value"); addConstraint(null, ActionDesc.OP_OR, null); 
```
The important thing to note about the above example is that the constraints are processed in postfix order, so the above example should be read as
```
 (field1 == "field1Value") OR (field2 == "field2Value") 
```

        }
        // SQL length = end - begin
        rd.addConstraint(null, RetrieveDesc.OP_VALUE, 
        new Integer(endValue-beginValue));
        // SQL start index = begin + 1 
        rd.addConstraint(null, RetrieveDesc.OP_VALUE, 
        new Integer(beginValue+1));
        }
        else
        {
        // At least one of begin or end is a non constant value =>

View Full Code Here

        // generate the arguments start and length of the SQL SUBSTRING 
        // function as binary plus/minus expressions.
        // The next 3 line denote the SQL length = end - begin
        expression(begin);
        expression(end);
        rd.addConstraint(null, RetrieveDesc.OP_SUB, null);
        // The next 3 lines denote the SQL start index = begin + 1 
        rd.addConstraint(null, RetrieveDesc.OP_VALUE, new Integer(1));
        expression(begin);
        rd.addConstraint(null, RetrieveDesc.OP_ADD, null);
        }

View Full Code Here

        // The next 3 line denote the SQL length = end - begin
        expression(begin);
        expression(end);
        rd.addConstraint(null, RetrieveDesc.OP_SUB, null);
        // The next 3 lines denote the SQL start index = begin + 1 
        rd.addConstraint(null, RetrieveDesc.OP_VALUE, new Integer(1));
        expression(begin);
        rd.addConstraint(null, RetrieveDesc.OP_ADD, null);
        }
        // now push the string on the constraint stack
        expression(string);

View Full Code Here

        expression(end);
        rd.addConstraint(null, RetrieveDesc.OP_SUB, null);
        // The next 3 lines denote the SQL start index = begin + 1 
        rd.addConstraint(null, RetrieveDesc.OP_VALUE, new Integer(1));
        expression(begin);
        rd.addConstraint(null, RetrieveDesc.OP_ADD, null);
        }
        // now push the string on the constraint stack
        expression(string);
        rd.addConstraint(null, RetrieveDesc.OP_SUBSTRING, null);

View Full Code Here

        expression(begin);
        rd.addConstraint(null, RetrieveDesc.OP_ADD, null);
        }
        // now push the string on the constraint stack
        expression(string);
        rd.addConstraint(null, RetrieveDesc.OP_SUBSTRING, null);
        
      }
    }
    catch (RecognitionException ex) {
      if (inputState.guessing==0) {

View Full Code Here

        
        RetrieveDesc rd = op.getRetrieveDesc();
        // the 3 lines denote the SQL function POSITION OR POSITION_START
        expression(pattern);
        expression(string);
        rd.addConstraint(null, opCode, null);
        // SQL handles indexes starting from 1 =>
        // decrement the returned value to make it Java like!
        incr--;
        if (incr != 0)
        {

View Full Code Here

        // SQL handles indexes starting from 1 =>
        // decrement the returned value to make it Java like!
        incr--;
        if (incr != 0)
        {
        rd.addConstraint(null, RetrieveDesc.OP_VALUE, new Integer(incr));
        rd.addConstraint(null, RetrieveDesc.OP_ADD, null);
        }
        
      }
    }

View Full Code Here

        // decrement the returned value to make it Java like!
        incr--;
        if (incr != 0)
        {
        rd.addConstraint(null, RetrieveDesc.OP_VALUE, new Integer(incr));
        rd.addConstraint(null, RetrieveDesc.OP_ADD, null);
        }
        
      }
    }
    catch (RecognitionException ex) {

View Full Code Here

0 1

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.