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()