Package org.jitterbit.integration.data.structure.database

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

52
53
54
55
56
57
58
59
60
61
62
63
        }
        layoutComponents();
    }

    private static String getSqlStatement(DatabaseStructure dbStruct) {
        SqlScript script = dbStruct.getSqlScript();
        String sql = script.getManualSqlStatement();
        if (sql == null) {
            sql = script.getConstructedSqlStatement();
        }
        return sql;
    }
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
96
            throw new RuntimeException("The SQL statement has not been tested. This is a bug.");
        }
        Map<DatabaseObject, Integer> usage = Maps.newHashMap();
        usage.put(statementDetails, 1);
        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
102
103
104
105
106
107
108
109
110
111
        return page;
    }

    @Override
    public void applyTo(DatabaseStructure s) {
        SqlScript sql = new SqlScript();
        sql.setPrimaryKeysEntry(incomingObject);
        sql.setSqlStatement(incomingObject, dbLocation.getBeginEndQuote(), ui.getWhereClause());
        s.setSqlScript(sql);
    }
View Full Code Here
114
115
116
117
118
119
120
121
122
123
    public void setStructureToEdit(StructureToEdit toEdit) {
        // If the user has selected another object than the original one when editing the
        // structure, we do not do anything:
        DatabaseObject o = getObjectToEdit(toEdit);
        if (o != null) {
            SqlScript sql = toEdit.getStructure().getSqlScript();
            ui.setWhereClause(sql.getWhereClause());
            ui.setBeginEndQuotes(toEdit.getStructure().getBeginEndQuote());
        }
    }
View Full Code Here
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
        }
    }

    // Only for source.
    private void addSqlScript(DatabaseStructure dbStructure, String sTranId) {
        SqlScript sqlScript = dbStructure.getSqlScript();
        SqlScript.Entry[] entries = sqlScript.getAllEntries();
        for (SqlScript.Entry entry : entries) {
            String[] fields = entry.getColumnValues(sTranId);
            m_updatedSqlScript.add(getInterchangeDataRow(fields));
        }
    }
View Full Code Here
693
694
695
696
697
698
699
700
701
702
703
704
        }

        addFilterToCrom(root, filter_map, order_map);

        if (dbStruct.getRelations().getRelations().size() == 0 && tableNames.size() == 1) {
            SqlScript sql_script=dbStruct.getSqlScript();
            String sqlFilter = sql_script.getWhereClause();
            if(StringUtils.isNotEmpty(sqlFilter)){
                CROM table=root.getChild(0);
                if(table!=null){
                    String ORDER_BY="ORDER BY ";
                    int k=sqlFilter.indexOf(ORDER_BY);
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
56
        DatabaseObject[] objects = info.getDatabaseObjects();
        switch (objects.length) {
        case 0:
            return null;
        case 1:
            SqlScript existingScript = structure.getSqlScript();
            String existingWhereClause = (existingScript == null) ? "" :
                            existingScript.getWhereClause();
            BeginEndQuote quotes = structure.getBeginEndQuote();
            return new SingleTableEditorUi(objects[0], existingWhereClause, quotes);
        default:
            DbTranFilters filters = structure.getHierarchicalFilters();
            return new MultipleTableEditorUi(objects, filters);
View Full Code Here
85
86
87
88
89
90
91
92
93
94
        @Override
        public void applyTo(Transformation tf) {
            DataStructure struct = tf.getInputStructure();
            if (struct instanceof DatabaseStructure) {
                DatabaseStructure dbStruct = (DatabaseStructure) struct;
                SqlScript script = dbStruct.getSqlScript();
                script.updateWhereClause(ui.getWhereClause());
                dbStruct.setSqlScript(script);
            }
        }
View Full Code Here
347
348
349
350
351
352
353
354
355
356
357
358
359
360
     * A copy will be created of the <code>sqlScript</code> argument and stored in this object.
     * This means that modifying <code>sqlScript</code> after this method has been called will not
     * affect the data that is stored internally in this object.
     */
    public void setSqlScript(SqlScript newScript) {
        SqlScript old;
        synchronized (getDataLock()) {
            old = this.sqlScript;
            this.sqlScript = (newScript == null) ? new SqlScript() : newScript.getCopy();
        }
        if (differs(old, newScript)) {
            firePropertyChange(SQL_SCRIPT, old, newScript);
        }
    }
View Full Code Here
TOP

Related Classes of org.jitterbit.integration.data.structure.database.SqlScript

  • org.jitterbit.integration.client.mapping.db.DatabaseStructureMappingTreeConverter
  • org.jitterbit.integration.client.ui.interchange.entity.transformation.data.db.FlatStructureFilterDefiner
  • org.jitterbit.integration.client.ui.interchange.entity.transformation.database.WhereClauseEditorUiFactory
  • org.jitterbit.integration.client.ui.interchange.entity.transformation.database.WhereClauseEditorUiFactory$SingleTableEditorUi
  • org.jitterbit.integration.client.ui.structure.editor.db.ManualSqlStatementPage
  • org.jitterbit.integration.client.ui.structure.editor.db.SingleTableWhereClausePage
  • org.jitterbit.integration.data.structure.DatabaseStructure
  • org.jitterbit.integration.server.implementation.webservice.interchange.deploy.impl.DeployInterchangeModelWsImplWrapper
    • 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.