Examples of ManualSqlStatement

org.jitterbit.integration.database.info.ManualSqlStatement
DatabaseObject representing a manual SQL statement entered by the user. @author Torgil Zethson @since 3.1.0

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

        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

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

        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

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


    @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

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

        return structure;
    }


    private DatabaseObject[] getDatabaseObjectsFromStructure(DatabaseStructure dbStruct) {
        if (dbStruct.hasManualSqlStatement()) {
            return new DatabaseObject[] { new ManualSqlStatement(dbStruct.getManualSqlStatement()) };
        }
        return dbStruct.getDatabaseObjects();
    }

View Full Code Here

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

            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

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.