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])