com.orchestranetworks.addon.dex.configuration

Class SQLImportConfigurationSpec

java.lang.Object

com.orchestranetworks.addon.dex.configuration.SQLImportConfigurationSpec

All Implemented Interfaces:

ConfigurationSpec<SQLTable>, ImportConfigurationSpec<SQLTable>

public final class SQLImportConfigurationSpec
extends Object
implements ImportConfigurationSpec<SQLTable>

Defines the configuration used for importing data from an external database.

Since:

2.3.0

Constructor Summary

Constructors

Constructor and Description
SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, JNDIDataSource jndiDataSource, SQLTable sqlTableOrView, com.orchestranetworks.service.Session session) Imports data with JNDIDataSource outside of a UIService.
SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, JNDIDataSource jndiDataSource, SQLTable sqlTableOrView, TableFilter tableFilter, com.orchestranetworks.service.Session session) Imports data with a filter and JNDIDataSource outside of a UIService.
SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, String sqlDataSourceName, SQLTable sqlTableOrView, com.orchestranetworks.service.Session session) Imports data outside of a UIService.
SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, String sqlDataSourceName, SQLTable sqlTableOrView, TableFilter tableFilter, com.orchestranetworks.service.Session session) Imports data from an SQL table with a filter outside of a UIService.

Method Summary

Modifier and Type	Method and Description
com.onwbp.adaptation.Adaptation	getCurrentDataset() Returns the current dataset.
com.onwbp.adaptation.AdaptationTable	getCurrentTable() Returns the current table.
Map<TableMapping,FieldMapperDefinition>	getFieldMapperDefinitions() Returns the map of the FieldMapperDefinition implementations and TableMapping instance as the key parameter.
ImportMode	getImportMode() Returns the specified import mode.
JNDIDataSource	getJNDIDataSource() Returns the specified JNDI data source for SQL import.
String	getSchemaName() Returns the specified schema name.
ServiceType	getServiceType() Returns the service type.
com.orchestranetworks.service.Session	getSession() Returns the current session.
Map<SQLTable,TableFilter>	getSourceTableFilters() Returns a map of table filters and an SQLTable instance as the key parameter.
List<SQLTable>	getSourceTables() Returns the list of source tables.
String	getSQLDataSourceName() Returns the SQL data source name.
String	getTablePattern() Returns the specified table naming pattern.
boolean	isEmptyOrNullPrimaryKeyChecked() Returns true if all empty or null primary keys were checked before data import and false if this verification was not performed.
boolean	isEmptyOrNullValueIgnored() Returns true if all empty or null values are ignored in the process of importing data.
boolean	isImportForced() Returns true if all triggers and constraints are disabled in the process of importing data.
void	setEmptyOrNullPrimaryKeyChecked(boolean emptyOrNullPrimaryKeyChecked) Sets whether all empty or null primary keys were checked before data import and false if this verification was not performed.
void	setEmptyOrNullValueIgnored(boolean emptyOrNullValueIgnored) Sets whether all empty or null values are ignored in the process of importing data.
void	setFieldMapperDefinitions(Map<TableMapping,FieldMapperDefinition> fieldMapperDefinitions) Sets a map of the FieldMapperDefinition implementations and TableMapping instance as the key parameter.
void	setImportForced(boolean importForced) Sets whether all triggers and constraints are disabled in the process of importing data.
void	setImportMode(ImportMode importMode) Sets the import mode.
void	setTablePattern(String tablePattern) Sets a table naming pattern.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLImportConfigurationSpec

public SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable,
                                  String sqlDataSourceName,
                                  SQLTable sqlTableOrView,
                                  com.orchestranetworks.service.Session session)
                           throws DataExchangeException

Imports data outside of a UIService.

Throws:

DataExchangeException

SQLImportConfigurationSpec

public SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable,
                                  JNDIDataSource jndiDataSource,
                                  SQLTable sqlTableOrView,
                                  com.orchestranetworks.service.Session session)
                           throws DataExchangeException

Imports data with JNDIDataSource outside of a UIService.

Throws:

DataExchangeException

Since:

2.5.0

SQLImportConfigurationSpec

public SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable,
                                  String sqlDataSourceName,
                                  SQLTable sqlTableOrView,
                                  TableFilter tableFilter,
                                  com.orchestranetworks.service.Session session)
                           throws DataExchangeException

Imports data from an SQL table with a filter outside of a UIService.

Throws:

DataExchangeException

SQLImportConfigurationSpec

public SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable,
                                  JNDIDataSource jndiDataSource,
                                  SQLTable sqlTableOrView,
                                  TableFilter tableFilter,
                                  com.orchestranetworks.service.Session session)
                           throws DataExchangeException

Imports data with a filter and JNDIDataSource outside of a UIService.

Throws:

DataExchangeException

Since:

2.5.0

Method Detail

getServiceType

public ServiceType getServiceType()

Returns the service type.

Specified by:

getServiceType in interface ConfigurationSpec<SQLTable>

isImportForced

public boolean isImportForced()

Returns true if all triggers and constraints are disabled in the process of importing data.

Specified by:

isImportForced in interface ImportConfigurationSpec<SQLTable>

setImportForced

public void setImportForced(boolean importForced)

Sets whether all triggers and constraints are disabled in the process of importing data.

getImportMode

public ImportMode getImportMode()

Returns the specified import mode.

Specified by:

getImportMode in interface ImportConfigurationSpec<SQLTable>

setImportMode

public void setImportMode(ImportMode importMode)

Sets the import mode.

isEmptyOrNullValueIgnored

public boolean isEmptyOrNullValueIgnored()

Returns true if all empty or null values are ignored in the process of importing data.

Specified by:

isEmptyOrNullValueIgnored in interface ImportConfigurationSpec<SQLTable>

setEmptyOrNullValueIgnored

public void setEmptyOrNullValueIgnored(boolean emptyOrNullValueIgnored)

Sets whether all empty or null values are ignored in the process of importing data.

isEmptyOrNullPrimaryKeyChecked

public boolean isEmptyOrNullPrimaryKeyChecked()

Returns true if all empty or null primary keys were checked before data import and false if this verification was not performed.

Specified by:

isEmptyOrNullPrimaryKeyChecked in interface ImportConfigurationSpec<SQLTable>

setEmptyOrNullPrimaryKeyChecked

public void setEmptyOrNullPrimaryKeyChecked(boolean emptyOrNullPrimaryKeyChecked)

Sets whether all empty or null primary keys were checked before data import and false if this verification was not performed.

getSQLDataSourceName

public String getSQLDataSourceName()

Returns the SQL data source name.

getCurrentDataset

public com.onwbp.adaptation.Adaptation getCurrentDataset()

Returns the current dataset.

Specified by:

getCurrentDataset in interface ConfigurationSpec<SQLTable>

getCurrentTable

public com.onwbp.adaptation.AdaptationTable getCurrentTable()

Returns the current table.

Specified by:

getCurrentTable in interface ConfigurationSpec<SQLTable>

getSession

public com.orchestranetworks.service.Session getSession()

Returns the current session.

Specified by:

getSession in interface ConfigurationSpec<SQLTable>

getSourceTables

public List<SQLTable> getSourceTables()

Returns the list of source tables.

Specified by:

getSourceTables in interface ConfigurationSpec<SQLTable>

getSourceTableFilters

public Map<SQLTable,TableFilter> getSourceTableFilters()

Returns a map of table filters and an SQLTable instance as the key parameter. Returns null when importing CSV, Excel and XML.

Specified by:

getSourceTableFilters in interface ConfigurationSpec<SQLTable>

getFieldMapperDefinitions

public Map<TableMapping,FieldMapperDefinition> getFieldMapperDefinitions()

Returns the map of the FieldMapperDefinition implementations and TableMapping instance as the key parameter.

setFieldMapperDefinitions

public void setFieldMapperDefinitions(Map<TableMapping,FieldMapperDefinition> fieldMapperDefinitions)

Sets a map of the FieldMapperDefinition implementations and TableMapping instance as the key parameter.

getTablePattern

public String getTablePattern()

Returns the specified table naming pattern.

setTablePattern

public void setTablePattern(String tablePattern)

Sets a table naming pattern.

getSchemaName

public String getSchemaName()

Returns the specified schema name.

getJNDIDataSource

public JNDIDataSource getJNDIDataSource()

Returns the specified JNDI data source for SQL import.

Since:

2.5.0