【clickhouse】访问clickhouse数据库，并且插入数据

陈晓明start

已于 2024-08-23 09:10:47 修改

阅读量130

点赞数 2

文章标签：数据库

于 2024-08-23 08:58:04 首次发布

本文链接：https://blog.csdn.net/cxm19830125/article/details/141451282

版权

from clickhouse_driver import Client,connect
from datetime import datetime,timedelta

connection = connect(host='10.9.0.81', port=9001, user='xxx', password='xxx', database='xxx')
# 循环打印近30天的日期
for i in range(1,31):
    date = (datetime.now() - timedelta(days=i)).strftime('%Y-%m-%d')
    date2 = date + ' 00:00:00'
    insert_sql = '''
    INSERT INTO dwd_station_connect (station_id,region_id,region_name,line_num,line_name,regist_time,last_time,valid,stat,ip_address,date_time,fep_ip_address) VALUES (11301006,1,'2222',1,NULL,'2024-07-04 12:23:34','2024-06-04 20:32:18',0,1,'10.141.13.246','%s','10.14.101.32')
                 ''' % date2
    print(insert_sql)
    # 执行插入语句
    with connection.cursor() as cursor:
        cursor.execute(insert_sql)

# 关闭客户端连接
connection.close()