Python ---使用Fake库向clickhouse造数据小案例

每次insert太麻烦了

先在clickhosue中建表 test_user表

CREATE TABLE dwh.test_user
(
    name String,
    age Int32,
    address String,
    phone String,
    email String
) ENGINE = MergeTree()
ORDER BY name;

此时表中暂无数据

用Python脚本来造一些数据

from faker import Faker
from clickhouse_driver import Client
 
# 创建fake实例
fake = Faker('zh_CN')
 
# 连接clickhouse数据库
client = Client(host='xxxx',user='xxx',password='xxxx')
 
# 定义插入语句
insert_query = "INSERT INTO dwh.test_user (name, age, address, phone, email) VALUES"
 
# 生成数据并执行
data = [(fake.name(), fake.random_int(min=0, max=100), fake.address().replace('\n', ', '), fake.phone_number(), fake.email()) for _ in range(100)]
client.execute(insert_query, data)
 
print("Data insertion complete.")
 
# 关闭连接
client.disconnect()

 此时数据已写入表中