Package org.apache.ws.jaxme.sqls

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

404
405
406
407
408
409
410
411
412
413
414
415
    if (pUpdater != null) {
      tableInfo.add(pUpdater);
    }
   
    for (Iterator iter = pTable.getForeignKeys();  iter.hasNext();  ) {
      ForeignKey foreignKey = (ForeignKey) iter.next();
      Table referencedTable = foreignKey.getReferencedTable();
      for (Iterator iter2 = tablesByOrder.iterator();  iter2.hasNext();  ) {
        TableInfo referencedTableInfo = (TableInfo) iter2.next();
        if (referencedTableInfo.getTable().equals(referencedTable)) {
          ColumnUpdater columnUpdater = new ForeignKeyUpdater(foreignKey, referencedTableInfo);
          tableInfo.add(columnUpdater);
View Full Code Here
864
865
866
867
868
869
870
871
872
873
874
875
    LocalJavaField referencedValues = null;
    for (Iterator referencingIter = tablesByOrder.iterator();  referencingIter.hasNext();  ) {
      TableInfo prevTableInfo = (TableInfo) referencingIter.next();
      Table prevTable = prevTableInfo.getTable();
      for (Iterator fkIter = prevTable.getForeignKeys();  fkIter.hasNext();  ) {
        ForeignKey fk = (ForeignKey) fkIter.next();
        if (fk.getReferencedTable().equals(table)) {
          if (referencedValues == null) {
            referencedValues = jm.newJavaField(Object[].class);
            referencedValues.addLine(baseKey, ".getValues()");
          }
          getSelectRowsCode(jm, prevTableInfo, fk, connection, map, referencedValues, false);
View Full Code Here
167
168
169
170
171
172
173
174
175
   public Iterator getForeignKeys() {
      return foreignKeys.iterator();
   }

   public ForeignKey newForeignKey(Table pTable) {
      ForeignKey foreignKey = new ForeignKeyImpl(this, pTable);
      foreignKeys.add(foreignKey);
      return foreignKey;
   }
View Full Code Here
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
    logger.finest(mName, "Looking for foreign keys of " + pTable + "=" + pTable.getTable().getQName());
    List result = new ArrayList();
    ResultSet rs = pData.getImportedKeys(pTable.getCatalogName(),
                                         pTable.getSchemaName(),
                                         pTable.getTableName());
    ForeignKey foreignKey = null;
    boolean isRsClosed = false;
    try {
      while (rs.next()) {
        JDBCTable referencedTable = new JDBCTable(rs.getString(1), rs.getString(2),
                                                  rs.getString(3), "TABLE");
        String referencedColumnName = rs.getString(4);
        String localColumnName = rs.getString(8);
        logger.finest(mName, "Found column " + localColumnName + " referencing " +
                      referencedColumnName + " in " + referencedTable);
        for (int i = 0;  i < pTables.length;  i++) {
          JDBCTable refIterTable = pTables[i];
          if (refIterTable.equals(referencedTable)) {
            referencedTable.setTable(refIterTable.getTable());
            break;
          }
        }
        if (referencedTable.getTable() == null) {
          logger.finest(mName, "Unknown table, ignoring");
          continue;
        }

        short seq = rs.getShort(9);
        if (seq == 1) {
          foreignKey = pTable.getTable().newForeignKey(referencedTable.getTable());
          result.add(foreignKey);
        }
        foreignKey.addColumnLink(localColumnName, referencedColumnName);
      }

      isRsClosed = true;
      rs.close();
    } finally {
View Full Code Here
227
228
229
230
231
232
233
234
235
236
237
238
  private Set propertyNames = new HashSet();
  private boolean generatingLogging;
 
  private boolean isReferencing(Table pReferencingTable, Table pReferencedTable) {
    for (Iterator iter = pReferencingTable.getForeignKeys();  iter.hasNext();  ) {
      ForeignKey foreignKey = (ForeignKey) iter.next();
      if (foreignKey.getReferencedTable().equals(pReferencedTable)) {
        return true;
      }
    }
    return false;
  }
View Full Code Here
411
412
413
414
415
416
417
418
419
420
421
422
    if (pUpdater != null) {
      tableInfo.add(pUpdater);
    }
   
    for (Iterator iter = pTable.getForeignKeys();  iter.hasNext();  ) {
      ForeignKey foreignKey = (ForeignKey) iter.next();
      Table referencedTable = foreignKey.getReferencedTable();
      for (Iterator iter2 = tablesByOrder.iterator();  iter2.hasNext();  ) {
        TableInfo referencedTableInfo = (TableInfo) iter2.next();
        if (referencedTableInfo.getTable().equals(referencedTable)) {
          ColumnUpdater columnUpdater = new ForeignKeyUpdater(foreignKey, referencedTableInfo);
          tableInfo.add(columnUpdater);
View Full Code Here
872
873
874
875
876
877
878
879
880
881
882
883
    LocalJavaField referencedValues = null;
    for (Iterator referencingIter = tablesByOrder.iterator();  referencingIter.hasNext();  ) {
      TableInfo prevTableInfo = (TableInfo) referencingIter.next();
      Table prevTable = prevTableInfo.getTable();
      for (Iterator fkIter = prevTable.getForeignKeys();  fkIter.hasNext();  ) {
        ForeignKey fk = (ForeignKey) fkIter.next();
        if (fk.getReferencedTable().equals(table)) {
          if (referencedValues == null) {
            referencedValues = jm.newJavaField(Object[].class);
            referencedValues.addLine(baseKey, ".getValues()");
          }
          getSelectRowsCode(jm, prevTableInfo, fk, connection, map, referencedValues, false);
View Full Code Here
143
144
145
146
147
148
149
150
151
     Column referenceColumn = otherTable.newColumn("RefIndex", Column.Type.INTEGER);
     Column companyColumn = otherTable.newColumn("Company", Column.Type.VARCHAR);
     ((StringColumn) companyColumn).setLength(60);
     otherTable.newPrimaryKey().addColumn(otherIndex);

     ForeignKey reference = otherTable.newForeignKey(pTable);
     reference.addColumnLink(referenceColumn, pTable.getColumn("MyIndex"));
     return otherTable;
  }
View Full Code Here
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
    Table table = getComposedKeyTable();

    Table otherTable = table.getSchema().newTable("OtherTable");
    Column otherIndex = otherTable.newColumn("MyIndex", Column.Type.INTEGER);
    otherTable.newPrimaryKey().addColumn(otherIndex);
    ForeignKey foreignKey = otherTable.newForeignKey(table);
    SelectStatement selectStatement = sqlFactory.newSelectStatement();
    selectStatement.setTable(otherTable);
    DeleteStatement deleteStatement = sqlFactory.newDeleteStatement();
    deleteStatement.setTable(table);
    List columns = new ArrayList();
    for (Iterator iter = table.getColumns();  iter.hasNext();  ) {
      Column column = (Column) iter.next();
      Column refColumn = otherTable.newColumn("Ref" + column.getName(), column.getType());
      foreignKey.addColumnLink(refColumn, column);
      if (column.isPrimaryKeyPart()) {
        selectStatement.addResultColumn(selectStatement.getTableReference().newColumnReference(refColumn));
        columns.add(deleteStatement.getTableReference().newColumnReference(column));
      }
    }
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
157
158
      stEmail.setNullable(true);
     
      Index primaryKey = st.newPrimaryKey();
      primaryKey.addColumn(stId);
     
      ForeignKey foreignKey = st.newForeignKey(getMainTable());
      foreignKey.addColumnLink(stMtId, getMainTable().getColumn("ID"));
      foreignKey.addColumnLink(stMtVer, getMainTable().getColumn("VER"));
     
      subTable = st;
    }
    return subTable;
  }
View Full Code Here
TOP

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

  • org.apache.ws.jaxme.js.junit.VersionTest
  • org.apache.ws.jaxme.js.pattern.VersionGenerator
  • org.apache.ws.jaxme.sqls.impl.SQLFactoryImpl
  • org.apache.ws.jaxme.sqls.impl.SQLGeneratorImpl
  • org.apache.ws.jaxme.sqls.impl.TableImpl
  • org.apache.ws.jaxme.sqls.junit.CreateTest
    • 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.