gbase8s-sqlalchemy

介绍

GBase 8s数据库的SQLAlchemy方言，支持GBase 8s V8.8_3.6.2版本及以上。

依赖

gbase8sdb
sqlalchemy~=1.4.0

安装教程

pip install gbase8s-sqlalchemy

使用说明

方言使用python-gbase8sdb驱动连接数据库，安装gbase8s-sqlalchemy时会作为依赖进行安装，您也可以手动安装：

pip install gbase8sdb

python-gbase8sdb驱动连接数据库依赖GSDK 1.1版本，所以您需要联系GBase 8s技术支持或通过官方渠道获取相应版本的GSDK，并安装到您的机器上，并设置如下环境变量：

GSDK_PATH=/path/to/gsdk
export LD_LIBRARY_PATH=${GSDK_PATH}/lib:$LD_LIBRARY_PATH
export GBASEDBTDIR=${GSDK_PATH}/lib

入门

在您的Python应用程序中，可以通过以下方式连接到数据库：

from sqlalchemy import create_engine
username = 'gbasedbt'
password = 'xxxxxx'
ip = '192.168.xxx.xxx'
port = 9088
dbname = 'testdb'
servername = 'gbase8s01'
url = f'gbase8s+gbase8sdb://{username}:{password}@{ip}:{port}/{dbname}?GBASEDBTSERVER={servername}&DB_LOCALE=zh_CN.utf8'
# 或使用sqlhosts文件连接
# url = f'gbase8s+gbase8sdb://{username}:{password}@{dbname}?GBASEDBTSERVER={servername}&DB_LOCALE=zh_CN.utf8&SQLH_FILE=/path/to/sqlhosts'
engine = create_engine(url, echo=True)
# 验证连接
from sqlalchemy import text
with engine.connect() as connection:
    result = connection.execute(text("SELECT 1 FROM DUAL"))
    print(result.fetchone())

Release files for gbase8s-sqlalchemy 1.2.1

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

Built distribution (wheel)

Table of built distributions (wheels) for gbase8s-sqlalchemy 1.2.1
File	Interpreter	ABI	Platform	Reset
gbase8s_sqlalchemy-1.2.1-py2.py3-none-any.whl 16.3 kB Aug 25, 2026	Python 2, Python 3	none	any	Details

Release files / gbase8s_sqlalchemy-1.2.1-py2.py3-none-any.whl

Download URL	gbase8s_sqlalchemy-1.2.1-py2.py3-none-any.whl
Size	16.3 kB
Tags	Python 2 Python 3
SHA-256 checksum How to use checksums	`e492312a702367e937e463b11506cfcb1ca5f020cb915b200a5bcb0c60f373d9`
BLAKE2b-256 checksum How to use checksums	`bc93a49fb9f6ec3c718f0b528200ed23c2777cc4291e5b47607bba4d33574a78`
Upload date	Aug 25, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/6.1.0 CPython/3.9.7`