Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import sys
- import pymysql
- from PyQt5.QtWidgets import *
- from PyQt5.QtGui import *
- con = pymysql.connect(
- host=host,
- port=3306,
- user=user,
- password=password,
- db="test",
- charset='utf8mb4')
- cur = con.cursor()
- with open('woman.jpg', "rb") as f:
- img_data = f.read()
- binary = pymysql.Binary(img_data)
- cur.execute("INSERT INTO Images(Data) VALUES (%s)", (binary,))
- con.commit()
- app = QApplication([])
- w = QWidget()
- layout = QVBoxLayout()
- w.setLayout(layout)
- cur.execute("SELECT Data FROM Images")
- d = cur.fetchall()
- for (img_data,) in d:
- pixmap = QPixmap()
- pixmap.loadFromData(img_data)
- label = QLabel()
- label.setPixmap(pixmap)
- layout.addWidget(label)
- w.show()
Add Comment
Please, Sign In to add comment