report.html

self = <test_url_city_check.TestUrlCityVerification object at 0x000001DE7E7C59D0>
testdata = {'db_type': 'mysql', 'query_to_fetch_course_url_city': "Select distinct json_extract(s.params, '$.city_name') as city ...ct_type=1 and json_extract(s.params, '$.country_id')='6' and (s.url like 'val_city%' or s.linkable_id= val_linkable);"}

@pytest.mark.test_details("SLUB-T0000","high","Url City Verification","Prince")
def test_create_json_from_DB_for_course_program_url(self,testdata):
self._test_add_rows_in_csv()
x={}
with open("course_program_city_url.csv") as csvFile:
reader = csv.DictReader(csvFile)
for row in reader:
query_to_fetch_page_city_name = testdata['query_to_fetch_course_url_city'].replace('val_city',str(row['url'])).replace('val_linkable',str(row['linkable_id']))
query_to_store_city = db_helper.get_prod_data(query_to_fetch_page_city_name,testdata['db_type'])
city_name = list(map(itemgetter('city'), query_to_store_city))
city_name = [item.replace('"', '') for item in city_name]
#returns string where the first character is upper case, and the rest is lower case
city_name = [ i.capitalize() for i in city_name]
#returns blank quotes if city list is empty for URL else city names
if not city_name:
city_name.append("")
else:
city_name
city_url="https://www.simplilearn.com"+row['url']
x[city_url]=city_name
with open('url_new_cities.json', 'w') as outfile:
outfile.truncate(0)
json.dump(x, outfile, indent=4)
with open("course_program_city_url.csv") as csvFile:
reader = csv.DictReader(csvFile)
for row in reader:
cities=[]
url = "https://www.simplilearn.com"+row['url']
pytest.driver.get(url)
time.sleep(2)
cities=pg_university_load.check_city_present(url)
x[url]=cities
with open('url_cities.json', 'w') as outfile:
outfile.truncate(0)
json.dump(x, outfile, indent=4)
count = self.url_city_json_comparison_new()
print("value of count is :", count)
if count >= 1:
> pytest.fail(f"Missing city, hence failed")
E Failed: Missing city, hence failed

test_prod\test_url_city_check.py:71: Failed
------------------------------Captured stdout call------------------------------
key: https://www.simplilearn.com/digital-marketing/search-engine-optimization-seo-certification-training, missing values: ['Kanpur', 'Agra'] in UI key: https://www.simplilearn.com/agile-and-scrum/agile-scrum-master-certification-training, missing values: ['Indore'] in UI key: https://www.simplilearn.com/agile-and-scrum/agile-scrum-master-certification-training, missing values: ['Bhopal', 'Gurgaon', 'Hyderabad', 'Lucknow', 'Thiruvananthapuram', 'Vadodara', 'Vijayawada'] in DB key: https://www.simplilearn.com/microsoft-azure-administrator-associate-certification-training-course, missing values: ['Kolkata', 'Pune', 'Ahmedabad'] in UI value of count is : 4

self = <test_url_city_check.TestUrlCityVerification object at 0x000001DE7E925820>
testdata = {'db_type': 'mysql', 'query_to_fetch_master_url_city': "Select distinct json_extract(s.params, '$.city_name') as city ...ct_type=2 and json_extract(s.params, '$.country_id')='6' and (s.url like 'val_city%' or s.linkable_id= val_linkable);"}

@pytest.mark.test_details("SLUB-T0000","high","Url City Verification","Prince")
def test_create_json_from_DB_for_masters_program_url(self,testdata):
x={}
with open("master_program_city_url.csv") as csvFile:
reader = csv.DictReader(csvFile)
for row in reader:
query_to_fetch_page_city_name = testdata['query_to_fetch_master_url_city'].replace('val_city',str(row['url'])).replace('val_linkable',str(row['linkable_id']))
query_to_store_city = db_helper.get_prod_data(query_to_fetch_page_city_name,testdata['db_type'])
city_name = list(map(itemgetter('city'), query_to_store_city))
city_name = [item.replace('"', '') for item in city_name]
#returns string where the first character is upper case, and the rest is lower case
city_name = [ i.capitalize() for i in city_name]
#returns blank quotes if city list is empty for URL else city names
if not city_name:
city_name.append("")
else:
city_name
city_url="https://www.simplilearn.com"+row['url']
x[city_url]=city_name
with open('url_new_cities.json', 'w') as outfile:
outfile.truncate(0)
json.dump(x, outfile, indent=4)
with open("master_program_city_url.csv") as csvFile:
reader = csv.DictReader(csvFile)
for row in reader:
cities=[]
url = "https://www.simplilearn.com"+row['url']
pytest.driver.get(url)
time.sleep(2)
cities=pg_university_load.check_city_present(url)
x[url]=cities
with open('url_cities.json', 'w') as outfile:
outfile.truncate(0)
json.dump(x, outfile, indent=4)
count = self.url_city_json_comparison_new()
if count >= 1:
> pytest.fail(f"Missing city, hence failed")
E Failed: Missing city, hence failed

test_prod\test_url_city_check.py:109: Failed
------------------------------Captured stdout call------------------------------
key: https://www.simplilearn.com/quality-management/lean-six-sigma-certification-training-all-in-one-bundle, missing values: [''] in UI key: https://www.simplilearn.com/quality-management/lean-six-sigma-certification-training-all-in-one-bundle, missing values: ['Ahmedabad', 'Bangalore', 'Chennai', 'Delhi', 'Kolkata', 'Mumbai', 'Pune'] in DB key: https://www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training, missing values: ['Dehra dun'] in UI key: https://www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training, missing values: ['Dehra Dun'] in DB key: https://www.simplilearn.com/devops-engineer-masters-program-certification-training, missing values: ['Visakhapatnam'] in UI key: https://www.simplilearn.com/artificial-intelligence-masters-program-training-course, missing values: ['Shimoga'] in DB key: https://www.simplilearn.com/business-analyst-certification-training-course, missing values: ['Cochin'] in UI

self = <test_url_city_check.TestUrlCityVerification object at 0x000001DE7E99BAC0>
testdata = {'db_type': 'mysql', 'query_to_fetch_classroom_course_url_city': "Select distinct json_extract(s.params, '$.city_name'...ct_type=1 and json_extract(s.params, '$.country_id')='6' and (s.url like 'val_city%' or s.linkable_id= val_linkable);"}

@pytest.mark.test_details("SLUB-T0000","high","Url City Verification","Prince")
def test_create_json_from_DB_for_classroom_course_program_url(self,testdata):
x={}
with open("classroom_program_city_url.csv") as csvFile:
reader = csv.DictReader(csvFile)
for row in reader:
query_to_fetch_page_city_name = testdata['query_to_fetch_classroom_course_url_city'].replace('val_city',str(row['url'])).replace('val_linkable',str(row['linkable_id']))
query_to_store_city = db_helper.get_prod_data(query_to_fetch_page_city_name,testdata['db_type'])
city_name = list(map(itemgetter('city'), query_to_store_city))
city_name = [item.replace('"', '') for item in city_name]
#returns string where the first character is upper case, and the rest is lower case
city_name = [ i.capitalize() for i in city_name]
#returns blank quotes if city list is empty for URL else city names
if not city_name:
city_name.append("")
else:
city_name
city_url="https://www.simplilearn.com"+row['url']
x[city_url]=city_name
with open('url_new_cities.json', 'w') as outfile:
outfile.truncate(0)
json.dump(x, outfile, indent=4)
with open("classroom_program_city_url.csv") as csvFile:
reader = csv.DictReader(csvFile)
for row in reader:
cities=[]
url = "https://www.simplilearn.com"+row['url']
pytest.driver.get(url)
time.sleep(2)
cities=pg_university_load.check_city_present(url)
x[url]=cities
with open('url_cities.json', 'w') as outfile:
outfile.truncate(0)
json.dump(x, outfile, indent=4)
count = self.url_city_json_comparison_new()
if count >= 1:
> pytest.fail(f"Missing city, hence failed")
E Failed: Missing city, hence failed

test_prod\test_url_city_check.py:147: Failed
------------------------------Captured stdout call------------------------------
key: https://www.simplilearn.com/agile-and-scrum/csm-certification-training, missing values: ['Cochin'] in UI

self = <test_url_city_check.TestUrlCityVerification object at 0x000001DE7E9ED9D0>
testdata = {'db_type': 'mysql', 'query_to_fetch_PG_program_url_city': "Select distinct json_extract(s.params, '$.city_name') as c...ct_type=2 and json_extract(s.params, '$.country_id')='6' and (s.url like 'val_city%' or s.linkable_id= val_linkable);"}

@pytest.mark.test_details("SLUB-T0000","high","Url City Verification","Prince")
def test_create_json_from_DB_for_PG_program_url(self,testdata):
x={}
with open("PG_program_city_url.csv") as csvFile:
reader = csv.DictReader(csvFile)
for row in reader:
query_to_fetch_page_city_name = testdata['query_to_fetch_PG_program_url_city'].replace('val_city',str(row['url'])).replace('val_linkable',str(row['linkable_id']))
query_to_store_city = db_helper.get_prod_data(query_to_fetch_page_city_name,testdata['db_type'])
city_name = list(map(itemgetter('city'), query_to_store_city))
city_name = [item.replace('"', '') for item in city_name]
#returns string where the first character is upper case, and the rest is lower case
city_name = [ i.capitalize() for i in city_name]
#returns blank quotes if city list is empty for URL else city names
if not city_name:
city_name.append("")
else:
city_name
city_url="https://www.simplilearn.com"+row['url']
x[city_url]=city_name
with open('url_new_cities.json', 'w') as outfile:
outfile.truncate(0)
json.dump(x, outfile, indent=4)
with open("PG_program_city_url.csv") as csvFile:
reader = csv.DictReader(csvFile)
for row in reader:
cities=[]
url = "https://www.simplilearn.com"+row['url']
pytest.driver.get(url)
time.sleep(2)
cities=pg_university_load.check_city_present(url)
x[url]=cities
with open('url_cities.json', 'w') as outfile:
outfile.truncate(0)
json.dump(x, outfile, indent=4)
count = self.url_city_json_comparison_new()
if count >= 1:
> pytest.fail(f"Missing city, hence failed")
E Failed: Missing city, hence failed

test_prod\test_url_city_check.py:222: Failed
------------------------------Captured stdout call------------------------------
key: https://www.simplilearn.com/professional-certificate-digital-marketing, missing values: ['Dehra dun'] in UI key: https://www.simplilearn.com/professional-certificate-digital-marketing, missing values: ['Dehra Dun'] in DB