from selenium import webdriver from selenium.webdriver.common.desired_capabilities import DesiredCapabilities import pymysql as mysql import datetime import time js = "window.open('{}','_blank');" d = DesiredCapabilities.CHROME d['goog:loggingPrefs'] = {'browser': 'ALL'} driver = webdriver.Chrome(desired_capabilities=d) driver.get('https://zhidao.baidu.com/question/1898371488391506460.html') remarks = 'chrome, xs.labking.net, 8095, /SampleHandler loginedwelcome.html' #time.sleep(5) # print messages # printList = []; for entry in driver.get_log('browser'): # printList.append(entry['message']); # 连接到数据库,.connect()返回一个connection对象 db = mysql.connect(host="localhost", port=3306, user="root", passwd="root", db="hongqiaowebtext") sql = '''insert into hongqiaowebwebtest.webtestversion (time, consoleLog, Resolve,remarks) values(%s, %s, %s, %s)''' current_time = datetime.datetime.now() time = str(current_time) Resolve = '否' # entry1 = ''.join(printList) entry1 = ''.join(repr(entry)) # 用db(connection对象)创建一个游标 cur = db.cursor() # 用游标cur执行一个数据库的查询命令,用result来接收返回值 result = cur.execute(sql, (time, entry1, Resolve, remarks)) print(result) # 提交当前事务,才会提交到数据库,可以尝试只执行上面的代码,看看结果 db.commit() # 关闭游标对象 cur.close() # 关闭连接 db.close() print(entry)
python selenium获取web控制台信息并存入数据库
最新推荐文章于 2024-04-29 17:55:25 发布