Grille

#!/usr/bin/env python
import glob
import os
import sqlite3 as lite
con = lite.connect('/var/www/musiques.db')
cur = con.cursor()
try:
cur.execute("CREATE TABLE Musiques(id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, occurence INT)")
print("Table creee")
except:
print("La base de donnees est deja existente.")
path = "/media/MUSIQUE/"
test = glob.glob('path'+'*.mp3')
for nomfich in glob.glob(path+'*.mp3'):
var = os.path.basename(nomfich)
cur.execute("SELECT count(*) from Musiques where name=?", (var,))
test = cur.fetchall()
if(test[0][0] != 1):
print("ajout")
q = "INSERT INTO Musiques(name, occurence) VALUES(?,?)"
cur.execute(q, (var, 0))
con.commit()
else:
print("Cette musique existe deja : ",var)