Created
February 2, 2023 02:46
sqlite binary data convert to file
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python3 | |
import sqlite3 | |
def write_file(data, filename): | |
'''Convert binary data and write it on Hard Disk''' | |
with open(filename, 'wb') as file: | |
file.write(data) | |
print(f"Stored blob data into:{filename}\n") | |
def read_blob(emp_id, audio_path, db_path): | |
try: | |
sqlite_con = sqlite3.connect(db_path) | |
cursor = sqlite_con.cursor() | |
print("Connected to SQLite") | |
sql_blob_query = "SELECT * from table where id = ?" | |
cursor.execute(sql_blob_query, (emp_id,)) | |
record = cursor.fetchall() | |
for row in record: | |
name = row[6] | |
data = row[7] | |
audio = f"{audio_path}{name}.mp3" | |
write_file(data, audio) | |
cursor.close() | |
except sqlite3.Error as error: | |
print(f"Failed to read blob data from sqlite table {error}") | |
finally: | |
if sqlite_con: | |
sqlite_con.close() | |
print("sqlite connection is closed") | |
if __name__ == '__main__': | |
db_path = '/Users/HTC/Downloads/audios.sqlite' | |
audio_path = "/Users/HTC/Downloads/" | |
read_blob(1, audio_path, db_path) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment