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)