SqlAlchemy

王江南2025年12月9日小于 1 分钟

kingbase集成

安装方言


uv pip install git+https://gitee.com/LFunTech/sqlalchemy_kingbase.gitf

下载驱动

https://www.kingbase.com.cn/download.html#drive

engine = create_engine('kingbase://SYSTEM:123456@127.0.0.1:54321/TEST')

log

engine = create_engine(DATABASE_URL, echo=False, future=True)

echo=False -- 禁用日志

engine configuration

密码特殊字符

import urllib.parse
urllib.parse.quote_plus("kx@jj5/g")

pgsql

engine = create_engine("postgresql+psycopg2://scott:tiger@localhost:5432/mydatabase")

import pandas as pd 
from sqlalchemy import create_engine
from urllib.parse import quote_plus as urlquote
password = urlquote("Mysql@2023")

engine = create_engine(f"mysql+mysqldb://root:{password}@192.168.3.204:3306/zjioc_202?charset=utf8")

with engine.connect() as conn, conn.begin():
    # 模型
    model = pd.read_sql("select * from dp_dorm limit 10", conn)

model