blob: 9dd6f4af2ae10fb765afd22eea3131e045a771fe (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
*** Settings ***
Documentation The main interface for interacting with Mariadb Galera. It contains the keywords which will login to the Mariadb Galera pod and validates SO databases connectivity.
Library Collections
Library OperatingSystem
Library String
*** Variables ***
&{MARIADB_GALERA_CREDENTIALS} user=root password=secretpassword
@{MARIADB_GALERA_SO_DATABASES} catalogdb requestdb camundabpmn
@{CONNECTION_ERROR_MESSAGE} Can't connect No such file or directory command terminated
${POD_LOGGED_IN_MESSAGE} logged into Mariadb Galera pod
${MYSQL_STATUS_MESSAGE} Current database:
*** Keywords ***
Fetch Namespace
[Documentation] This keyword is responsible for fetching and returning the value of namespace from the provided Global IP Address variable.
[Arguments] ${GLOBAL_INJECTED_SO_BPMN_IP_ADDR}
${namespace}= Evaluate "${GLOBAL_INJECTED_SO_BPMN_IP_ADDR}".split(".")[-1]
[Return] ${namespace}
Check for Mariadb Galera Pod Connection
[Documentation] This keyword is responsible for logging into the Mariadb Galera pod and check if we can login to the Mariadb Galera pod. To verify we print a string and match the output whether the same string was returned or not.
[Arguments] ${message}=${POD_LOGGED_IN_MESSAGE}
${namespace}= Fetch Namespace ${GLOBAL_INJECTED_SO_BPMN_IP_ADDR}
# Extracting the mariadb galera pod and storing it into a variable
${mariadb_pod}= Run kubectl -n ${namespace} get po -o name | grep -w 'mariadb-galera-[0-9]'
${pod_connectivity_command}= Catenate kubectl -n ${namespace} exec ${mariadb_pod} -- sh -c "echo ${message}"
${pod_connectivity_output}= Run ${pod_connectivity_command}
# The output should contain the exact same message which we are printing by logging into the Mariadb Galera pod
Should Contain ${pod_connectivity_output} ${message} ignore_case=True
Check for SO Databases Connection
[Documentation] This keyword is responsible for logging into the Mariadb Galera pod and check if we can login to the SO MySQL Databases.
${namespace}= Fetch Namespace ${GLOBAL_INJECTED_SO_BPMN_IP_ADDR}
# Extracting the mariadb galera pod and storing it into a variable
${mariadb_pod}= Run kubectl -n ${namespace} get po -o name | grep -w 'mariadb-galera-[0-9]'
# Looping through all 3 mariadb galera databases (catalogdb, requestdb and camundabpmn) to validate SO connectivity
FOR ${index} IN RANGE 3
${mysql_connectivity_command}= Catenate kubectl -n ${namespace} exec ${mariadb_pod} -- sh
... -c "mysql -u ${MARIADB_GALERA_CREDENTIALS}[user] -p${MARIADB_GALERA_CREDENTIALS}[password] ${MARIADB_GALERA_SO_DATABASES}[${index}]
... -e 'status'"
${mysql_connectivity_output}= Run ${mysql_connectivity_command}
# The output should contain the message that is having SO databases name.
Should Contain ${mysql_connectivity_output} ${MYSQL_STATUS_MESSAGE} ${MARIADB_GALERA_SO_DATABASES}[${index}] ignore_case=True
Should Not Contain Any ${CONNECTION_ERROR_MESSAGE} ${mysql_connectivity_output} ignore_case=True
END
|
