Files
steampipe/tests/acceptance/test_files/cloud.bats

72 lines
2.9 KiB
Bash

load "$LIB_BATS_ASSERT/load.bash"
load "$LIB_BATS_SUPPORT/load.bash"
# These set of tests are skipped locally
# To run these tests locally set the SPIPETOOLS_PG_CONN_STRING and SPIPETOOLS_TOKEN env vars.
# These tests will be skipped locally unless both of the above env vars are set.
@test "connect to cloud workspace - passing the postgres connection string to workspace-database arg" {
# run steampipe query and fetch an account from the cloud workspace
run steampipe query "select account_aliases from all_aws.aws_account where account_id='632902152528'" --workspace-database $SPIPETOOLS_PG_CONN_STRING --output json
echo $output
# fetch the value of account_alias to compare
op=$(echo $output | jq '.rows[0].account_aliases[0]')
echo $op
# check if values match
assert_equal "$op" "\"nagraj-aaa\""
}
@test "connect to cloud workspace - passing the cloud-token arg and the workspace name to workspace-database arg" {
# run steampipe query and fetch an account from the cloud workspace
run steampipe query "select account_aliases from all_aws.aws_account where account_id='632902152528'" --pipes-token $SPIPETOOLS_TOKEN --workspace-database turbot-ops/clitesting --output json
echo $output
# fetch the value of account_alias to compare
op=$(echo $output | jq '.rows[0].account_aliases[0]')
echo $op
# check if values match
assert_equal "$op" "\"nagraj-aaa\""
}
@test "connect to cloud workspace - passing the cloud-host arg, the cloud-token arg and the workspace name to workspace-database arg" {
# run steampipe query and fetch an account from the cloud workspace
run steampipe query "select account_aliases from all_aws.aws_account where account_id='632902152528'" --pipes-host "pipes.turbot.com" --pipes-token $SPIPETOOLS_TOKEN --workspace-database turbot-ops/clitesting --output json
echo $output
# fetch the value of account_alias to compare
op=$(echo $output | jq '.rows[0].account_aliases[0]')
echo $op
# check if values match
assert_equal "$op" "\"nagraj-aaa\""
}
@test "connect to cloud workspace(FAILED TO CONNECT) - passing wrong postgres connection string to workspace-database arg" {
# run steampipe query using wrong connection string
run steampipe query "select account_aliases from all_aws.aws_account where account_id='632902152528'" --workspace-database abcd/efgh --output json
echo $output
# check the error message
assert_output --partial 'Error: Not authenticated for Turbot Pipes.'
}
function teardown_file() {
# list running processes
ps -ef | grep steampipe
# check if any processes are running
num=$(ps aux | grep steampipe | grep -v bats | grep -v grep | grep -v tests/acceptance | wc -l | tr -d ' ')
assert_equal $num 0
}
function setup() {
if [[ -z "${SPIPETOOLS_PG_CONN_STRING}" || -z "${SPIPETOOLS_TOKEN}" ]]; then
skip
else
echo "Both SPIPETOOLS_PG_CONN_STRING and SPIPETOOLS_TOKEN are set..."
fi
}