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)
