Python driver with native interface for Databend
Project description
# databend-py
Databend Cloud Python Driver with native http interface support
[![image](https://img.shields.io/pypi/v/databend-py.svg)](https://pypi.org/project/databend-py)
[![image](https://coveralls.io/repos/github/databendcloud/databend-py/badge.svg?branch=master)](https://coveralls.io/github/databendcloud/databend-py?branch=master)
[![image](https://img.shields.io/pypi/l/databend-py.svg)](https://pypi.org/project/databend-py)
[![image](https://img.shields.io/pypi/pyversions/databend-py.svg)](https://pypi.org/project/databend-py)
# Installation
pip install databend-py
# Usage
Use the next code to check connection:
> ` python > >>> from databend_py import Client > >>> client = Client( > host='tenant--warehouse.ch.datafusecloud.com', > database="default", > user="user", > port="443", > password="password",settings={"copy_purge":True,"force":True}) > >>> print(client.execute("SELECT 1")) > `
The [host]{.title-ref}, [user]{.title-ref}, [password]{.title-ref} info will be found in databend cloud warehouse connect page as flows:
Pure Client example:
> ` python > >>> from databend_py import Client > >>> > >>> client = Client.from_url('http://root@localhost:8000/db?secure=False©_purge=True') > >>> > >>> 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 > `
More usages examples find [here](./examples).
# 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
# Compatibility
If databend version >= v0.9.0 or later, you need to use databend-py version >= v0.3.0.
# License
Databend Python Driver is distributed under the [Apache license]{.title-ref}.
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
Built Distribution
Hashes for databend_py-0.4.7-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3f518830398067ecaa8d09680cb6b221ba04309dcbae17d9accdee6a96397e3f |
|
MD5 | 8dad779ec9f9aaf3c9cd0bc1d5e93d05 |
|
BLAKE2b-256 | 8f3463f48940dac0f4b05d972c588f8ca274deb5584d1ffaad1a0ea11458333c |