import sqlite3

stationId = 0

def buildBlob(string):
	""" Builds the needed blob for value column """
	return sqlite3.Binary(chr(1) + chr(0) * 3 + '@' + chr(0) * 3 + string + chr(0) )

def insertIntoDB(cursor, title, uri):
    """ inserts station in db"""
    global stationId
    stationId = stationId + 1

    cursor.execute('INSERT INTO iradiobookmarks VALUES (?, "title", ?)', (stationId, buildBlob(title),))
    cursor.execute('INSERT INTO iradiobookmarks VALUES (?, "mime-type", ?)', (stationId, buildBlob("audio"),))
    cursor.execute('INSERT INTO iradiobookmarks VALUES (?, "uri", ?)', (stationId, buildBlob(uri),))
    print 'inserted station %s' % title

conn = sqlite3.connect("/home/user/.mafw.db")
cursor = conn.cursor()

cursor.execute('DELETE FROM iradiobookmarks')
print 'database cleared'

insertIntoDB(cursor, 'Radio 1', 'http://shoutcast.omroep.nl:8100/listen.pls')
insertIntoDB(cursor, 'Radio 3', 'http://shoutcast.omroep.nl:8104/listen.pls')

conn.commit()
print 'commited!'