Das deutsche Python-Forum

Code: Alles auswählen

[...]
SQL_QR = '%s\\QR_Codes.db'  %(path_qr)
conn = sqlite3.connect(SQL_QR)
cursor = conn.cursor()
conn.execute('''CREATE TABLE IF NOT EXISTS QR_Codes(ID INTEGER PRIMARY KEY AUTOINCREMENT,PICTURE BLOB,TYPE TEXT,FILE_NAME TEXT,QR_TEXT TEXT);''')
cursor = conn.cursor()
cursor.execute('''SELECT PICTURE, TYPE, FILE_NAME, QR_TEXT FROM QR_Codes''')
result = cursor.fetchall()
for hurika in result:
    ablob = hurika[0]
    ext = hurika[1]
    afile = hurika[2]
    qr_text = hurika[3]

    beschreibung = [qr_text]
    qr_BESCHREIBUNG.append(beschreibung)
    with open("Output.png", "wb") as output_file:
        output_file.write(ablob)

        I = Image(output_file)
        I.drawHeight = 1*inch*I.drawHeight / I.drawWidth
        I.drawWidth = 1*inch
        I.show()


conn.close()

Code: Alles auswählen

SQL_QR = os.path.join(path_qr+"\\QR_Codes.db")
conn = sqlite3.connect(SQL_QR)
cursor = conn.cursor()
cursor.execute('''SELECT PICTURE, TYPE, FILE_NAME, QR_TEXT FROM QR_Codes''')
result = cursor.fetchall()

for hurika in result:
    ablob = hurika[0]
    ext = hurika[1]
    afile = hurika[2]
    qr_text = hurika[3]
    beschreibung = [qr_text]
    qr_BESCHREIBUNG.append(beschreibung)

    with open("Output.png", "wb") as output_file:
        output_file.write(ablob)

    I = Image(output_file)
    I.drawHeight = cm*I.drawHeight / I.drawWidth
    I.drawWidth = cm
    I.show()