import sqlite3

# establish the connection with
# history database file which is 
# located at given location
# you can search in your system 
# for that location and provide 
# the path here
conn = sqlite3.connect("/path/to/History")

# point out at the cursor
c = conn.cursor()

# create a variable id 
# and assign 0 initially
id = 0  

# create a variable result 
# initially as True, it will
# be used to run while loop
result = True

# create a while loop and put
# result as our condition
while result:

    result = False

    # a list which is empty at first,
    # this is where all the urls will
    # be stored
    ids = []

    # we will go through our database and 
    # search for the given keyword
    for rows in c.execute("SELECT id,url FROM urls\
    WHERE url LIKE '%geeksforgeeks%'"):

        # this is just to check all
        # the urls that are being deleted
        print(rows)

        # we are first selecting the id
        id = rows[0]

        # append in ids which was initially
        # empty with the id of the selected url
        ids.append((id,))

    # execute many command which is delete
    # from urls (this is the table)
    # where id is ids (list having all the urls)
    c.executemany('DELETE from urls WHERE id = ?',ids)

    # commit the changes
    conn.commit()

# close the connection 
conn.close()

import os
import shutil
import platform

# 確定用戶數(shù)據(jù)目錄
def get_chrome_user_data_path():
    system = platform.system()
    if system == "Windows":
        return os.path.join(os.getenv('LOCALAPPDATA'), 'Google', 'Chrome', 'User Data', 'Default')
    elif system == "Darwin":  # macOS
        return os.path.join(os.path.expanduser('~'), 'Library', 'Application Support', 'Google', 'Chrome', 'Default')
    elif system == "Linux":
        return os.path.join(os.path.expanduser('~'), '.config', 'google-chrome', 'Default')
    else:
        raise Exception("Unsupported operating system")

# 清理緩存
def clear_chrome_cache():
    user_data_path = get_chrome_user_data_path()
    cache_path = os.path.join(user_data_path, 'Cache')
    media_cache_path = os.path.join(user_data_path, 'Media Cache')
    
    # 檢查緩存目錄是否存在并刪除
    if os.path.exists(cache_path):
        shutil.rmtree(cache_path)
        print("清理緩存完成！")
    else:
        print("緩存目錄不存在。")

    if os.path.exists(media_cache_path):
        shutil.rmtree(media_cache_path)
        print("清理媒體緩存完成！")
    else:
        print("媒體緩存目錄不存在。")

if __name__ == "__main__":
    clear_chrome_cache()

import os
import shutil
import platform

def clear_chrome_cache():
    # 獲取當(dāng)前系統(tǒng)的平臺(tái)
    system = platform.system()
    
    if system == 'Windows':
        cache_path = os.path.join(os.environ['LOCALAPPDATA'], r'Google\Chrome\User Data\Default\Cache')
    elif system == 'Darwin':  # macOS
        cache_path = os.path.join(os.environ['HOME'], 'Library/Caches/Google/Chrome/Default')
    else:  # 其他的操作系統(tǒng)
        print(f"Unsupported OS: {system}")
        return

    try:
        # 清空緩存目錄
        if os.path.exists(cache_path):
            shutil.rmtree(cache_path)
            os.makedirs(cache_path)  # 重新創(chuàng)建緩存目錄
            print("Chrome cache cleared successfully.")
        else:
            print("Cache directory does not exist.")
    except Exception as e:
        print(f"Error occurred while clearing cache: {e}")

if __name__ == "__main__":
    clear_chrome_cache()