playbinary.py

# Playing the Binary Music File
# the player for the storebinary music
import sqlite3
def extract_binary(cursor, picture_id):
    sql = "SELECT binaryD, TYPE, FILE_NAME FROM Binaries WHERE id = :id"
    param = {'id': picture_id}
    cursor.execute(sql, param)
    ablob, ext, afile = cursor.fetchone()
    filename = afile + ext
    with open(filename, 'wb') as output_file:
        output_file.write(ablob)
    return filename

#conn = create_or_open_db('MP3/music.db')
conn = sqlite3.connect('MP3/junk4.db')
cur = conn.cursor()
filename = extract_binary(cur, 4)
cur.close()
conn.close()
print filename
from GISTstore import Pmp3
Pmp3.pmp3(filename)