Advertisement
Guest User

Untitled

a guest
Jan 28th, 2020
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.68 KB | None | 0 0
  1. def showMovieWindow(self):
  2.  
  3. '''
  4. Fyller huvudframen med rätt objekt för att visa alla böcker
  5. :param frame: Huvudframen
  6. :return: Void
  7. '''
  8. try:
  9. self.topFrame.destroy()
  10. self.contentFrame.destroy()
  11. self.mainFrame.destroy()
  12. except:
  13. pass
  14.  
  15. self.mainFrame = tk.Frame(self.root)
  16. self.mainFrame.pack(expand=1, fill=tk.BOTH)
  17.  
  18. self.backbutton = tk.Button(self.mainFrame, text="Tillbaka", command=lambda: self.__init__(self.root))
  19. self.backbutton.pack(side=TOP)
  20.  
  21. def visaEgenListaFilmer():
  22. results = self.DBConn("SELECT * FROM egenlista")
  23.  
  24. scrollbar = tk.Scrollbar(self.mainFrame)
  25. scrollbar.pack(side=tk.RIGHT, fill=tk.Y)
  26.  
  27. movieListInTk = tk.Listbox(self.mainFrame, yscrollcommand=scrollbar.set)
  28. for z in results:
  29. movieListInTk.insert(tk.END, "Movieid: {}\n".format(z[0]))
  30. movieListInTk.insert(tk.END, "Title: {}\n".format(z[1]))
  31. movieListInTk.insert(tk.END, "Score: {}\n".format(z[2]))
  32. movieListInTk.insert(tk.END, "Regissör: {}\n".format(z[3]))
  33. movieListInTk.insert(tk.END, "År: {}\n".format(z[4]))
  34. movieListInTk.insert(tk.END, "Genre: {}\n".format(z[5]))
  35. movieListInTk.insert(tk.END, "RunTime: {}\n".format(z[6]) + " minuter")
  36. movieListInTk.insert(tk.END, "\n")
  37.  
  38. movieListInTk.pack(side=tk.LEFT, expand=1, fill=tk.BOTH)
  39. scrollbar.config(command=movieListInTk.yview)
  40.  
  41.  
  42. def visaAllaFilmer(self):
  43. results = self.DBConn("SELECT * FROM movies, egenlista")
  44.  
  45. scrollbar = tk.Scrollbar(self.mainFrame)
  46. scrollbar.pack(side=tk.RIGHT, fill=tk.Y)
  47.  
  48. movieListInTk = tk.Listbox(self.mainFrame, yscrollcommand=scrollbar.set)
  49. for z in results:
  50. movieListInTk.insert(tk.END, "Movieid: {}\n".format(z[0]))
  51. movieListInTk.insert(tk.END, "Title: {}\n".format(z[1]))
  52. movieListInTk.insert(tk.END, "Score: {}\n".format(z[2]))
  53. movieListInTk.insert(tk.END, "Regissör: {}\n".format(z[3]))
  54. movieListInTk.insert(tk.END, "År: {}\n".format(z[4]))
  55. movieListInTk.insert(tk.END, "Genre: {}\n".format(z[5]))
  56. movieListInTk.insert(tk.END, "RunTime: {}\n".format(z[6]) + " minuter")
  57. movieListInTk.insert(tk.END, "\n")
  58.  
  59. movieListInTk.pack(side=tk.LEFT, expand=1, fill=tk.BOTH)
  60. scrollbar.config(command=movieListInTk.yview)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement