Package org.jitterbit.integration.database.info

Examples of org.jitterbit.integration.database.info.ManualSqlStatement

36
37
38
39
40
41
42
43
        DatabaseObject table = new DatabaseTable("sourcestab", null);
        test.listColumns(table);
    }

    private static void testManualSqlStatement(DatabaseColumnRetrieverTest test) throws SQLException {
        DatabaseObject table = new ManualSqlStatement("select * from sourcestab where (1=2)");
        test.listColumns(table);
    }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
        assertEquals("prod_1.orders.xsd", generator.getXsdName(table));
    }

    @Test
    public void ensureSimpleManualSqlStatementsAreHandled() {
        ManualSqlStatement sql = new ManualSqlStatement("select order_id, order_date from orders");
        assertEquals("orders.xsd", generator.getXsdName(sql));
        sql = new ManualSqlStatement("select order_id, order_date from orders where order_id is not null");
        assertEquals("orders.xsd", generator.getXsdName(sql));
        sql = new ManualSqlStatement("SELECT order_id, order_date\nFROM orders\nWHERE order_id IS NOT NULL");
        assertEquals("orders.xsd", generator.getXsdName(sql));
        sql = new ManualSqlStatement("SELECT order_id, order_date\nFROM orders\nWHERE order_id IN\n" +
            "(SELECT order_id FROM pending_orders)");
        assertEquals("orders.xsd", generator.getXsdName(sql));
        generator = new XsdNameGenerator("prod", quotes);
        sql = new ManualSqlStatement("select order_id, order_date from orders");
        assertEquals("prod.orders.xsd", generator.getXsdName(sql));
    }
View Full Code Here
64
65
66
67
68
69
70
71
72
    @Override
    protected void runImpl() throws InterruptedException {
        if (isSupportedLocation()) {
            DatabaseInfoProvider provider = DatabaseInfoProviderFactory.createProvider(connectionParams);
            DatabaseObject[] objects = new DatabaseObject[] { new ManualSqlStatement(sql) };
            provider.getTableInfo(connectionParams, sourceId, null, objects, callback);
        }
    }
View Full Code Here
215
216
217
218
219
220
221
222
223
        return structure;
    }

    private DatabaseObject[] getDatabaseObjectsFromStructure(DatabaseStructure dbStruct) {
        if (dbStruct.hasManualSqlStatement()) {
            return new DatabaseObject[] { new ManualSqlStatement(dbStruct.getManualSqlStatement()) };
        }
        return dbStruct.getDatabaseObjects();
    }
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
            table = new DatabaseView(name, schema);
            break;
        case MANUAL_SQL:
            //String manualSql = deResolver.resolve(name);
            String manualSql=name;
            table = new ManualSqlStatement(manualSql);
            break;
        default:
            throw new RuntimeException("Unexpected type of database object: " + type);
        }
        return table;
View Full Code Here
TOP

Related Classes of org.jitterbit.integration.database.info.ManualSqlStatement

  • org.jitterbit.integration.client.connect.db2xml.wizard.XsdNameGeneratorJUnitTest
  • org.jitterbit.integration.client.mapping.db.DatabaseStructureMappingTreeConverter
  • org.jitterbit.integration.client.ui.structure.editor.db.GetManualSqlStatementDetailsJob
  • org.jitterbit.integration.database.info.retriever.DatabaseColumnRetrieverTest
  • org.jitterbit.integration.server.implementation.webservice.interchange.db.DatabaseObjectConverter
  • java.util.regex.Pattern
  • java.util.regex.Matcher
    • 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.