def auto_completion(self, useless):
self.delEntry()
info = (self.box.get(),)
db = DbGenre()
data = db.findOneGenre(info)
self.nameEntry.insert(1, data[1])
self.id = data[0]
def getGenre(self):
database = DbGenre()
genres = database.findAllGenres()
for genre in genres :
self.listGenres.append(genre[1])
if self.genre :
self.genre = database.findGenreWithId((self.genre,))
def getGenreId(self):
database = DbGenre()
id = database.findOneGenre((self.genreBox.get(),))
if len(id) > 0 :
return id[0]
else :
return
def valider(self):
info = (self.box.get(), )
test = messagebox.askokcancel(
'Valider', 'Etes-vous sur de vouloir supprimer ce contenu')
if test:
db = DbGenre()
db.deleteOldGenre(info)
self.frameApp.destroy()
SeeGenre(mainFrame)
def __init__(self, frame):
self.frameApp = tkinter.Frame(frame)
self.frameApp.pack(side='left', fill='both', expand=1)
#
self.secondFrame = tkinter.Frame(self.frameApp)
self.secondFrame.pack(side='top', fill='both', expand=1)
#
self.db = DbGenre()
self.data = self.db.findAllGenres()
self.seeAllItem()
def valider(self):
pass
if self.nameEntry.get() != '' and self.box.get() != '' :
info = (self.nameEntry.get(), self.id)
test = messagebox.askokcancel('Valider', 'Etes vous sur de vouloir modifier ce genre')
if test :
db = DbGenre()
db.updateGenre(info)
self.frameApp.destroy()
SeeGenre(mainFrame)
else :
messagebox.showinfo("Erreur", 'Veuillez remplir tous les champs')
def valider(self):
if self.nameEntry.get() != '':
test = messagebox.askokcancel(
'Valider', 'Etes-vous sur de vouloir Ajouter ce genre ?')
if test:
info = (self.nameEntry.get(), )
bd = DbGenre()
bd.addNewGenre(info)
self.frameApp.destroy()
SeeGenre(mainFrame)
else:
messagebox.showinfo('Erreur', 'Veuillez remplir tous les champs')
class SeeGenre:
def __init__(self, frame):
self.frameApp = tkinter.Frame(frame)
self.frameApp.pack(side='left', fill='both', expand=1)
#
self.secondFrame = tkinter.Frame(self.frameApp)
self.secondFrame.pack(side='top', fill='both', expand=1)
#
self.db = DbGenre()
self.data = self.db.findAllGenres()
self.seeAllItem()
def seeAllItem(self):
if self.data is None:
messagebox.showinfo("Echec",
'Connexion à la base de données perdue')
elif len(self.data) == 0:
self.label = tkinter.Label(
self.secondFrame, text='Aucun Genre de Jeux Video dans la BDD')
self.label.grid(row=1, column=1)
else:
i = 1
y = 2
lab = tkinter.Label(self.secondFrame,
text='Tous les genres de jeux existant')
lab.grid(row=0, column=0, columnspan=5, padx=10)
for genre in self.data:
if i > 4:
i = 1
y += 1
label = tkinter.Label(self.secondFrame, text=genre[1])
label.grid(row=y, column=i, pady=10, padx=10)
i += 1
def getIdGenre(self):
database = DbGenre()
nom = (genreBox.get(),)
return database.findOneGenre(nom)[0]
def getAllGenre(self):
db = DbGenre()
data = db.findAllGenres()
for genre in data:
self.values.append(genre[1])
def getAllGenres(self):
db = DbGenre()
data = db.findAllGenres()
for console in data :
self.values.append(console[1])
def getGenres(self):
database = DbGenre()
data = database.findAllGenres()
for genre in data :
self.valuesGenre.append(genre[1])