databend-py 0.2.7

Python driver with native interface for Databend

databend-py

Databend Cloud Python Driver with native http interface support

Installation

pip install databend-py

Usage

Use the next code to check connection:

>>> from databend_py import Client
>>> client = Client(
    host='tenant--warehouse.ch.datafusecloud.com',
    database="default",
    user="user",
    password="password")
>>> print(client.execute("SELECT 1"))

The host, user, password info will be found in databend cloud warehouse connect page as flows:

Pure Client example:

>>> from databend_pyimport Client
>>>
>>> client = Client('http://root:rootlocalhost:8081/db')
>>>
>>> client.execute('SHOW TABLES')
[('test',)]
>>> client.execute('DROP TABLE IF EXISTS test')
[]
>>> client.execute('CREATE TABLE test (x Int32)')
[]
>>> client.execute(
...     'INSERT INTO test (x) VALUES', [(1,)]
... )
1
>>> client.execute('INSERT INTO test (x) VALUES', [(200,)])
1

Features

• Basic SQL.

• TLS support.

• Query settings.

• Types support:

  • Float32/64

  • [U]Int8/16/32/64/128/256

  • Date/Date32/DateTime(‘timezone’)/DateTime64(‘timezone’)

  • String

  • Array(T)

  • Nullable(T)

  • Bool

Documentation

// TODO

License

Databend Python Driver is distributed under the Apache license.