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

org.apache.ws.jaxme.sqls.TableReference

A table reference is used in the {@link Statement}.
@author Jochen Wiedmann


    protected void createTableAliases() {
        if (tables.size() > 1) {
            // Make sure that all tables have an alias
            for (Iterator iter = tables.iterator();  iter.hasNext();  ) {
                TableReference tableReference = (TableReference) iter.next();
                if (tableReference.getAlias() == null) {
                    String alias = getUniqueAlias(tableReference.getTable().getName().getName(), aliases);
                    aliases.put(alias, tableReference);
                    if (!alias.equals(tableReference.getTable().getName().getName())) {
                        tableReference.setAlias(alias);
                    }
                }
            }
        }
    }

View Full Code Here

      // maps key is the column name, and the maps value is the
      // number of possible references. In other words: If an entry
      // in the map has a value > 1, then its column name must be
      // qualified, because it is used in multiple tables.
      for (int i = 0;  i < tables.size();  i++) {
        TableReference table = (TableReference) tables.get(i);
        for (Iterator iter = table.getTable().getColumns();  iter.hasNext();  ) {
          Column col = (Column) iter.next();
          addColumnName(col.getName());
        }
      }
    }

View Full Code Here

        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();

View Full Code Here

        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();

View Full Code Here

                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

    Column c1 = ref.getColumn();
    Column c2 = getColumn();
    if (c1 == null  ||  c2 == null) {
      return super.equals(o);
    }
    TableReference t1 = ref.getTableReference();
    TableReference t2 = ref.getTableReference();
    if (t1 == null  ||  t2 == null) {
      return super.equals(o);
    }
      return t1.equals(t2)  &&  c1.equals(c2);
   }

View Full Code Here

     * </pre></p>
     */
    private SelectStatement getSelectAllChildsByOrganisationsId() {
        OraSelectStatement stmt = (OraSelectStatement) sqlFactory.newSelectStatement();
        stmt.setTable(kettenElement);
        TableReference tRef  = stmt.getTableReference();


        BooleanConstraint in = stmt.getStartWith().createIN();
        in.addPart(tRef.newColumnReference(kettenElement.getColumn("aId")));
        in.addPart(getSelectAidByOrganisationsId());
        
        BooleanConstraint bc = stmt.getConnectBy().createEQ();
        OraColumnReference ref1 = (OraColumnReference) tRef.newColumnReference(kettenElement.getColumn("aId"));
        ref1.setPrior(true);
        bc.addPart(ref1);
        bc.addPart(tRef.newColumnReference(kettenElement.getColumn("aVertreterId")));


        return stmt;
    }

View Full Code Here

     * </pre></p>
     */
    private DeleteStatement getDeleteAllChildsByOrganisationsId() {
        DeleteStatement dstmt = sqlFactory.newDeleteStatement();
        dstmt.setTable(kettenElement);
        TableReference tRef  = dstmt.getTableReference();
        CombinedConstraint whereClause = dstmt.getWhere();
        BooleanConstraint bc = whereClause.createIN();
        bc.addPart(tRef.newColumnReference(kettenElement.getColumn("aId")));
        bc.addPart(getSelectAllChildsByOrganisationsId());
        return dstmt;
    }

View Full Code Here


   public SelectStatement getSelectStatement() {
       SQLFactory factory = getSchema().getSQLFactory();
       SelectStatement result = factory.newSelectStatement();
      result.setTable(this);
      TableReference ref = result.getTableReference();
      for (Iterator iter = getColumns();  iter.hasNext();  ) {
         Column column = (Column) iter.next();
         result.addResultColumn(factory.getObjectFactory().newColumnReference(ref, column));
      }
      return result;

View Full Code Here

   }


  public UpdateStatement getUpdateStatement() {
    UpdateStatement result = getSchema().getSQLFactory().newUpdateStatement();
    result.setTable(this);
    TableReference ref = result.getTableReference();
    boolean hasPrimaryKey = false;
    for (Iterator iter = getColumns();  iter.hasNext();  ) {
      Column column = (Column) iter.next();
      if (column.isPrimaryKeyPart()) {
        hasPrimaryKey = true;

View Full Code Here

0 1 2 3

TOP

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

org.apache.ws.jaxme.sqls.impl.ColumnReferenceImpl

org.apache.ws.jaxme.sqls.impl.CombinedConstraintImpl

org.apache.ws.jaxme.sqls.impl.SelectStatementMetaData

org.apache.ws.jaxme.sqls.impl.SQLGeneratorImpl

org.apache.ws.jaxme.sqls.impl.SQLGeneratorImpl$SelectStatementMetaData

org.apache.ws.jaxme.sqls.impl.StatementMetaData

org.apache.ws.jaxme.sqls.impl.TableImpl

org.apache.ws.jaxme.sqls.impl.TableReferenceImpl

org.apache.ws.jaxme.sqls.junit.CreateTest

org.apache.ws.jaxme.sqls.junit.JoinTest

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.