def test_post_colleges_filter(): logger.info("POST /colleges/filter - Positive Test") payload = {"mcocids": [342, 306, 308]} response = post('/colleges/filter', payload) print(response) responseTest(response.status, 200)
def test_account_verification_validate(): logger.info( "POST /account_verification/validate?authentication_id={Authentication_ID} - Positive Test" ) payload = {"zip": Zip, "date_of_birth": Bday} response = post( '/account_verification/validate?authentication_id=' + Authentication_ID, payload) responseTest(response.status, 200) print(response.body) ##########Verifying the user's isautologin is updated to 1####################333 mydb = pyodbc.connect('Driver={SQL Server};' 'Server=' + ss_helpers.dbserv + ';' 'DB=mco;' 'user='******';' 'pwd=' + ss_helpers.dbpword + ';') mycursor = mydb.cursor() mycursor.execute( "select * from MCO.Core.entityuser where authenticationid=?", (Authentication_ID)) myresult = mycursor.fetchall() for x in myresult: print(x) responseTest(x[3], True)
def test_get_colleges_offset_limit_search(): logger.info("GET /colleges - Positive Test") response = get('/colleges?offset=0&limit=10&search=texas') responseTest(response.status, 200) print(response.body)
def test_get_high_schools_searchcriteria(): logger.info("GET /high_schools - Positive Test") response = get('/high_schools?search=a%20%26%20m&limit=100&offset=0') responseTest(response.status, 200) print(response.body)
def test_delete_account_verification_email(): logger.info( "DELETE /account_verification?authentication_id={Authentication_ID} - Positive Test" ) head = { 'Content-Type': 'application/json', 'x-api-key': ss_helpers.environ, } response = delete('/account_verification?authentication_id=' + Authentication_ID) responseTest(response.status, 200) print(response.body) ##########Verifying the user's email is deleted####################333 mydb = pyodbc.connect('Driver={SQL Server};' 'Server=' + ss_helpers.dbserv + ';' 'DB=mco;' 'user='******';' 'pwd=' + ss_helpers.dbpword + ';') mycursor = mydb.cursor() mycursor.execute( "select StudentProfile.AuthenticationID, StudentProfile.EmailAddress from MCO.Api.StudentProfile where authenticationid=?", (Authentication_ID)) myresult = mycursor.fetchall() for x in myresult: print(x) assert x[1] == None
def test_get_high_schools_hs_id(): logger.info("GET /high_schools{hs_id} - Positive Test") response = get('/high_schools/HS017655') responseTest(response.status, 200) print(response.body)
def test_post_student_accounts_filter(): logger.info("POST /student_accounts/filter - Positive Test") payload = {"email": newuemailname, "password": "******"} response = post('/student_accounts/filter', payload) print(response.body) responseTest(response.status, 200)
def test_post_student_accounts(): logger.info("POST /student_accounts - Positive Test") payload = { "survey_year": 2020, "is_approved": False, "is_active_login": False, "email": newuemailname, "password": "******", "first_name": "f_name", "last_name": "lname", "date_of_birth": "07-07-2002" } response = post('/student_accounts', payload) print(response.body) responseTest(response.status, 201) global student_key global user_id global auth_id student_key = response.body['student_key'] user_id = response.body['user_id'] auth_id = response.body['authentication_id'] print(student_key)
def test_get_encourage_user(): logger.info("GET /encourage_users/{entitykey} - Positive Test") response = get('/encourage_users/' + MentorEntityKey) responseTest(response.status, 200) print(response.body)
def test_get_college_matching(): logger.info("GET /college_matching/trigger - Positive Test") payload = {"student_key": 966365098} response = post('/college_matching/trigger', payload) responseTest(response.status, 202)
def test_get_survey_questions(): logger.info( "GET /survey_questions?year=2021&editions=mco,mop - Positive Test") response = get('/survey_questions?year=2021&editions=mco,mop') responseTest(response.status, 200) print(response.body)
def test_get_lead_generation_mcocid(): logger.info("GET /lead_generation/{mcocid} - Positive Test") response = get('/lead_generation/10692') responseTest(response.status, 200) print(response.body)
def test_get_lead_generation_student(): logger.info("GET /lead_generation/student/{authentication_id} - Positive Test") response = get('/lead_generation/student/53276DD6-6865-4CCD-B9BF-7D8E10BDCF92') responseTest(response.status, 200) print(response.body)
def test_post_emailsettings_collegeoptout(): logger.info("POST /email_settings/college_opt_out - Positive Test") payload = {"authentication_id": Authentication_ID, "mcocid": 10064} response = post('/email_settings/college_opt_out', payload) print(response) responseTest(response.status, 200)
def test_getstudents(): logger.info("GET /students/{student_key} - Positive Test") response = get('/students/966365098') responseTest(response.status, 200) print (response.body)
def test_email_settings_authentication_id(): logger.info("GET /email_settings?authentication_id={Authentication_ID} - Positive Test") response = get('/email_settings?authentication_id=' + Authentication_ID) responseTest(response.status, 200) print(response.body)
def test_getstudents_surveyanswers(): logger.info("GET /students/{student_key}/survey_answers?year=2019&editions=mco,mop - Positive Test") response = get('/students/966365098/survey_answers?year=2019&editions=mco,mop') responseTest(response.status, 200) print (response.body)
def test_get_campaign_validate_student_pin(): logger.info("GET /campaign/student/validate/{pin} - Positive Test") response = get('/campaign/student/validate/R3GF9Q') responseTest(response.status, 200) print(response.body) responseTest(response.body['student_key'], 966365098)
def test_get_esurvey(): logger.info("GET /esurvey/in_class_survey/{document_name} - Positive Test") response = get('/esurvey/in_class_survey/ACTFL') responseTest(response.status, 200) print(response.body) responseTest(response.body['document_name'], 'ACTFL')
def test_get_encourage_user_relationship(): logger.info( "GET /encourage_users/{entitykey}/relationships - Positive Test") response = get('/encourage_users/' + MentorEntityKey + '/relationships') responseTest(response.status, 200) print(response.body)
def test_get_colleges_mcocid(): logger.info("GET /colleges - Positive Test") response = get('/colleges/1466') responseTest(response.status, 200) print(response.body) responseTest(response.body['mcocid'], 1466)
def test_email_settings_entitytype(): logger.info("GET /email_settings/options?entity_type_key={entity_type - Positive Test") # EntityType 3 is a High school student response = get('/email_settings/options?entity_type_key=3') responseTest(response.status, 200) print(response.body)
def test_get_campaign_campaignname(): logger.info("GET /campaign/{campaign_name} - Positive Test") response = get('/campaign/Culinary-Institute-of-America') responseTest(response.status, 200) print(response.body) responseTest(response.body['campaign_name'], "Culinary-Institute-of-America")
def test_getstudents(): logger.info("GET /students/{student_key} - Positive Test") response = get('/students/' + EntityKey) responseTest(response.status, 200) print(response.body) global Authentication_ID Authentication_ID = response.body['authentication_id']
def test_account_verification(): logger.info( "GET /account_verification/?authentication_id={Authentication_ID} - Positive Test" ) response = get('/account_verification/?authentication_id=' + auth_id) responseTest(response.status, 200) print(response.body)
def test_account_verification_error(): logger.info( "GET /account_verification/?authentication_id={Authentication_ID} - Positive Test" ) response = get('/account_verification/?authentication_id=' + auth_id) responseTest(response.status, 404) responseTest(response.body['error_code'], "ACCOUNT_NOT_FOUND") print(response.body)
def test_delete_encourage_user_relationship(): logger.info( "GET /encourage_users/<entity_key>/relationships/<entity_key>?relationship_type_keys=8,9 - Positive Test" ) response = delete('/encourage_users/' + MentorEntityKey + '/relationships/' + StudentEntityKey) responseTest(response.status, 204) print(response.body)
def test_poststudents(): logger.info("POST /students/filter - Positive Test") payload = { "student_keys": [ 1004523128, 966365098 ] } response = post('/students/filter', payload) print(response) responseTest(response.status, 200)
def test_account_verification_is_auto_login(): logger.info( "GET /account_verification/is_auto_login?authentication_id={Authentication_ID} - Positive Test" ) response = get('/account_verification/is_auto_login?authentication_id=' + Authentication_ID) responseTest(response.status, 200) print(response.body) responseTest(response.body['is_auto_login'], True)
def test_get_encourage_user_relationship_student_search(): logger.info( "GET /encourage_users/{entitykey}/student_search - Positive Test") response = get( '/encourage_users/' + MentorEntityKey + '/students_search?relationship_type_keys=8,9&graduation_years=2020,2021,2022&search=a&limit=10&offset=0' ) responseTest(response.status, 200) print(response.body)