StoreBinary.py

#Creating a database and inserting binaries
"""
Created to store sound for slide show clips. However it will store any files in binary 
database. Great for images

"""

import sqlite3
def open_db(database):
    conn = sqlite3.connect(database)
    c=conn.cursor()
    c.execute(
        '''create table if not exists Binaries(
        ID INTEGER PRIMARY KEY AUTOINCREMENT,
        binaryD BLOB,
        TYPE TEXT,
        FILE_NAME TEXT);''')

def insert_binary(conn):
    titlelist = "GISTstore/music.list"
    titles = open(titlelist,"r")
    for title in titles.readlines():
        title = title.replace("\n","")
        filename = os.path.basename(title)
        with open(title, 'rb') as input_file:
            ablob = input_file.read()
            base=os.path.basename(title)
            afile, ext = os.path.splitext(base)
            sql = '''INSERT INTO Binaries
            (binaryD, TYPE, FILE_NAME)
            VALUES(?, ?, ?);'''
            conn.execute(sql,[sqlite3.Binary(ablob), ext, afile]) 
            conn.commit()
database = 'MP3/junk4.db'
open_db(database)            
conn = sqlite3.connect(database)
insert_binary(conn)