sqlalchemy-clickhouse源码解析

首先下载源码git clone https://github.com/cloudflare/sqlalchemy-clickhouse.git

可以看到里面有个example.py写了使用例子

 

#!/usr/bin/env python

# Use connector directly
import connector
cursor = connector.connect('tools').cursor()
cursor.execute('SELECT * FROM users LIMIT 10')
print(cursor.fetchone())

# Register SQLAlchemy dialect
from sqlalchemy.dialects import registry
registry.register("clickhouse", "base", "dialect")

# Test engine and table 
from sqlalchemy import *
from sqlalchemy.engine import create_engine
from sqlalchemy.schema import *

engine = create_engine('clickhouse://default:@192.168.1.22:8123/tools')
logs = Table('users', MetaData(bind=engine), autoload=True)
print(select([func.count('*')], from_obj=logs).scalar())

查看connector.connect方法