from PyQt5.QtWidgets import *from PyQt5 import QtWidgets, QtGuifrom PIL import Image, ImageQt import cv2 as cvimg = cv.imread('1.1 cat.jpeg.jpeg')im = Image.fromarray(img)im.save('file.png')con = lite.connect('Final_Avirs.db')cur = con.cursor()def createtb(): queryveh = """CREATE TABLE IF NOT EXISTS VehicleTB(Scan_DI INTEGER PRIMARY KEY NOT NULL UNIQUE, Vehicle_number TEXT NOT NULL, Vehicle_type TEXT NOT NULL, Cam_loc TEXT NOT NULL, Date_Time TEXT NOT NULL, Vehicle_number_pic BLOB NOT NULL) """ cur.execute(queryveh) con.commit()def vehicledetailsquery(vn, vt, cl, dt, vnp): scan_id = vn + "1" query = " INSERT INTO 'VehicleTB' ( Vehicle_number, Vehicle_type, Cam_loc, " \ "Date_Time, Vehicle_number_pic ) VALUES( ?, ?, ?, ?, ?)" cur.execute(query, (vn, vt, cl, dt, vnp)) con.commit() img = Image.open('file.png')createtb()vehicledetailsquery('aswe23','2039230', 'cam-2', '23343', img )app = QtWidgets.QApplication([])def vehicletbquery(): query = "SELECT * from VehicleTB" vehicletb = cur.execute(query).fetchall() return vehicletbdata = vehicletbquery()ww = QtWidgets.QLabel()for i, d in enumerate(data): if i == 6: ww.w.setPixmap(QtGui.QPixmap.fromImage(d)) ww.show()app.exec()我知道問題出在我的圖像值上，但我不知道如何處理它，我能做的最好的是將枕頭圖像轉(zhuǎn)換為字符串，然后這樣做，我可以在 PYQT 標簽上顯示圖像，標簽只是出來是空的。
1 回答
喵喵時光機
TA貢獻1846條經(jīng)驗 獲得超7個贊
數(shù)據(jù)類型 BLOB 保存字節(jié)，在您的情況下，您嘗試保存拋出錯誤的 PIL 對象。解決方案是轉(zhuǎn)換這些對象。然后從數(shù)據(jù)庫獲取的數(shù)據(jù)也會發(fā)生同樣的情況，但情況相反：
import sqlite3
import io
from PyQt5 import QtGui, QtWidgets
from PIL import Image
import cv2 as cv
img = cv.imread('1.1 cat.jpeg.jpeg')
im = Image.fromarray(img)
im.save("file.png")
con = sqlite3.connect("Final_Avirs.db")
cur = con.cursor()
def createtb():
queryveh = """CREATE TABLE IF NOT EXISTS VehicleTB(Scan_DI INTEGER PRIMARY KEY NOT NULL UNIQUE,
Vehicle_number TEXT NOT NULL, Vehicle_type TEXT NOT NULL, Cam_loc TEXT NOT NULL, Date_Time TEXT NOT NULL,
Vehicle_number_pic BLOB NOT NULL) """
cur.execute(queryveh)
con.commit()
def vehicledetailsquery(vn, vt, cl, dt, vnp):
scan_id = vn + "1"
query = (
" INSERT INTO 'VehicleTB' ( Vehicle_number, Vehicle_type, Cam_loc, "
"Date_Time, Vehicle_number_pic ) VALUES( ?, ?, ?, ?, ?)"
)
cur.execute(query, (vn, vt, cl, dt, vnp))
con.commit()
img = Image.open("file.png")
createtb()
# convert to bytes
f = io.BytesIO()
img.save(f, format="PNG")
img_bytes = f.getvalue()
vehicledetailsquery("aswe23", "2039230", "cam-2", "23343", img_bytes)
def vehicletbquery():
query = "SELECT * from VehicleTB"
vehicletb = cur.execute(query).fetchall()
return vehicletb
data = vehicletbquery()
app = QtWidgets.QApplication([])
scroll_area = QtWidgets.QScrollArea(widgetResizable=True)
container = QtWidgets.QWidget()
scroll_area.setWidget(container)
lay = QtWidgets.QVBoxLayout(container)
for row_data in data:
for i, d in enumerate(row_data):
if i == 5:
# QPixmap from bytes
pixmap = QtGui.QPixmap()
pixmap.loadFromData(d)
label = QtWidgets.QLabel()
label.setPixmap(pixmap)
lay.addWidget(label)
scroll_area.show()
app.exec()
添加回答
舉報
0/150
提交
取消