Skip to main content
Pre-release

This release is a pre-release and may not be stable for production use.

YDB Dialect for SQLAlchemy


License Functional tests Style checks

This repository contains work in progress YQL dialect for SqlAlchemy 2.0. Api may be changed in future without backward compatibility.

Installation

To work with current ydb-sqlalchemy version clone this repo and run from source root:

$ pip install -U .

Getting started

Connect to local YDB throw SqlAlchemy:

import sqlalchemy as sa


engine = sa.create_engine("yql+ydb://localhost:2136/local")

with engine.connect() as conn:
  rs = conn.execute(sa.text("SELECT 1 AS value"))
  print(rs.fetchone())

Development

Run Tests:

For run local YDB throw docker, run in source root:

$ docker-compose up

For run all tests from source root make:

$ tox -e test-all

Run specific test:

$ tox -e test -- test_dbapi/test_dbapi.py

Check code style:

$ tox -e style

Reformat code:

$ tox -e isort
$ tox -e black-format

Run example (needs running local YDB):

$ python -m pip install virtualenv
$ virtualenv venv
$ source venv/bin/activate
$ pip install -r requirements.txt
$ python examples/example.py

Release files for ydb-sqlalchemy 0.0.1b5

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for ydb-sqlalchemy 0.0.1b5
File Size Uploaded
ydb-sqlalchemy-0.0.1b5.tar.gz 31.4 kB Details

Built distribution (wheel)

Table of built distributions (wheels) for ydb-sqlalchemy 0.0.1b5
File Interpreter ABI Platform
ydb_sqlalchemy-0.0.1b5-py2.py3-none-any.whl Python 2, Python 3 none any Details

Total release size: 66.8 kB

Release files / ydb-sqlalchemy-0.0.1b5.tar.gz

Download URL ydb-sqlalchemy-0.0.1b5.tar.gz
Size 31.4 kB
Tags Source
SHA-256 checksum
How to use checksums
03b51fe117471c65ad0979c94ba11815f9d1ed825459fd0a50dd3f66680d3e00
BLAKE2b-256 checksum
How to use checksums
ee2bd6b098159d6d62c80ad58c54f7e1f0e2f00f33e735f26f77d081f62e07e5
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/5.0.0 CPython/3.12.2

Release files / ydb_sqlalchemy-0.0.1b5-py2.py3-none-any.whl

Download URL ydb_sqlalchemy-0.0.1b5-py2.py3-none-any.whl
Size 35.4 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
8b532d3de5827255e142232945a32fca0e5953df2681739a41da825c7dbeb458
BLAKE2b-256 checksum
How to use checksums
e5ee3e15b6e50acf6a274a3a9c2b3224ce5726a9c993b4959835b0274434601f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/5.0.0 CPython/3.12.2

Release history Release notifications | RSS feed

0.1.24

2 release files

0.1.20

2 release files

0.1.19

2 release files

0.1.18

2 release files

0.1.16

2 release files

0.1.15

2 release files

0.1.14

2 release files

0.1.13

2 release files

0.1.12

2 release files

0.1.11

2 release files

0.1.10

2 release files

0.1.9

2 release files

0.1.8

2 release files

0.1.7

2 release files

0.1.6

2 release files

0.1.5

2 release files

0.1.4

2 release files

0.1.3

2 release files

0.1.2

2 release files

0.1.1

2 release files

0.1.0

2 release files

This release

0.0.1b5 This release

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page