Class SQLImportConfigurationSpec
- java.lang.Object
-
- com.orchestranetworks.addon.dex.configuration.SQLImportConfigurationSpec
-
- All Implemented Interfaces:
ConfigurationSpec<SQLTable>
,ImportConfigurationSpec<SQLTable>
public final class SQLImportConfigurationSpec extends java.lang.Object implements ImportConfigurationSpec<SQLTable>
Defines the configuration used for importing data from an external database.- Since:
- 2.3.0
-
-
Constructor Summary
Constructors Constructor Description SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, JNDIDataSource jndiDataSource, SQLTable sqlTableOrView, TableFilter tableFilter, com.orchestranetworks.service.Session session)
Imports data with a filter andJNDIDataSource
outside of aUIService
.SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, JNDIDataSource jndiDataSource, SQLTable sqlTableOrView, com.orchestranetworks.service.Session session)
Imports data withJNDIDataSource
outside of aUIService
.SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, java.lang.String sqlDataSourceName, SQLTable sqlTableOrView, TableFilter tableFilter, com.orchestranetworks.service.Session session)
Imports data from an SQL table with a filter outside of aUIService
.SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, java.lang.String sqlDataSourceName, SQLTable sqlTableOrView, com.orchestranetworks.service.Session session)
Imports data outside of aUIService
.
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description com.onwbp.adaptation.Adaptation
getCurrentDataset()
Returns the current dataset.com.onwbp.adaptation.AdaptationTable
getCurrentTable()
Returns the current table.java.util.Map<TableMapping,FieldMapperDefinition>
getFieldMapperDefinitions()
Returns the map of theFieldMapperDefinition
implementations andTableMapping
instance as the key parameter.ImportMode
getImportMode()
Returns the specified import mode.JNDIDataSource
getJNDIDataSource()
Returns the specified JNDI data source for SQL import.java.lang.String
getSchemaName()
Returns the specified schema name.ServiceType
getServiceType()
Returns the service type.com.orchestranetworks.service.Session
getSession()
Returns the current session.java.util.Map<SQLTable,TableFilter>
getSourceTableFilters()
Returns a map of table filters and anSQLTable
instance as the key parameter.java.util.List<SQLTable>
getSourceTables()
Returns the list of source tables.java.lang.String
getSQLDataSourceName()
Returns the SQL data source name.java.lang.String
getTablePattern()
Returns the specified table naming pattern.boolean
isEmptyOrNullPrimaryKeyChecked()
Returnstrue
if all empty ornull
primary keys were checked before data import andfalse
if this verification was not performed.boolean
isEmptyOrNullValueIgnored()
Returnstrue
if all empty ornull
values are ignored in the process of importing data.boolean
isImportForced()
Returnstrue
if all triggers and constraints are disabled in the process of importing data.void
setEmptyOrNullPrimaryKeyChecked(boolean emptyOrNullPrimaryKeyChecked)
Sets whether all empty ornull
primary keys were checked before data import andfalse
if this verification was not performed.void
setEmptyOrNullValueIgnored(boolean emptyOrNullValueIgnored)
Sets whether all empty ornull
values are ignored in the process of importing data.void
setFieldMapperDefinitions(java.util.Map<TableMapping,FieldMapperDefinition> fieldMapperDefinitions)
Sets a map of theFieldMapperDefinition
implementations andTableMapping
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(java.lang.String tablePattern)
Sets a table naming pattern.
-
-
-
Constructor Detail
-
SQLImportConfigurationSpec
public SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, java.lang.String sqlDataSourceName, SQLTable sqlTableOrView, com.orchestranetworks.service.Session session) throws DataExchangeException
Imports data outside of aUIService
.- Throws:
DataExchangeException
-
SQLImportConfigurationSpec
public SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, JNDIDataSource jndiDataSource, SQLTable sqlTableOrView, com.orchestranetworks.service.Session session) throws DataExchangeException
Imports data withJNDIDataSource
outside of aUIService
.- Throws:
DataExchangeException
- Since:
- 2.5.0
-
SQLImportConfigurationSpec
public SQLImportConfigurationSpec(com.onwbp.adaptation.AdaptationTable currentTable, java.lang.String sqlDataSourceName, SQLTable sqlTableOrView, TableFilter tableFilter, com.orchestranetworks.service.Session session) throws DataExchangeException
Imports data from an SQL table with a filter outside of aUIService
.- 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 andJNDIDataSource
outside of aUIService
.- Throws:
DataExchangeException
- Since:
- 2.5.0
-
-
Method Detail
-
getServiceType
public ServiceType getServiceType()
Returns the service type.- Specified by:
getServiceType
in interfaceConfigurationSpec<SQLTable>
-
isImportForced
public boolean isImportForced()
Returnstrue
if all triggers and constraints are disabled in the process of importing data.- Specified by:
isImportForced
in interfaceImportConfigurationSpec<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 interfaceImportConfigurationSpec<SQLTable>
-
setImportMode
public void setImportMode(ImportMode importMode)
Sets the import mode.
-
isEmptyOrNullValueIgnored
public boolean isEmptyOrNullValueIgnored()
Returnstrue
if all empty ornull
values are ignored in the process of importing data.- Specified by:
isEmptyOrNullValueIgnored
in interfaceImportConfigurationSpec<SQLTable>
-
setEmptyOrNullValueIgnored
public void setEmptyOrNullValueIgnored(boolean emptyOrNullValueIgnored)
Sets whether all empty ornull
values are ignored in the process of importing data.
-
isEmptyOrNullPrimaryKeyChecked
public boolean isEmptyOrNullPrimaryKeyChecked()
Returnstrue
if all empty ornull
primary keys were checked before data import andfalse
if this verification was not performed.- Specified by:
isEmptyOrNullPrimaryKeyChecked
in interfaceImportConfigurationSpec<SQLTable>
-
setEmptyOrNullPrimaryKeyChecked
public void setEmptyOrNullPrimaryKeyChecked(boolean emptyOrNullPrimaryKeyChecked)
Sets whether all empty ornull
primary keys were checked before data import andfalse
if this verification was not performed.
-
getSQLDataSourceName
public java.lang.String getSQLDataSourceName()
Returns the SQL data source name.
-
getCurrentDataset
public com.onwbp.adaptation.Adaptation getCurrentDataset()
Returns the current dataset.- Specified by:
getCurrentDataset
in interfaceConfigurationSpec<SQLTable>
-
getCurrentTable
public com.onwbp.adaptation.AdaptationTable getCurrentTable()
Returns the current table.- Specified by:
getCurrentTable
in interfaceConfigurationSpec<SQLTable>
-
getSession
public com.orchestranetworks.service.Session getSession()
Returns the current session.- Specified by:
getSession
in interfaceConfigurationSpec<SQLTable>
-
getSourceTables
public java.util.List<SQLTable> getSourceTables()
Returns the list of source tables.- Specified by:
getSourceTables
in interfaceConfigurationSpec<SQLTable>
-
getSourceTableFilters
public java.util.Map<SQLTable,TableFilter> getSourceTableFilters()
Returns a map of table filters and anSQLTable
instance as the key parameter. Returnsnull
when importing CSV, Excel and XML.- Specified by:
getSourceTableFilters
in interfaceConfigurationSpec<SQLTable>
-
getFieldMapperDefinitions
public java.util.Map<TableMapping,FieldMapperDefinition> getFieldMapperDefinitions()
Returns the map of theFieldMapperDefinition
implementations andTableMapping
instance as the key parameter.
-
setFieldMapperDefinitions
public void setFieldMapperDefinitions(java.util.Map<TableMapping,FieldMapperDefinition> fieldMapperDefinitions)
Sets a map of theFieldMapperDefinition
implementations andTableMapping
instance as the key parameter.
-
getTablePattern
public java.lang.String getTablePattern()
Returns the specified table naming pattern.
-
setTablePattern
public void setTablePattern(java.lang.String tablePattern)
Sets a table naming pattern.
-
getSchemaName
public java.lang.String getSchemaName()
Returns the specified schema name.
-
getJNDIDataSource
public JNDIDataSource getJNDIDataSource()
Returns the specified JNDI data source for SQL import.- Since:
- 2.5.0
-
-