use of eu.esdihumboldt.hale.common.core.io.supplier.NoStreamInputSupplier in project hale by halestudio.
the class MsSqlDataReaderTest method readSchema.
/**
* Reads a schema from a MS SQL database.
*
* @return the schema
* @throws Exception any exception thrown by {@link JDBCSchemaReader}
*/
private Schema readSchema() throws Exception {
JDBCSchemaReader schemaReader = new JDBCSchemaReader();
JDBCURI = new MsSqlURIBuilder().createJdbcUri(HOST, DATABASE);
schemaReader.setSource(new NoStreamInputSupplier(JDBCURI));
schemaReader.setParameter(JDBCSchemaReader.PARAM_USER, Value.of(USER_NAME));
schemaReader.setParameter(JDBCSchemaReader.PARAM_PASSWORD, Value.of(PASSWORD));
// This is set for setting inclusion rule for reading schema
schemaReader.setParameter(JDBCSchemaReader.SCHEMAS, Value.of(SCHEMA));
IOReport report = schemaReader.execute(new LogProgressIndicator());
assertTrue(report.isSuccess());
assertTrue(report.getErrors().isEmpty());
Schema schema = schemaReader.getSchema();
assertNotNull(schema);
return schema;
}
use of eu.esdihumboldt.hale.common.core.io.supplier.NoStreamInputSupplier in project hale by halestudio.
the class MsSqlDataReaderTest method readInstances.
/**
* Reads instances from from a MsAccess database file with the provided
* schema.
*
* @param sourceSchema the schema of the source database
* @return the read instances
* @throws Exception any exception thrown by {@link JDBCInstanceReader}
*/
private InstanceCollection readInstances(Schema sourceSchema) throws Exception {
JDBCInstanceReader instanceReader = new JDBCInstanceReader();
JDBCURI = new MsSqlURIBuilder().createJdbcUri(HOST, DATABASE);
instanceReader.setSource(new NoStreamInputSupplier(JDBCURI));
instanceReader.setSourceSchema(sourceSchema);
instanceReader.setParameter(JDBCInstanceReader.PARAM_USER, Value.of(USER_NAME));
instanceReader.setParameter(JDBCInstanceReader.PARAM_PASSWORD, Value.of(PASSWORD));
// Test instances
IOReport report = instanceReader.execute(new LogProgressIndicator());
assertTrue("Data import was not successfull.", report.isSuccess());
return instanceReader.getInstances();
}
Aggregations