#!-*-coding:utf-8-*-
import sys
import fdb
# import PyQt4 QtCore and QtGui modules
from PyQt4.QtCore import *
from PyQt4.QtGui import *
from PyQt4 import uic
(Ui_MainWindow, QMainWindow) = uic.loadUiType('Sql_grid.ui')
class MainWindow(QMainWindow):
    """MainWindow inherits QMainWindow"""
    def __init__(self, parent=None):
        QMainWindow.__init__(self, parent)
        self.ui = Ui_MainWindow()
        self.ui.setupUi(self)
    def __del__(self):
        self.ui = None
class TableSql(QAbstractTableModel):
    def __init__(self, strings):
        QAbstractTableModel.__init__(self)
        self._stringList = strings
    def rowCount(self, parent=QModelIndex()):
        return len(self._stringList)
    def columnCount(self, parent=QModelIndex()):
        return len(self._stringList[0])
    def data(self, index, role):
        if index.isValid and index.row() < len(self._stringList):
            if role == Qt.DisplayRole or role == Qt.EditRole:
                return self._stringList[index.row()][index.column()]
        pass
#-----------------------------------------------------#
if __name__ == '__main__':
    # create application
    app = QApplication(sys.argv)
    app.setApplicationName('test_my')
    # create widget
    w = MainWindow()
    w.setWindowTitle('test_my')
    con = fdb.connect(dsn='/firebird/2.5/data/employee.fdb', user='SYSDBA', password='123456',
                      charset='UTF8')
    cur = con.cursor()
    cur.execute("SELECT r.EMP_NO, r.CHANGE_DATE, r.UPDATER_ID, r.OLD_SALARY,"
                "r.PERCENT_CHANGE,r.NEW_SALARY FROM SALARY_HISTORY r")
    result = cur.fetchall()
    model = TableSql(result)
    w.ui.tableView.setModel(model)
    w.show()
    # connection
    QObject.connect(app, SIGNAL('lastWindowClosed()'), app, SLOT('quit()'))
    # execute application
    sys.exit(app.exec_())