def createTables(self):
        tableMusic = "CREATE TABLE IF NOT EXISTS 'music' \
                    (id INTEGER PRIMARY KEY, dir VARCHAR(1000), name VARCHAR(100));"
        self.cursor.execute(tableMusic)
        self.connect.commit()




def insertMusic(self, dir, name):
        music = "INSERT INTO music(dir,name) VALUES ('%s', '%s')" % (dir_unicode, name_unicode)
        print music
        self.cursor.execute(music)


--------------------------


INSERT INTO music(dir,name) VALUES ('/home/adriano/Music/SoundTracks/Um Amor Para Recordar/', '03 - Mandy Moore & Jonathan Foreman - Someday We'll Know.mp3')
Traceback (most recent call last):
  File "/usr/lib/python2.5/site-packages/zukebox_server/server/zb_server.py", line 169, in start
    self.savePathDB()
  File "/usr/lib/python2.5/site-packages/zukebox_server/server/zb_server.py", line 138, in savePathDB
    self.db.insertList(self.listMusic.getListMusic())
  File "/usr/lib/python2.5/site-packages/zukebox_server/plugins/bd/zukebox_db.py", line 53, in insertList
    self.insertMusic(m.getDir(), m.getName())
  File "/usr/lib/python2.5/site-packages/zukebox_server/plugins/bd/zukebox_db.py", line 35, in insertMusic
    self.cursor.execute(music)
sqlite3.OperationalError: near "ll": syntax error