def get_random_server(provider, load_from="db"):
load_from = load_from.lower()
if load_from == "ui":
servers = MiddlewareServer.servers(provider=provider)
elif load_from == "db":
servers = MiddlewareServer.servers_in_db(provider=provider)
elif load_from == "mgmt":
servers = MiddlewareServer.servers_in_mgmt(provider=provider)
assert len(servers) > 0, "There is no server(s) available in {}".format(load_from)
else:
raise RuntimeError("Not supported option: '{}'".format(load_from))
return get_random_list(servers, 1)[0]
def get_random_server(provider, load_from="db"):
load_from = load_from.lower()
if load_from == "ui":
servers = MiddlewareServer.servers(provider=provider)
elif load_from == "db":
servers = MiddlewareServer.servers_in_db(provider=provider)
elif load_from == "mgmt":
servers = MiddlewareServer.servers_in_mgmt(provider=provider)
assert len(servers) > 0, "There is no server(s) available in {}".format(load_from)
else:
raise RuntimeError("Not supported option: '{}'".format(load_from))
return get_random_list(servers, 1)[0]
def test_list_provider_servers(provider):
"""Tests servers lists from current Provider between UI, DB and Management system
Steps:
* Get servers list from UI of provider
* Get servers list from Database of provider
* Get servers list from Management system(Hawkular)
* Compare content of all the list [UI, Database, Management system]
"""
ui_servers = _get_servers_set(MiddlewareServer.servers(provider=provider))
db_servers = _get_servers_set(MiddlewareServer.servers_in_db(provider=provider))
mgmt_servers = _get_servers_set(MiddlewareServer.servers_in_mgmt(provider=provider))
assert ui_servers == db_servers == mgmt_servers, \
("Lists of servers mismatch! UI:{}, DB:{}, MGMT:{}"
.format(ui_servers, db_servers, mgmt_servers))
def test_list_provider_servers(provider):
"""Tests servers lists from current Provider between UI, DB and Management system
Steps:
* Get servers list from UI of provider
* Get servers list from Database of provider
* Get servers list from Management system(Hawkular)
* Compare content of all the list [UI, Database, Management system]
"""
ui_servers = _get_servers_set(MiddlewareServer.servers(provider=provider))
db_servers = _get_servers_set(MiddlewareServer.servers_in_db(provider=provider))
mgmt_servers = _get_servers_set(MiddlewareServer.servers_in_mgmt(provider=provider))
assert ui_servers == db_servers == mgmt_servers, \
("Lists of servers mismatch! UI:{}, DB:{}, MGMT:{}"
.format(ui_servers, db_servers, mgmt_servers))
def test_server_suspend_resume(provider):
"""Tests server suspend/resume operation on UI
Steps:
* Get servers list from UI
* Chooses Wildfly server from list
* Invokes Suspend Server' toolbar operation
* Checks that server status is not running in UI, in DB and in MGMT.
* Invokes 'Resume Server' toolbar operation
* Waits for some time
* Checks that server status is running in UI, in DB and in MGMT.
"""
server_list = MiddlewareServer.servers(provider=provider)
for _server in server_list:
if _server.product != 'Hawkular':
server = _server
break
assert server, 'Wildfly server was not found in servers list'
_check_server_running(server)
server.suspend_server()
flash.assert_success_message('Suspend initiated for selected server(s)')
# enable when HWKINVENT-185 is fixed
# _check_server_stopped(server)
server.resume_server()
flash.assert_success_message('Resume initiated for selected server(s)')
_check_server_running(server)
def test_hawkular_reload(provider):
"""Tests Hawkular server itself reload operation message on UI
Steps:
* Get servers list from UI
* Chooses Hawkular server from list
* Invokes 'Reload Server' toolbar operation
* Checks that notification message is shown
* Checks that server status is running in UI, in DB and in MGMT.
* Invokes 'Stop Server' toolbar operation
* Checks that notification message is shown
* Checks that server status is running in UI, in DB and in MGMT.
"""
server_list = MiddlewareServer.servers(provider=provider)
for _server in server_list:
if _server.product == 'Hawkular':
server = _server
break
assert server, 'Hawkular server was not found in servers list'
server.reload_server()
flash.assert_success_message('Not reloading Hawkular server')
_check_server_running(server)
server.stop_server()
flash.assert_success_message('Not stopping Hawkular server')
_check_server_running(server)
def test_topology_server_hierarchy(provider):
"""Tests all server's hierarchical content in topology
Steps:
* Read Servers in topology.
* For each server read elements in topology.
* Compare elements from topology with server's elements from DB.
"""
# reload topology page to make sure all elements are loaded
provider.topology.reload()
provider.topology.refresh()
for ui_server in provider.topology.elements(
element_type='MiddlewareServer'):
elements = []
server = MiddlewareServer.servers_in_db(name=ui_server.name)[0]
elements.extend(
MiddlewareDeployment.deployments_in_db(server,
provider,
strict=False))
elements.extend(
MiddlewareDatasource.datasources_in_db(server,
provider,
strict=False))
elements.extend(
MiddlewareMessaging.messagings_in_db(server,
provider,
strict=False))
verify_elements_included(elements, ui_server.children)
def test_topology_details(provider):
"""Tests items details in topology page from provider page
Steps:
* Get topology elements detail
* Check details of `Servers`, `Domains`, `Messagings`,
* `Datasources`, `Server Groups`, `Deployments` on topology page
"""
# reload topology page to make sure all elements are loaded
provider.topology.reload()
provider.topology.refresh()
verify_elements_match(MiddlewareServer.servers_in_db(),
provider.topology.elements(element_type='MiddlewareServer'))
verify_elements_match(MiddlewareMessaging.messagings_in_db(),
provider.topology.elements(element_type='MiddlewareMessaging'))
verify_elements_match(MiddlewareDatasource.datasources_in_db(),
provider.topology.elements(element_type='MiddlewareDatasource'))
verify_elements_match(MiddlewareDomain.domains_in_db(),
provider.topology.elements(element_type='MiddlewareDomain'))
server_groups = []
for domain in MiddlewareDomain.domains_in_db():
server_groups.extend(MiddlewareServerGroup.server_groups_in_db(domain))
verify_elements_match(server_groups,
provider.topology.elements(element_type='MiddlewareServerGroup'))
deployments = provider.topology.elements(element_type='MiddlewareDeployment')
deployments.extend(provider.topology.elements(element_type='MiddlewareDeploymentWar'))
deployments.extend(provider.topology.elements(element_type='MiddlewareDeploymentEar'))
verify_elements_match(MiddlewareDeployment.deployments_in_db(), deployments)
def test_server_suspend_resume(provider):
"""Tests server suspend/resume operation on UI
Steps:
* Get servers list from UI
* Chooses Wildfly server from list
* Invokes Suspend Server' toolbar operation
* Checks that server status is not running in UI, in DB and in MGMT.
* Invokes 'Resume Server' toolbar operation
* Waits for some time
* Checks that server status is running in UI, in DB and in MGMT.
"""
server_list = MiddlewareServer.servers(provider=provider)
for _server in server_list:
if _server.product != 'Hawkular':
server = _server
break
assert server, 'Wildfly server was not found in servers list'
_check_server_running(server)
server.suspend_server()
flash.assert_success_message('Suspend initiated for selected server(s)')
# enable when HWKINVENT-185 is fixed
# _check_server_stopped(server)
server.resume_server()
flash.assert_success_message('Resume initiated for selected server(s)')
_check_server_running(server)
def messaging(self):
self.load_details(refresh=True)
self.id = self.get_detail("Properties", "Nativeid")
self.server = MiddlewareServer(
provider=self.provider,
name=self.get_detail("Relationships", "Middleware Server"))
return self
def datasource(self):
self.summary.reload()
self.id = self.summary.properties.nativeid.text_value
self.server = MiddlewareServer(
provider=self.provider,
name=self.summary.relationships.middleware_server.text_value)
return self
def datasource(self):
self.load_details(refresh=False)
self.id = self.get_detail("Properties", "Nativeid")
self.server = MiddlewareServer(
provider=self.provider,
name=self.get_detail("Relationships", "Middleware Server"))
return self
def _get_server_by_name(provider, product=None, name=None, container=False):
"""
Return server by given provider, product and server name.
Args:
provider: provider object
product: name of product
name: name of server, used as regex, optional
Usage:
_get_server_by_name(provider, EAP_PRODUCT_NAME, 'EAP7|Local')
_get_server_by_name(provider, HAWKULAR_PRODUCT_NAME)
_get_server_by_name(provider, EAP_PRODUCT_NAME, 'server-one')
"""
servers = MiddlewareServer.servers_in_db(provider=provider,
product=product,
strict=False)
if len(servers) > 0:
if name:
for server in servers:
if (re.match("^({})$".format(name), server.name)
and _is_hostname_expected_container(
server.hostname, container)):
return server
else:
return servers[0]
raise ValueError('{} server was not found in servers list'.format(product))
def test_hawkular_fail(provider):
"""Tests Hawkular server itself reload operation message on UI
Steps:
* Get servers list from UI
* Chooses Hawkular server from list
* Invokes all 'Power' toolbar operation
* Checks that notification message is shown
* Checks that server status is running in UI, in DB and in MGMT.
"""
server_list = MiddlewareServer.servers(provider=provider)
for _server in server_list:
if _server.product == 'Hawkular':
server = _server
break
assert server, 'Hawkular server was not found in servers list'
server.reload_server()
flash.assert_success_message('Not reloading the provider')
_check_server_running(server)
server.stop_server()
flash.assert_success_message('Not stopping the provider')
_check_server_running(server)
server.shutdown_server()
flash.assert_success_message('Not shutting down the provider')
_check_server_running(server)
server.restart_server()
flash.assert_success_message('Not restarting the provider')
_check_server_running(server)
server.suspend_server()
flash.assert_success_message('Not suspending the provider')
_check_server_running(server)
server.resume_server()
flash.assert_success_message('Not resuming the provider')
_check_server_running(server)
def test_list_provider_server_deployments(provider):
"""Tests deployments list from current Provider for each server
between UI, DB and Management system
Steps:
* Get servers list from UI of provider
* Get deployments list for the server
* Get deployments list from UI of provider, server
* Get deployments list from Database of provider, server
* Get deployments list from Database of provider, server
* Get deployments list from Management system(Hawkular) of server
* Compare size of all the list [UI, Database, Management system]
"""
servers = MiddlewareServer.servers(provider=provider)
assert len(servers) > 0, "There is no server(s) available in UI"
for server in get_random_list(servers, ITEMS_LIMIT):
ui_deps = _get_deployments_set(
MiddlewareDeployment.deployments(provider=provider, server=server))
db_deps = _get_deployments_set(
MiddlewareDeployment.deployments_in_db(provider=provider, server=server))
mgmt_deps = _get_deployments_set(
MiddlewareDeployment.deployments_in_mgmt(provider=provider, server=server))
assert ui_deps == db_deps == mgmt_deps, \
("Lists of deployments mismatch! UI:{}, DB:{}, MGMT:{}"
.format(ui_deps, db_deps, mgmt_deps))
def _get_server_by_name(provider, product=None, name=None, container=False):
"""
Return server by given provider, product and server name.
Args:
provider: provider object
product: name of product
name: name of server, used as regex, optional
Usage:
_get_server_by_name(provider, EAP_PRODUCT_NAME, 'EAP7|Local')
_get_server_by_name(provider, HAWKULAR_PRODUCT_NAME)
_get_server_by_name(provider, EAP_PRODUCT_NAME, 'server-one')
"""
servers = MiddlewareServer.servers_in_db(provider=provider, product=product,
strict=False)
if len(servers) > 0:
if name:
for server in servers:
if (re.match("^({})$".format(name), server.name) and
_is_hostname_expected_container(server.hostname, container)):
return server
else:
return servers[0]
raise ValueError('{} server was not found in servers list'.format(product))
def test_list_provider_server_deployments(provider):
"""Tests deployments list from current Provider for each server
between UI, DB and Management system
Steps:
* Get servers list from UI of provider
* Get deployments list for the server
* Get deployments list from UI of provider, server
* Get deployments list from Database of provider, server
* Get deployments list from Database of provider, server
* Get deployments list from Management system(Hawkular) of server
* Compare size of all the list [UI, Database, Management system]
"""
servers = MiddlewareServer.servers(provider=provider)
assert len(servers) > 0, "There is no server(s) available in UI"
for server in get_random_list(servers, ITEMS_LIMIT):
ui_deps = _get_deployments_set(
MiddlewareDeployment.deployments(provider=provider, server=server))
db_deps = _get_deployments_set(
MiddlewareDeployment.deployments_in_db(provider=provider,
server=server))
mgmt_deps = _get_deployments_set(
MiddlewareDeployment.deployments_in_mgmt(provider=provider,
server=server))
assert ui_deps == db_deps == mgmt_deps, \
("Lists of deployments mismatch! UI:{}, DB:{}, MGMT:{}"
.format(ui_deps, db_deps, mgmt_deps))
def test_topology_details(provider):
"""Tests items details in topology page from provider page
Steps:
* Get topology elements detail
* Check details of `Servers`, `Domains`, `Messagings`,
* `Datasources`, `Server Groups`, `Deployments` on topology page
"""
# reload topology page to make sure all elements are loaded
provider.topology.reload()
provider.topology.refresh()
verify_elements_match(MiddlewareServer.servers_in_db(),
provider.topology.elements(element_type='MiddlewareServer'))
verify_elements_match(MiddlewareMessaging.messagings_in_db(),
provider.topology.elements(element_type='MiddlewareMessaging'))
verify_elements_match(MiddlewareDatasource.datasources_in_db(),
provider.topology.elements(element_type='MiddlewareDatasource'))
verify_elements_match(MiddlewareDomain.domains_in_db(),
provider.topology.elements(element_type='MiddlewareDomain'))
server_groups = []
for domain in MiddlewareDomain.domains_in_db():
server_groups.extend(MiddlewareServerGroup.server_groups_in_db(domain))
verify_elements_match(server_groups,
provider.topology.elements(element_type='MiddlewareServerGroup'))
deployments = provider.topology.elements(element_type='MiddlewareDeployment')
deployments.extend(provider.topology.elements(element_type='MiddlewareDeploymentWar'))
deployments.extend(provider.topology.elements(element_type='MiddlewareDeploymentEar'))
verify_elements_match(MiddlewareDeployment.deployments_in_db(), deployments)
def datasource_in_db(self):
datasource = _db_select_query(name=self.name, server=self.server,
nativeid=self.nativeid).first()
if datasource:
_server = MiddlewareServer(name=datasource.server_name, provider=self.provider)
return MiddlewareDatasource(provider=self.provider, server=_server,
nativeid=datasource.nativeid, name=datasource.name,
properties=parse_properties(datasource.properties))
return None
def test_list_servers():
"""Tests servers lists between UI, DB and Management system.
Steps:
* Get servers list from UI
* Get servers list from Database
* Get headers from UI
* Compare headers from UI with expected headers list
* Compare content of all the list [UI, Database, Management system]
"""
ui_servers = _get_servers_set(MiddlewareServer.servers())
db_servers = _get_servers_set(MiddlewareServer.servers_in_db())
mgmt_servers = _get_servers_set(MiddlewareServer.servers_in_mgmt())
headers = MiddlewareServer.headers()
headers_expected = ['Server Name', 'Product', 'Host Name', 'Feed', 'Provider']
assert headers == headers_expected
assert ui_servers == db_servers == mgmt_servers, \
("Lists of servers mismatch! UI:{}, DB:{}, MGMT:{}"
.format(ui_servers, db_servers, mgmt_servers))
def datasources(cls, provider=None, server=None):
datasources = []
_get_datasources_page(provider=provider, server=server)
if sel.is_displayed(list_tbl):
for _ in paginator.pages():
for row in list_tbl.rows():
_server = MiddlewareServer(provider=provider, name=row.server.text)
datasources.append(MiddlewareDatasource(provider=provider, server=_server,
name=row.datasource_name.text))
return datasources
def deployment_in_db(self):
deployment = _db_select_query(name=self.name, server=self.server,
provider=self.provider).first()
if deployment:
_provider = get_crud(get_provider_key(deployment.provider_name))
_server = MiddlewareServer(name=deployment.server_name, feed=deployment.feed,
provider=_provider)
return MiddlewareDeployment(nativeid=deployment.nativeid, name=deployment.name,
server=_server, provider=_provider, db_id=deployment.id)
return None
def test_list_servers():
"""Tests servers lists between UI, DB and Management system.
Steps:
* Get servers list from UI
* Get servers list from Database
* Get headers from UI
* Compare headers from UI with expected headers list
* Compare content of all the list [UI, Database, Management system]
"""
ui_servers = _get_servers_set(MiddlewareServer.servers())
db_servers = _get_servers_set(MiddlewareServer.servers_in_db())
mgmt_servers = _get_servers_set(MiddlewareServer.servers_in_mgmt())
headers = MiddlewareServer.headers()
headers_expected = ['Server Name', 'Product', 'Host Name', 'Feed', 'Provider']
assert headers == headers_expected
assert ui_servers == db_servers == mgmt_servers, \
("Lists of servers mismatch! UI:{}, DB:{}, MGMT:{}"
.format(ui_servers, db_servers, mgmt_servers))
def deployments(cls, provider=None, server=None):
deployments = []
_get_deployments_page(provider=provider, server=server)
if sel.is_displayed(list_tbl):
_provider = provider # In deployment UI, we cannot get provider name on list all page
for _ in paginator.pages():
for row in list_tbl.rows():
_server = MiddlewareServer(provider=provider, name=row.server.text)
deployments.append(MiddlewareDeployment(provider=_provider, server=_server,
name=row.deployment_name.text))
return deployments
def test_server_tags(provider):
"""Tests tags in server page
Steps:
* Select a server randomly from database
* Run `_validate_tags` with `tags` input
"""
servers_db = MiddlewareServer.servers_in_db(provider=provider)
assert len(servers_db) > 0, "There is no server(s) available in DB"
server = get_random_list(servers_db, 1)[0]
validate_tags(taggable=server, tags=tags)
def test_list_server_group_servers(provider):
"""Tests servers lists from server groups of domain and checks values
between UI, DB and Management system
Steps:
* Get domains list from UI of provider
* Chooses one of domains
* Get server groups list from UI of domain
* Get servers list from UI of each server group
* Get servers list from Database of each server group
* @TODO add support of checking in MGMT
* Compare content of all the list [UI, Database]
"""
domain_list = MiddlewareDomain.domains(provider=provider)
for domain in get_random_list(domain_list, 1):
server_groups = MiddlewareServerGroup.server_groups(domain=domain)
for server_group in server_groups:
ui_servers = get_servers_set(MiddlewareServer.servers(server_group=server_group))
db_servers = get_servers_set(MiddlewareServer.servers_in_db(server_group=server_group))
assert ui_servers == db_servers, "Lists of servers mismatch! UI:{}, DB:{}".format(ui_servers, db_servers)
def test_list_server_group_servers(provider):
"""Tests servers lists from server groups of domain and checks values
between UI, DB and Management system
Steps:
* Get domains list from UI of provider
* Chooses one of domains
* Get server groups list from UI of domain
* Get servers list from UI of each server group
* Get servers list from Database of each server group
* @TODO add support of checking in MGMT
* Compare content of all the list [UI, Database]
"""
domain_list = MiddlewareDomain.domains(provider=provider)
for domain in get_random_list(domain_list, 1):
server_groups = MiddlewareServerGroup.server_groups(domain=domain)
for server_group in server_groups:
ui_servers = get_servers_set(MiddlewareServer.servers(server_group=server_group))
db_servers = get_servers_set(MiddlewareServer.servers_in_db(server_group=server_group))
assert ui_servers == db_servers, \
("Lists of servers mismatch! UI:{}, DB:{}"
.format(ui_servers, db_servers))
def deployments_in_db(cls, server=None, provider=None, strict=True):
deployments = []
rows = _db_select_query(server=server, provider=provider).all()
_provider = provider
for deployment in rows:
if strict:
_provider = get_crud(get_provider_key(deployment.provider_name))
_server = MiddlewareServer(name=deployment.server_name, feed=deployment.feed,
provider=provider)
deployments.append(MiddlewareDeployment(nativeid=deployment.nativeid,
name=deployment.name, db_id=deployment.id,
server=_server, provider=_provider))
return deployments
def messagings(cls, provider=None, server=None):
messagings = []
_get_messagings_page(provider=provider, server=server)
if sel.is_displayed(list_tbl):
for _ in paginator.pages():
for row in list_tbl.rows():
_server = MiddlewareServer(provider=provider, name=row.server.text)
messagings.append(MiddlewareMessaging(
provider=provider,
server=_server,
name=row.messaging_name.text,
messaging_type=row.messaging_type.text))
return messagings
def datasources(cls, provider=None, server=None):
datasources = []
view = _get_datasources_page(provider=provider, server=server)
for _ in view.entities.paginator.pages():
for row in view.entities.elements:
_server = MiddlewareServer(provider=provider,
name=row.server.text)
datasources.append(
MiddlewareDatasource(provider=provider,
server=_server,
name=row.datasource_name.text,
hostname=row.host_name.text))
return datasources
def datasources_in_db(cls, server=None, provider=None, strict=True):
datasources = []
rows = _db_select_query(server=server, provider=provider).all()
_provider = provider
for datasource in rows:
if strict:
_provider = get_crud(get_provider_key(datasource.provider_name))
_server = MiddlewareServer(name=datasource.server_name, feed=datasource.feed,
provider=provider)
datasources.append(MiddlewareDatasource(nativeid=datasource.nativeid,
name=datasource.name,
server=_server, provider=_provider,
properties=parse_properties(datasource.properties)))
return datasources
def messagings(cls, provider=None, server=None):
messagings = []
view = _get_messagings_page(provider=provider, server=server)
for _ in view.entities.paginator.pages():
for row in view.entities.elements:
_server = MiddlewareServer(provider=provider,
name=row.server.text)
messagings.append(
MiddlewareMessaging(
provider=provider,
server=_server,
name=row.messaging_name.text,
messaging_type=row.messaging_type.text))
return messagings
def messaging_in_db(self):
messaging = _db_select_query(name=self.name, server=self.server,
nativeid=self.nativeid).first()
if messaging:
_server = MiddlewareServer(name=messaging.server_name, provider=self.provider)
return MiddlewareMessaging(
provider=self.provider,
server=_server,
db_id=messaging.id,
nativeid=messaging.nativeid,
name=messaging.name,
messaging_type=messaging.messaging_type,
properties=parse_properties(messaging.properties))
return None
def test_list_server_datasources():
"""Gets servers list and tests datasources list for each server
Steps:
* Get servers list from UI
* Get datasources list from UI of server
* Get datasources list from Database of server
* Compare size of all the list [UI, Database]
"""
servers = MiddlewareServer.servers()
assert len(servers) > 0, "There is no server(s) available in UI"
for server in get_random_list(servers, ITEMS_LIMIT):
ui_dses = _get_datasources_set(MiddlewareDatasource.datasources(server=server))
db_dses = _get_datasources_set(MiddlewareDatasource.datasources_in_db(server=server))
assert ui_dses == db_dses, \
("Lists of datasources mismatch! UI:{}, DB:{}".format(ui_dses, db_dses))
def deployments(cls, provider=None, server=None):
deployments = []
view = _get_deployments_page(provider=provider, server=server)
_provider = provider # In deployment UI, we cannot get provider name on list all page
for _ in view.entities.paginator.pages():
for row in view.entities.elements:
_server = MiddlewareServer(provider=provider,
name=row.server.text,
hostname=row.host_name.text)
deployments.append(
MiddlewareDeployment(provider=_provider,
server=_server,
name=row.deployment_name.text,
hostname=row.host_name.text,
status=row.status.text))
return deployments
def test_tags(provider):
"""Tests tags in server page
Steps:
* Select a server randomly from database
* Run `validate_tags` with `tags` input
"""
tags = [
Tag(category=Category(display_name='Environment', single_value=True), display_name='Test'),
Tag(category=Category(display_name='Location', single_value=True), display_name='New York'),
Tag(category=Category(display_name='Workload', single_value=False),
display_name='Application Servers'),
]
servers_db = MiddlewareServer.servers_in_db(provider=provider)
assert len(servers_db) > 0, "There is no server(s) available in DB"
server = get_random_list(servers_db, 1)[0]
server.validate_tags(tags=tags)
def test_tags(provider):
"""Tests tags in server page
Steps:
* Select a server randomly from database
* Run `validate_tags` with `tags` input
"""
tags = [
Tag(category=Category(display_name='Environment', single_value=True), display_name='Test'),
Tag(category=Category(display_name='Location', single_value=True), display_name='New York'),
Tag(category=Category(display_name='Workload', single_value=False),
display_name='Application Servers'),
]
servers_db = MiddlewareServer.servers_in_db(provider=provider)
assert len(servers_db) > 0, "There is no server(s) available in DB"
server = get_random_list(servers_db, 1)[0]
server.validate_tags(tags=tags)
def test_list_server_datasources():
"""Gets servers list and tests datasources list for each server
Steps:
* Get servers list from UI
* Get datasources list from UI of server
* Get datasources list from Database of server
* Compare size of all the list [UI, Database]
"""
servers = MiddlewareServer.servers()
assert len(servers) > 0, "There is no server(s) available in UI"
for server in get_random_list(servers, ITEMS_LIMIT):
ui_dses = _get_datasources_set(
MiddlewareDatasource.datasources(server=server))
db_dses = _get_datasources_set(
MiddlewareDatasource.datasources_in_db(server=server))
assert ui_dses == db_dses, \
("Lists of datasources mismatch! UI:{}, DB:{}".format(ui_dses, db_dses))
def _datasources_in_mgmt(cls, provider, server=None):
datasources = []
rows = provider.mgmt.inventory.list_server_datasource()
for datasource in rows:
_server = MiddlewareServer(name=get_server_name(datasource.path),
feed=datasource.path.feed_id,
provider=provider)
_include = False
if server:
if server.name == _server.name:
_include = True if not server.feed else server.feed == _server.feed
else:
_include = True
if _include:
datasources.append(MiddlewareDatasource(nativeid=datasource.id,
name=datasource.name,
server=_server,
provider=provider))
return datasources
def _datasources_in_mgmt(cls, provider, server=None):
datasources = []
rows = provider.mgmt.list_server_datasource()
for datasource in rows:
_server = MiddlewareServer(name=re.sub(r'~~$', '', datasource.path.resource[0]),
feed=datasource.path.feed,
provider=provider)
_include = False
if server:
if server.name == _server.name:
_include = True if not server.feed else server.feed == _server.feed
else:
_include = True
if _include:
datasources.append(MiddlewareDatasource(nativeid=datasource.id,
name=datasource.name,
server=_server,
provider=provider))
return datasources
def _deployments_in_mgmt(cls, provider, server=None):
deployments = []
rows = provider.mgmt.list_server_deployment()
for deployment in rows:
_server = MiddlewareServer(name=re.sub(r'~~$', '', deployment.path.resource_id[0]),
feed=deployment.path.feed_id,
provider=provider)
_include = False
if server:
if server.name == _server.name:
_include = True if not server.feed else server.feed == _server.feed
else:
_include = True
if _include:
deployments.append(MiddlewareDeployment(provider=provider, server=_server,
nativeid=deployment.id,
name=deployment.name))
return deployments
def test_topology_server_hierarchy(provider):
"""Tests all server's hierarchical content in topology
Steps:
* Read Servers in topology.
* For each server read elements in topology.
* Compare elements from topology with server's elements from DB.
"""
# reload topology page to make sure all elements are loaded
provider.topology.reload()
provider.topology.refresh()
for ui_server in provider.topology.elements(element_type='MiddlewareServer'):
elements = []
server = MiddlewareServer.servers_in_db(name=ui_server.name)[0]
elements.extend(MiddlewareDeployment.deployments_in_db(server, provider, strict=False))
elements.extend(MiddlewareDatasource.datasources_in_db(server, provider, strict=False))
elements.extend(MiddlewareMessaging.messagings_in_db(server, provider, strict=False))
verify_elements_included(elements, ui_server.children)
def messagings_in_db(cls, server=None, provider=None, strict=True):
messagings = []
rows = _db_select_query(server=server, provider=provider).all()
_provider = provider
for messaging in rows:
if strict:
_provider = get_crud_by_name(messaging.provider_name)
_server = MiddlewareServer(name=messaging.server_name,
feed=messaging.feed,
provider=provider)
messagings.append(
MiddlewareMessaging(nativeid=messaging.nativeid,
name=messaging.name,
db_id=messaging.id,
server=_server,
provider=_provider,
messaging_type=messaging.messaging_type,
properties=parse_properties(
messaging.properties)))
return messagings
def test_server_details(provider):
"""Tests server details on UI
Steps:
* Get servers list from UI
* Select each server details in UI
* Compare selected server UI details with CFME database and MGMT system
"""
server_list = MiddlewareServer.servers(provider=provider)
for server in get_random_list(server_list, 1):
srv_ui = server.server(method='ui')
srv_db = server.server(method='db')
srv_mgmt = srv_ui.server(method='mgmt')
assert srv_ui, "Server was not found in UI"
assert srv_db, "Server was not found in DB"
assert srv_mgmt, "Server was not found in MGMT system"
assert srv_ui.name == srv_db.name == srv_mgmt.name, \
("server name does not match between UI:{}, DB:{}, MGMT:{}"
.format(srv_ui.name, srv_db.name, srv_mgmt.name))
srv_db.validate_properties()
srv_mgmt.validate_properties()
def test_server_stop(provider):
"""Tests server reload operation on UI
Steps:
* Get servers list from UI
* Chooses Wildfly server from list
* Invokes 'Stop Server' toolbar operation
* Checks that server status is not running in UI, in DB and in MGMT.
* Invokes 'Start Server' toolbar operation
* Waits for some time
* Checks that server status is running in UI, in DB and in MGMT.
"""
server_list = MiddlewareServer.servers(provider=provider)
for _server in server_list:
if _server.product != 'Hawkular':
server = _server
break
assert server, 'Wildfly server was not found in servers list'
_check_server_running(server)
server.stop_server()
flash.assert_success_message('Stop initiated for selected server(s)')
_check_server_stopped(server)
server.start_server()
_check_server_running(server)
def get_random_server(provider):
servers = MiddlewareServer.servers_in_db(provider=provider, strict=False)
assert len(servers) > 0, "There is no server(s) available in DB"
return get_random_list(servers, 1)[0]
def get_server(provider, product):
for server in MiddlewareServer.servers(provider=provider):
if server.product == product:
return server
else:
raise ValueError('{} server was not found in servers list'.format(provider))
def server_group_servers(provider, server_group):
return MiddlewareServer.servers_in_db(provider=provider, server_group=server_group)
def get_random_server(provider):
servers = MiddlewareServer.servers(provider=provider)
assert len(servers) > 0, "There is no server(s) available in UI"
return get_random_list(servers, 1)[0]
