SQL programming
Project description
ClickSQL: ClickHouse client for Humans
Package information:
Records is a very simple, but powerful, library for making raw SQL queries to most relational databases.
ClickSQL is a smart client for ClickHouse database, which may help users to use ClickHouse more easier and smoother.
more information for ClickHouse can be found at here
Installation
pip install ClickSQL
Usage
initial connection
Approach 1
from ClickSQL import ClickHouseTableNode
conn_str = "clickhouse://default:test121231@99.99.9.9:8123/system"
ct = ClickHouseTableNode(conn_str)
>>> connection test: Ok.
Approach 2
from ClickSQL import ClickHouseTableNode
conn_str = {'name':'clickhouse','host':'99.99.9.9','port':8123,'user':'default',
'password':'test121231','database':'system'}
ct = ClickHouseTableNode(conn_str)
>>> connection test: Ok.
Query
from ClickSQL import ClickHouseTableNode
conn_str = "clickhouse://default:test121231@99.99.9.9:8123/system"
ct = ClickHouseTableNode(conn_str)
ct.query('show tables from system limit 1')
>>> connection test: Ok.
>>> name
>>> 0 aggregate_function_combinators
Contribution
there is welcome to do more work to improve this package more convenient
Author
sn0wfree
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
ClickSQL-0.1.4.1.tar.gz
(18.8 kB
view hashes)