分析Chrome 中浏览记录，获取时间，转换时间戳，使用谷歌浏览器驱动，自动查看浏览记录

代码

import sqlite3 as db
import time
import json
import datetime
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.support import expected_conditions as EC
from selenium.webdriver.support.wait import WebDriverWait
from selenium.webdriver.chrome.options import Options
# 从SQLite文件中读取数据
def readFronSqllite(db_path,exectCmd):
    conn = db.connect(db_path)  # 该 API 打开一个到 SQLite 数据库文件 database 的链接，如果数据库成功打开，则返回一个连接对象
    cursor=conn.cursor()        # 该例程创建一个 cursor，将在 Python 数据库编程中用到。
    conn.row_factory=db.Row     # 可访问列信息
    cursor.execute(exectCmd)    #该例程执行一个 SQL 语句
    rows=cursor.fetchall()      #该例程获取查询结果集中所有（剩余）的行，返回一个列表。当没有可用的行时，则返回一个空的列表。
    return rows
    #print(rows[0][2]) # 选择某一列数据


def Trans_time(visite_time):
    true_time = visite_time / 1000000 - 11644473600
    time_normal = time.gmtime(true_time)  # 转换为普通时间格式（时间数组）
    dt = time.strftime("%Y-%m-%d", time_normal)  # 格式化为需要的格式
    # print(dt)
    from_dt = datetime.datetime(2021, 10, 4)
    start_date = datetime.datetime.strptime(dt, "%Y-%m-%d")
    if from_dt>start_date:
        print(start_date)
        dt="!!"
    return dt

def Get_condition_json():
    article_info = {}
    Data = []
    rows = readFronSqllite('./data/History.db', "select url,title,last_visit_time from urls")
    i = 0
    for row in rows:
        try:
            if ('github' in row[0] and 'issues' in row[0]):
                data_parent_child = json.loads(json.dumps(article_info))
                data_parent_child['url'] = row[0]
                data_parent_child['title'] = row[1]
                data_parent_child['time'] = Trans_time(row[2])
                if (data_parent_child['time'] =="!!" or "search" in row[0]):
                    continue
                i = i + 1
                data_parent_child['id'] = i
                Data.append(data_parent_child)
        except:
            continue
    return Data

def Save_json(url,data):
    with open(url, "w") as f:
        json.dump(data, f)

def Open_web(url):
    js = "window.open('{}','_blank');"
    if(Chrome_num==1):
        driver.get(url)
    else:
        driver.execute_script(js.format(url))
def Save_data():
    Data=Get_condition_json()
    Save_json(json_url,Data)
    print("加载入文件完成...")
    print(Data)
def Read_data(url):
    with open(json_url, 'r') as load_f:
        Datas = json.load(load_f)
    return Datas
if __name__=="__main__":
    options = Options()
    # options.headless = True#禁止打开
    driver = webdriver.Chrome('D:\Program Apps\Google\Chrome\driver\chromedriver.exe',options=options)
    Datas=[]
    json_url="./data/data.json"
    # Save_data()

    Datas=Read_data(json_url)
    Chrome_num=0
    print(len(Datas))
    for data in Datas:
        Chrome_num=Chrome_num+1
        Num=data["id"]
        if(Num>=0 and Num<=10):
            print(data["id"])
            Open_web(data["url"])