sqlalchemy 密码@ 处理, 以及ssl连接处理

from grant.sql_connection import tellus_conn
from sqlalchemy import text, create_engine
import pandas as pd
from urllib.parse import quote_plus

password = "123z@W2823in"
encoded_password = quote_plus(password)
AI_DEV_conn = create_engine(f'mysql+pymysql://JL_Dev_AI_Amin:{encoded_password}@110.279.241.4:3306/joinlead_integration?ssl=true&ssl_verify_cert=false')

sql = '''select 123'''
df = pd.read_sql(sql, con=AI_DEV_conn)
df.to_sql('test', if_exists='append', con=AI_DEV_conn, index=False)

  

posted @ 2025-10-20 14:27  CrossPython  阅读(4)  评论(0)    收藏  举报