Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def showMovieWindow(self):
- '''
- Fyller huvudframen med rätt objekt för att visa alla böcker
- :param frame: Huvudframen
- :return: Void
- '''
- try:
- self.topFrame.destroy()
- self.contentFrame.destroy()
- self.mainFrame.destroy()
- except:
- pass
- self.mainFrame = tk.Frame(self.root)
- self.mainFrame.pack(expand=1, fill=tk.BOTH)
- self.backbutton = tk.Button(self.mainFrame, text="Tillbaka", command=lambda: self.__init__(self.root))
- self.backbutton.pack(side=TOP)
- def visaEgenListaFilmer():
- results = self.DBConn("SELECT * FROM egenlista")
- scrollbar = tk.Scrollbar(self.mainFrame)
- scrollbar.pack(side=tk.RIGHT, fill=tk.Y)
- movieListInTk = tk.Listbox(self.mainFrame, yscrollcommand=scrollbar.set)
- for z in results:
- movieListInTk.insert(tk.END, "Movieid: {}\n".format(z[0]))
- movieListInTk.insert(tk.END, "Title: {}\n".format(z[1]))
- movieListInTk.insert(tk.END, "Score: {}\n".format(z[2]))
- movieListInTk.insert(tk.END, "Regissör: {}\n".format(z[3]))
- movieListInTk.insert(tk.END, "År: {}\n".format(z[4]))
- movieListInTk.insert(tk.END, "Genre: {}\n".format(z[5]))
- movieListInTk.insert(tk.END, "RunTime: {}\n".format(z[6]) + " minuter")
- movieListInTk.insert(tk.END, "\n")
- movieListInTk.pack(side=tk.LEFT, expand=1, fill=tk.BOTH)
- scrollbar.config(command=movieListInTk.yview)
- def visaAllaFilmer(self):
- results = self.DBConn("SELECT * FROM movies, egenlista")
- scrollbar = tk.Scrollbar(self.mainFrame)
- scrollbar.pack(side=tk.RIGHT, fill=tk.Y)
- movieListInTk = tk.Listbox(self.mainFrame, yscrollcommand=scrollbar.set)
- for z in results:
- movieListInTk.insert(tk.END, "Movieid: {}\n".format(z[0]))
- movieListInTk.insert(tk.END, "Title: {}\n".format(z[1]))
- movieListInTk.insert(tk.END, "Score: {}\n".format(z[2]))
- movieListInTk.insert(tk.END, "Regissör: {}\n".format(z[3]))
- movieListInTk.insert(tk.END, "År: {}\n".format(z[4]))
- movieListInTk.insert(tk.END, "Genre: {}\n".format(z[5]))
- movieListInTk.insert(tk.END, "RunTime: {}\n".format(z[6]) + " minuter")
- movieListInTk.insert(tk.END, "\n")
- movieListInTk.pack(side=tk.LEFT, expand=1, fill=tk.BOTH)
- scrollbar.config(command=movieListInTk.yview)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement