import subprocess
import datetime
import os

def create_encrypted_backup(password):
    # 获取当前日期和时间
    timestamp = datetime.datetime.now().strftime('%Y%m%d%H%M')
    backup_file = f'/root/vaultwarden_{timestamp}.tar.enc'
    
    # 创建加密备份
    tar_command = f'tar -cvf - /root/vaultwarden/ | openssl enc -aes-256-cbc -e -out {backup_file} -pass pass:{password}'
    subprocess.run(tar_command, shell=True, check=True)
    
    return backup_file

def upload_to_rclone(backup_file, rclone_upload_path):
    # 使用 rclone 上传文件
    subprocess.run(["rclone", "copy", "--transfers", "5", backup_file, rclone_upload_path], check=True)

def cleanup_local_backup(backup_file):
    # 删除本地备份文件
    if os.path.exists(backup_file):
        os.remove(backup_file)

def main():
    password = '11111'  # 替换为实际的密码
    rclone_upload_path = 'download:vaultwarden加密备份/'
    
    try:
        backup_file = create_encrypted_backup(password)
        upload_to_rclone(backup_file, rclone_upload_path)
        cleanup_local_backup(backup_file)
        print("备份上传成功，本地文件删除.")
    except subprocess.CalledProcessError as e:
        print(f"发生错误: {e}")
    except Exception as e:
        print(f"发生错误：{e}")

if __name__ == "__main__":
    main()

 docker ps -q | xargs -n1 docker inspect --format '{{.Name}} {{range .Netw
orkSettings.Networks}}{{.IPAddress}}{{end}}' | sed 's#^/##'

整理了需要卸载这个几个组件，以下命令均需要root权限运行：

#ModemManager
systemctl |grep Modem
systemctl stop ModemManager.service
systemctl disable ModemManager.service
apt-get purge --auto-remove -y modemmanager  

#hostguard
dpkg -P hostguard
irqbalance
apt-get purge --auto-remove -y irqbalance

#polkitd
systemctl disable polkit.service
systemctl stop polkit.service

#CloudResetPwdUpdateAgent
bash /CloudrResetPwdAgent/bin/cloudResetPwdAgent.script remove
bash /CloudResetPwdUpdateAgent/bin/cloudResetPwdUpdateAgent.script remove
rm -rf /CloudrResetPwdAgent
rm -rf /CloudResetPwdUpdateAgent

setx http_proxy http://127.0.0.1:9999
setx https_proxy http://127.0.0.1:9999

id=1 enabled=yes comment= action=drop dir=forward ctdir=1 iinterface=adsl1,adsl2,adsl3,adsl4 ointerface=lan1 src_addr= dst_addr= src6_addr= dst6_addr= src6_mode=0 dst6_mode=0 src6_suffix= dst6_suffix= src6_mac= dst6_mac= protocol=any src_port= dst_port= week=1234567 time=00:00-23:59 ip_type=6

id=2 enabled=yes comment= action=accept dir=forward ctdir=0 iinterface=【wan列表】 ointerface=lan1 src_addr= dst_addr= src6_addr= dst6_addr=【设备ipv6地址】/64 src6_mode=0 dst6_mode=0 src6_suffix= dst6_suffix= src6_mac= dst6_mac= protocol=tcp src_port= dst_port=【端口列表】 week=1234567 time=00:00-23:59 ip_type=6

import os
import subprocess

from bs4 import BeautifulSoup
import pandas as pd
from datetime import datetime
import random
import string
from selenium import webdriver
from selenium.webdriver.chrome.service import Service


def generate_random_string(length=6):
    return ''.join(random.choices(string.ascii_letters + string.digits, k=length))

try:
    subprocess.run(
        ["taskkill", "/f", "/im", "chrome.exe"],
        stdout=subprocess.DEVNULL,
        stderr=subprocess.DEVNULL,
        check=True
    )
except subprocess.CalledProcessError:
    pass

user_data_dir = os.path.join(os.environ['LOCALAPPDATA'], r"Google\Chrome\User Data")

options = webdriver.ChromeOptions()
options.add_argument(f"user-data-dir={user_data_dir}")
service = Service(executable_path=r'C:\Windows\chromedriver.exe')

driver = webdriver.Chrome(options=options, service=service)

# 打开一个网页
driver.get("https://baidu.com")

while True:
    try:
        # 提示用户按回车开始读取网页内容
        input("请访问web表格所在页面，回车开始执行：")
        div_html = driver.page_source

        # 使用 BeautifulSoup 解析 HTML
        soup = BeautifulSoup(div_html, 'html.parser')

        # 获取 title 标签内容或生成随机字符串
        title_tag = soup.title.string if soup.title else generate_random_string()
        current_date = datetime.now().strftime("%m%d")

        # 找到所有表格
        tables = soup.find_all('table')

        num_tables = len(tables)
        if num_tables == 0:
            print("未找到表格，请检查页面内容。")
            continue

        print(f"*****识别到 {num_tables} 个表格*****")

        dataframes = []
        for i, table in enumerate(tables):
            rows = []
            for row in table.find_all('tr'):
                cols = row.find_all(['td', 'th'])
                cols = [ele.text.strip() for ele in cols]
                rows.append(cols)

            # 使用 pandas 将数据转换为 DataFrame
            df = pd.DataFrame(rows[1:], columns=rows[0])
            dataframes.append(df)

            print(f"\n======================预览数据 (表格 {i + 1})===========================")
            print(df.head())

        # 用户选择需要输出的表格序号
        selection = input(f"\n请输入要输出的表格序号 (1-{num_tables}) 或 'a' 输出所有表格: ").strip().lower()

        if selection == 'a':
            for i, df in enumerate(dataframes):
                excel_path = f'{title_tag}_{current_date}_table{i + 1}.xlsx'
                df.to_excel(excel_path, index=False)
                print(f"数据已保存到 {excel_path}")
        else:
            try:
                selected_table = int(selection) - 1
                if 0 <= selected_table < num_tables:
                    excel_path = f'{title_tag}_{current_date}_table{selected_table + 1}.xlsx'
                    dataframes[selected_table].to_excel(excel_path, index=False)
                    print(f"数据已保存到 {excel_path}")
                else:
                    print("无效的table序号。")
            except ValueError:
                print("请输入有效的序号")

    except Exception as e:
        if 'target window already closed' in str(e):
            print('监听窗口已关闭..')
            exit()
        print(f"发生错误: {e}")

    # 检查是否继续
    cont = input('继续处理？(y/其他退出): ')
    if cont.strip().lower() != 'y':
        driver.quit()
        break