fafafafaf

from PyQt4.QtSql import *
from PyQt4.QtGui import *
from sshtunnel import SSHTunnelForwarder
import sys

app = QApplication(sys.argv)
server = SSHTunnelForwarder(
    ('10.10.14.177', 22),
    ssh_password="thuglife",
    ssh_username="sneak",
    remote_bind_address=('127.0.0.1', 3306))
server.start()

db = QSqlDatabase.addDatabase('QMYSQL')
db.setHostName("localhost")
db.setPort(server.local_bind_port)
db.setDatabaseName("mydb")
db.setUserName("coach")
db.setPassword("masterkey")
db.open()

testModel = QSqlTableModel()
testModel.setTable("otdel")
testModel.setEditStrategy(QSqlTableModel.OnFieldChange)
testModel.select()
testView = QTableView()
testView.setModel(testModel)
testView.show()
app.exec_()
server.close()