Package org.apache.oodt.xmlps.mapping

Examples of org.apache.oodt.xmlps.mapping.DatabaseTable

157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
        if (mapping.getNumTables() > 0) {
            for (Iterator<String> i = mapping.getTableNames().iterator(); i
                    .hasNext();) {
                String tableName = i.next();
                DatabaseTable tbl = mapping.getTableByName(tableName);
                sqlBuf.append("INNER JOIN ");
                sqlBuf.append(tbl.getName());
                sqlBuf.append(" ON ");
                sqlBuf.append(tbl.getName());
                sqlBuf.append(".");
                sqlBuf.append(tbl.getJoinFieldName());
                sqlBuf.append(" = ");
                sqlBuf.append((tbl.getDefaultTableJoin() != null && !tbl
                        .getDefaultTableJoin().equals("")) ? tbl
                        .getDefaultTableJoin() : mapping.getDefaultTable());
                sqlBuf.append(".");
                sqlBuf.append(tbl.getDefaultTableJoinFieldName());
                sqlBuf.append(" ");
            }
        }

        if (parsedQuery != null) {
View Full Code Here
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
        if (mapping.getNumTables() > 0) {
            for (Iterator<String> i = mapping.getTableNames().iterator(); i
                    .hasNext();) {
                String tableName = i.next();
                DatabaseTable tbl = mapping.getTableByName(tableName);
                sqlBuf.append("INNER JOIN ");
                sqlBuf.append(tbl.getName());
                sqlBuf.append(" ON ");
                sqlBuf.append(tbl.getName());
                sqlBuf.append(".");
                sqlBuf.append(tbl.getJoinFieldName());
                sqlBuf.append(" = ");
                sqlBuf.append((tbl.getDefaultTableJoin() != null &&
                        !tbl.getDefaultTableJoin().equals("")) ? tbl
                        .getDefaultTableJoin() : mapping.getDefaultTable());
                sqlBuf.append(".");
                sqlBuf.append(tbl.getDefaultTableJoinFieldName());
                sqlBuf.append(" ");
            }
        }

        if(parsedQuery != null){
View Full Code Here
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
        // add tables from where element set
        if (whereElemNames != null) {
            for (QueryElement qe : whereElemNames) {
                MappingField fld = mapping.getFieldByLocalName(qe.getValue());
                if (fld != null) {
                    DatabaseTable t = mapping.getTableByName(fld.getTableName());
                    if (t != null && !tables.contains(t) && !t.getName().equals(mapping.getDefaultTable())) {
                        tables.add(t);
                    }
                }
            }
        }
        // add tables from select element set
        if (selectElemNames != null) {
            for (QueryElement qe : selectElemNames) {
                MappingField fld = mapping.getFieldByLocalName(qe.getValue());
                if (fld != null) {
                    DatabaseTable t = mapping.getTableByName(fld.getTableName());
                    if (t != null && !tables.contains(t) && !t.getName().equals(mapping.getDefaultTable())) {
                        tables.add(t);
                    }
                }
            }
        }
        // the tables found may be joined on columns from tables we haven't found
        // yet
        // add additional required join tables
        Set<DatabaseTable> moreTables = new HashSet<DatabaseTable>(tables);
        for (DatabaseTable t : tables) {
            DatabaseTable join = mapping.getTableByName(t.getDefaultTableJoin());
            // recursively add all join tables until we get to either
            // (a) the mapping default table (join == null)
            // (b) or a table already found (moreTables.contains(join))
            while (join != null && !moreTables.contains(join) && !join.getName().equals(mapping.getDefaultTable())) {
                moreTables.add(join);
                join = mapping.getTableByName(join.getDefaultTableJoin());
            }
        }
        return moreTables;
    }
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
        if (mapping.getNumTables() > 0) {
            for (Iterator<String> i = mapping.getTableNames().iterator(); i
                    .hasNext();) {
                String tableName = i.next();
                if(tableName.equals(mapping.getDefaultTable())) continue;
                DatabaseTable tbl = mapping.getTableByName(tableName);
                sqlBuf.append("INNER JOIN ");
                sqlBuf.append(tbl.getName());
                sqlBuf.append(" ON ");
                sqlBuf.append(tbl.getName());
                sqlBuf.append(".");
                sqlBuf.append(tbl.getJoinFieldName());
                sqlBuf.append(" = ");
                sqlBuf.append(tbl.getDefaultTableJoin());
                sqlBuf.append(".");
                sqlBuf.append(tbl.getDefaultTableJoinFieldName());
                sqlBuf.append(" ");
            }
        }

        if (parsedQuery != null) {
View Full Code Here
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
        if (mapping.getNumTables() > 0) {
            for (Iterator<String> i = mapping.getTableNames().iterator(); i
                    .hasNext();) {
                String tableName = i.next();
                DatabaseTable tbl = mapping.getTableByName(tableName);
                sqlBuf.append("INNER JOIN ");
                sqlBuf.append(tbl.getName());
                sqlBuf.append(" ON ");
                sqlBuf.append(tbl.getName());
                sqlBuf.append(".");
                sqlBuf.append(tbl.getJoinFieldName());
                sqlBuf.append(" = ");
                sqlBuf.append(tbl.getDefaultTableJoin());
                sqlBuf.append(".");
                sqlBuf.append(tbl.getDefaultTableJoinFieldName());
                sqlBuf.append(" ");
            }
        }

        if (parsedQuery != null) {
View Full Code Here
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
        // add tables from where element set
        if (whereElemNames != null) {
            for (QueryElement qe : whereElemNames) {
                MappingField fld = mapping.getFieldByLocalName(qe.getValue());
                if (fld != null) {
                    DatabaseTable t = mapping.getTableByName(fld.getTableName());
                    if (t != null && !tables.contains(t)) {
                        tables.add(t);
                    }
                }
            }
        }
        // add tables from select element set
        if (selectElemNames != null) {
            for (QueryElement qe : selectElemNames) {
                MappingField fld = mapping.getFieldByLocalName(qe.getValue());
                if (fld != null) {
                    DatabaseTable t = mapping.getTableByName(fld.getTableName());
                    if (t != null && !tables.contains(t)) {
                        tables.add(t);
                    }
                }
            }
        }
        // the tables found may be joined on columns from tables we haven't found
        // yet
        // add additional required join tables
        Set<DatabaseTable> moreTables = new HashSet<DatabaseTable>(tables);
        for (DatabaseTable t : tables) {
            DatabaseTable join = mapping.getTableByName(t.getDefaultTableJoin());
            // recursively add all join tables until we get to either
            // (a) the mapping default table (join == null)
            // (b) or a table already found (moreTables.contains(join))
            while (join != null && !moreTables.contains(join)) {
                moreTables.add(join);
                join = mapping.getTableByName(join.getDefaultTableJoin());
            }
        }
        return moreTables;
    }
View Full Code Here
TOP

Related Classes of org.apache.oodt.xmlps.mapping.DatabaseTable

  • org.apache.oodt.xmlps.product.XMLPSProductHandler
  • org.apache.oodt.xmlps.profile.XMLPSProfileHandler
    • 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.