Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pymysql.cursors
- from PyQt5 import QtCore, QtGui, QtWidgets
- class Ui_Form(object):
- def sql_stuff(self):
- cnx = pymysql.connect(user='root',
- password='ptekm8n8',
- host='127.0.0.1',
- database='toiletdb')
- cursor = cnx.cursor()
- query1 = ("""SELECT t.adress, t.zipcode, t.status from toiletdata t
- NATURAL LEFT JOIN descriptiondb d NATURAL LEFT JOIN ratingdb r ORDER BY toilet_id""")
- cursor.execute(query1)
- fetchq = cursor.fetchall()
- query2 = ("""SELECT t.adress, r.rating, d.suggest_description from toiletdata t
- NATURAL LEFT JOIN descriptiondb d NATURAL LEFT JOIN ratingdb r ORDER BY toilet_id""")
- cursor.execute(query2)
- fetchq2 = cursor.fetchall()
- query3 = ('SELECT zipcode, cityname FROM zipcodedb ORDER BY zipcode')
- cursor.execute(query3)
- fetchq3 = cursor.fetchall()
- self.Placering_table.setRowCount(0)
- self.rating_table.setRowCount(0)
- self.tableWidget.setRowCount(0)
- for row_number, row_data in enumerate(fetchq):
- self.Placering_table.insertRow(row_number)
- for column_number, data in enumerate(row_data):
- self.Placering_table.setItem(row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
- for row_number, row_data in enumerate(fetchq2):
- self.rating_table.insertRow(row_number)
- for column_number, data in enumerate(row_data):
- self.rating_table.setItem(row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
- for row_number, row_data in enumerate(fetchq3):
- self.tableWidget.insertRow(row_number)
- for column_number, data in enumerate(row_data):
- self.tableWidget.setItem(row_number, column_number, QtWidgets.QTableWidgetItem(str(data)))
- cnx.close()
- def setupUi(self, Form):
- Form.setObjectName("Form")
- Form.resize(905, 692)
- Form.setStyleSheet("background-color: rgb(255, 255, 255);")
- self.horizontalLayout_2 = QtWidgets.QHBoxLayout(Form)
- self.horizontalLayout_2.setObjectName("horizontalLayout_2")
- self.verticalLayout = QtWidgets.QVBoxLayout()
- self.verticalLayout.setObjectName("verticalLayout")
- self.formLayout_2 = QtWidgets.QFormLayout()
- self.formLayout_2.setSizeConstraint(QtWidgets.QLayout.SetDefaultConstraint)
- self.formLayout_2.setObjectName("formLayout_2")
- spacerItem = QtWidgets.QSpacerItem(40, 20, QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
- self.formLayout_2.setItem(0, QtWidgets.QFormLayout.LabelRole, spacerItem)
- self.search_label = QtWidgets.QLabel(Form)
- font = QtGui.QFont()
- font.setPointSize(10)
- self.search_label.setFont(font)
- self.search_label.setObjectName("search_label")
- self.formLayout_2.setWidget(0, QtWidgets.QFormLayout.FieldRole, self.search_label)
- self.post_label = QtWidgets.QLabel(Form)
- font = QtGui.QFont()
- font.setPointSize(10)
- self.post_label.setFont(font)
- self.post_label.setObjectName("post_label")
- self.formLayout_2.setWidget(1, QtWidgets.QFormLayout.LabelRole, self.post_label)
- self.lineEdit = QtWidgets.QLineEdit(Form)
- sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Expanding, QtWidgets.QSizePolicy.Minimum)
- sizePolicy.setHorizontalStretch(0)
- sizePolicy.setVerticalStretch(0)
- sizePolicy.setHeightForWidth(self.lineEdit.sizePolicy().hasHeightForWidth())
- self.lineEdit.setSizePolicy(sizePolicy)
- font = QtGui.QFont()
- font.setPointSize(10)
- self.lineEdit.setFont(font)
- self.lineEdit.setObjectName("lineEdit")
- self.formLayout_2.setWidget(1, QtWidgets.QFormLayout.FieldRole, self.lineEdit)
- self.label_4 = QtWidgets.QLabel(Form)
- font = QtGui.QFont()
- font.setPointSize(10)
- self.label_4.setFont(font)
- self.label_4.setObjectName("label_4")
- self.formLayout_2.setWidget(2, QtWidgets.QFormLayout.LabelRole, self.label_4)
- self.lineEdit_2 = QtWidgets.QLineEdit(Form)
- font = QtGui.QFont()
- font.setPointSize(10)
- self.lineEdit_2.setFont(font)
- self.lineEdit_2.setObjectName("lineEdit_2")
- self.formLayout_2.setWidget(2, QtWidgets.QFormLayout.FieldRole, self.lineEdit_2)
- self.min_label = QtWidgets.QLabel(Form)
- font = QtGui.QFont()
- font.setPointSize(10)
- self.min_label.setFont(font)
- self.min_label.setObjectName("min_label")
- self.formLayout_2.setWidget(3, QtWidgets.QFormLayout.LabelRole, self.min_label)
- self.dropdown_rating = QtWidgets.QComboBox(Form)
- self.dropdown_rating.setContextMenuPolicy(QtCore.Qt.DefaultContextMenu)
- self.dropdown_rating.setObjectName("dropdown_rating")
- self.dropdown_rating.addItem("")
- self.dropdown_rating.addItem("")
- self.dropdown_rating.addItem("")
- self.dropdown_rating.addItem("")
- self.dropdown_rating.addItem("")
- self.dropdown_rating.addItem("")
- self.formLayout_2.setWidget(3, QtWidgets.QFormLayout.FieldRole, self.dropdown_rating)
- self.verticalLayout.addLayout(self.formLayout_2)
- self.pushButton = QtWidgets.QPushButton(Form)
- sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Minimum, QtWidgets.QSizePolicy.Minimum)
- sizePolicy.setHorizontalStretch(5)
- sizePolicy.setVerticalStretch(0)
- sizePolicy.setHeightForWidth(self.pushButton.sizePolicy().hasHeightForWidth())
- self.pushButton.setSizePolicy(sizePolicy)
- self.pushButton.setMinimumSize(QtCore.QSize(5, 5))
- self.pushButton.setBaseSize(QtCore.QSize(0, 5))
- font = QtGui.QFont()
- font.setPointSize(10)
- font.setBold(False)
- font.setWeight(50)
- self.pushButton.setFont(font)
- self.pushButton.setObjectName("pushButton")
- self.verticalLayout.addWidget(self.pushButton)
- spacerItem1 = QtWidgets.QSpacerItem(20, 20, QtWidgets.QSizePolicy.Minimum, QtWidgets.QSizePolicy.Expanding)
- self.verticalLayout.addItem(spacerItem1)
- self.gridLayout_15 = QtWidgets.QGridLayout()
- self.gridLayout_15.setObjectName("gridLayout_15")
- self.PICTURE_TOILET = QtWidgets.QLabel(Form)
- self.PICTURE_TOILET.setText("")
- self.PICTURE_TOILET.setPixmap(QtGui.QPixmap("Toilet_transparent.png"))
- self.PICTURE_TOILET.setScaledContents(True)
- self.PICTURE_TOILET.setObjectName("PICTURE_TOILET")
- self.gridLayout_15.addWidget(self.PICTURE_TOILET, 0, 0, 1, 1)
- self.verticalLayout.addLayout(self.gridLayout_15)
- self.horizontalLayout_2.addLayout(self.verticalLayout)
- self.tabWidget = QtWidgets.QTabWidget(Form)
- sizePolicy = QtWidgets.QSizePolicy(QtWidgets.QSizePolicy.Minimum, QtWidgets.QSizePolicy.Expanding)
- sizePolicy.setHorizontalStretch(0)
- sizePolicy.setVerticalStretch(0)
- sizePolicy.setHeightForWidth(self.tabWidget.sizePolicy().hasHeightForWidth())
- self.tabWidget.setSizePolicy(sizePolicy)
- self.tabWidget.setMinimumSize(QtCore.QSize(500, 50))
- font = QtGui.QFont()
- font.setPointSize(11)
- font.setBold(False)
- font.setWeight(50)
- self.tabWidget.setFont(font)
- self.tabWidget.setFocusPolicy(QtCore.Qt.NoFocus)
- self.tabWidget.setObjectName("tabWidget")
- self.Placering = QtWidgets.QWidget()
- self.Placering.setObjectName("Placering")
- self.Placering_table = QtWidgets.QTableWidget(self.Placering)
- self.Placering_table.setGeometry(QtCore.QRect(0, 0, 491, 651))
- self.Placering_table.setRowCount(0)
- self.Placering_table.setColumnCount(3)
- self.Placering_table.setObjectName("Placering_table")
- item = QtWidgets.QTableWidgetItem()
- self.Placering_table.setHorizontalHeaderItem(0, item)
- item = QtWidgets.QTableWidgetItem()
- self.Placering_table.setHorizontalHeaderItem(1, item)
- item = QtWidgets.QTableWidgetItem()
- self.Placering_table.setHorizontalHeaderItem(2, item)
- self.tabWidget.addTab(self.Placering, "")
- self.Rating_beskrivelse = QtWidgets.QWidget()
- self.Rating_beskrivelse.setObjectName("Rating_beskrivelse")
- self.rating_table = QtWidgets.QTableWidget(self.Rating_beskrivelse)
- self.rating_table.setGeometry(QtCore.QRect(-10, 0, 501, 651))
- self.rating_table.setColumnCount(3)
- self.rating_table.setObjectName("rating_table")
- self.rating_table.setRowCount(0)
- item = QtWidgets.QTableWidgetItem()
- self.rating_table.setHorizontalHeaderItem(0, item)
- item = QtWidgets.QTableWidgetItem()
- self.rating_table.setHorizontalHeaderItem(1, item)
- item = QtWidgets.QTableWidgetItem()
- self.rating_table.setHorizontalHeaderItem(2, item)
- self.tabWidget.addTab(self.Rating_beskrivelse, "")
- self.Postnummer = QtWidgets.QWidget()
- self.Postnummer.setObjectName("Postnummer")
- self.tableWidget = QtWidgets.QTableWidget(self.Postnummer)
- self.tableWidget.setGeometry(QtCore.QRect(0, 0, 491, 651))
- self.tableWidget.setColumnCount(2)
- self.tableWidget.setObjectName("tableWidget")
- self.tableWidget.setRowCount(0)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setHorizontalHeaderItem(0, item)
- item = QtWidgets.QTableWidgetItem()
- self.tableWidget.setHorizontalHeaderItem(1, item)
- self.tabWidget.addTab(self.Postnummer, "")
- self.horizontalLayout_2.addWidget(self.tabWidget)
- self.pushButton.clicked.connect(self.sql_stuff)
- self.retranslateUi(Form)
- self.tabWidget.setCurrentIndex(0)
- QtCore.QMetaObject.connectSlotsByName(Form)
- def retranslateUi(self, Form):
- _translate = QtCore.QCoreApplication.translate
- Form.setWindowTitle(_translate("Form", "Data"))
- self.search_label.setText(_translate("Form", "Søge funktioner"))
- self.post_label.setText(_translate("Form", "Post nr"))
- self.lineEdit.setText(_translate("Form", "Indtast post nr"))
- self.label_4.setText(_translate("Form", "Adresse"))
- self.lineEdit_2.setText(_translate("Form", "Indtast adresse"))
- self.min_label.setText(_translate("Form", "Vælg minimum rating"))
- self.dropdown_rating.setItemText(0, _translate("Form", "Ingen"))
- self.dropdown_rating.setItemText(1, _translate("Form", "1"))
- self.dropdown_rating.setItemText(2, _translate("Form", "2"))
- self.dropdown_rating.setItemText(3, _translate("Form", "3"))
- self.dropdown_rating.setItemText(4, _translate("Form", "4"))
- self.dropdown_rating.setItemText(5, _translate("Form", "5"))
- self.pushButton.setText(_translate("Form", "Søg"))
- item = self.Placering_table.horizontalHeaderItem(0)
- item.setText(_translate("Form", "Adresse"))
- item = self.Placering_table.horizontalHeaderItem(1)
- item.setText(_translate("Form", "Ny kolonne"))
- item = self.Placering_table.horizontalHeaderItem(2)
- item.setText(_translate("Form", "status"))
- self.tabWidget.setTabText(self.tabWidget.indexOf(self.Placering), _translate("Form", "Placering"))
- item = self.rating_table.horizontalHeaderItem(0)
- item.setText(_translate("Form", "Adresse"))
- item = self.rating_table.horizontalHeaderItem(1)
- item.setText(_translate("Form", "Rating"))
- item = self.rating_table.horizontalHeaderItem(2)
- item.setText(_translate("Form", "Beskrivelse"))
- self.tabWidget.setTabText(self.tabWidget.indexOf(self.Rating_beskrivelse), _translate("Form", "Rating og beskrivelse"))
- item = self.tableWidget.horizontalHeaderItem(0)
- item.setText(_translate("Form", "Postnummer"))
- item = self.tableWidget.horizontalHeaderItem(1)
- item.setText(_translate("Form", "Bydel"))
- self.tabWidget.setTabText(self.tabWidget.indexOf(self.Postnummer), _translate("Form", "Postnummer"))
- if __name__ == "__main__":
- import sys
- app = QtWidgets.QApplication(sys.argv)
- Form = QtWidgets.QWidget()
- ui = Ui_Form()
- ui.setupUi(Form)
- Form.show()
- sys.exit(app.exec_())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement