Examples of org.teiid.test.framework.datasource.DataSourceFactory

• org.teiid.test.framework.datasource.DataSourceFactory
  The DataSourceFactory is responsible for managing the datasources used during a single test. It ensures the same data source is used in both the connector binding and during validation to ensure validation is performed against the same datasource the test was performed on. The following are the available options for controlling which datasources are used during a test:
• Control which datasources are used and to which model they are assigned

Use the {@link ConfigPropertyNames#USE_DATASOURCES_PROP} property to specify a comma delimited ordered list to control which data sources to use.

This will enable integration testing to be setup to use well known combinations, to ensure coverage and makes it easier to replicate issues. This indicates to use only the specified datasources for this test. This option can be used in test cases where only specific sources are to be used and tested against. This ordered list will map to the model:order mapping in the config.properties file.

Example: in the config.properties file, the models in the test and their order can be specified:

• pm1=1
• pm2=2

Then set property: ConfigPropertyNames.USE_DATASOURCES_PROP=oracle,sqlserver This will use oracle and sqlserver datasources in the test, and when a datasource is requested for model "pm1", the oracle datasource will be returned. And when a data source for "pm2" is requested, the data source mapped to 2nd ordered datasource of sqlserver will be returned.
• Control which datasources of a specific database type to exclude

Use the {@link ConfigPropertyNames#EXCLUDE_DATASBASE_TYPES_PROP} property to specify a comma delimited list of {@link DataBaseTypes} to exclude.

This will remove all datasources of a specific database type from the list of available datasources. This option will be applied after {@link ConfigPropertyNames#USE_DATASOURCES_PROP} option. This is done because there are some test that will not work with certain databasetypes, and therefore, if the required datasources are not met, the test will be bypassed for execution.

• Control for a specfic model, which database type of datasource to be assigned

This option gives the developer even more fine grain control of how datasources are assigned. There are cases where a specific model must be assigned to a datasource of a specific database type. To use this option,

@author vanhalbert