public static StringProperty newString(String name, String initialValue) { StringProperty property = newString(name); property.setValue(initialValue); return property; }
/** * {@inheritDoc} */ @Override public void setupProperties() { super.setupProperties(); hostUrl.setValue(INITIAL_HOST); }
/** * {@inheritDoc} */ @Override public void setupProperties() { super.setupProperties(); hostUrl.setValue(INITIAL_HOST); }
public static StringProperty newString(String name, String initialValue, String defaultValue) { StringProperty property = newString(name); property.setValue(initialValue); property.setDefaultValue(defaultValue); return property; }
public void afterSourceType() throws IOException { // refresh the module list retrieveModules(); moduleName.setValue(null); selectColumnIds.setValue(null); query.setValue(null); refreshLayout(getForm(Form.MAIN)); }
@Override public void setupProperties() { super.setupProperties(); host.setRequired(); host.setValue("127.0.0.1"); port.setRequired(); port.setValue(8000); database.setRequired(); database.setValue("Documents"); username.setRequired(); password.setRequired(); authentication.setPossibleValues("DIGEST", "BASIC"); authentication.setValue("DIGEST"); }
public void afterSourceType() throws IOException { // refresh the module list retrieveModules(); moduleName.setValue(null); selectColumnIds.setValue(null); query.setValue(null); refreshLayout(getForm(Form.MAIN)); }
private void setupProperties() { properties = (TJiraInputProperties) componentService.getComponentProperties(TJiraInputDefinition.COMPONENT_NAME); properties.connection.hostUrl.setValue(HOST_PORT); properties.connection.basicAuthentication.userId.setValue(USER); properties.connection.basicAuthentication.password.setValue(PASS); }
private void setupProperties() { properties = (TJiraInputProperties) componentService.getComponentProperties(TJiraInputDefinition.COMPONENT_NAME); properties.connection.hostUrl.setValue(INCORRECT_HOST_PORT); properties.connection.basicAuthentication.userId.setValue(USER); properties.connection.basicAuthentication.password.setValue(PASS); }
/** * Checks {@link JiraSourceOrSink#validate(RuntimeContainer)} returns {@link ValidationResult.Result#ERROR} and * {@link ValidationResult} contains correct message in case of connection wasn't established */ @Test public void testValidateError() { JiraSourceOrSink sourceOrSink = new JiraSourceOrSink(); outputProperties.connection.hostUrl.setValue(INCORRECT_HOST_PORT); sourceOrSink.initialize(null, outputProperties); ValidationResult result = sourceOrSink.validate(null); Result actualStatus = result.getStatus(); String actualMessage = result.getMessage(); assertEquals(Result.ERROR, actualStatus); assertThat(actualMessage, containsString("Host validation failed for URL: " + INCORRECT_HOST_PORT)); assertThat(actualMessage, containsString("Exception during connection: ")); }
public ValidationResult afterFormFinishMain(Repository<Properties> repo) throws Exception { ValidationResult vr = SalesforceSourceOrSink.validateConnection(this); if (vr.getStatus() != ValidationResult.Result.OK) { return vr; } String connRepLocation = repo.storeProperties(connection, connection.name.getValue(), repositoryLocation, null); for (NamedThing nl : selectedModuleNames.getValue()) { String moduleId = nl.getName(); SalesforceModuleProperties modProps = new SalesforceModuleProperties(moduleId); modProps.connection = connection; modProps.init(); Schema schema = SalesforceSourceOrSink.getSchema(null, this, moduleId); modProps.moduleName.setValue(moduleId); modProps.main.schema.setValue(schema); repo.storeProperties(modProps, nl.getName(), connRepLocation, "main.schema"); } return ValidationResult.OK; }
public ValidationResult afterFormFinishMain(Repository<Properties> repo) throws Exception { ValidationResult vr = SnowflakeSourceOrSink.validateConnection(this); if (vr.getStatus() != ValidationResult.Result.OK) { return vr; } String connRepLocation = repo.storeProperties(connection, connection.name.getValue(), repositoryLocation, null); for (NamedThing nl : selectedTableNames.getValue()) { String tableId = nl.getName(); SnowflakeTableProperties tableProps = new SnowflakeTableProperties(tableId); tableProps.connection = connection; tableProps.init(); Schema schema = SnowflakeSourceOrSink.getSchema(null, this, tableId); tableProps.tableName.setValue(tableId); tableProps.main.schema.setValue(schema); repo.storeProperties(tableProps, nl.getName(), connRepLocation, "main.schema"); } return ValidationResult.OK; }
/** * Checks {@link JiraSourceOrSink#validate(RuntimeContainer)} returns {@link ValidationResult.Result#ERROR} and * {@link ValidationResult} contains correct message in case of connection was established, but there is no such resource * on server */ @Test public void testValidateWrongStatus() { String expectedMessage = "Host validation failed for URL: " + HOST_PORT + "notFoundPage" + System.lineSeparator() + "Connection is established, but status code is 404"; JiraSourceOrSink sourceOrSink = new JiraSourceOrSink(); outputProperties.connection.hostUrl.setValue(HOST_PORT + "notFoundPage"); sourceOrSink.initialize(null, outputProperties); ValidationResult result = sourceOrSink.validate(null); Result actualStatus = result.getStatus(); String actualMessage = result.getMessage(); assertEquals(Result.ERROR, actualStatus); assertEquals(expectedMessage, actualMessage); }
@Test public void testGetSchemaNames() throws Exception { TJDBCInputDefinition definition = new TJDBCInputDefinition(); TJDBCInputProperties properties = DBTestUtils.createCommonJDBCInputProperties(allSetting, definition); properties.main.schema.setValue(DBTestUtils.createTestSchema(tablename)); properties.tableSelection.tablename.setValue(tablename); properties.sql.setValue(DBTestUtils.getSQL(tablename)); JDBCSource source = DBTestUtils.createCommonJDBCSource(properties); List<NamedThing> schemaNames = source.getSchemaNames(null); assertTrue(schemaNames != null); assertTrue(!schemaNames.isEmpty()); boolean exists = false; for (NamedThing name : schemaNames) { if (tablename.equals(name.getName().toUpperCase())) { exists = true; break; } } assertTrue(exists); }
@SuppressWarnings("rawtypes") @Test public void test_basic_as_output() throws Exception { TJDBCRowDefinition definition = new TJDBCRowDefinition(); TJDBCRowProperties properties = DBTestUtils.createCommonJDBCRowProperties(allSetting, definition); Schema schema = DBTestUtils.createTestSchema(tablename); properties.main.schema.setValue(schema); properties.updateOutputSchemas(); properties.tableSelection.tablename.setValue(tablename); properties.sql.setValue("insert into " + tablename + " values(?,?)"); properties.dieOnError.setValue(true); randomCommit(properties); properties.usePreparedStatement.setValue(true); properties.preparedStatementTable.indexs.setValue(Arrays.asList(1, 2)); properties.preparedStatementTable.types .setValue(Arrays.asList(PreparedStatementTable.Type.Int.name(), PreparedStatementTable.Type.String.name())); properties.preparedStatementTable.values.setValue(Arrays.<Object> asList(4, "momo")); commonAssert(properties, schema); }
private SerPropertiesDto createDatasetDatastoreSerPropertiesDto() { FullExampleDatastoreProperties datastoreProperties = new FullExampleDatastoreProperties("foo"); datastoreProperties.init(); datastoreProperties.tag.setValue("DERBY"); FullExampleDatasetProperties datasetProperties = new FullExampleDatasetProperties("bar"); datasetProperties.init(); datasetProperties.sourceType.setValue(SourceType.SOQL_QUERY); datasetProperties.moduleName.setValue("Account"); datasetProperties.query.setValue("SELECT * FROM users"); SerPropertiesDto serPropertiesDto = new SerPropertiesDto(); serPropertiesDto.setProperties(datasetProperties.toSerialized()); serPropertiesDto.setDependencies(Collections.singletonList(datastoreProperties.toSerialized())); return serPropertiesDto; }
/** * Prepares required instances for tests */ @Before public void setUp() { AvroRegistry registry = new AvroRegistry(); Schema stringSchema = registry.getConverter(String.class).getSchema(); Schema.Field jsonField = new Schema.Field("json", stringSchema, null, null, Order.ASCENDING); schema = Schema.createRecord("jira", null, null, false, Collections.singletonList(jsonField)); schema.addProp(TALEND_IS_LOCKED, "true"); outputProperties = new TJiraOutputProperties("root"); outputProperties.connection.hostUrl.setValue(HOST_PORT); outputProperties.connection.basicAuthentication.userId.setValue("userIdValue"); outputProperties.connection.basicAuthentication.password.setValue("passwordValue"); outputProperties.resource.setValue(Resource.ISSUE); outputProperties.schema.schema.setValue(schema); outputProperties.action.setValue(Action.INSERT); }
/** * Prepares required instances for tests */ @Before public void setUp() { AvroRegistry registry = new AvroRegistry(); Schema stringSchema = registry.getConverter(String.class).getSchema(); Schema.Field jsonField = new Schema.Field("json", stringSchema, null, null, Order.ASCENDING); schema = Schema.createRecord("jira", null, null, false, Collections.singletonList(jsonField)); schema.addProp(TALEND_IS_LOCKED, "true"); outputProperties = new TJiraOutputProperties("root"); outputProperties.connection.hostUrl.setValue("hostValue"); outputProperties.connection.basicAuthentication.userId.setValue("userIdValue"); outputProperties.connection.basicAuthentication.password.setValue("passwordValue"); outputProperties.resource.setValue(Resource.ISSUE); outputProperties.schema.schema.setValue(schema); outputProperties.action.setValue(Action.INSERT); outputProperties.deleteSubtasks.setValue(true); }
@SuppressWarnings("rawtypes") @Test public void test_basic_not_use_prepared_statement_as_output() throws Exception { TJDBCRowDefinition definition = new TJDBCRowDefinition(); TJDBCRowProperties properties = DBTestUtils.createCommonJDBCRowProperties(allSetting, definition); Schema schema = DBTestUtils.createTestSchema(tablename); properties.main.schema.setValue(schema); properties.updateOutputSchemas(); properties.tableSelection.tablename.setValue(tablename); properties.sql.setValue("insert into " + tablename + " values(4,'momo')"); properties.dieOnError.setValue(true); randomCommit(properties); properties.usePreparedStatement.setValue(false); commonAssert(properties, schema); }
@Test public void test_die_on_error_no_connector() throws Exception { TJDBCRowDefinition definition = new TJDBCRowDefinition(); TJDBCRowProperties properties = DBTestUtils.createCommonJDBCRowProperties(allSetting, definition); properties.tableSelection.tablename.setValue(tablename); properties.sql.setValue("insert into " + tablename + " values(4, 'a too long value')"); properties.dieOnError.setValue(true); randomCommit(properties); JDBCRowSourceOrSink sourceOrSink = new JDBCRowSourceOrSink(); sourceOrSink.initialize(null, properties); ValidationResult result = sourceOrSink.validate(null); Assert.assertTrue(result.getStatus() == ValidationResult.Result.ERROR); Assert.assertNotNull(result.getMessage()); }