我正在尝试制作一个每1分钟更新一次gui的绘制事件。。以下是main.py的代码:
# -*- coding: utf-8 -*-
from PyQt4 import QtGui, QtCore
import sys
import main3, report
import MySQLdb
db = MySQLdb.connect(host="localhost", # your host, usually localhost
user="root", # your username
passwd="**************", # your password
db="health",
port=3306) # name of the data base
cur = db.cursor()
class report(QtGui.QMainWindow, report.Ui_Report1):
def __init__(self, p_id, parent=None):
super(report, self).__init__(parent)
self.setupUi(self)
self.lineEdit.setText('ID: ' + str(p_id))
cur.execute("SELECT * FROM patient WHERE id = '%s'"%(p_id))
pt_row_report = cur.fetchall()
for row in pt_row_report:
pt_name_report = row[1]
pt_age_report = row[2]
cur.execute("SELECT * FROM clinic WHERE p_id = '%s'"%(p_id))
clinic_row = cur.fetchone()
d_id = clinic_row[2]
ray_type1 = clinic_row[6]
ray_type = ray_type1[17:]
cur.execute("SELECT * FROM staff WHERE id = '%s'"%(d_id))
staff_row = cur.fetchall()[0]
doctor_name = staff_row[1]
doctor_id = staff_row[0]
self.lineEdit_2.setText('Name: ' + str(pt_name_report))
self.lineEdit_3.setText('Age: ' + str(pt_age_report))
self.lineEdit_6.setText(str(ray_type))
self.lineEdit_7.setText('Dr. ' + str(doctor_name))
cur.execute("SELECT Name FROM staff WHERE id = 48588")
ray_dr_name = cur.fetchone()[0]
self.lineEdit_4.setText('Dr. ' + str(ray_dr_name))
self.pushButton.clicked.connect(lambda: self.update_report(p_id, ray_type,doctor_id))
def update_report(self, name, ray, d_id):
x = self.textEdit.toPlainText()
sql = "UPDATE clinic SET Extra_Notice = (%s) WHERE p_id=(%s)"
cur.execute(sql,(x,name))
db.commit()
cur.execute("INSERT INTO rays (p_ID, Ray_Type, Report, D_ID, RS_ID) VALUES (%s,%s,%s,%s,%s)", (int(name), ray, x, d_id, 48588))
db.commit()
def get_text(self, x):
x = self.textEdit.text()
return x
class First(QtGui.QMainWindow, main3.Ui_MainWindow):
def __init__(self, parent=None):
super(First, self).__init__(parent)
self.setupUi(self)
timer = QtCore.QTimer(self)
timer.timeout.connect(self.reload_data)
timer.start(60*1000)
self.reload_data()
def reload_data(self):
self.tableWidget.clear()
self.tableWidget.setColumnCount(7)
cur.execute("SELECT * FROM clinic WHERE Extra_Notice LIKE %s",("%{}%".format('x-ray is required'),))
test_list = cur.fetchall()
queue = 1
for row in test_list:
c_id = row[0]
p_id = row[1]
cur.execute("SELECT * FROM patient WHERE id = '%s'"%(p_id))
pt = cur.fetchall()[0]
if pt:
pt_name = pt[1]
pt_age = pt[2]
pt_address = pt[4]
pt_phone = pt[3]
button = QtGui.QPushButton('Make Operation')
button.setStyleSheet("background-color: #4f81bc; color: white;")
button.clicked.connect(lambda checked, p_id=p_id : self.open_report(p_id))
rowposition = self.tableWidget.rowCount()
self.tableWidget.insertRow(rowposition)
for i, val in enumerate([queue, c_id, pt_name, pt_age, pt_address, pt_phone]):
self.tableWidget.setItem(rowposition , i , QtGui.QTableWidgetItem(str(val)))
self.tableWidget.setCellWidget(rowposition , 6, button)
queue += 1
def open_report(self, p_id):
self.child_win = report(p_id)
self.child_win.show()
sys.exit(app.exec_())
return p_id
def main():
app = QtGui.QApplication(sys.argv)
app.setStyle('Plastique')
main = First()
main.update()
main.show()
sys.exit(app.exec_())
if __name__ == '__main__':
main()
以下是qdesign生成的ui设计代码:
# -*- coding: utf-8 -*-
# Form implementation generated from reading ui file 'main.ui'
#
# Created: Sun Jul 1 17:18:19 2018
# by: PyQt4 UI code generator 4.10
#
# WARNING! All changes made in this file will be lost!
from PyQt4 import QtCore, QtGui
import datetime
import MySQLdb
import r_rc
import r_new_rc
db = MySQLdb.connect(host="localhost", # your host, usually localhost
user="root", # your username
passwd="***************", # your password
db="health",
port=3306) # name of the data base
cur = db.cursor()
try:
_fromUtf8 = QtCore.QString.fromUtf8
except AttributeError:
def _fromUtf8(s):
return s
try:
_encoding = QtGui.QApplication.UnicodeUTF8
def _translate(context, text, disambig):
return QtGui.QApplication.translate(context, text, disambig, _encoding)
except AttributeError:
def _translate(context, text, disambig):
return QtGui.QApplication.translate(context, text, disambig)
class AlignDelegate(QtGui.QItemDelegate):
def paint(self, painter, option, index):
option.displayAlignment = QtCore.Qt.AlignCenter
QtGui.QItemDelegate.paint(self, painter, option, index)
class Ui_MainWindow(object):
date = datetime.datetime.now().strftime ("%d - %m - %Y")
def setupUi(self, MainWindow):
MainWindow.setObjectName(_fromUtf8("MainWindow"))
MainWindow.resize(723, 372)
MainWindow.setStyleSheet(_fromUtf8("background-color: qradialgradient(spread:pad, cx:0.5, cy:0.5, radius:0.5, fx:0.488636, fy:0.506, stop:0.443182 rgba(135, 164, 207, 255), stop:0.9375 rgba(0, 0, 164, 255));"))
MainWindow.setAnimated(True)
MainWindow.setDocumentMode(False)
MainWindow.setUnifiedTitleAndToolBarOnMac(False)
self.centralwidget = QtGui.QWidget(MainWindow)
self.centralwidget.setObjectName(_fromUtf8("centralwidget"))
self.label2 = QtGui.QLabel(self.centralwidget)
self.label2.setGeometry(QtCore.QRect(120, 10, 481, 51))
self.label2.setStyleSheet(_fromUtf8("background-color: #0000a4;color: gray;\n"
"font: 75 18pt \"Arial\";\n"))
self.label2.setObjectName(_fromUtf8("textEdit"))
self.label2.setText(' Analysis & Rays')
self.lineEdit = QtGui.QLineEdit(self.centralwidget)
self.lineEdit.setGeometry(QtCore.QRect(210, 70, 321, 31))
self.lineEdit.setStyleSheet(_fromUtf8("background-color: rgb(255, 255, 255);"))
self.lineEdit.setObjectName(_fromUtf8("lineEdit"))
self.lineEdit.setText(self.date)
self.lineEdit.setReadOnly(True)
self.tableWidget = QtGui.QTableWidget(self.centralwidget)
self.tableWidget.setGeometry(QtCore.QRect(10, 120, 701, 231))
sizePolicy = QtGui.QSizePolicy(QtGui.QSizePolicy.Fixed, QtGui.QSizePolicy.Fixed)
sizePolicy.setHorizontalStretch(0)
sizePolicy.setVerticalStretch(0)
sizePolicy.setHeightForWidth(self.tableWidget.sizePolicy().hasHeightForWidth())
self.tableWidget.setSizePolicy(sizePolicy)
self.tableWidget.setMaximumSize(QtCore.QSize(800, 500))
self.tableWidget.setStyleSheet(_fromUtf8("background-color: rgb(255, 255, 255);"))
self.tableWidget.setObjectName(_fromUtf8("tableWidget"))
self.tableWidget.setItemDelegate(AlignDelegate())
self.tableWidget.verticalHeader().hide()
self.tableWidget.setHorizontalHeaderLabels(("Queue number;ID;Name;Age;Address;Phone;Make Operation;").split(";"))
header = self.tableWidget.horizontalHeader()
header.setResizeMode(0, QtGui.QHeaderView.Stretch)
header.setResizeMode(1, QtGui.QHeaderView.ResizeToContents)
header.setResizeMode(2, QtGui.QHeaderView.ResizeToContents)
self.label = QtGui.QLabel(self.centralwidget)
self.label.setGeometry(QtCore.QRect(640, 0, 31, 51))
self.label.setObjectName(_fromUtf8("label"))
#self.label_2 = QtGui.QLabel(self.centralwidget)
#self.label_2.setGeometry(QtCore.QRect(450, 0, 70, 65))
#self.label_2.setStyleSheet(_fromUtf8("background-color: rgb(255, 255, 255);"))
#self.label_2.setObjectName(_fromUtf8("label_2"))
MainWindow.setCentralWidget(self.centralwidget)
self.retranslateUi(MainWindow)
QtCore.QMetaObject.connectSlotsByName(MainWindow)
def retranslateUi(self, MainWindow):
MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow", None))
self.label.setText(_translate("MainWindow", "<html><head/><body><p><img src=\":/newPrefix//444.png\"/></p></body></html>", None))
##self.label_2.setText(_translate("MainWindow", "<html><head/><body><p><img src=\":/newPrefix/36611129_2021894281460024_9133838233774325760_n.png\"/></p></body></html>", None))
我需要做的是每一分钟重新更新一次tablewidget,剩下的代码只是gui中其他元素的设计,以便它显示从db获取的新项
代码正常执行,但我在控制台中不断收到这个错误,更新没有发生 TypeError: paintEvent() takes exactly 1 argument (2 given)
更新
我删除了paint事件函数,并尝试向代码的主循环中添加一个普通计时器。
如上面的代码所示,它现在可以工作了,但是每1分钟就添加一个空行,循环将永远继续向表中添加空行。
2条答案
按热度按时间snvhrwxg1#
从您的评论,您不想更新绘画,您想要的是重新加载数据,您从数据库中获得每分钟。
paintEvent()
是一种允许绘制的小部件方法,在本例中,除了该方法之外,它不是必需的update()
用于间接调用该方法,在您的情况下,我强调它不是必需的。您应该做的是创建一个负责填充QTableWidget
用一个QTimer
.x6h2sr282#
paintEvent
应该像您正在做的那样重新实现,但是qt希望它有一个特定的参数签名。请参阅文档以了解paintEvent
. 唯一的论点,event
属于类型QPaintEvent
可能会提供一些关于这个事件的额外信息。你通常不打电话paintEvent
你自己。qt在画画的时候会叫它。将函数定义更改为你应该准备好了。