Skip to main content

Sqlalchemy dialect for OceanBase mysql tenant

Project description

Sqlalchemy-OceanBase

PyPI - License Python Version

OceanBase mysql tenant use pymysql to connect to OceanBase database.

See OceanBase Document

But the DDL of OceanBase is slightly different from MySQL, and user will get some warnings when reflecting metadata from OceanBase.

Alembic thus cannot work with OceanBase directly.

This package is a workaround to make Alembic work with OceanBase.

Installation

pip install sqlalchemy-oceanbase

Usage

from sqlalchemy import create_engine

engin = create_engine('msyql+oceanbase://user:password@host:port/dbname')

Async model

from sqlalchemy.ext.asyncio import create_async_engine

engin = create_async_engine('msyql+oceanbase://user:password@host:port/dbname')

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlalchemy_oceanbase-0.1.6.tar.gz (3.8 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

sqlalchemy_oceanbase-0.1.6-py3-none-any.whl (5.1 kB view details)

Uploaded Python 3

File details

Details for the file sqlalchemy_oceanbase-0.1.6.tar.gz.

File metadata

  • Download URL: sqlalchemy_oceanbase-0.1.6.tar.gz
  • Upload date:
  • Size: 3.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.12.9

File hashes

Hashes for sqlalchemy_oceanbase-0.1.6.tar.gz
Algorithm Hash digest
SHA256 bf15c01ca8b471b2b258640352922f21ae15deca24ca31aebeb42c23658a23a9
MD5 3dcc166c47691923860fdc9b67dc81fd
BLAKE2b-256 19a920efd83976422bbc5c8ca46c09236b1ab55da88b572d26da904fb8073bd3

See more details on using hashes here.

File details

Details for the file sqlalchemy_oceanbase-0.1.6-py3-none-any.whl.

File metadata

File hashes

Hashes for sqlalchemy_oceanbase-0.1.6-py3-none-any.whl
Algorithm Hash digest
SHA256 a951ed64300c1533c721bac45d4501db8faec71324cdb80e188aab4aeaa4b2f2
MD5 24c076e017b9445b4033c773c480baa5
BLAKE2b-256 687bc66495328f6b3d59770e1f07f7f30e1750929007170373b5fce3f20771e2

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page