pb保存图片到数据库

import sqlite3
import protobuf_image_pb2  # 假设已经定义了protobuf_image.proto文件

# 创建数据库连接
conn = sqlite3.connect('images.db')
cursor = conn.cursor()

# 创建表
cursor.execute('''
CREATE TABLE IF NOT EXISTS images (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    data BLOB NOT NULL
)
''')

# 读取图片并转换为二进制数据
with open('example.jpg', 'rb') as f:
    image_data = f.read()

# 使用PB序列化数据
image_message = protobuf_image_pb2.Image()
image_message.data = image_data
serialized_data = image_message.SerializeToString()

# 将序列化后的数据存储到数据库
cursor.execute('INSERT INTO images (data) VALUES (?)', (serialized_data,))
conn.commit()

# 关闭数据库连接
conn.close()