sqlalchemy连接clickhouse批量插入数据

直接上代码

这里放下他的文档，一定要看呀~
https://www.osgeo.cn/sqlalchemy/core/dml.html#sqlalchemy.sql.expression.update

以下代码sqlalchemy的版本是1.4的

pip install sqlalchemy==1.4.40

听说快出2.0的了，好期待啊，2.0版本的很多方法会更新，不知道如下代码适不适用哦！
创建表

CREATE TABLE city
(
    `id` UInt8, 
    `country` String, 
    `province` String, 
    `city` String, 
    `create_time` datetime DEFAULT now()
)
ENGINE = MergeTree()
PARTITION BY toYYYYMM(create_time)
ORDER BY id

插入批量数据代码

from sqlalchemy.orm import scoped_session, sessionmaker
from sqlalchemy import create_engine, MetaData, Table

CK_CONN = {
    # 远程连接地址
    "server_host": '10.10.10.10',
    # 用户名
    "user": '123',
    # 密码
    "password": '123',
    # 数据库名
    "db": 'tt',
    # 端口
    "port": '8123',//clickhouse 21版本的必须是这个端口哦!
}

def session(name):
    connection = 'clickhouse://{user}:{password}@{server_host}:{port}/{db}'.format(**CK_CONN)
    engine = create_engine(connection, pool_size=100, pool_recycle=3600, pool_timeout=20)
    metadata = MetaData(engine)
    table = Table(name, metadata, autoload=True)

    get_session = scoped_session(sessionmaker(bind=engine))
    return table, get_session
  
 
def insert_data(name, values):
    table, conn = session(name)
    conn.execute(table.insert(), values)
    conn.remove()
    return 200

values=[{'id': 2, 'country': 'sprinfall@gmail.com', 'province': '11', 'city': '22'},
		{'id': 3, 'country': 'sprinfall@hotmail.com', 'province': '22', 'city': '233'},
		{'id': 4, 'country': 'sprinfall@hotmail.com', 'province': '22', 'city': '233'},
		{'id': 5, 'country': 'sprinfall@hotmail.com', 'province': '22', 'city': '233'},
        ]
 
if __name__ == '__main__':
	insert_data('test',values)