def test_create_delete_xa_datasource(provider, datasource):
"""Tests XA datasource creation and deletion on EAP server
Method is executed for all database types
Steps:
* Get servers list from UI
* Chooses JBoss EAP server from list
* Invokes 'Add JDBC Driver' toolbar operation
* Fills all necessary fields and saves
* Invokes 'Add Datasource' toolbar operation
* Selects Datasource type.
* Selects XA Datasource type.
* Click Next.
* Input Datasource Name.
* Input Datasource JNDI Name.
* Click Next.
* Input Driver Name.
* Input Module Name.
* Input Driver Name.
* Input Driver Class.
* Click Next.
* Input Database Connection URL.
* Input Database username.
* Input Database password.
* Submits the form.
* Checks if newly created datasource is listed. Selects it.
* Deletes that Datasource via UI operation.
* Checks whether resource is deleted.
"""
server = get_eap_server(provider)
file_path = download_jdbc_driver(datasource.driver.database_name)
deploy_jdbc_driver(provider,
server,
file_path,
driver_name=datasource.driver.driver_name,
module_name=datasource.driver.module_name,
driver_class=datasource.driver.driver_class,
major_version=datasource.driver.major_version,
minor_version=datasource.driver.minor_version)
server.add_datasource(ds_type='{} XA'.format(datasource.database_type),
ds_name='{}XA'.format(datasource.datasource_name),
jndi_name='{}XA'.format(datasource.jndi_name),
xa_ds=True,
driver_name=datasource.driver.driver_name,
driver_module_name=datasource.driver.module_name,
driver_class=datasource.driver.xa_class,
ds_url=datasource.connection_url.replace("\\", ""),
username=datasource.username,
password=datasource.password)
datasource_name = "XA Datasource [{}XA]".format(datasource.datasource_name)
verify_datasource_listed(provider, datasource_name, server)
delete_datasource(provider, server, datasource_name)
verify_datasource_not_listed(provider, datasource_name)
def test_create_delete_datasource(provider):
"""Tests datasource creation and deletion on EAP server
Steps:
* Get servers list from UI
* Chooses JBoss EAP server from list
* Invokes 'Add JDBC Driver' toolbar operation
* Fills all necessary fields and saves
* Invokes 'Add Datasource' toolbar operation
* Selects Datasource type.
* Click Next.
* Input Datasource Name.
* Input Datasource JNDI Name.
* Click Next.
* Input Driver Name.
* Input Module Name.
* Input Driver Name.
* Input Driver Class.
* Click Next.
* Input Database Connection URL.
* Input Database username.
* Input Database password.
* Submits the form.
* Checks if newly created datasource is listed. Selects it.
* Deletes that Datasource via UI operation.
* Checks whether resource is deleted.
"""
server = get_eap_server(provider)
datasource = ORACLE_12C_DS
file_path = download_jdbc_driver(datasource.driver.database_name)
deploy_jdbc_driver(provider, server, file_path,
driver_name=datasource.driver.driver_name,
module_name=datasource.driver.module_name,
driver_class=datasource.driver.driver_class,
xa_class=datasource.driver.xa_class,
major_version=datasource.driver.major_version,
minor_version=datasource.driver.minor_version)
server.add_datasource(ds_type=datasource.database_type,
ds_name=datasource.datasource_name,
jndi_name=datasource.jndi_name,
driver_name=datasource.driver.driver_name,
driver_module_name=datasource.driver.module_name,
driver_class=datasource.driver.driver_class,
ds_url=datasource.connection_url.replace("\\", ""),
username=datasource.username,
password=datasource.password)
datasource_name = "Datasource [{}]".format(datasource.datasource_name)
verify_datasource_listed(provider, datasource_name, server)
""" @TODO enable when BZ#1460296 is fixed
def test_create_xa_datasource(provider, datasource):
"""Tests XA datasource creation and deletion on EAP server
Method is executed for all database types
Steps:
* Get servers list from UI
* Chooses JBoss EAP server from list
* Invokes 'Add JDBC Driver' toolbar operation
* Fills all necessary fields and saves
* Invokes 'Add Datasource' toolbar operation
* Selects Datasource type.
* Selects XA Datasource type.
* Click Next.
* Input Datasource Name.
* Input Datasource JNDI Name.
* Click Next.
* Input Driver Name.
* Input Module Name.
* Input Driver Name.
* Input Driver Class.
* Click Next.
* Input Database Connection URL.
* Input Database username.
* Input Database password.
* Submits the form.
* Checks if newly created datasource is listed.
"""
server = get_eap_server(provider)
file_path = download_jdbc_driver(datasource.driver.database_name)
deploy_jdbc_driver(provider, server, file_path,
driver_name=datasource.driver.driver_name,
module_name=datasource.driver.module_name,
driver_class=datasource.driver.driver_class,
xa_class=datasource.driver.xa_class,
major_version=datasource.driver.major_version,
minor_version=datasource.driver.minor_version)
server.add_datasource(ds_type='{} XA'.format(datasource.database_type),
ds_name='{}XA'.format(datasource.datasource_name),
jndi_name='{}XA'.format(datasource.jndi_name),
xa_ds=True,
driver_name=datasource.driver.driver_name,
driver_module_name=datasource.driver.module_name,
driver_class=datasource.driver.xa_class,
ds_url=datasource.connection_url.replace("\\", ""),
username=datasource.username,
password=datasource.password)
datasource_name = "XA Datasource [{}XA]".format(datasource.datasource_name)
verify_datasource_listed(provider, datasource_name, server)
def test_create_datasource_select_driver(provider, datasource):
"""Tests datasource creation and deletion on EAP server
Method is executed for all database types
Steps:
* Get servers list from UI
* Chooses JBoss EAP server from list
* Invokes 'Add JDBC Driver' toolbar operation
* Fills all necessary fields and saves
* Invokes 'Add Datasource' toolbar operation
* Selects Datasource type.
* Click Next.
* Input Datasource Name.
* Input Datasource JNDI Name.
* Click Next.
* Choose the tab "Existing Driver".
* Select just created driver
* Click Next.
* Input Database Connection URL.
* Input Database username.
* Input Database password.
* Submits the form.
* Checks if newly created datasource is listed.
"""
server = get_eap_server(provider)
file_path = download_jdbc_driver(datasource.driver.database_name)
deploy_jdbc_driver(provider,
server,
file_path,
driver_name=datasource.driver.driver_name,
module_name=datasource.driver.module_name,
driver_class=datasource.driver.driver_class,
xa_class=datasource.driver.xa_class,
major_version=datasource.driver.major_version,
minor_version=datasource.driver.minor_version)
verify_server_running(provider, server)
server.add_datasource(ds_type=datasource.database_type,
ds_name=datasource.datasource_name,
jndi_name=datasource.jndi_name,
existing_driver=datasource.driver.driver_name,
ds_url=datasource.connection_url.replace("\\", ""),
username=datasource.username,
password=datasource.password)
datasource_name = "Datasource [{}]".format(datasource.datasource_name)
verify_datasource_listed(provider, datasource_name, server)