ARTICLE DETAIL

建站实战干货

来自一线的建站与推广经验沉淀,每一条都经过真实交付验证。

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

2026/8/10 1:02:02 拓冰建站 浏览量
sqlalchemy 密码@ 处理, 以及ssl连接处理
from grant.sql_connection import tellus_conn
from sqlalchemy import text, create_engine
import pandas as pd
from urllib.parse import quote_pluspassword = "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)