use of eu.esdihumboldt.hale.common.core.io.impl.LogProgressIndicator in project hale by halestudio.
the class MsSQLServer14Test 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.impl.LogProgressIndicator 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.impl.LogProgressIndicator 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();
}
use of eu.esdihumboldt.hale.common.core.io.impl.LogProgressIndicator in project hale by halestudio.
the class AppSchemaFileWriterTest method loadTestProject.
@BeforeClass
public static void loadTestProject() {
try {
URL archiveLocation = AppSchemaFileWriterTest.class.getResource(PROJECT_LOCATION);
ArchiveProjectReader projectReader = new ArchiveProjectReader();
projectReader.setSource(new DefaultInputSupplier(archiveLocation.toURI()));
IOReport report = projectReader.execute(new LogProgressIndicator());
if (!report.isSuccess()) {
throw new RuntimeException("project reader execution failed");
}
tempDir = projectReader.getTemporaryFiles().iterator().next();
project = projectReader.getProject();
assertNotNull(project);
sourceSchemaSpace = new DefaultSchemaSpace();
targetSchemaSpace = new DefaultSchemaSpace();
// load schemas
List<IOConfiguration> resources = project.getResources();
for (IOConfiguration resource : resources) {
String actionId = resource.getActionId();
String providerId = resource.getProviderId();
// get provider
IOProvider provider = null;
IOProviderDescriptor descriptor = IOProviderExtension.getInstance().getFactory(providerId);
if (descriptor == null) {
throw new RuntimeException("Could not load I/O provider with ID: " + resource.getProviderId());
}
provider = descriptor.createExtensionObject();
provider.loadConfiguration(resource.getProviderConfiguration());
prepareProvider(provider, project, tempDir.toURI());
IOReport providerReport = provider.execute(new LogProgressIndicator());
if (!providerReport.isSuccess()) {
throw new RuntimeException("I/O provider execution failed");
}
// TODO: could (should?) be done by an advisor
if (provider instanceof SchemaReader) {
Schema schema = ((SchemaReader) provider).getSchema();
if (actionId.equals(SchemaIO.ACTION_LOAD_SOURCE_SCHEMA)) {
sourceSchemaSpace.addSchema(schema);
} else if (actionId.equals(SchemaIO.ACTION_LOAD_TARGET_SCHEMA)) {
targetSchemaSpace.addSchema(schema);
}
}
}
// load alignment
List<ProjectFileInfo> projectFiles = project.getProjectFiles();
for (ProjectFileInfo projectFile : projectFiles) {
if (projectFile.getName().equals(AlignmentIO.PROJECT_FILE_ALIGNMENT)) {
AlignmentReader alignReader = new JaxbAlignmentReader();
alignReader.setSource(new DefaultInputSupplier(projectFile.getLocation()));
alignReader.setSourceSchema(sourceSchemaSpace);
alignReader.setTargetSchema(targetSchemaSpace);
alignReader.setPathUpdater(new PathUpdate(null, null));
IOReport alignReport = alignReader.execute(new LogProgressIndicator());
if (!alignReport.isSuccess()) {
throw new RuntimeException("alignment reader execution failed");
}
alignment = alignReader.getAlignment();
assertNotNull(alignment);
break;
}
}
} catch (Exception e) {
log.error("Exception occurred", e);
fail("Test project could not be loaded: " + e.getMessage());
}
}
use of eu.esdihumboldt.hale.common.core.io.impl.LogProgressIndicator in project hale by halestudio.
the class AppSchemaIsolatedWorkspacesMappingTest method loadAlignment.
private static Alignment loadAlignment(AlignmentReader alignReader, String resource) throws Exception {
alignReader.setSource(new DefaultInputSupplier(AppSchemaIsolatedWorkspacesMappingTest.class.getResource(resource).toURI()));
alignReader.setSourceSchema(sourceSchemaSpace);
alignReader.setTargetSchema(targetSchemaSpace);
alignReader.setPathUpdater(new PathUpdate(null, null));
IOReport report = alignReader.execute(new LogProgressIndicator());
assertTrue(report.isSuccess());
assertTrue("Errors are contained in the report", report.getErrors().isEmpty());
return alignReader.getAlignment();
}
Aggregations