Python-сообщество

# -*- coding: utf-8 -*-
import sys
from PyQt4 import QtCore, QtGui

class MyWindow(QtGui.QWidget):
    def __init__(self, *args):
        QtGui.QWidget.__init__(self, *args)

        table = self.createTable()

        layout = QtGui.QVBoxLayout()
        layout.addWidget(table)
        self.setLayout(layout)


    def createTable(self):
        tv = QtGui.QTableView()
        tm = MyTableModel(self)

        # set the proxy model
        pm = QtGui.QSortFilterProxyModel(self)
        pm.setSourceModel(tm)

        tv.setModel(pm)
        tv.setMinimumSize(400, 300)

        # show vertical header
        tv.verticalHeader().setVisible(True)

        # Сортировка по щелчку на заголовке столбца
        tv.setSortingEnabled(True)
        tv.sortByColumn(0, QtCore.Qt.AscendingOrder)

        return tv

class MyTableModel(QtCore.QAbstractTableModel):
    def __init__(self, parent=None, *args):
        QtCore.QAbstractTableModel.__init__(self, parent, *args)

        self.colLabels = ['Col1', 'Col2', 'Col3', 'Col4', 'Col5']
        self.cached = [
                        ['89','cell12','cell13','cell14','cell15',],
                        ['34','cell22','cell23','cell24','cell25',],
                        ['56','cell32','cell33','cell34','cell35',],
                        ['18','cell42','cell43','cell44','cell45',],
                        ['22','cell52','cell53','cell54','cell55',],
                        ['44','cell62','cell63','cell64','cell65',],
                        ['19','cell72','cell73','cell74','cell75',],
                        ['76','cell82','cell83','cell84','cell85',],
                    ]
    def rowCount(self, parent):
        return len(self.cached)

    def columnCount(self, parent):
        return len(self.colLabels)

    def data(self, index, role):
        if not index.isValid():
            return QtCore.QVariant()
        elif role != QtCore.Qt.DisplayRole and role != QtCore.Qt.EditRole:
            return QtCore.QVariant()
        value = ''
        if role == QtCore.Qt.DisplayRole:
            row = index.row()
            col = index.column()
            value = self.cached[row][col]
        return QtCore.QVariant(value)

    def headerData(self, section, orientation, role):
        if orientation == QtCore.Qt.Horizontal and role == QtCore.Qt.DisplayRole:
            return QtCore.QVariant(self.colLabels[section])
        #заголовки строк
        if orientation == QtCore.Qt.Vertical and role == QtCore.Qt.DisplayRole:
            return QtCore.QVariant("%s" % str(section + 1))
        return QtCore.QVariant()

if __name__ == "__main__":
    app = QtGui.QApplication(sys.argv)
    w = MyWindow()
    w.show()
    sys.exit(app.exec_())

#!/usr/bin/env python
# -*- coding: utf-8 -*-

from PyQt4 import QtCore, QtGui, QtSql

import connection


class TableEditor(QtGui.QDialog):
    def __init__(self, tableName, parent=None):
        super(TableEditor, self).__init__(parent)

        self.model = QtSql.QSqlTableModel(self)
        self.model.setTable(tableName)
        self.model.setEditStrategy(QtSql.QSqlTableModel.OnManualSubmit)
        self.model.select()

        self.model.setHeaderData(0, QtCore.Qt.Horizontal, "ID")
        self.model.setHeaderData(1, QtCore.Qt.Horizontal, "First name")
        self.model.setHeaderData(2, QtCore.Qt.Horizontal, "Last name")

        self.pm = QtGui.QSortFilterProxyModel(self)
        self.pm.setSourceModel(self.model)

        view = QtGui.QTableView()
        view.setModel(self.pm)

        # Сортировка по щелчку на заголовке столбца
        view.setSortingEnabled(True)
        view.sortByColumn(0, QtCore.Qt.AscendingOrder)

        submitButton = QtGui.QPushButton("Submit")
        submitButton.setDefault(True)
        revertButton = QtGui.QPushButton("&Revert")
        quitButton = QtGui.QPushButton("Quit")

        buttonBox = QtGui.QDialogButtonBox(QtCore.Qt.Vertical)
        buttonBox.addButton(submitButton, QtGui.QDialogButtonBox.ActionRole)
        buttonBox.addButton(revertButton, QtGui.QDialogButtonBox.ActionRole)
        buttonBox.addButton(quitButton, QtGui.QDialogButtonBox.RejectRole)

        submitButton.clicked.connect(self.submit)
        revertButton.clicked.connect(self.model.revertAll)
        quitButton.clicked.connect(self.close)

        mainLayout = QtGui.QHBoxLayout()
        mainLayout.addWidget(view)
        mainLayout.addWidget(buttonBox)
        self.setLayout(mainLayout)

        self.setWindowTitle("Cached Table")

    def submit(self):
        self.model.database().transaction()
        if self.model.submitAll():
            self.model.database().commit()
        else:
            self.model.database().rollback()
            QtGui.QMessageBox.warning(self, "Cached Table",
                        "The database reported an error: %s" % self.model.lastError().text())


if __name__ == '__main__':

    import sys

    app = QtGui.QApplication(sys.argv)
    if not connection.createConnection():
        sys.exit(1)

    editor = TableEditor('person')
    editor.show()
    sys.exit(editor.exec_())