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.1b14

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.1b14
File Size Uploaded
ydb_sqlalchemy-0.0.1b14.tar.gz 34.4 kB Details

Built distribution (wheel)

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

Total release size: 72.8 kB

Release files / ydb_sqlalchemy-0.0.1b14.tar.gz

Download URL ydb_sqlalchemy-0.0.1b14.tar.gz
Size 34.4 kB
Tags Source
SHA-256 checksum
How to use checksums
83290014909eab6cda23a2aef43d476d10201077b3dfc9446e3e38873b1928ce
BLAKE2b-256 checksum
How to use checksums
1300529429713d26f5ebbfe72a3c6b22b28b01cffc7e3f903d9ca14f6852d41f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/5.0.0 CPython/3.12.3

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

Download URL ydb_sqlalchemy-0.0.1b14-py2.py3-none-any.whl
Size 38.4 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
01d65fb9e5b3bf890ecd0ed2f79a03c760cd2ae0c144577cf0615f50749e183f
BLAKE2b-256 checksum
How to use checksums
a01269daa05f763a1ffe0fe7fdb9b436d90fdea9a76afdadcf36b2ed2449f795
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/5.0.0 CPython/3.12.3

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.1b14 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