Nov-05-2020, 05:10 AM
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(empId): try: sqliteConnection = sqlite3.connect('SQLite_Python.db') cursor = sqliteConnection.cursor() print("Connected to SQLite") sql_fetch_blob_query = """SELECT * from new_employee where id = ?""" cursor.execute(sql_fetch_blob_query, (empId,)) record = cursor.fetchall() for row in record: #print("Id = ", row[0], "Name = ", row[1]) name = row[1] photo = row[2] print("Storing employee image and resume on disk \n") photoPath = r"C:\AdwCleaner\\" + name + ".txt" 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") # 1.G 2. M readBlobData(1)The above code works well in the folder in which it was created. But when I transfer it to another folder for making and run it I get the following output:
Connected to SQLite
Failed to read blob data from sqlite table no such table: new_employee
sqlite connection is closed