| Name | gbase8sdb-python2 JSON |
| Version |
0.2.2
JSON |
| download |
| home_page | None |
| Summary | Python interface to GBase 8s Database |
| upload_time | 2025-08-02 01:49:08 |
| maintainer | None |
| docs_url | None |
| author | None |
| requires_python | None |
| license | MIT |
| keywords |
gbase 8s
database
|
| VCS |
|
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
# python-gbase8sdb
python-gbase8sdb 是一个 [Python 编程语言][python] 扩展模块，允许 Python 程序连接到 GBase 8s 数据库。
该模块符合 [Python 数据库 API 2.0 规范][pep249]，并且包含大量扩展和少数排除项。
## 安装
运行 `python -m pip install gbase8sdb` 安装。
## 依赖和互操作性
- 支持的 Python 版本：2.7 。
- 支持的 GBase 8s 数据库版本：GBase 8s V8.8_3.6.2版本及以上。
- 支持的操作系统：Linux x86_64、 Windows 64位操作系统 。
- 依赖 GSDK 1.1 版本。
#### 使用说明
1. gbase8sdb驱动连接数据库依赖GSDK，所以您需要联系GBase 8s技术支持或通过官方渠道获取相应版本的GSDK，并安装到您的机器上， 并设置如下环境变量：
- Linux系统：
```bash
GSDK_PATH=/path/to/gsdk
export LD_LIBRARY_PATH=${GSDK_PATH}/lib:$LD_LIBRARY_PATH
export GBASEDBTDIR=${GSDK_PATH}/lib
```
- Windows系统：
```cmd
GSDK_PATH=\path\to\gsdk
set PATH=%GSDK_PATH%\lib;%PATH%
set GBASEDBTDIR=%GSDK_PATH%\lib
```
#### 入门
在您的Python应用程序中，可以通过以下方式连接到数据库：
```python
import gbase8sdb
# 生成dsn
dsn = gbase8sdb.makedsn(
server_name="ol_gbasedbt1210_2", # 数据库实例名称
db_name="testdbutf8", # 数据库名称
host="192.168.xxx.xxx", # 数据库实例所在服务器的IP地址或域名
port=9088, # 数据库实例的端口号
db_locale='zh_CN.utf8' # 数据库字符集
)
user = "gbasedbt" # 数据库用户名
password = "xxxxxx" # 数据库用户密码
# 连接数据库
conn = gbase8sdb.connect(dsn, user, password)
# 创建游标
cursor = conn.cursor()
# 执行SQL语句
cursor.execute("drop table if exists t")
cursor.execute("create table t (id int, name varchar(20))")
cursor.execute("insert into t values (?, ?)", (1, "zhangsan"))
cursor.execute("select * from t")
# 获取查询结果
print(cursor.fetchall())
# 关闭游标和连接
cursor.close()
conn.close()
```
Raw data
{
"_id": null,
"home_page": null,
"name": "gbase8sdb-python2",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": "GBase 8s, database",
"author": null,
"author_email": null,
"download_url": null,
"platform": null,
"description": "# python-gbase8sdb\n\npython-gbase8sdb \u662f\u4e00\u4e2a [Python \u7f16\u7a0b\u8bed\u8a00][python] \u6269\u5c55\u6a21\u5757\uff0c\u5141\u8bb8 Python \u7a0b\u5e8f\u8fde\u63a5\u5230 GBase 8s \u6570\u636e\u5e93\u3002\n\n\u8be5\u6a21\u5757\u7b26\u5408 [Python \u6570\u636e\u5e93 API 2.0 \u89c4\u8303][pep249]\uff0c\u5e76\u4e14\u5305\u542b\u5927\u91cf\u6269\u5c55\u548c\u5c11\u6570\u6392\u9664\u9879\u3002\n\n\n## \u5b89\u88c5\n\n\u8fd0\u884c `python -m pip install gbase8sdb` \u5b89\u88c5\u3002\n\n\n## \u4f9d\u8d56\u548c\u4e92\u64cd\u4f5c\u6027\n\n- \u652f\u6301\u7684 Python \u7248\u672c\uff1a2.7 \u3002\n\n- \u652f\u6301\u7684 GBase 8s \u6570\u636e\u5e93\u7248\u672c\uff1aGBase 8s V8.8_3.6.2\u7248\u672c\u53ca\u4ee5\u4e0a\u3002\n\n- \u652f\u6301\u7684\u64cd\u4f5c\u7cfb\u7edf\uff1aLinux x86_64\u3001 Windows 64\u4f4d\u64cd\u4f5c\u7cfb\u7edf \u3002\n\n- \u4f9d\u8d56 GSDK 1.1 \u7248\u672c\u3002\n\n\n#### \u4f7f\u7528\u8bf4\u660e\n\n1. gbase8sdb\u9a71\u52a8\u8fde\u63a5\u6570\u636e\u5e93\u4f9d\u8d56GSDK\uff0c\u6240\u4ee5\u60a8\u9700\u8981\u8054\u7cfbGBase 8s\u6280\u672f\u652f\u6301\u6216\u901a\u8fc7\u5b98\u65b9\u6e20\u9053\u83b7\u53d6\u76f8\u5e94\u7248\u672c\u7684GSDK\uff0c\u5e76\u5b89\u88c5\u5230\u60a8\u7684\u673a\u5668\u4e0a\uff0c \u5e76\u8bbe\u7f6e\u5982\u4e0b\u73af\u5883\u53d8\u91cf\uff1a\n\n- Linux\u7cfb\u7edf\uff1a\n```bash\nGSDK_PATH=/path/to/gsdk\nexport LD_LIBRARY_PATH=${GSDK_PATH}/lib:$LD_LIBRARY_PATH\nexport GBASEDBTDIR=${GSDK_PATH}/lib\n```\n\n- Windows\u7cfb\u7edf\uff1a\n\n```cmd\nGSDK_PATH=\\path\\to\\gsdk\nset PATH=%GSDK_PATH%\\lib;%PATH%\nset GBASEDBTDIR=%GSDK_PATH%\\lib\n```\n\n#### \u5165\u95e8\n\u5728\u60a8\u7684Python\u5e94\u7528\u7a0b\u5e8f\u4e2d\uff0c\u53ef\u4ee5\u901a\u8fc7\u4ee5\u4e0b\u65b9\u5f0f\u8fde\u63a5\u5230\u6570\u636e\u5e93\uff1a\n```python\nimport gbase8sdb\n\n# \u751f\u6210dsn\ndsn = gbase8sdb.makedsn(\n server_name=\"ol_gbasedbt1210_2\", # \u6570\u636e\u5e93\u5b9e\u4f8b\u540d\u79f0\n db_name=\"testdbutf8\", # \u6570\u636e\u5e93\u540d\u79f0\n host=\"192.168.xxx.xxx\", # \u6570\u636e\u5e93\u5b9e\u4f8b\u6240\u5728\u670d\u52a1\u5668\u7684IP\u5730\u5740\u6216\u57df\u540d\n port=9088, # \u6570\u636e\u5e93\u5b9e\u4f8b\u7684\u7aef\u53e3\u53f7\n db_locale='zh_CN.utf8' # \u6570\u636e\u5e93\u5b57\u7b26\u96c6\n)\nuser = \"gbasedbt\" # \u6570\u636e\u5e93\u7528\u6237\u540d\npassword = \"xxxxxx\" # \u6570\u636e\u5e93\u7528\u6237\u5bc6\u7801\n\n# \u8fde\u63a5\u6570\u636e\u5e93\nconn = gbase8sdb.connect(dsn, user, password) \n# \u521b\u5efa\u6e38\u6807 \ncursor = conn.cursor() \n# \u6267\u884cSQL\u8bed\u53e5 \ncursor.execute(\"drop table if exists t\")\ncursor.execute(\"create table t (id int, name varchar(20))\")\ncursor.execute(\"insert into t values (?, ?)\", (1, \"zhangsan\"))\ncursor.execute(\"select * from t\")\n# \u83b7\u53d6\u67e5\u8be2\u7ed3\u679c\nprint(cursor.fetchall())\n# \u5173\u95ed\u6e38\u6807\u548c\u8fde\u63a5\ncursor.close()\nconn.close()\n```\n\n\n\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Python interface to GBase 8s Database",
"version": "0.2.2",
"project_urls": null,
"split_keywords": [
"gbase 8s",
" database"
],
"urls": [
{
"comment_text": null,
"digests": {
"blake2b_256": "c41c76eb3a3b7fb81ba76c0764c05eea82bf07720f00fba7bb2816565cc2c82b",
"md5": "53a007e7a1ec0b6d06c929ddaccb8851",
"sha256": "7ef5fa7e398ce2b59fbcc1119e6dd1cf2bbad238eba5b816a7cc75ba539f86e7"
},
"downloads": -1,
"filename": "gbase8sdb_python2-0.2.2-cp27-cp27mu-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"has_sig": false,
"md5_digest": "53a007e7a1ec0b6d06c929ddaccb8851",
"packagetype": "bdist_wheel",
"python_version": "cp27",
"requires_python": null,
"size": 984986,
"upload_time": "2025-08-02T01:49:08",
"upload_time_iso_8601": "2025-08-02T01:49:08.413527Z",
"url": "https://files.pythonhosted.org/packages/c4/1c/76eb3a3b7fb81ba76c0764c05eea82bf07720f00fba7bb2816565cc2c82b/gbase8sdb_python2-0.2.2-cp27-cp27mu-manylinux2014_x86_64.manylinux_2_17_x86_64.whl",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-08-02 01:49:08",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "gbase8sdb-python2"
}
