QTableView 按 UserRole 对列数据进行排序 [英] QTableView sort column data by UserRole

问题描述

我有一个 QStandardItemModel 管道到 QTableView.我的模型中的一列包含具有用户友好的 displayData 和计算机友好的 userData 的日期.例如，一个 QStandardItem 可能会显示一个类似 22 Nov 2018 的字符串，但用户数据看起来像 324586(自纪元以来的秒数).但是，当我对列进行排序时，它当然会按 displayData 进行排序.如何强制表按 userData 排序?

解决方案

你必须使用

虽然我更喜欢直接保存 QDateTime 并使用委托以您想要的格式显示数据.

from PyQt5 import QtCore, QtGui, QtWidgets随机导入日期列 = 1类 DateDelegate(QtWidgets.QStyledItemDelegate):def displayText(self, value, locale):返回 locale.toString(value, "dd MMM yyyy")类 MainWindow(QtWidgets.QMainWindow):def __init__(self, parent=None):super(MainWindow, self).__init__(parent)self._tableView = QtWidgets.QTableView()self.setCentralWidget(self._tableView)self._model = QtGui.QStandardItemModel(10, 4)self._tableView.setModel(self._model)委托 = DateDelegate(self._tableView)self._tableView.setItemDelegateForColumn(日期列，委托)now_second = QtCore.QDateTime.currentDateTime().toSecsSinceEpoch()对于 i 在范围内(self._model.rowCount()):对于范围内的 j(self._model.columnCount()):如果 j == 日期列:t = QtCore.QDateTime.fromSecsSinceEpoch(random.randint(0, now_second))它 = QtGui.QStandardItem()it.setData(t, QtCore.Qt.DisplayRole)别的:it = QtGui.QStandardItem("{}-{}".format(i, j))self._model.setItem(i, j, it)self._model.sort(日期列，QtCore.Qt.AscendingOrder)如果 __name__ == '__main__':导入系统app = QtWidgets.QApplication(sys.argv)w = 主窗口()w.show()sys.exit(app.exec_())

I have a QStandardItemModel piped into a QTableView. One of the columns in my model contains dates which have user-friendly displayData and computer-friendly userData. So for example one QStandardItem might display a string like 22 Nov 2018 but the userdata would look like 324586 (seconds since the epoch). However when I sort the column it of course sorts by the displayData. How can I force the table to sort by userData instead?

解决方案

You have to use setSortRole():

from PyQt5 import QtCore, QtGui, QtWidgets
import random

DATECOLUMN = 1

class MainWindow(QtWidgets.QMainWindow):
    def __init__(self, parent=None):
        super(MainWindow, self).__init__(parent)
        self._tableView = QtWidgets.QTableView()
        self.setCentralWidget(self._tableView)

        self._model = QtGui.QStandardItemModel(10, 4) 
        self._tableView.setModel(self._model)

        now_second = QtCore.QDateTime.currentDateTime().toSecsSinceEpoch()
        for i in range(self._model.rowCount()):
            for j in range(self._model.columnCount()):
                if j == DATECOLUMN:
                    t = QtCore.QDateTime.fromSecsSinceEpoch(random.randint(0, now_second))
                    text = t.toString("dd MMM yyyy")
                    it = QtGui.QStandardItem(text)
                    it.setData(t.toSecsSinceEpoch(), QtCore.Qt.UserRole)
                else:
                    it = QtGui.QStandardItem("{}-{}".format(i, j))
                self._model.setItem(i, j, it)

        self._model.setSortRole(QtCore.Qt.UserRole)
        self._model.sort(DATECOLUMN, QtCore.Qt.AscendingOrder)

if __name__ == '__main__':
    import sys
    app = QtWidgets.QApplication(sys.argv)
    w = MainWindow()
    w.show()
    sys.exit(app.exec_())

Although I prefer to save the QDateTime directly and use a delegate to show the data with the format you want.

from PyQt5 import QtCore, QtGui, QtWidgets
import random

DATECOLUMN = 1

class DateDelegate(QtWidgets.QStyledItemDelegate):
    def displayText(self, value, locale):
        return locale.toString(value, "dd MMM yyyy")

class MainWindow(QtWidgets.QMainWindow):
    def __init__(self, parent=None):
        super(MainWindow, self).__init__(parent)
        self._tableView = QtWidgets.QTableView()
        self.setCentralWidget(self._tableView)

        self._model = QtGui.QStandardItemModel(10, 4) 
        self._tableView.setModel(self._model)
        delegate = DateDelegate(self._tableView)
        self._tableView.setItemDelegateForColumn(DATECOLUMN, delegate)

        now_second = QtCore.QDateTime.currentDateTime().toSecsSinceEpoch()
        for i in range(self._model.rowCount()):
            for j in range(self._model.columnCount()):
                if j == DATECOLUMN:
                    t = QtCore.QDateTime.fromSecsSinceEpoch(random.randint(0, now_second))
                    it = QtGui.QStandardItem()
                    it.setData(t, QtCore.Qt.DisplayRole)
                else:
                    it = QtGui.QStandardItem("{}-{}".format(i, j))
                self._model.setItem(i, j, it)

        self._model.sort(DATECOLUMN, QtCore.Qt.AscendingOrder)

if __name__ == '__main__':
    import sys
    app = QtWidgets.QApplication(sys.argv)
    w = MainWindow()
    w.show()
    sys.exit(app.exec_())

这篇关于QTableView 按 UserRole 对列数据进行排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！