def test_download_single_existing_audience(self):
section = self.__class__.__name__
project_name = self.configAB["DownloadAudience"]["project_name"]
audience_name = self.configAB["DownloadAudience"]["audience_name"]
# Delete existing file in workspace
path = self.workspace + "\\" + project_name + " - " + audience_name + ".xlsx"
print(path)
print(glob.glob(path))
for file in glob.glob(path):
os.remove(file)
home_page = HomePage(self.webdriver, self.config)
home_page.searchProjects(project_name)
# Download Audience
project_page = ProjectPage(self.webdriver, self.config)
project_page.audience_menu_icon(audience_name).click()
project_page.audience_download_icon(audience_name).click()
project_page.audience_data(audience_name).click()
sleep(30)
path1 = self.workspace + "\\" + project_name + " - " + audience_name + ".xlsx"
check = os.path.exists(path1)
self.assertEqual(check, True, "Audience download failed")
for file in glob.glob(path1):
excel_sheet = xlrd.open_workbook(file)
sheet1 = excel_sheet.sheet_by_index(0)
row = sheet1.row_slice(0)
excel_header = row[0].value
sheet = excel_sheet.sheet_by_index(0)
Cols = ""
for i in range(sheet1.ncols):
Cols = Cols + str(sheet.cell_value(1, i))
print(excel_header)
row_count = sheet.nrows
print(Cols)
self.assertEqual(excel_header,
"Location Data for \"DNT_Auto_Aud02\"",
"Column header not matching")
def test_download_audiences(self):
project_name = self.configAB["Aqfer"]["project_name"]
path = os.path.join('testdata', 'sidebar.json')
print("location:" + path)
project_page = ProjectPage(self.webdriver, self.config)
audience_page = AudiencePage(self.webdriver, self.config)
home_page = HomePage(self.webdriver, self.config)
with open(path) as file:
data = json.load(file)
for item in range(len(data)):
link = data[item]["link"]
# Project selection
new_project_name = project_name + '_' + link + '_QA'
print(new_project_name)
sleep(5)
home_page.searchProjects(new_project_name)
sleep(10)
num_aud_panel = len(
self.webdriver.find_elements_by_xpath(
"//div[@class = 'audiences-section']//audience-panel"))
print(num_aud_panel)
for i in range(1, num_aud_panel + 1):
audience_name = self.webdriver.find_element_by_xpath(
"(//div[@class = 'audience-title ng-binding'])[position()="
+ str(i) + "]").click()
# download_link = self.webdriver.find_element_by_xpath("(//div[@class = 'audiences-section']//div[contains(@class,'download-button')])[position()= "+str(i)+"]")
# download_link.click()
# audience_menu_icon = self.webdriver.find_element_by_xpath("//div[text()='" + audience_name + "']//following::div[1]")
self.webdriver.execute_script(
"arguments[0].click();",
project_page.audience_menu_icon(audience_name))
self.webdriver.execute_script(
"arguments[0].click();",
project_page.audience_download_icon(audience_name))
self.webdriver.execute_script(
"arguments[0].click();",
project_page.audience_data(audience_name))
