tpym python一鍵導出百度網盤目錄文件
找到百度網盤本地的數據庫文件 D:BaiduNetdiskusers用戶名BaiduYunCacheFileV0.db+通過查詢該數據庫文件+獲取網盤文件目錄
也可以直接下載我打包好的exe文件
查找百度網盤離線數據庫BaiduYunCacheFileV0.db文件
https://www.bilibili.com/video/BV11n3keUEZJ/
版本一、
from tkinter import *
from tkinter.filedialog import askopenfilename
from tkinter.filedialog import asksaveasfilename
from tkinter.ttk import *
import sqlite3
def 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()
版本二、out_to_txthtml? 導出為html文件
from tkinter import *
from tkinter.filedialog import askopenfilename
from tkinter.filedialog import asksaveasfilename
from tkinter.ttk import *
import sqlite3
import os
#https://blog.csdn.net/weixin_54062494/article/details/128280105
filetype_pre = "" # 上一個文件類型
items_pre = 1 # 上一個文件/文件夾所在目錄層數
gaps="" # 總層數
def 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 txtTOhtml(path):
'''
param txt文件路徑n
將生成好的html標簽寫入為html文件
'''
base=[
"<html><head><meta charset='UTF-8'><style> body { margin: 0; background-color: rgb(156, 215, 217); } p { color: aliceblue; } ul { list-style: none; } ul li ul { display: none; } #box1 { flex: 3; } .zk { display: block; } </style><script src='https://cdn.bootcdn.net/ajax/libs/jquery/3.5.1/jquery.js'></script></head><body><div id='box1'><ul><!-- 目錄樹開始 -->n",
"n<!-- 目錄樹結束 --></ul></div><script> $('li').click(function (event) { obj = $(this).children('ul'); if (!obj.hasClass('zk')) { siblings = $(this).siblings().children('ul'); if (siblings.hasClass('zk')) { siblings.removeClass('zk'); }; $(obj).addClass('zk'); } else { $(obj).removeClass('zk'); }; event.stopPropagation(); }); </script></body></html>"
]
pathportion = os.path.splitext(path) # 分離文件名與擴展名
scratchFile=pathportion[0]+".html" # 拼接html文件名
#向html文件寫入
f = open(scratchFile,'w',encoding='utf-8')
with open(path,'r',encoding='utf-8') as fa:
Readeddata = fa.readlines()
f.write(base[0]) #寫入html固定頭
for x in Readeddata:#寫入生成的html標簽
f.write(x)
f.write(base[1]) #寫入html固定尾
f.close()
def html_tails(gaps):
'''
param gaps 最后的層n
return html 文檔末尾的標簽
'''
html_tails=""
for i in range(gaps.count("┃")):
html_tails=html_tails+"</li></ul>"
return html_tails
def htmltxt(filetype_pre, filetypes, item_vary):
'''
獲得對應的html標簽n
param filetype_pre 上個文件類型n
param filetypes 當前文件類型n
param item_vary 層數差
'''
html = {
"<li><p>": "<li><p>", # 文件夾頭
"</p>": "</p>", # 文件夾尾
"<li>": "<li>", # 文件頭
"</li>": "</li>", # 文件尾/
"<ul>": "<ul>",
"</ul></li>": "</ul></li>",
"</li></ul></li>": "</li></ul></li>"
}
html_txt = "" #當前文件與上個文件之間的結束標簽
html_head = "" #文件/文件夾頭標簽
html_tail = "" #文件/文件夾尾標簽
#True為文件夾 False為文件
if (filetype_pre == ""): # 上個文件類型=空
return html["<li><p>"], html["</p>"]
if (filetypes == True): # 當前文件類型=文件夾
html_head = html["<li><p>"]
html_tail = html["</p>"]
else:
html_head = html["<li>"]
html_tail = html["</li>"]
if (filetype_pre == True): # 上個文件類型=文件夾
if(item_vary==0):
html_txt=html["</li>"]
elif(item_vary==1):
html_txt=html["<ul>"]
elif(item_vary<0):
for i in range(abs(item_vary)):
html_txt=html_txt+html["</li></ul></li>"]
if(filetype_pre==False): #上個文件類型=文件
if(item_vary==0):
html_txt=""
else:
for i in range(abs(item_vary)): #按層數依次補充
html_txt=html_txt+html["</ul></li>"]
return html_txt+html_head, html_tail
def file_type(filename):
'''
判斷文件是 文件夾True 還是 文件False
'''
types = [
".mp4", ".mp3", ".ts", ".pdf", ".docx", ".ppt", ".ppts", ".doc", ".7z", ".zip", ".xlsx", ".jpeg",".jpg", ".png", ".heic", ".mov", "3gp", "aac", "ace", "aif", "arj", "asf", "avi", "bin", "bz2", "exe", "gz", "gzip", "img", "iso", "lzh", "m4a", "m4v", "mkv", "mpa", "mpe", "mpeg", "mpg", "msi", "msu", "ogg", "ogv", "pdf", "plj", "pps", "qt", "ra", "rar", "rm", "rmvb", "sea", "sit", "sitx", "tar", "tif", "tiff", "wav", "wma", "wmv", "apk", "m3u8", "apks", "apkm"
]
if "." in filename:
for i in types:
if i in filename:
return False
for i in types:
if i.upper() in filename:
return False
return True
def filetype(filename, item):
'''
param filename 文件名n
param item 當前目錄n
返回文件前后html標簽n
return 前標簽,后標簽
'''
#True為文件夾 False為文件
global filetype_pre # 上個文件類型
filetypes = True # 當前文件類型
# 判斷當前文件類型
filetypes = file_type(filename)
global items_pre # 上個文件所在目錄層數
items = item.count('/') # 當前文件所在目錄層數
item_vary = items-items_pre # 當前目錄與上個目錄 層數變化
html_head = ""
html_tail = ""
html_head,html_tail=htmltxt(filetype_pre,filetypes,item_vary)
filetype_pre = filetypes # 更新上個文件類型
items_pre = items # 更新上個文件所在目錄層數
return html_head, html_tail
def write_file(file_dict, f, item, gap=""):
'''
向txt寫入
'''
global gaps
if item == "/":
for i in file_dict["/"]:
html_head,html_tail=filetype(i,"/")
f.write(html_head+ i + html_tail+"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]:
if(i==""):
print(item)
html_head,html_tail=filetype(i,item)
f.write(html_head+ i + html_tail+"n")
gaps=""
gaps=gap
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, "/")
global gaps
fp.write(html_tails(gaps))
txtTOhtml(fp.name)
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()1. 本站所有資源來源于用戶上傳和網絡，如有侵權請郵件聯系站長！
2. 分享目的僅供大家學習和交流，您必須在下載后24小時內刪除！
3. 不得使用于非法商業用途，不得違反國家法律。否則后果自負！
4. 本站提供的源碼、模板、插件等等其他資源，都不包含技術服務請大家諒解！
5. 如有鏈接無法下載、失效或廣告，請聯系管理員處理！
6. 本站資源售價只是贊助，收取費用僅維持本站的日常運營所需！
7. 如遇到加密壓縮包，請使用WINRAR解壓,如遇到無法解壓的請聯系管理員！
8. 精力有限，不少源碼未能詳細測試（解密），不能分辨部分源碼是病毒還是誤報，所以沒有進行任何修改，大家使用前請進行甄別
TP源碼網 » python一鍵導出百度網盤目錄文件
TP源碼網 » python一鍵導出百度網盤目錄文件
