Advertisement
Guest User

Untitled

a guest
Mar 27th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.68 KB | None | 0 0
  1. import pymysql.cursors
  2.  
  3. from PyQt5 import QtCore, QtGui, QtWidgets
  4.  
  5. class Ui_Form(object):
  6.  
  7. def sql_stuff(self):
  8.  
  9. cnx = pymysql.connect(user='root',
  10. password='ptekm8n8',
  11. host='127.0.0.1',
  12. database='toiletdb')
  13. cursor = cnx.cursor()
  14.  
  15.  
  16.  
  17. query1 = ("""SELECT t.adress, t.zipcode, t.status from toiletdata t
  18. NATURAL LEFT JOIN descriptiondb d NATURAL LEFT JOIN ratingdb r ORDER BY toilet_id""")
  19.  
  20. cursor.execute(query1)
  21. fetchq = cursor.fetchall()
  22.  
  23. query2 = ("""SELECT t.adress, r.rating, d.suggest_description from toiletdata t
  24. NATURAL LEFT JOIN descriptiondb d NATURAL LEFT JOIN ratingdb r ORDER BY toilet_id""")
  25. cursor.execute(query2)
  26.  
  27. fetchq2 = cursor.fetchall()
  28.  
  29. query3 = ('SELECT zipcode, cityname FROM zipcodedb ORDER BY zipcode')
  30. cursor.execute(query3)
  31. fetchq3 = cursor.fetchall()
  32.  
  33.  
  34. self.Placering_table.setRowCount(0)
  35. self.rating_table.setRowCount(0)
  36. self.tableWidget.setRowCount(0)
  37.  
  38.  
  39. for row_number, row_data in enumerate(fetchq):
  40. self.Placering_table.insertRow(row_number)
  41.  
  42. for column_number, data in enumerate(row_data):
  43.  
  44. self.Placering_table.setItem(row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
  45.  
  46. for row_number, row_data in enumerate(fetchq2):
  47. self.rating_table.insertRow(row_number)
  48.  
  49. for column_number, data in enumerate(row_data):
  50.  
  51. self.rating_table.setItem(row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
  52.  
  53. for row_number, row_data in enumerate(fetchq3):
  54. self.tableWidget.insertRow(row_number)
  55.  
  56. for column_number, data in enumerate(row_data):
  57.  
  58. self.tableWidget.setItem(row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
  59.  
  60. cnx.close()
  61.  
  62.  
  63.  
  64.  
  65. def setupUi(self, Form):
  66. Form.setObjectName("Form")
  67. Form.resize(905, 692)
  68. Form.setStyleSheet("background-color: rgb(255, 255, 255);")
  69. self.horizontalLayout_2 = QtWidgets.QHBoxLayout(Form)
  70. self.horizontalLayout_2.setObjectName("horizontalLayout_2")
  71. self.verticalLayout = QtWidgets.QVBoxLayout()
  72. self.verticalLayout.setObjectName("verticalLayout")
  73. self.formLayout_2 = QtWidgets.QFormLayout()
  74. self.formLayout_2.setSizeConstraint(QtWidgets.QLayout.SetDefaultConstraint)
  75. self.formLayout_2.setObjectName("formLayout_2")
  76. spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
  77. self.formLayout_2.setItem(0, QtWidgets.QFormLayout.LabelRole, spacerItem)
  78. self.search_label = QtWidgets.QLabel(Form)
  79. font = QtGui.QFont()
  80. font.setPointSize(10)
  81. self.search_label.setFont(font)
  82. self.search_label.setObjectName("search_label")
  83. self.formLayout_2.setWidget(0, QtWidgets.QFormLayout.FieldRole, self.search_label)
  84. self.post_label = QtWidgets.QLabel(Form)
  85. font = QtGui.QFont()
  86. font.setPointSize(10)
  87. self.post_label.setFont(font)
  88. self.post_label.setObjectName("post_label")
  89. self.formLayout_2.setWidget(1, QtWidgets.QFormLayout.LabelRole, self.post_label)
  90. self.lineEdit = QtWidgets.QLineEdit(Form)
  91. sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
  92. sizePolicy.setHorizontalStretch(0)
  93. sizePolicy.setVerticalStretch(0)
  94. sizePolicy.setHeightForWidth(self.lineEdit.sizePolicy().hasHeightForWidth())
  95. self.lineEdit.setSizePolicy(sizePolicy)
  96. font = QtGui.QFont()
  97. font.setPointSize(10)
  98. self.lineEdit.setFont(font)
  99. self.lineEdit.setObjectName("lineEdit")
  100. self.formLayout_2.setWidget(1, QtWidgets.QFormLayout.FieldRole, self.lineEdit)
  101. self.label_4 = QtWidgets.QLabel(Form)
  102. font = QtGui.QFont()
  103. font.setPointSize(10)
  104. self.label_4.setFont(font)
  105. self.label_4.setObjectName("label_4")
  106. self.formLayout_2.setWidget(2, QtWidgets.QFormLayout.LabelRole, self.label_4)
  107. self.lineEdit_2 = QtWidgets.QLineEdit(Form)
  108. font = QtGui.QFont()
  109. font.setPointSize(10)
  110. self.lineEdit_2.setFont(font)
  111. self.lineEdit_2.setObjectName("lineEdit_2")
  112. self.formLayout_2.setWidget(2, QtWidgets.QFormLayout.FieldRole, self.lineEdit_2)
  113. self.min_label = QtWidgets.QLabel(Form)
  114. font = QtGui.QFont()
  115. font.setPointSize(10)
  116. self.min_label.setFont(font)
  117. self.min_label.setObjectName("min_label")
  118. self.formLayout_2.setWidget(3, QtWidgets.QFormLayout.LabelRole, self.min_label)
  119. self.dropdown_rating = QtWidgets.QComboBox(Form)
  120. self.dropdown_rating.setContextMenuPolicy(QtCore.Qt.DefaultContextMenu)
  121. self.dropdown_rating.setObjectName("dropdown_rating")
  122. self.dropdown_rating.addItem("")
  123. self.dropdown_rating.addItem("")
  124. self.dropdown_rating.addItem("")
  125. self.dropdown_rating.addItem("")
  126. self.dropdown_rating.addItem("")
  127. self.dropdown_rating.addItem("")
  128. self.formLayout_2.setWidget(3, QtWidgets.QFormLayout.FieldRole, self.dropdown_rating)
  129. self.verticalLayout.addLayout(self.formLayout_2)
  130. self.pushButton = QtWidgets.QPushButton(Form)
  131. sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Minimum, QtWidgets.QSizePolicy.Minimum)
  132. sizePolicy.setHorizontalStretch(5)
  133. sizePolicy.setVerticalStretch(0)
  134. sizePolicy.setHeightForWidth(self.pushButton.sizePolicy().hasHeightForWidth())
  135. self.pushButton.setSizePolicy(sizePolicy)
  136. self.pushButton.setMinimumSize(QtCore.QSize(5, 5))
  137. self.pushButton.setBaseSize(QtCore.QSize(0, 5))
  138.  
  139.  
  140.  
  141. font = QtGui.QFont()
  142. font.setPointSize(10)
  143. font.setBold(False)
  144. font.setWeight(50)
  145. self.pushButton.setFont(font)
  146. self.pushButton.setObjectName("pushButton")
  147. self.verticalLayout.addWidget(self.pushButton)
  148. spacerItem1 = QtWidgets.QSpacerItem(20, 20, QtWidgets.QSizePolicy.Minimum, QtWidgets.QSizePolicy.Expanding)
  149. self.verticalLayout.addItem(spacerItem1)
  150. self.gridLayout_15 = QtWidgets.QGridLayout()
  151. self.gridLayout_15.setObjectName("gridLayout_15")
  152. self.PICTURE_TOILET = QtWidgets.QLabel(Form)
  153. self.PICTURE_TOILET.setText("")
  154. self.PICTURE_TOILET.setPixmap(QtGui.QPixmap("Toilet_transparent.png"))
  155. self.PICTURE_TOILET.setScaledContents(True)
  156. self.PICTURE_TOILET.setObjectName("PICTURE_TOILET")
  157. self.gridLayout_15.addWidget(self.PICTURE_TOILET, 0, 0, 1, 1)
  158. self.verticalLayout.addLayout(self.gridLayout_15)
  159. self.horizontalLayout_2.addLayout(self.verticalLayout)
  160. self.tabWidget = QtWidgets.QTabWidget(Form)
  161. sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Minimum, QtWidgets.QSizePolicy.Expanding)
  162. sizePolicy.setHorizontalStretch(0)
  163. sizePolicy.setVerticalStretch(0)
  164. sizePolicy.setHeightForWidth(self.tabWidget.sizePolicy().hasHeightForWidth())
  165. self.tabWidget.setSizePolicy(sizePolicy)
  166. self.tabWidget.setMinimumSize(QtCore.QSize(500, 50))
  167. font = QtGui.QFont()
  168. font.setPointSize(11)
  169. font.setBold(False)
  170. font.setWeight(50)
  171. self.tabWidget.setFont(font)
  172. self.tabWidget.setFocusPolicy(QtCore.Qt.NoFocus)
  173. self.tabWidget.setObjectName("tabWidget")
  174. self.Placering = QtWidgets.QWidget()
  175. self.Placering.setObjectName("Placering")
  176. self.Placering_table = QtWidgets.QTableWidget(self.Placering)
  177. self.Placering_table.setGeometry(QtCore.QRect(0, 0, 491, 651))
  178. self.Placering_table.setRowCount(0)
  179. self.Placering_table.setColumnCount(3)
  180. self.Placering_table.setObjectName("Placering_table")
  181. item = QtWidgets.QTableWidgetItem()
  182. self.Placering_table.setHorizontalHeaderItem(0, item)
  183. item = QtWidgets.QTableWidgetItem()
  184. self.Placering_table.setHorizontalHeaderItem(1, item)
  185. item = QtWidgets.QTableWidgetItem()
  186. self.Placering_table.setHorizontalHeaderItem(2, item)
  187. self.tabWidget.addTab(self.Placering, "")
  188. self.Rating_beskrivelse = QtWidgets.QWidget()
  189. self.Rating_beskrivelse.setObjectName("Rating_beskrivelse")
  190. self.rating_table = QtWidgets.QTableWidget(self.Rating_beskrivelse)
  191. self.rating_table.setGeometry(QtCore.QRect(-10, 0, 501, 651))
  192. self.rating_table.setColumnCount(3)
  193. self.rating_table.setObjectName("rating_table")
  194. self.rating_table.setRowCount(0)
  195. item = QtWidgets.QTableWidgetItem()
  196. self.rating_table.setHorizontalHeaderItem(0, item)
  197. item = QtWidgets.QTableWidgetItem()
  198. self.rating_table.setHorizontalHeaderItem(1, item)
  199. item = QtWidgets.QTableWidgetItem()
  200. self.rating_table.setHorizontalHeaderItem(2, item)
  201. self.tabWidget.addTab(self.Rating_beskrivelse, "")
  202. self.Postnummer = QtWidgets.QWidget()
  203. self.Postnummer.setObjectName("Postnummer")
  204. self.tableWidget = QtWidgets.QTableWidget(self.Postnummer)
  205. self.tableWidget.setGeometry(QtCore.QRect(0, 0, 491, 651))
  206. self.tableWidget.setColumnCount(2)
  207. self.tableWidget.setObjectName("tableWidget")
  208. self.tableWidget.setRowCount(0)
  209. item = QtWidgets.QTableWidgetItem()
  210. self.tableWidget.setHorizontalHeaderItem(0, item)
  211. item = QtWidgets.QTableWidgetItem()
  212. self.tableWidget.setHorizontalHeaderItem(1, item)
  213. self.tabWidget.addTab(self.Postnummer, "")
  214. self.horizontalLayout_2.addWidget(self.tabWidget)
  215.  
  216.  
  217. self.pushButton.clicked.connect(self.sql_stuff)
  218.  
  219. self.retranslateUi(Form)
  220. self.tabWidget.setCurrentIndex(0)
  221. QtCore.QMetaObject.connectSlotsByName(Form)
  222.  
  223. def retranslateUi(self, Form):
  224. _translate = QtCore.QCoreApplication.translate
  225. Form.setWindowTitle(_translate("Form", "Data"))
  226. self.search_label.setText(_translate("Form", "Søge funktioner"))
  227. self.post_label.setText(_translate("Form", "Post nr"))
  228. self.lineEdit.setText(_translate("Form", "Indtast post nr"))
  229. self.label_4.setText(_translate("Form", "Adresse"))
  230. self.lineEdit_2.setText(_translate("Form", "Indtast adresse"))
  231. self.min_label.setText(_translate("Form", "Vælg minimum rating"))
  232. self.dropdown_rating.setItemText(0, _translate("Form", "Ingen"))
  233. self.dropdown_rating.setItemText(1, _translate("Form", "1"))
  234. self.dropdown_rating.setItemText(2, _translate("Form", "2"))
  235. self.dropdown_rating.setItemText(3, _translate("Form", "3"))
  236. self.dropdown_rating.setItemText(4, _translate("Form", "4"))
  237. self.dropdown_rating.setItemText(5, _translate("Form", "5"))
  238. self.pushButton.setText(_translate("Form", "Søg"))
  239. item = self.Placering_table.horizontalHeaderItem(0)
  240. item.setText(_translate("Form", "Adresse"))
  241. item = self.Placering_table.horizontalHeaderItem(1)
  242. item.setText(_translate("Form", "Ny kolonne"))
  243. item = self.Placering_table.horizontalHeaderItem(2)
  244. item.setText(_translate("Form", "status"))
  245. self.tabWidget.setTabText(self.tabWidget.indexOf(self.Placering), _translate("Form", "Placering"))
  246. item = self.rating_table.horizontalHeaderItem(0)
  247. item.setText(_translate("Form", "Adresse"))
  248. item = self.rating_table.horizontalHeaderItem(1)
  249. item.setText(_translate("Form", "Rating"))
  250. item = self.rating_table.horizontalHeaderItem(2)
  251. item.setText(_translate("Form", "Beskrivelse"))
  252. self.tabWidget.setTabText(self.tabWidget.indexOf(self.Rating_beskrivelse), _translate("Form", "Rating og beskrivelse"))
  253. item = self.tableWidget.horizontalHeaderItem(0)
  254. item.setText(_translate("Form", "Postnummer"))
  255. item = self.tableWidget.horizontalHeaderItem(1)
  256. item.setText(_translate("Form", "Bydel"))
  257. self.tabWidget.setTabText(self.tabWidget.indexOf(self.Postnummer), _translate("Form", "Postnummer"))
  258.  
  259.  
  260. if __name__ == "__main__":
  261. import sys
  262. app = QtWidgets.QApplication(sys.argv)
  263. Form = QtWidgets.QWidget()
  264. ui = Ui_Form()
  265. ui.setupUi(Form)
  266. Form.show()
  267. sys.exit(app.exec_())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement