def test_delete_users_uid_impersonate():
logger.info("DELETE /users/{ userUid }/impersonate - Positive Test")
response = delete('/users/' + userid + '/impersonate')
responseTest(response.status, 200)
responseTest(response.body, 'sessionToken')
def test_delete_users_uid():
logger.info("DELETE /users/{ userUid } - Positive Test")
print(userid)
response = delete('/users/' + userid)
print (response.body)
responseTest(response.body['message'], 'Success')
responseTest(response.status, 200)
def test_post_login():
logger.info("POST /login - Positive Test")
head = {
'Content-Type': 'application/json',
'x-api-key': ecqa_helpers.environ
}
creds = {'userName': ecqa_helpers.uname, 'password': ecqa_helpers.pword}
response = requests.post(ecqa_helpers.envUrl + '/login',
headers=head,
json=creds)
for _ in range(3):
if response.status_code != 504:
break
response = requests.post(ecqa_helpers.envUrl + '/login',
headers=head,
json=creds)
print(
"Login Test 1st Valid Account: Expected Response Code is 200, Actual Response Code is",
response.status_code)
responseTest(response.status_code, 200)
responseTest(type(response.json()['sessionToken']), str)
global TOKEN
TOKEN = response.json()['sessionToken']
def test_get_users():
logger.info("GET /users - Positive Test")
response = get('/users')
responseTest(response.status, 200)
print (response.body)
def test_post_reset_password3():
logger.info("POST /reset-password - Positive Test (Exists)")
payload = {"uid": userid, "newPassword": "******"}
response = post('/reset-password', payload)
responseTest(response.status, 200)
responseTest(response.body['message'], "Success")
def test_get_students():
logger.info("GET /students - Positive Test")
response = get('/students')
responseTest(response.status, 200)
global student_key
student_key = (response.body[0]['student_key'])
print(response.body)
def test_post_users_uid_impersonate():
logger.info("POST /users/{ userUid }/impersonate - Positive Test")
response = post('/users/' + userid + '/impersonate', {})
responseTest(response.status, 200)
responseTest(response.body, 'sessionToken')
ecqa_helpers.AUTHTOKEN = response.body['sessionToken']
def test_get_students_key_include_appstatus_checklist_fafsa():
logger.info(
"GET /students{student_key}include application_status,checklist,fafsa - Positive Test"
)
response = get('/students/' + str(student_key) +
'?include=application_status,checklist,fafsa')
responseTest(response.status, 200)
print(response.body)
def test_post_reset_password2():
logger.info("POST /reset-password - Positive Test (Exists)")
payload = {
"newPassword": "******",
"verificationCode": verificationcode
}
response = post('/reset-password', payload)
responseTest(response.status, 200)
responseTest(response.body['message'], "Success")
def test_post_reset_password4():
logger.info("POST /reset-password - Positive Test (Exists)")
head = {
'Content-Type': 'application/json',
'x-api-key': ecqa_helpers.environ,
'Authorization': 'JWT ' + TOKEN
}
creds = {"newPassword": "******"}
response = requests.post(ecqa_helpers.envUrl + '/reset-password',
headers=head,
json=creds)
responseTest(response.status_code, 200)
def test_get_module_access_yes_access():
logger.info("GET /authorize-module - No Access to ReadUsers Module Test")
responseTest(type(TOKEN), str)
head = {
'Content-Type': 'application/json',
'x-api-key': ecqa_helpers.environ,
'Authorization': 'JWT ' + TOKEN
}
response = requests.get(ecqa_helpers.envUrl +
'/authorize-module/encourage.users.readlist',
headers=head)
print(
"Read User Module No Access Test: Expected Response Code is 200, Actual Response Code is",
response.status_code)
responseTest(response.status_code, 200)
def test_post_forgot_password():
logger.info("POST /forgot-password - Positive Test")
head = {
'Content-Type': 'application/json',
'x-api-key': ecqa_helpers.environ
}
creds = {'credential': newuemailname}
response = requests.post(ecqa_helpers.envUrl + '/forgot-password',
headers=head,
json=creds)
for _ in range(3):
if response.status_code != 504:
break
response = requests.post(ecqa_helpers.envUrl + '/forgot-password',
headers=head,
json=creds)
print(
"Forgot Password Test: Expected Response Code is 200, Actual Response Code is",
response.status_code)
responseTest(response.status_code, 200)
def test_verify_fname_db():
logger.info("Verifying Updated FirstName")
try:
connection = psycopg2.connect(user=ecqa_helpers.pguser,
password=ecqa_helpers.pgpassword,
host=ecqa_helpers.pghost,
port=ecqa_helpers.pgport,
database=ecqa_helpers.pgdatabase)
cursor = connection.cursor()
# Print PostgreSQL Connection properties
print(connection.get_dsn_parameters(), "\n")
# Print PostgreSQL version
cursor.execute("SELECT version();")
record = cursor.fetchone()
print("You are connected to - ", record, "\n")
cursor.execute("""SELECT * FROM public."User" where "UserName" = %s;""", [newuname, ])
query_results = cursor.fetchall()
print(query_results)
for x in query_results:
print(x[4])
responseTest ((x[4]), "PythonFirstNameUpdated")
except (Exception, psycopg2.Error) as error:
print("Error while connecting to PostgreSQL", error)
finally:
# closing database connection.
if (connection):
cursor.close()
connection.close()
print("PostgreSQL connection is closed")
def test_post_validate_email():
logger.info("POST /validate-email - Positive Test (Exists)")
payload = {'email': newuemailname}
response = post('/validate-email', payload)
responseTest(response.status, 200)
responseTest(response.body['isEmailUnique'], False)
logger.info("POST /validate-email - Positive Test (Does Not Exist)")
payload = {'email': '*****@*****.**'}
response = post('/validate-email', payload)
responseTest(response.status, 200)
responseTest(response.body['isEmailUnique'], True)
def test_put_users_uid():
logger.info("PUT /users/{ userUid } - Positive Test")
payload = {
"firstName": "PythonFirstNameUpdated",
"lastName": "PythonLastName",
"userName": newuname,
"status": "Active",
"email": newuemailname
}
response = put('/users/' + userid, payload)
responseTest(response.status, 200)
responseTest(response.body['uid'], userid)
responseTest(response.body['status'], 'Active')
def test_get_refresh_token():
logger.info("GET /refresh-token - Positive Test")
responseTest(type(TOKEN), str)
head = {
'Content-Type': 'application/json',
'x-api-key': ecqa_helpers.environ,
'Authorization': 'JWT ' + TOKEN
}
response = requests.get(ecqa_helpers.envUrl + '/refresh-token',
headers=head)
print(
"Refresh Token Test: Expected Response Code is 200, Actual Response Code is",
response.status_code)
responseTest(response.status_code, 200)
responseTest(type(response.json()['sessionToken']), str)
responseNegTest(response.json()['sessionToken'], TOKEN)
def test_post_validate_username():
logger.info("POST /validate-username - Positive Test (Exists)")
payload = {'userName': newuname}
response = post('/validate-username', payload)
responseTest(response.status, 200)
responseTest(response.body['isUserNameUnique'], False)
responseTest(response.body['isUserNameValid'], True)
logger.info("POST /validate-username - Positive Test (Does Not Exist)")
payload = {'userName': '******'}
response = post('/validate-username', payload)
responseTest(response.status, 200)
responseTest(response.body['isUserNameUnique'], True)
responseTest(response.body['isUserNameValid'], True)
logger.info("POST /validate-username - Positive Test (Invalid)")
payload = {'userName': '******'}
response = post('/validate-username', payload)
responseTest(response.status, 200)
responseTest(response.body['isUserNameUnique'], True)
responseTest(response.body['isUserNameValid'], False)
def test_get_users_uid():
logger.info("GET /users/{ userUid } - Positive Test")
response = get('/users/' + userid)
responseTest(response.status, 200)
def test_post_activate():
logger.info("POST /activate-user - Positive Test")
global userid
global verificationcode
global emailaddress
try:
connection = psycopg2.connect(user=ecqa_helpers.pguser,
password=ecqa_helpers.pgpassword,
host=ecqa_helpers.pghost,
port=ecqa_helpers.pgport,
database=ecqa_helpers.pgdatabase)
cursor = connection.cursor()
# Print PostgreSQL Connection properties
print(connection.get_dsn_parameters(), "\n")
# Print PostgreSQL version
cursor.execute("SELECT version();")
record = cursor.fetchone()
print("You are connected to - ", record, "\n")
cursor.execute(
"""SELECT * FROM public."User" where "UserName" = %s;""", [
newuname,
])
query_results = cursor.fetchall()
print(query_results)
for x in query_results:
print(x[0])
print(x[2])
print(x[7])
userid = (x[0])
verificationcode = (x[2])
emailaddress = (x[7])
except (Exception, psycopg2.Error) as error:
print("Error while connecting to PostgreSQL", error)
finally:
#closing database connection.
if (connection):
cursor.close()
connection.close()
print("PostgreSQL connection is closed")
head = {
'Content-Type': 'application/json',
'x-api-key': ecqa_helpers.environ,
'Authorization': 'JWT ' + TOKEN
}
creds = {
'verificationCode': verificationcode,
'userName': newuname,
'password': ecqa_helpers.pword2,
'acceptedTerms': 'true'
}
##########Post to Activate the User#########################
response = requests.post(ecqa_helpers.envUrl + '/activate-user',
headers=head,
json=creds)
for _ in range(3):
if response.status_code != 504:
break
response = requests.post(ecqa_helpers.envUrl + '/login',
headers=head,
json=creds)
print(
"Login Test 1st Valid Account: Expected Response Code is 200, Actual Response Code is",
response.status_code)
responseTest(response.status_code, 200)
