Advertisement
Guest User

Untitled

a guest
Dec 4th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 KB | None | 0 0
  1. def searchPackages (self, searchField, searchValue):
  2. if (searchField == "appName"):
  3. query = "SELECT appName, appDescription, appPackage, appIcon FROM apps WHERE appName LIKE %s"
  4. if (searchField == "Description"):
  5. query = "SELECT appName, appDescription, appPackage, appIcon FROM apps WHERE appDescription LIKE %s"
  6. if (searchField == "Package"):
  7. query = "SELECT appName, appDescription, appPackage, appIcon FROM apps WHERE appPackage LIKE %s"
  8. voc = []
  9. try:
  10. conn = mysql.connector.connect(host='localhost',
  11. database='depot',
  12. user='dbadmin',
  13. password='Apassword')
  14. cursor = conn.cursor()
  15. cursor.execute(query, ("%" + searchValue + "%",))
  16. rows = cursor.fetchall()
  17. list = ""
  18. for item in rows:
  19. list += item[0] + ":"
  20. list += item[1] + ":"
  21. list += item[2] + ":"
  22. path = "images/" + item[2] + ".png"
  23. #self.write_file(item[3], path)
  24. list += "../" + path + ":"
  25. if (self.isInstalled(item[2])):
  26. list += "true;"
  27. else:
  28. list += "false;"
  29. voc.append(list)
  30. list = ""
  31.  
  32. except Error as e:
  33. print(e)
  34. self.sumResult.emit(e)
  35.  
  36. finally:
  37. cursor.close()
  38. conn.close()
  39. return voc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement