diff options
| author |   waynedunican <wayne.dunican@est.tech> | 2022-03-16 08:10:54 +0000 |
|---|---|---|
| committer | Wayne Dunican <wayne.dunican@est.tech> | 2022-03-30 09:36:37 +0000 |
| commit | 74501197005fb7051b95f6614ef60605373fd521 (patch) | |
| tree | 5be7fedf20333f560faf9aac9d292f7c5a140464 /csit/db-migrator/tests/db-migrator-test.robot | |
| parent | 7a58ae144338d6b8ecf9904c05a62ee00ee0538b (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.robot | 34 |
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 |