main

from PyQt4 import QtCore, QtGui, QtSql
from sshtunnel import SSHTunnelForwarder

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 Ui_MainWindow(QtGui.QMainWindow):

    def setupUi(self, MainWindow):
        MainWindow.setObjectName(_fromUtf8("MainWindow"))
        MainWindow.resize(728, 391)
        self.centralwidget = QtGui.QWidget(MainWindow)
        self.centralwidget.setObjectName(_fromUtf8("centralwidget"))
        self.tableView = QtGui.QTableView(self.centralwidget)
        self.tableView.setGeometry(QtCore.QRect(20, 30, 331, 321))
        self.tableView.setObjectName(_fromUtf8("tableView"))
        self.tableView_2 = QtGui.QTableView(self.centralwidget)
        self.tableView_2.setGeometry(QtCore.QRect(360, 30, 341, 321))
        self.tableView_2.setObjectName(_fromUtf8("tableView_2"))
        self.pushButton_3 = QtGui.QPushButton(self.centralwidget)
        self.pushButton_3.setGeometry(QtCore.QRect(190, 360, 75, 23))
        self.pushButton_3.setObjectName(_fromUtf8("pushButton_3"))
        self.pushButton_4 = QtGui.QPushButton(self.centralwidget)
        self.pushButton_4.setGeometry(QtCore.QRect(270, 360, 75, 23))
        self.pushButton_4.setObjectName(_fromUtf8("pushButton_4"))
        self.pushButton_5 = QtGui.QPushButton(self.centralwidget)
        self.pushButton_5.setGeometry(QtCore.QRect(540, 360, 75, 23))
        self.pushButton_5.setObjectName(_fromUtf8("pushButton_5"))
        self.pushButton_6 = QtGui.QPushButton(self.centralwidget)
        self.pushButton_6.setGeometry(QtCore.QRect(620, 360, 75, 23))
        self.pushButton_6.setObjectName(_fromUtf8("pushButton_6"))
        self.pushButton_3.connect(self.pushButton_3, QtCore.SIGNAL("clicked()"), self.delrow)
        self.pushButton_5.connect(self.pushButton_5, QtCore.SIGNAL("clicked()"), self.delrow1)
        self.pushButton_4.connect(self.pushButton_4,QtCore.SIGNAL("clicked()"),self.addrow)
        self.pushButton_6.connect(self.pushButton_6, QtCore.SIGNAL("clicked()"), self.addrow1)
        self.label = QtGui.QLabel(self.centralwidget)
        self.label.setGeometry(QtCore.QRect(160, 10, 46, 13))
        self.label.setObjectName(_fromUtf8("label"))
        self.label_2 = QtGui.QLabel(self.centralwidget)
        self.label_2.setGeometry(QtCore.QRect(510, 10, 54, 13))
        self.label_2.setObjectName(_fromUtf8("label_2"))
        MainWindow.setCentralWidget(self.centralwidget)

        self.retranslateUi(MainWindow)
        QtCore.QMetaObject.connectSlotsByName(MainWindow)
        global server
        server = SSHTunnelForwarder(
            ('93.95.101.20', 41331),
            ssh_password="thuglife",
            ssh_username="sneak",
            remote_bind_address=('127.0.0.1', 3306))
        server.start()
        global db
        db = QtSql.QSqlDatabase.addDatabase('QMYSQL')
        db.setHostName("localhost")
        db.setPort(server.local_bind_port)
        db.setDatabaseName("mydb")
        db.setUserName("khl")
        db.setPassword("297001")
        db.open()
        global mod
        mod = QtSql.QSqlTableModel()
        mod.setTable("otdel")
        mod.setEditStrategy(QtSql.QSqlTableModel.OnRowChange)
        mod.select()
        self.tableView.setModel(mod)
        global testModel2
        testModel2 = QtSql.QSqlTableModel()
        testModel2.setTable("zayav")
        testModel2.setEditStrategy(QtSql.QSqlTableModel.OnFieldChange)
        testModel2.select()
        self.tableView_2.setModel(testModel2)

    def addrow1(self):
        testModel2 = QtSql.QSqlTableModel()
        testModel2.setTable("zayav")
        testModel2.setEditStrategy(QtSql.QSqlTableModel.OnRowChange)
        testModel2.select()
        self.tableView_2.setModel(testModel2)
        testModel2.insertRow(testModel2.rowCount())
        testModel2.insertRow(testModel2.rowCount())

    def addrow(self):
        mod = QtSql.QSqlTableModel()
        mod.setTable("otdel")
        mod.setEditStrategy(QtSql.QSqlTableModel.OnRowChange)
        mod.select()
        self.tableView.setModel(mod)
        mod.insertRow(mod.rowCount())
        mod.insertRow(mod.rowCount())
    def delrow1(self):
        testModel2.removeRow(self.tableView_2.currentIndex().row())
        testModel2.select()

    def delrow(self):
        mod.removeRow(self.tableView.currentIndex().row())
        mod.select()
    def retranslateUi(self, MainWindow):
        MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow", None))
        self.pushButton_3.setText(_translate("MainWindow", "Удалить", None))
        self.pushButton_4.setText(_translate("MainWindow", "Добавить", None))
        self.pushButton_5.setText(_translate("MainWindow", "Удалить", None))
        self.pushButton_6.setText(_translate("MainWindow", "Добавить", None))
        self.label.setText(_translate("MainWindow", "Отделы", None))
        self.label_2.setText(_translate("MainWindow", "Заявления", None))


import sys
app = QtGui.QApplication(sys.argv)
MainWindow = QtGui.QMainWindow()
ui = Ui_MainWindow()
ui.setupUi(MainWindow)
MainWindow.show()
app.exec_()
server.close()