class TestBase(unittest.TestCase):
def setUp(self) -> None:
self.testName = unittest.TestCase.id(self)
self.logger = Logger(self.testName)
if not self.logger:
self.fail("No logger!")
self.logger.info("Test started!")
self.driver = webdriver.Chrome()
self.UtilsSelenium = UtilsSelenium(self.driver, self.logger)
self.driver.get("https://www.eobuwie.com.pl/")
WebDriverWait(self.driver, 20).until(
EC.element_to_be_clickable(mpl.main_page_login_button))
self.driver.maximize_window()
# assert self.driver.title == "Modne buty damskie, męskie, dziecięce oraz torebki | eobuwie.pl", f"Loaded page in not main page. Title is {self.driver.title} and should be Modne buty damskie, męskie, dziecięce oraz torebki | eobuwie.pl"
accept_cookies_button = self.driver.find_element(
*mpl.main_page_cookies_accept_button)
accept_cookies_close_button = self.driver.find_element(
*mpl.main_page_cookies_close_button)
if accept_cookies_button.is_displayed():
accept_cookies_close_button.click()
def tearDown(self) -> None:
self.logger.info(f"Test runner finished!")
self.driver.quit()
account_logo = display.getElementsByTagName(
'headimage')[0].childNodes[0].data # 公众号LOGO',
openid = display.getElementsByTagName(
'openid')[0].childNodes[0].data # 公众账号',
ext = display.getElementsByTagName(
'ext')[0].childNodes[0].data # 扩展请求',
doc_id = display.getElementsByTagName(
'docid')[0].childNodes[0].data # 文章ID
tpl_id = item.getElementsByTagName(
'tplid')[0].childNodes[0].data # 类型ID',
class_id = item.getElementsByTagName(
'classid')[0].childNodes[0].data # 等级ID
lastModified = item.getElementsByTagName(
'lastModified')[0].childNodes[0].data # 等级ID
lastModifiedTime = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime(float(lastModified)))
# 文章入库
sql = "insert into wd_article (article_title, article_url, article_head, article_desc, account_name, account_logo, openid, ext, doc_id, tpl_id, class_id,create_time,publish_time,status ) values ("
sql = sql + "\"" + article_title + "\",\"" + article_url_real + "\",\"" + article_head + "\",\"" + "--" + "\",\"" + account_name + "\",\"" + account_logo + "\",\"" + openid + "\",\"" + ext + "\",\"" + doc_id + "\"," + tpl_id + "," + class_id + ",sysdate(),str_to_date('" + lastModifiedTime + "','%Y-%m-%d %H:%i:%s')," + status + ")"
logger.info("【新增】公众号文章【" + (account_name.encode('utf-8')) +
"】 ,【标题】=" + (article_title.encode('utf-8')))
DBUtils.excute(sql)
def run(args):
pool = threadpool.ThreadPool(5)
requests = threadpool.makeRequests(parseArticleWithAccount, args)
[pool.putRequest(req) for req in requests]
pool.wait()
