API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 9th, 2017
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.87 KB | None | 0 0
raw download clone embed print report
  1. from Tkinter import *
  2. import mysql.connector
  3. from mysql.connector import errorcode
  4. import main
  5.  
  6. config = {
  7. 'user': 'mattg',
  8. 'password': 's8wncNZkttdlN2Cn',
  9. 'host': 'mysql.digispan.org',
  10. 'database': 'mattg_personalitytypes',
  11. 'raise_on_warnings': True,
  12. }
  13.  
  14.  
  15. def login_callback():
  16.  
  17. try:
  18. cnx = mysql.connector.connect(**config)
  19. cursorUser = cnx.cursor()
  20. login = ("SELECT * FROM user_database WHERE user = %s")
  21. cursorUser.execute(login, user_name)
  22. for (username) in cursorUser:
  23. print(username)
  24.  
  25.  
  26. except mysql.connector.Error as err:
  27. if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
  28. print("Something is wrong with your user name or password")
  29. elif err.errno == errorcode.ER_BAD_DB_ERROR:
  30. print("Database does not exist")
  31. else:
  32. print(err)
  33. else:
  34. cnx.close()
  35.  
  36.  
  37. def create_callback():
  38. create_user = Tk()
  39. create_user.geometry('250x400')
  40. create_user.title('Create Profile')
  41. Label(create_user, text="Desired Username: ").grid(row=0, padx=4, pady=2, sticky=W)
  42. Label(create_user, text="Password: ").grid(row=1, padx=4, pady=2, sticky=W)
  43. Label(create_user, text="Real Name: ").grid(row=2, padx=4, pady=2, sticky=W)
  44. Label(create_user, text="Age: ").grid(row=3, padx=4, pady=2, sticky=W)
  45. Label(create_user, text="Gender: ").grid(row=4, padx=4, pady=2, sticky=W)
  46. Label(create_user, text="Height?: ").grid(row=5, padx=4, pady=2, sticky=W)
  47. Label(create_user, text="Personality Type: ").grid(row=6, padx=4, pady=2, sticky=W)
  48. Label(create_user, text="Faith: ").grid(row=7, padx=4, pady=2, sticky=W)
  49. Label(create_user, text="Kids?: ").grid(row=8, padx=4, pady=2, sticky=W)
  50. Label(create_user, text="Smoker?: ").grid(row=9, padx=4, pady=2, sticky=W)
  51. Label(create_user, text="Drinker?: ").grid(row=10, padx=4, pady=2, sticky=W)
  52. Label(create_user, text="Employed?: ").grid(row=11, padx=4, pady=2, sticky=W)
  53. Label(create_user, text="Dogs?: ").grid(row=12, padx=4, pady=2, sticky=W)
  54. Label(create_user, text="Cats?: ").grid(row=13, padx=4, pady=2, sticky=W)
  55. user_create = Entry(create_user)
  56. user_create.grid(row=0, column=1, sticky=E, padx=4, pady=2)
  57. pass_create = Entry(create_user)
  58. pass_create.grid(row=1, column=1, sticky=E, padx=4, pady=2)
  59. name_create = Entry(create_user)
  60. name_create.grid(row=2, column=1, sticky=E, padx=4, pady=2)
  61. age_create = Entry(create_user)
  62. age_create.grid(row=3, column=1, sticky=E, padx=4, pady=2)
  63. gender_create = Entry(create_user)
  64. gender_create.grid(row=4, column=1, sticky=E, padx=4, pady=2)
  65. height_create = Entry(create_user)
  66. height_create.grid(row=5, column=1, sticky=E, padx=4, pady=2)
  67. TYPE_create = Entry(create_user)
  68. TYPE_create.grid(row=6, column=1, sticky=E, padx=4, pady=2)
  69. faith_create = Entry(create_user)
  70. faith_create.grid(row=7, column=1, sticky=E, padx=4, pady=2)
  71. kids_create = Entry(create_user)
  72. kids_create.grid(row=8, column=1, sticky=E, padx=4, pady=2)
  73. smoke_create = Entry(create_user)
  74. smoke_create.grid(row=9, column=1, sticky=E, padx=4, pady=2)
  75. drink_create = Entry(create_user)
  76. drink_create.grid(row=10, column=1, sticky=E, padx=4, pady=2)
  77. job_create = Entry(create_user)
  78. job_create.grid(row=11, column=1, sticky=E, padx=4, pady=2)
  79. dog_create = Entry(create_user)
  80. dog_create.grid(row=12, column=1, sticky=E, padx=4, pady=2)
  81. cat_create = Entry(create_user)
  82. cat_create.grid(row=13, column=1, sticky=E, padx=4, pady=2)
  83. user_create.focus_set()
  84. pass_create.focus_set()
  85. name_create.focus_set()
  86. age_create.focus_set()
  87. gender_create.focus_set()
  88. height_create.focus_set()
  89. TYPE_create.focus_set()
  90. faith_create.focus_set()
  91. kids_create.focus_set()
  92. smoke_create.focus_set()
  93. drink_create.focus_set()
  94. job_create.focus_set()
  95. dog_create.focus_set()
  96. cat_create.focus_set()
  97. user_get = user_create.get()
  98. pass_get = pass_create.get()
  99. name_get = name_create.get()
  100. age_get = age_create.get()
  101. gender_get = gender_create.get()
  102. height_get = height_create.get()
  103. TYPE_get = TYPE_create.get()
  104. faith_get = faith_create.get()
  105. kids_get = kids_create.get()
  106. smoke_get = smoke_create.get()
  107. drink_get = drink_create.get()
  108. job_get = job_create.get()
  109. dog_get = dog_create.get()
  110. cat_get = cat_create.get()
  111.  
  112. def add_user():
  113. try:
  114. cnx = mysql.connector.connect(**config)
  115. cursorUser = cnx.cursor()
  116. insert_user = ("INSERT INTO user_database "
  117. "(id, user, name, age, type, PASSWORD, LOCATION, GENDER, HEIGHT, FAITH, KIDS, SMOKING, DRINKING, ETHNICITY, EMPLOYED, DOGS, CATS) "
  118. "VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)")
  119.  
  120. user_info = (103, user_get, name_get, age_get, pass_get, "Hays, KS", gender_get, height_get, faith_get, kids_get, smoke_get, drink_get, "UNSPECIFIED", job_get, dog_get, cat_get)
  121. cursorUser.execute(insert_user, user_info)
  122. for (username) in cursorUser:
  123. print(username)
  124.  
  125. except mysql.connector.Error as err:
  126. if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
  127. print("Something is wrong with your user name or password")
  128. elif err.errno == errorcode.ER_BAD_DB_ERROR:
  129. print("Database does not exist")
  130. else:
  131. print(err)
  132. cnx.commit()
  133. cnx.close()
  134.  
  135. Button(create_user, text="Create Account", command=add_user).grid(row=14, column=0, padx=1, pady=2, columnspan=5)
  136. create_user.mainloop()
  137.  
  138.  
  139. def profile_callback():
  140. profile = Tk()
  141. profile.geometry('600x600')
  142. profile.title('Profile')
  143.  
  144. photo = PhotoImage(file="user_male.gif")
  145. label_p = Label(image=photo)
  146. label_p.image = photo
  147. Label(text="USERNAME HERE").grid(row=0, column=0, columnspan=2)
  148. label_p.grid(row=1, rowspan=9, column=0, columnspan=2, padx=20)
  149. Label(text="REAL NAME HERE").grid(row=10, column=0, columnspan=2, pady=10)
  150. Label(text="AGE").grid(row=11, column=0, sticky=S)
  151. Label(text="GENDER").grid(row=11, column=0, sticky=E)
  152. Label(text="TYPE").grid(row=11, column=1, sticky=S)
  153.  
  154. Label(text="Faith: UNSPECIFIED").grid(row=1, column=2, sticky=W)
  155. Label(text="Kids?: NO").grid(row=2, column=2, sticky=W)
  156. Label(text="Smoking?: NO").grid(row=3, column=2, sticky=W)
  157. Label(text="Drinker?: OCCASIONALLY").grid(row=4, column=2, sticky=W)
  158. Label(text="Height: 5'6").grid(row=5, column=2, sticky=W)
  159. Label(text="Ethnicity: UNSPECIFIED").grid(row=6, column=2, sticky=W)
  160. Label(text="Employed?: YES").grid(row=7, column=2, sticky=W)
  161. Label(text="Dogs?: YES").grid(row=8, column=2, sticky=W)
  162. Label(text="Cats?: NO").grid(row=9, column=2, sticky=W)
  163. Button(profile, text="Search Compatible", command=main.locate).grid(row=12, column=0, padx=1, pady=2, columnspan=5)
  164.  
  165. profile.mainloop()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!