aaaAAAAAAAAAAAAAAAAAAAAAAAAAAAA

# -*- coding: utf-8 -*-

# Form implementation generated from reading ui file 'untitled.ui'
#
# Created by: PyQt4 UI code generator 4.11.4
#
# WARNING! All changes made in this file will be lost!

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 = QtGui.QPushButton(self.centralwidget)
        self.pushButton.setGeometry(QtCore.QRect(270, 360, 75, 23))
        self.pushButton.setObjectName(_fromUtf8("pushButton"))
        self.pushButton_2 = QtGui.QPushButton(self.centralwidget)
        self.pushButton_2.setGeometry(QtCore.QRect(620, 360, 75, 23))
        self.pushButton_2.setObjectName(_fromUtf8("pushButton_2"))
        self.pushButton_3 = QtGui.QPushButton(self.centralwidget)
        self.pushButton_3.setGeometry(QtCore.QRect(110, 360, 75, 23))
        self.pushButton_3.setObjectName(_fromUtf8("pushButton_3"))
        self.pushButton_4 = QtGui.QPushButton(self.centralwidget)
        self.pushButton_4.setGeometry(QtCore.QRect(190, 360, 75, 23))
        self.pushButton_4.setObjectName(_fromUtf8("pushButton_4"))
        self.pushButton_5 = QtGui.QPushButton(self.centralwidget)
        self.pushButton_5.setGeometry(QtCore.QRect(460, 360, 75, 23))
        self.pushButton_5.setObjectName(_fromUtf8("pushButton_5"))
        self.pushButton_6 = QtGui.QPushButton(self.centralwidget)
        self.pushButton_6.setGeometry(QtCore.QRect(540, 360, 75, 23))
        self.pushButton_6.setObjectName(_fromUtf8("pushButton_6"))
        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.pushButton.connect(self.pushButton, QtCore.SIGNAL("clicked()"),
                                 self.renew)
        self.pushButton_3.connect(self.pushButton_3, QtCore.SIGNAL("clicked()"),self.delet)
        self.retranslateUi(MainWindow)
        QtCore.QMetaObject.connectSlotsByName(MainWindow)
        global server
        server = SSHTunnelForwarder(
            ('10.10.14.177', 22),
            ssh_password="thuglife",
            ssh_username="sneak",
            remote_bind_address=('127.0.0.1', 3306))
        server.start()
        db = QtSql.QSqlDatabase.addDatabase('QMYSQL')
        db.setHostName("localhost")
        db.setPort(server.local_bind_port)
        db.setDatabaseName("mydb")
        db.setUserName("coach")
        db.setPassword("masterkey")
        db.open()
        self.testModel = QtSql.QSqlTableModel()
        self.testModel.setTable("otdel")
        self.testModel.setEditStrategy(QtSql.QSqlTableModel.OnFieldChange)
        self.testModel.select()
        self.tableView.setModel(self.testModel)
        global testModel2
        testModel2 = QtSql.QSqlTableModel()
        testModel2.setTable("zayav")
        testModel2.setEditStrategy(QtSql.QSqlTableModel.OnFieldChange)
        testModel2.select()
        self.tableView_2.setModel(testModel2)

    def renew(self):
        self.testModel.setTable("otdel")
        self.testModel.select()
        self.tableView.setModel(self.testModel)

    def renew_t(self):
        testModel2.select()
        self.tableView2.setModel(testModel2)
    def delet(self):
        self.testModel.removeRow(2)
        #self.tableView.setModel(self.testModel)
        '''indexes = self.tableView.selectionModel().selectedRows()
        for index in sorted(indexes):'''




    def retranslateUi(self, MainWindow):
        MainWindow.setWindowTitle(_translate("MainWindow", "MainWindow", None))
        self.pushButton.setText(_translate("MainWindow", "Обновить", None))
        self.pushButton_2.setText(_translate("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))


if __name__ == "__main__":
    import sys
    app = QtGui.QApplication(sys.argv)
    MainWindow = QtGui.QMainWindow()
    ui = Ui_MainWindow()
    ui.setupUi(MainWindow)
    MainWindow.show()
    server.close()
    sys.exit(app.exec_())