Guest User

Untitled

a guest
Dec 30th, 2017
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.72 KB | None | 0 0
  1. import sys
  2. import pymysql
  3. from PyQt5.QtWidgets import *
  4. from PyQt5.QtGui import *
  5. con = pymysql.connect(
  6. host=host,
  7. port=3306,
  8. user=user,
  9. password=password,
  10. db="test",
  11. charset='utf8mb4')
  12. cur = con.cursor()
  13. with open('woman.jpg', "rb") as f:
  14. img_data = f.read()
  15. binary = pymysql.Binary(img_data)
  16. cur.execute("INSERT INTO Images(Data) VALUES (%s)", (binary,))
  17. con.commit()
  18. app = QApplication([])
  19. w = QWidget()
  20. layout = QVBoxLayout()
  21. w.setLayout(layout)
  22. cur.execute("SELECT Data FROM Images")
  23. d = cur.fetchall()
  24. for (img_data,) in d:
  25. pixmap = QPixmap()
  26. pixmap.loadFromData(img_data)
  27. label = QLabel()
  28. label.setPixmap(pixmap)
  29. layout.addWidget(label)
  30. w.show()
Add Comment
Please, Sign In to add comment