def test_deploy_driver(provider, driver):
"""Tests Deployment of provided JDBC Driver into EAP7 server
Steps:
* Get servers list from UI
* Chooses JBoss EAP server from list
* Invokes 'Add JDBC Driver' toolbar operation
* Selects JDBC driver file to upload.
* Input Driver Name.
* Input Module Name.
* Input Driver Name.
* Input Driver Class.
* Input Major Version.
* Input Minor Version.
* Submits the form.
* Checks that notification message is shown.
"""
server = get_eap_server(provider)
file_path = download_jdbc_driver(driver.database_name)
deploy_jdbc_driver(provider,
server,
file_path,
driver_name=driver.driver_name,
module_name=driver.module_name,
driver_class=driver.driver_class,
xa_class=driver.xa_class,
major_version=driver.major_version,
minor_version=driver.minor_version)
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)
verify_driver_listed(provider, datasource, server)
def test_deploy_driver(provider, driver):
"""Tests Deployment of provided JDBC Driver into EAP7 server
Steps:
* Get servers list from UI
* Chooses JBoss EAP server from list
* Invokes 'Add JDBC Driver' toolbar operation
* Selects JDBC driver file to upload.
* Input Driver Name.
* Input Module Name.
* Input Driver Name.
* Input Driver Class.
* Input Major Version.
* Input Minor Version.
* Submits the form.
* Checks that notification message is shown.
"""
server = get_eap_server(provider)
file_path = download_jdbc_driver(driver.database_name)
deploy_jdbc_driver(provider, server, file_path,
driver_name=driver.driver_name,
module_name=driver.module_name,
driver_class=driver.driver_class,
xa_class=driver.xa_class,
major_version=driver.major_version,
minor_version=driver.minor_version)
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)
verify_driver_listed(provider, datasource, server)
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_deploy_driver(provider, database_params):
"""Tests Deployment of provided JDBC Driver into EAP7 server
Steps:
* Get servers list from UI
* Chooses JBoss EAP server from list
* Invokes 'Add JDBC Driver' toolbar operation
* Selects JDBC driver file to upload.
* Input Driver Name.
* Input Module Name.
* Input Driver Name.
* Input Driver Class.
* Input Major Version.
* Input Minor Version.
* Submits the form.
* Checks that notification message is shown.
"""
server = get_server(provider, EAP_PRODUCT_NAME)
file_path = download_jdbc_driver(database_params[0])
deploy_jdbc_driver(provider, server, file_path, driver_name=database_params[1],
module_name=database_params[2], driver_class=database_params[3],
major_version=database_params[4], minor_version=database_params[5])
def gen_ds_creation_events(provider, datasource):
server = get_eap_server(provider)
ds_name = generate_ds_name(datasource.datasource_name)
jndi_name = generate_ds_name(datasource.jndi_name)
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=datasource.database_type,
ds_name=ds_name,
jndi_name=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)
ds_name = "Datasource [{}]".format(ds_name)
return ds_name
def gen_ds_creation_events(provider, datasource):
server = get_eap_server(provider)
ds_name = generate_ds_name(datasource.datasource_name)
jndi_name = generate_ds_name(datasource.jndi_name)
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=datasource.database_type,
ds_name=ds_name,
jndi_name=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)
ds_name = "Datasource [{}]".format(ds_name)
return ds_name
