import pymysql
from sshtunnel import SSHTunnelForwarder
from pymysql.converters import escape_string
from ruamel.yaml import YAML
import math


UUID = 	600000500823



# ===================config===================

    
server = SSHTunnelForwarder(
    ssh_address_or_host=("47.254.83.25", 22),
    ssh_username="root",
    ssh_password="ByWayStudios01!",
    remote_bind_address=("127.0.0.1",3306),
    local_bind_address=('127.0.0.1',5143)
)
server.start()
db_host = server.local_bind_host
db_port = server.local_bind_port
print(db_host, db_port)
RID = 102931
MYRID = 200100030

conn = pymysql.connect(
    host=db_host,
    port=db_port,
    user="root",
    password="Xijing1!",
    database="Merge_Pet_1"
)
cursor = conn.cursor()
cursor.execute(("select * from t_player_mod where dwUin = {rid}").format(rid = RID))
result1 = cursor.fetchone()


server2 = SSHTunnelForwarder(
    ssh_address_or_host=("1.15.182.107", 22),
    ssh_username="root",
    ssh_password="`NS?VGg@7]~F3}p",
    remote_bind_address=("127.0.0.1",3306),
    local_bind_address=('127.0.0.1',5144)
)
server2.start()
db_host2 = server2.local_bind_host
db_port2 = server2.local_bind_port
conn2 = pymysql.connect(
    host=db_host2,
    port=db_port2,
    user="root",
    password="Z4rf7eZZe500dxa",
    database=f"Merge_Pet_sdk"
)
cursor2 = conn2.cursor()

sql = "UPDATE t_player_mod SET mData = %s WHERE dwUin = %s"
cursor2.execute(sql, (result1[1], MYRID))
conn2.commit()

cursor.close()
conn.close()
cursor2.close()
conn2.close()
exit()