hhh

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()
print(server.local_bind_port)
server.close()
db = QSqlDatabase.addDatabase('QMYSQL')
db.setHostName("localhost")
db.setDatabaseName("usrdb")
db.setUserName("usr")
db.setPassword("passwrd")
db.open()

testModel = QSqlTableModel()
testModel.setTable("test")
testModel.setEditStrategy(QSqlTableModel.OnFieldChange)
testModel.select()

testView = QTableView()
testView.setModel(testModel)

app.exec_()