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

     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

     if (col.isVirtual()) {
       VirtualColumn virtCol = (VirtualColumn) col;
       return virtCol.getValue() + " AS " + s;
     } else {
       if (isQualifiedColumn(pData, pColumn)) {
         TableReference tableReference = pColumn.getTableReference();
         if (tableReference.getAlias() != null) {
           s = tableReference.getAlias().getName() + "." + s;
         } else {
           s = tableReference.getTable().getName() + "." + s;
         }
       }


       if (pColumn.getAlias() != null) {
         s = s + " AS " + pColumn.getAlias().getName();

View Full Code Here

      createColumnNames();
    }


    protected void addSelectStatement(SelectStatement pQuery) {
      for (Iterator tableIter = pQuery.getSelectTableReferences();  tableIter.hasNext();  ) {
        TableReference tableReference = (TableReference) tableIter.next();
        Table.Name alias = tableReference.getAlias();
        if (alias != null) {
          if (aliases.containsKey(alias.getName())) {
            throw new NullPointerException("The alias " + alias +
                " is used twice for the tables " +
                ((TableReference) aliases.get(alias)).getTable().getName() +
                " and " + tableReference.getTable().getName());
          }
          aliases.put(alias.getName(), tableReference);
        }
        tables.add(tableReference);

View Full Code Here


    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();
          String key = col.getName().toString().toUpperCase();
          Integer num = (Integer) columnNames.get(key);
          if (num == null) {
            num = new Integer(1);

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.