z7UftC4M

1import sys,sqlite3
2from PyQt5.QtWidgets import QWidget, QApplication,QPushButton
3from PyQt5.QtGui import QPainter, QColor, QFont,QIcon
4from PyQt5.QtCore import Qt,QSize
5class Example(QWidget):
6
7    def __init__(self):
8        super().__init__()
9        self.initUI()
10
11
12    def initUI(self):
13        conn = sqlite3.connect("test.db")
14        connect = conn.execute("SELECT Data from Images")
15        for row in connect:
16
17            self.label_im_qrcode = QLabel()
18            import io, qrcode
19            b = io.BytesIO(row[0])
20            img.save(b, 'png')
21            data = b.getvalue()
22
23            pixmap = QPixmap()
24            pixmap.loadFromData(data)
25
26
27            self.label_im_qrcode.setPixmap(pixmap)
28         self.setGeometry(300, 300, 280, 170)
29         self.setWindowTitle('Draw text')
30         self.show()
31if __name__ == '__main__':
32    con = sqlite3.connect('test.db')
33    cur = con.cursor()
34    fin = open('woman.jpg', "rb")
35    img = fin.read()
36    binary = sqlite3.Binary(img)
37    cur.execute("INSERT INTO Images(Data) VALUES (?)", (binary,))
38    con.commit()
39    app = QApplication(sys.argv)
40    ex = Example()
41    sys.exit(app.exec_())
42	
43text = self.input_text.toPlainText()
44img = qrcode.make(text)
45
46import io
47b = io.BytesIO()
48img.save(b, 'png')
49data = b.getvalue()
50
51pixmap = QPixmap()
52pixmap.loadFromData(data)
53
54self.label_im_qrcode.setPixmap(pixmap)
55	
56import sys
57import sqlite3
58from PyQt5.QtWidgets import *
59from PyQt5.QtGui import *
60
61
62if __name__ == '__main__':
63    con = sqlite3.connect('test.sqlite')
64    cur = con.cursor()
65    cur.execute('''
66    CREATE TABLE IF NOT EXISTS Images (
67        Data BLOB
68    )
69    ''')
70    con.commit()
71
72    with open('capture.png', mode='rb') as f:
73        binary = sqlite3.Binary(f.read())
74
75        cur.execute("INSERT INTO Images(Data) VALUES (?)", (binary,))
76        con.commit()
77
78    app = QApplication([])
79
80    w = QWidget()
81    layout = QVBoxLayout()
82    w.setLayout(layout)
83
84    for (img_data,) in con.execute("SELECT Data from Images"):
85        pixmap = QPixmap()
86        pixmap.loadFromData(img_data)
87
88        label = QLabel()
89        label.setPixmap(pixmap)
90
91        layout.addWidget(label)
92
93    w.show()
94
95    sys.exit(app.exec_())