python3 调用pymysql 通过ssh 链接mysql

直接放代码

from datetime import date, timedelta, timeimport pymysqlfrom sshtunnel import SSHTunnelForwarderfrom Page.random_time import get_user_id, Typeperf = ''zld_test = ""days = 6    # 循环多少天def UserMysql(db):    d = date(2017, 12, 1)   # 起始时间    server = SSHTunnelForwarder(        ssh_address_or_host=('*****', 22),  # 指定ssh登录的跳转机的address        ssh_username='root',  # 跳转机的用户        ssh_password='*****',  # 跳转机的密码        remote_bind_address=('127.0.0.1', 3306))    server.start()    myConfig = pymysql.connect(        user="root",        passwd="*****",        host="127.0.0.1",        db=db,        port=server.local_bind_port)    cursor =myConfig.cursor()    start_time = 0    for z in range(1, 6):        day = timedelta(days=z)        print(d+day)        for i in range(1, get_user_id(zld_test)):            start_time = start_time + random.randint(60, 3600)            a = time.localtime(start_time)            change_time = time.strftime("%H:%M:%S", a)            sql = """insert into            ****(day, time, type, attendancd, user_id )            VALUES ('%s','%s','%d',5,'173')""" % (d + day, change_time, Type())            print(sql)            rel = cursor.execute(sql)            myConfig.commit()            # sleep(0.5)            print(rel)            if int(time.strftime("%H", a)) == 23 and int(time.strftime("%M", a)) >= 30:                print('a')                continue    # myConfig.commit()    # 关闭数据库连接    cursor.close()