根据本地文件，生成百度云文件列表

来源：互联网发布：天猫和淘宝价格对比编辑：程序博客网时间：2024/04/30 08:39

百度云中存了太多文件，需要查找时很不方便，于是萌生了写一个小工具，生成百度云文件列表

主要参考资料为：点击打开链接

以下为Python的实现方法，选择本地百度云db文件。我的文件路径为：

C:\Users\Administrator\AppData\Roaming\baidu\BaiduYunGuanjia\users\一大串\BaiduYunCacheFileV0.db

#!/usr/bin/env python3# -*- coding:utf-8 -*-from tkinter import *from tkinter.filedialog import askopenfilenamefrom tkinter.filedialog import asksaveasfilenamefrom tkinter.ttk import *import sqlite3def select_db_file():    db_file = askopenfilename(title="请选择BaiduYunCacheFileV0.db文件",filetypes=[('db', '*.db')])    db.set(db_file)def select_save_file():    save_file = asksaveasfilename(filetypes=[('文件', '*.txt')])    f.set(save_file+".txt")def write_file(file_dict,f,item,gap=""):    if item=="/":        f.write("━" + "/" + "\n")        for i in file_dict["/"]:            f.write("┣" + "━" + i + "\n")            i = item + i + "/"            if i in file_dict:                write_file(file_dict,f,i, gap="┣━")    else:        gap = "┃  " + gap        for i in file_dict[item]:            f.write(gap + i + "\n")            i = item + i + "/"            if i in file_dict:                  write_file(file_dict,f,i,gap)def create_baiduyun_filelist():    file_dict = {}    conn = sqlite3.connect(db.get())    cursor = conn.cursor()    cursor.execute("select * from cache_file")    while True:        value = cursor.fetchone()        if not value:            break        path = value[2]        name = value[3]        size = value[4]        isdir = value[6]        if path not in file_dict:            file_dict[path] = []            file_dict[path].append(name)        else:            file_dict[path].append(name)    with open(f.get(),"w",encoding='utf-8') as fp:        write_file(file_dict,fp,"/")root = Tk()root.title('百度云文件列表生成工具')db_select = Button(root, text=' 选择DB文件 ',command=select_db_file)db_select.grid(row=1,column=1,sticky=W,padx=(2,0),pady=(2,0))db = StringVar()db_path = Entry(root,width=80,textvariable = db)db_path['state'] = 'readonly'db_path.grid(row=1,column=2,padx=3,pady=3,sticky=W+E)save_path = Button(root, text='选择保存地址',command=select_save_file)save_path.grid(row=2,column=1,sticky=W,padx=(2,0),pady=(2,0))f = StringVar()file_path = Entry(root,width=80,textvariable = f)file_path['state'] = 'readonly'file_path.grid(row=2, column=2,padx=3,pady=3,sticky=W+E)create_btn = Button(root, text='生成文件列表',command=create_baiduyun_filelist)create_btn.grid(row=3,column=1,columnspan=2,pady=(0,2))root.columnconfigure(2, weight=1)root.mainloop()

0 0