Package org.apache.ws.jaxme.sqls

Examples of org.apache.ws.jaxme.sqls.BooleanConstraint

138
139
140
141
142
143
144
145
146
    parts.add(result);
    return result;
  }

  public BooleanConstraint createLIKE() {
    BooleanConstraint result = new BooleanConstraintImpl(this, BooleanConstraint.Type.LIKE);
    parts.add(result);
    return result;
  }
View Full Code Here
144
145
146
147
148
149
150
151
152
    parts.add(result);
    return result;
  }

  public BooleanConstraint createISNULL() {
    BooleanConstraint result = new BooleanConstraintImpl(this, BooleanConstraint.Type.ISNULL);
    parts.add(result);
    return result;
  }
View Full Code Here
150
151
152
153
154
155
156
157
158
    parts.add(result);
    return result;
  }

  public BooleanConstraint createIN() {
    BooleanConstraint result = new BooleanConstraintImpl(this, BooleanConstraint.Type.IN);
    parts.add(result);
    return result;
  }
View Full Code Here
156
157
158
159
160
161
162
163
164
    parts.add(result);
    return result;
  }

  public void createEXISTS(SelectStatement pStatement) {
    BooleanConstraint bc = new BooleanConstraintImpl(this, BooleanConstraint.Type.EXISTS);
    parts.add(bc);
    bc.addPart(pStatement);
  }
View Full Code Here
173
174
175
176
177
178
179
180
181
182
    if (!pTableReference.getStatement().equals(getConstrainedStatement())) {
      throw new IllegalStateException("The statement of the table reference is not the same as this constraints statement.");
    }
    for (Iterator iter = pSet.getColumns();  iter.hasNext();  ) {
      Column column = (Column) iter.next();
      BooleanConstraint eq = createEQ();
      eq.addPart(new ColumnReferenceImpl(pTableReference, column));
      eq.addPlaceholder();
    }
  }
View Full Code Here
202
203
204
205
206
207
208
209
210
211
      throw new IllegalStateException("The statement of the referenced table is not the same as this constraints statement.");
    }

    for (Iterator iter = pKey.getColumnLinks();  iter.hasNext();  ) {
      ForeignKey.ColumnLink columnReference = (ForeignKey.ColumnLink) iter.next();
      BooleanConstraint eq = createEQ();
      eq.addPart(new ColumnReferenceImpl(pReferencingTable, columnReference.getLocalColumn()));
      eq.addPart(new ColumnReferenceImpl(pReferencedTable, columnReference.getReferencedColumn()));
    }
  }
View Full Code Here
236
237
238
239
240
241
242
243
244
245
        Column referencingColumn = (Column) iter.next();
        if (!referencedIter.hasNext()) {
           throw new IllegalStateException("The size of the referencing and referenced column sets doesn't match.");
        }
        Column referencedColumn = (Column) referencedIter.next();
        BooleanConstraint eq = createEQ();
        eq.addPart(pReferencingTable.newColumnReference(referencingColumn));
        eq.addPart(pReferencedTable.newColumnReference(referencedColumn));
     }
  }
View Full Code Here
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
        } else {
          throw new IllegalArgumentException("Invalid part: " + o.getClass().getName());
        }
      }
    } else if (pConstraint instanceof BooleanConstraint) {
      BooleanConstraint source = (BooleanConstraint) pConstraint;
      BooleanConstraint target;
      BooleanConstraint.Type sourceType = source.getType();
      if (BooleanConstraint.Type.EQ.equals(sourceType)) {
        target = createEQ();
      } else if (BooleanConstraint.Type.NE.equals(sourceType)) {
        target = createNE();
      } else if (BooleanConstraint.Type.GT.equals(sourceType)) {
        target = createGT();
      } else if (BooleanConstraint.Type.LT.equals(sourceType)) {
        target = createLT();
      } else if (BooleanConstraint.Type.GE.equals(sourceType)) {
        target = createGE();
      } else if (BooleanConstraint.Type.LE.equals(sourceType)) {
        target = createLE();
      } else if (BooleanConstraint.Type.LIKE.equals(sourceType)) {
        target = createLIKE();
      }  else if (BooleanConstraint.Type.ISNULL.equals(sourceType)) {
        target = createISNULL();
      } else if (BooleanConstraint.Type.IN.equals(sourceType)) {
        target = createIN();
      } else {
        throw new IllegalArgumentException("Invalid boolean constraint type: " + sourceType);
      }
      for (Iterator iter = source.getParts();  iter.hasNext();  ) {
        Object o = iter.next();
        if (o instanceof Value) {
          target.addPart((Value) o);
        } else if (o instanceof ColumnReference) {
           ColumnReference colRef = (ColumnReference) o;
           TableReference tableRef = (TableReference) pMap.get(colRef.getTableReference());
           if (tableRef == null) {
             throw new IllegalStateException("Unknown reference to table " + colRef.getTableReference().getTable().getQName());
           }
           target.addPart(tableRef.newColumnReference(colRef.getColumn()));
        } else {
           throw new IllegalStateException("Unknown part type: " + o.getClass().getName());
        }
      }
    } else {
View Full Code Here
248
249
250
251
252
253
254
255
256
257
258
259
260
     TableReference refRef = tableReference.getRightJoinedTableReference();

     joinReference.getOn().addJoin((ForeignKey) otherTable.getForeignKeys().next(),
                                   refLocal, refRef);
     CombinedConstraint cc = statement.getWhere();
     BooleanConstraint bc = cc.createEQ();
     bc.addPart(tableReference.newColumnReference("MyIndex"));
     bc.addPlaceholder();

     SQLGenerator generator = getSQLGenerator();
     generator.setLineTerminator("\n");
     String got = generator.getQuery(statement);
     String expect = getTestJoinResult();
View Full Code Here
278
279
280
281
282
283
284
285
286
287
288
289
290
     TableReference refRef = tableReference.getRightJoinedTableReference();

     joinReference.getOn().addJoin((ForeignKey) otherTable.getForeignKeys().next(),
                                   refLocal, refRef);
     CombinedConstraint cc = statement.getWhere();
     BooleanConstraint bc = cc.createEQ();
     bc.addPart(tableReference.newColumnReference("MyIndex"));
     bc.addPlaceholder();

     SQLGenerator generator = getSQLGenerator();
     generator.setLineTerminator("\n");
     String got = generator.getQuery(statement);
     String expect = getTestLeftOuterJoinResult();
View Full Code Here
TOP

Related Classes of org.apache.ws.jaxme.sqls.BooleanConstraint

  • org.apache.ws.jaxme.sqls.impl.CombinedConstraintImpl
  • org.apache.ws.jaxme.sqls.impl.SQLGeneratorImpl
  • org.apache.ws.jaxme.sqls.junit.CreateTest
  • org.apache.ws.jaxme.sqls.junit.JoinTest
  • org.apache.ws.jaxme.sqls.junit.Oracle8Test
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.