Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def searchPackages (self, searchField, searchValue):
- if (searchField == "appName"):
- query = "SELECT appName, appDescription, appPackage, appIcon FROM apps WHERE appName LIKE %s"
- if (searchField == "Description"):
- query = "SELECT appName, appDescription, appPackage, appIcon FROM apps WHERE appDescription LIKE %s"
- if (searchField == "Package"):
- query = "SELECT appName, appDescription, appPackage, appIcon FROM apps WHERE appPackage LIKE %s"
- voc = []
- try:
- conn = mysql.connector.connect(host='localhost',
- database='depot',
- user='dbadmin',
- password='Apassword')
- cursor = conn.cursor()
- cursor.execute(query, ("%" + searchValue + "%",))
- rows = cursor.fetchall()
- list = ""
- for item in rows:
- list += item[0] + ":"
- list += item[1] + ":"
- list += item[2] + ":"
- path = "images/" + item[2] + ".png"
- #self.write_file(item[3], path)
- list += "../" + path + ":"
- if (self.isInstalled(item[2])):
- list += "true;"
- else:
- list += "false;"
- voc.append(list)
- list = ""
- except Error as e:
- print(e)
- self.sumResult.emit(e)
- finally:
- cursor.close()
- conn.close()
- return voc
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement