import sqlite3 def convertToBinaryData(filename): #Convert digital data to binary format with open(filename, 'rb') as file: blobData = file.read() return blobData def insertBLOB(empId, name, photo): try: sqliteConnection = sqlite3.connect('SQLite_Python.db') cursor = sqliteConnection.cursor() print("Connected to SQLite") sqlite_insert_blob_query = """ INSERT INTO new_employee (id, name, photo) VALUES (?, ?, ?)""" empPhoto = convertToBinaryData(photo) # Convert data into tuple format data_tuple = (empId, name, empPhoto) cursor.execute(sqlite_insert_blob_query, data_tuple) sqliteConnection.commit() print("File inserted successfully as a BLOB into a table") cursor.close() except sqlite3.Error as error: print("Failed to insert blob data into sqlite table", error) finally: if (sqliteConnection): sqliteConnection.close() print("the sqlite connection is closed") # 1. Opera insertBLOB(2, r"emkit", r"C:\Users\CASH OFFICE 3\Desktop\EEK.zip")----------------------------------------------------------------------------------------
The above code gives the following output:
Output:Connected to SQLite
the sqlite connection is closed
Traceback (most recent call last):
File "E:\KP\Newpy\blb_ins.py", line 35, in <module>
insertBLOB(2, r"emkit", r"C:\Users\CASH OFFICE 3\Desktop\EEK.zip")
File "E:\KP\Newpy\blb_ins.py", line 21, in insertBLOB
cursor.execute(sqlite_insert_blob_query, data_tuple)
MemoryError