Dotaz: Python skript nevidi tabulku SQLite databaze Digikamu

[zdenek2008]

Nasledujicim pokusnym skriptem jsem si chtel nacitat obrazky z SQLite databaze Digikamu:

import sqlite3

def writeTofile(data, filename):
    # Convert binary data to proper format and write it on Hard Disk
    with open(filename, 'wb') as file:
        file.write(data)
    print("Stored blob data into: ", filename, "\n")

def readBlobData(Id):
    try:
        sqliteConnection = sqlite3.connect('thumbnails_digikam.db')
        cursor = sqliteConnection.cursor()
        print("Connected to SQLite")

        sql_fetch_blob_query = """SELECT * from Thumbnails where id = ?"""
#        sql_fetch_blob_query = """SELECT * from Thumbnails where id = 23"""
        cursor.execute(sql_fetch_blob_query, (Id,))
        record = cursor.fetchall()
        for row in record:
            print("Id = ", row[0],)
            photo = row[4]

            print("Storing image on disk \n")
            photoPath = "/home/q1/Pictures/thumbnails/" + name + ".jpg"
            writeTofile(photo, photoPath)

        cursor.close()

    except sqlite3.Error as error:
        print("Failed to read blob data from sqlite table", error)
    finally:
        if (sqliteConnection):
            sqliteConnection.close()
            print("sqlite connection is closed")

readBlobData(23)
readBlobData(24)

Bohuzel ale Python hlasi ze dotycna tabulka v db neni. Jenze ona tam JE, SQLiteBrowser ji zobrazuje a dotaz "SELECT * from Thumbnails where id = 23" v ni normalne funguje. Nebude neco s opravnenimi? Nebo co jineho je spatne? Predem dekuji za pripadne tipy.

q1@zzz:~/Pictures$ python3 blob_viewer.py
Connected to SQLite
Failed to read blob data from sqlite table no such table: Thumbnails
sqlite connection is closed
Connected to SQLite
Failed to read blob data from sqlite table no such table: Thumbnails
sqlite connection is closed

---

---

Odpovědi

[zdenek2008]

Je možné, že se pokoušíš otevřít databázi v jiném adresáři. Vytvoří se nová a logicky v ní taková tabulka nebude.

[zdenek2008]

Vyreseno. Mel jsem chybu v nazvu databaze. Takze misto otevreni databaze se vytvorila nova, prazdna. Ted mam jiny problem: soubory vytvorene z blobu se neotevrou jako obrazky, nejsou to platne jpg soubory.

[zdenek2008]

Gimp hlasi ze vytvoreny soubor neni image, protoze zacina 0x50 0x47. Tak hledam online o co jde.

[zdenek2008]

No tak je to PGF format...