通过定位sqlite3文件查询数据库。

import sqlite3 as db

def LocalFile(file,path):
    #获取标准的格式 file 000000000/File 000-000-000
    #定位到指定的文件 PathFile 000-000-000.DIR
    Len = 9 - len(file)    
    while Len:
        Len = Len - 1
        file = "0"+file
    File = file[:3]+"-"+file[3:6]+"-"+file[6:]+".DIR"
    PathFile = path+"/"+file[:3]+"/"+file[3:6]+"/"+File
    print("File is:",File)
    print("file is:",file)
    print("PathFile is:",PathFile)
    return PathFile
    
def GetInfo(File,exectCmd,name):
    #通过sqlite3获取列表信息
    conn = db.connect(File)
    cursor=conn.cursor()
    cursor.execute(exectCmd)
    #获取所有的数据
    Info=cursor.fetchall()
    for item in Info:
        if item[0] == name:
            return (item[2])
        

def main():
    file = "100515"
    path = "G:/PythonCode/DB"
    exectCmd = "select * from dirent"
    name = "14530847217414.d920ff0.jpg"
    TempFile = LocalFile(file,path)
    GetInfo(TempFile,exectCmd,name)

if __name__ == '__main__':
    main()