aboutsummaryrefslogtreecommitdiffstats
path: root/csit/db-migrator/tests/db-migrator-test.robot
diff options
context:
space:
mode:
authorwaynedunican <wayne.dunican@est.tech>2022-03-16 08:10:54 +0000
committerWayne Dunican <wayne.dunican@est.tech>2022-03-30 09:36:37 +0000
commit74501197005fb7051b95f6614ef60605373fd521 (patch)
tree5be7fedf20333f560faf9aac9d292f7c5a140464 /csit/db-migrator/tests/db-migrator-test.robot
parent7a58ae144338d6b8ecf9904c05a62ee00ee0538b (diff)
CSITs for db-migrator
- Added test to confirm databases are created - Added test for api healthcehck Issue-ID: POLICY-2715 Signed-off-by: Wayne Dunican <wayne.dunican@est.tech> Change-Id: I8ef9f67bf50d2fcbf7c7db2c78370f6b277e5993
Diffstat (limited to 'csit/db-migrator/tests/db-migrator-test.robot')
-rw-r--r--csit/db-migrator/tests/db-migrator-test.robot34
1 files changed, 34 insertions, 0 deletions
diff --git a/csit/db-migrator/tests/db-migrator-test.robot b/csit/db-migrator/tests/db-migrator-test.robot
new file mode 100644
index 00000000..44cb1553
--- /dev/null
+++ b/csit/db-migrator/tests/db-migrator-test.robot
@@ -0,0 +1,34 @@
+*** Settings ***
+Suite Setup Connect To Database psycopg2 ${DB_NAME} ${DB_USERNAME} ${DB_PASSWORD} ${POSTGRES_IP} ${DB_PORT}
+Suite Teardown Disconnect From Database
+Library DatabaseLibrary
+Library String
+Library RequestsLibrary
+Library OperatingSystem
+Library json
+Resource ${CURDIR}/../../common-library.robot
+
+*** Variables ***
+${DB_NAME} = policyadmin
+${DB_USERNAME} = policy_user
+${DB_PASSWORD} = policy_user
+${DB_PORT} = 5432
+${PGPASSWORD} = policy_user
+
+*** Keywords ***
+GetReq
+ [Arguments] ${url}
+ ${auth}= PolicyAdminAuth
+ ${resp}= PerformGetRequest ${POLICY_API_IP} ${url} 200 null ${auth}
+ [return] ${resp}
+
+*** Test Cases ***
+Test Connection
+ ${output} = Execute SQL String SELECT datname FROM pg_database WHERE datname='policyadmin';
+ Log ${output}
+ Should Be Equal As Strings ${output} None
+
+Healthcheck
+ [Documentation] Verify policy api health check
+ ${resp}= GetReq /policy/api/v1/healthcheck
+ Should Be Equal As Strings ${resp.json()['code']} 200 \ No newline at end of file