将文件写入本地SQL DB

import sqlite3

def create_table():
    conn = sqlite3.connect('example.db')
    cursor = conn.cursor()
    cursor.execute('''CREATE TABLE IF NOT EXISTS files (
                      id INTEGER PRIMARY KEY AUTOINCREMENT,
                      name TEXT NOT NULL,
                      content BLOB NOT NULL)''')
    conn.commit()
    conn.close()

def insert_file(file_path):
    with open(file_path, 'rb') as file:
        file_data = file.read()
    conn = sqlite3.connect('example.db')
    cursor = conn.cursor()
    cursor.execute('INSERT INTO files (name, content) VALUES (?, ?)', (file_path, file_data))
    conn.commit()
    conn.close()

def read_file(file_id):
    conn = sqlite3.connect('example.db')
    cursor = conn.cursor()
    cursor.execute('SELECT name, content FROM files WHERE id = ?', (file_id,))
    file_info = cursor.fetchone()
    conn.close()
    if file_info:
        with open(file_info[0], 'wb') as file:
            file.write(file_info[1])
    return file_info

# 创建表
create_table()

# 插入文件
insert_file('example.txt')

# 读取文件
read_file(1)