Examples of DbFields

org.jitterbit.integration.data.structure.database.DbFields
Class that represents the information in DBFieldsTab in TRANDB. This class describes the update keys in a database source or target as used by a Transformation.
There are three different kinds of fields:
- A list of the table columns that will be used as keys when doing an DIFF on a source table;
- A list of column-value pairs with the values that will be used to update the source table;
- A list of the table columns that will be used as keys when doing an update on a target table.
The class is modeled after the structure of DBFieldsTab. @see org.jitterbit.integration.data.structure.database.DbTables @see org.jitterbit.integration.data.structure.database.DbTranRelations @see org.jitterbit.integration.data.entity.Transformation @author Torgil Zethson

Examples of org.jitterbit.integration.data.structure.database.DbFields

        }
        dbStruct.setHierarchicalFilters(copiedFilters);
    }


    private void processDbFields() {
        DbFields original = dbStruct.getDbFields();
        DbFields copy = new DbFields();
        for (DbFields.Entry e : original.getAllEntries()) {
            if (e.getType() == DbFields.UPDATE_KEYS) {
                List<DatabaseColumn> updateKeys = Lists.newArrayList();
                for (String part : e.getKeyFields().split(DbFields.FIELD_SEPARATOR)) {
                    int sep = part.lastIndexOf('.');
                    String tableName = part.substring(0, sep);
                    String columnName = part.substring(sep + 1);
                    DatabaseObject table = translatedObjects.get(tableName);
                    if (table != null) {
                        DatabaseColumn column = table.findColumn(columnName);
                        if (column != null) {
                            updateKeys.add(column);
                        }
                    }
                }
                copy.addUpdateKeys(updateKeys);
            } else {
                // TODO: Implement me
            }
        }
        dbStruct.setDbFields(copy);

View Full Code Here

Examples of org.jitterbit.integration.data.structure.database.DbFields

                }
            }
        }


        public void setValues(DatabaseStructure struct, DatabaseObject obj) {
            DbFields fields = struct.getDbFields();
            Map<DatabaseColumn, String> updateValues = Maps.newHashMap();
            for (UpdateValue uv : fields.getUpdateValues(obj)) {
                updateValues.put(uv.getColumn(), uv.getValue());
            }
            for (int row = 0; row < getRowCount(); ++row) {
                DatabaseColumn col = getRowObjectAt(row);
                String value = updateValues.get(col);

View Full Code Here

Examples of org.jitterbit.integration.data.structure.database.DbFields

        return ui.getInsertMode();
    }


    @Override
    public void applyTo(DatabaseStructure s) {
        DbFields fields = ui.createDbFields();
        s.setDbFields(fields);
        s.setTruncateTargetFields(ui.isAutoTruncatingFields());
    }

View Full Code Here

Examples of org.jitterbit.integration.data.structure.database.DbFields

        setCanContinue(true);
    }


    @Override
    public void applyTo(DatabaseStructure s) {
        DbFields fields = new DbFields();
        Collection<DatabaseColumn> keys = ui.getSelectedColumns();
        fields.addUpdateKeys(keys);
        s.setDbFields(fields);
        if (keys.isEmpty()) {
            fields.removeEntry(DbFields.SOURCE_UPDATE_VALUES);
        }
    }

View Full Code Here

Examples of org.jitterbit.integration.data.structure.database.DbFields

            Object value = getValueAt(row, 2);
            return Boolean.TRUE.equals(value);
        }


        public void setSelectedColumns(DatabaseStructure struct, DatabaseObject obj) {
            DbFields fields = struct.getDbFields();
            Set<DatabaseColumn> keys = Sets.newHashSet(fields.getUpdateKeys(obj));
            for (int row = 0; row < getRowCount(); ++row) {
                DatabaseColumn col = getRowObjectAt(row);
                boolean selected = keys.contains(col);
                setValueAt(selected, row, 2);
            }

View Full Code Here

Examples of org.jitterbit.integration.data.structure.database.DbFields

        return null;
    }


    @Override
    public void applyTo(DatabaseStructure s) {
        DbFields dbFields = s.getDbFields();
        addFieldInformation(dbFields);
        if (primaryKeys != null) {
            dbFields.addUpdateKeys(primaryKeys);
        } else {
            dbFields.addUpdateKeys(dbObject.getPrimaryKeys());
        }
        s.setDbFields(dbFields);
    }

View Full Code Here

Examples of org.jitterbit.integration.data.structure.database.DbFields

    public PrimaryKeys[] getSelectedKeys() {
        return primaryKeyDefiner.getPrimaryKeys();
    }


    public DbFields createDbFields() {
        DbFields dbFields = new DbFields();
        dbFields.addUpdateKeys(getSelectedKeyColumns());
        return dbFields;
    }

View Full Code Here

Examples of org.jitterbit.integration.data.structure.database.DbFields

        s.setDatabaseObjectsUsage(usage);
        SqlScript script = new SqlScript();
        script.setManualSqlStatement(statementDetails.getName());
        s.setSqlScript(script);
        s.setDbTables(new DbTables());
        s.setDbFields(new DbFields());
        s.setHierarchicalFilters(new DbTranFilters());
        s.setRelations(new DbTranRelations());
    }

View Full Code Here

Examples of org.jitterbit.integration.data.structure.database.DbFields

        String[] fields = dbTables.getColumnValues(sTranId, bIsSource);
        m_updatedDbTables.add(getInterchangeDataRow(fields));
    }


    private void addDbFields(DatabaseStructure dbStructure, String sTranId) {
        DbFields dbFields = dbStructure.getDbFields();
        DbFields.Entry[] entries = dbFields.getAllEntries();
        for (DbFields.Entry entry : entries) {
            String[] fields = entry.getColumnValues(sTranId);
            m_updatedDbFields.add(getInterchangeDataRow(fields));
        }
    }

View Full Code Here

Examples of org.jitterbit.integration.data.structure.database.DbFields

          }
          DatabaseObject[] rawObjectsFromStructure=getDatabaseObjectsFromStructure(dbStruct);
            boolean bOldVersion=(rawObjectsFromStructure.length == 0);
          if(bOldVersion){
              log("Old-style version - it has either been downloaded from a server, or was created in an earlier version.");
            DbFields dbf=dbStruct.getDbFields();
          Entry entry=dbf.getEntry(DbFields.UPDATE_KEYS);
          if(entry!=null){
            String str=entry.getKeyFields();
            StringTokenizer tk=new StringTokenizer(str,",", false);
            while(tk.hasMoreTokens()){
              String token=tk.nextToken();

View Full Code Here

0 1

TOP

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.