Examples of SelectTableReference

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

103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
        }
        sb.append(getColumnAlias(pData, column));
      } while (columnIter.hasNext());
    }

    SelectTableReference selectTableReference = pQuery.getSelectTableReference();
    List whereClauses = new ArrayList();
    if (selectTableReference != null) {
      sb.append(" FROM ");
      sb.append(getTableAlias(selectTableReference));
      for (JoinReference joinReference = selectTableReference.getRightJoinedTableReference();
           joinReference != null;
           joinReference = joinReference.getRightJoinedTableReference()) {
        sb.append(", ");
        sb.append(getTableAlias(joinReference));
        OraJoinReferenceImpl oraJoin = null;
View Full Code Here

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

239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
   */
  public void testJoin() {
     Table table = getPrimaryKeyTable();
     Table otherTable = getForeignKeyTable(table);
     SelectStatement statement = otherTable.getSelectStatement();
     SelectTableReference tableReference = statement.getSelectTableReference();
     JoinReference joinReference = tableReference.join(table);

     TableReference refLocal = tableReference;
     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);
View Full Code Here

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

269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
   */
  public void testLeftOuterJoin() {
     Table table = getPrimaryKeyTable();
     Table otherTable = getForeignKeyTable(table);
     SelectStatement statement = otherTable.getSelectStatement();
     SelectTableReference tableReference = statement.getSelectTableReference();
     JoinReference joinReference = tableReference.leftOuterJoin(table);

     TableReference refLocal = tableReference;
     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);
View Full Code Here

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

295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
   */
  public void testExists() {
    Table table = getPrimaryKeyTable();
    Table otherTable = getForeignKeyTable(table);
    SelectStatement statement = table.getSelectStatement();
    SelectTableReference tableReference = statement.getSelectTableReference();
    SelectStatement existsStatement = otherTable.getSelectStatement();
    SelectTableReference existsTableReference = existsStatement.getSelectTableReference();
    BooleanConstraint bc = existsStatement.getWhere().createEQ();
    bc.addPart(existsTableReference.newColumnReference("RefIndex"));
    bc.addPart(tableReference.newColumnReference("MyIndex"));
    statement.getWhere().createEXISTS(existsStatement);
  
    SQLGenerator generator = getSQLGenerator();
    generator.setLineTerminator("\n");
View Full Code Here

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

918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
        }
        sb.append(getColumnAlias(pData, column));
      } while (columnIter.hasNext());
    }

    SelectTableReference selectTableReference = pQuery.getSelectTableReference();
    if (selectTableReference != null) {
      sb.append(" FROM ");
      sb.append(getTableAlias(selectTableReference));
      for (JoinReference joinReference = selectTableReference.getRightJoinedTableReference();
           joinReference != null;
           joinReference = joinReference.getRightJoinedTableReference()) {
        sb.append(getJoinAlias(pData, joinReference));              
      }
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.