使用sqlalchemy-gbasedbt连接GBase8s数据库的步骤详解

返回列表 >> 使用sqlalchemy-gbasedbt连接GBase8s数据库的步骤详解

使用sqlalchemy-gbasedbt连接GBase8s数据库的步骤详解

发布时间：2023-06-19

1，确认安装python3

　　确认已经安装python3和python3-devel

[root@localhost test]# python3 -V

Python 3.6.8

　　如果没有安装，建议使用yum install python3来安装。
升级pip的版本

[root@localhost test]# python3 -m pip install --upgrade --force-reinstall pip

WARNING: Running pip installwith root privileges is generally not a good idea. Try `__main__.py install--user` instead.

Collecting pip

Downloading https://files.pythonhosted.org/packages/a4/6d/6463d49a933f547439d6b5b98b46af8742cc03ae83543e4d7688c2420f8b/pip-21.3.1-py3-none-any.whl (1.7MB)

100% ████████████████████████████████ 1.7MB 235kB/s

Installing collected packages: pip

Successfully installed pip-21.3.1

[root@localhost test]# pip3 list

WARNING: pip is being invoked by an old script wrapper. This will fail ina future version of pip.

Please see https://github.com/pypa/pip/issues/5599foradvice on fixing the underlying issue.

To avoid this problem you can invoke Python with -m pipinstead of running pip directly.

Package Version

---------- -------

pip 21.3.1

setuptools 39.2.0

2，安装GBase 8s数据库连接工具（CSDK）

　　可以直接下载免安装版本的CSDK驱动：
链接：https://pan.baidu.com/s/1s9EW3VoRznlj6uDHubIEtg?pwd=ejfb
提取码：ejfb
解压到指定目录/opt下，生成/opt/gbase8s-odbc-driver目录

[root@localhost test]# ll

总用量 35188

-rw-r--r--. 1 root root 36029237 3月 11 20:52 GBase8s_3.0.0_1-Linux64-ODBC-Driver.tar.gz

[root@localhost test]# tar -zxf GBase8s_3.0.0_1-Linux64-ODBC-Driver.tar.gz -C /opt/

[root@localhost test]# cd /opt/

[root@localhost opt]# ll

总用量 4

drwxr-xr-x. 20 gbasedbt gbasedbt 4096 3月 10 15:14 gbase

drwxrwxr-x. 9 1001 1003 88 12月 13 2020 gbase8s-odbc-driver

drwxr-xr-x. 2 root root 6 10月 31 2018 rh

　　创建必须的环境变量，并使环境生效

exportGBASEDBTDIR=/opt/gbase8s-odbc-driver

exportCSDK_HOME=/opt/gbase8s-odbc-driver

exportPATH=$GBASEDBTDIR/bin:$PATH

exportLD_LIBRARY_PATH=$GBASEDBTDIR/lib:$GBASEDBTDIR/lib/cli:$GBASEDBTDIR/lib/esql:$LD_LIBRARY_PATH

　　创建sqlhosts配置文件

[root@localhost test]# vi /opt/gbase8s-odbc-driver/etc/sqlhosts

[root@localhost test]# more /opt/gbase8s-odbc-driver/etc/sqlhosts

gbase01 onsoctcp a02.gbasedbt.com 9088

3，安装sqlalchemy-gbasedbt

3.1, 在线安装sqlalchemy-gbasedbt

　　确认python3、python3-devel和gcc均已经安装，CSDK也已经安装以及环境变量已经配置的情况下，可直连网络的情况下，可使用pip3 install sqlalchemy-gbasedbt直接安装

[root@localhost test]# pip3 install sqlalchemy-gbasedbt

Collecting sqlalchemy-gbasedbt

Using cached sqlalchemy_gbasedbt-0.2.4-py3-none-any.whl (10 kB)

Collecting DbtPy

Using cached DbtPy-3.0.5.4.tar.gz (162 kB)

Preparing metadata (setup.py) ... done

Requirement already satisfied: sqlalchemy in/usr/local/lib64/python3.6/site-packages(from sqlalchemy-gbasedbt) (1.4.46)

Requirement already satisfied: greenlet!=0.4.17 in/usr/local/lib64/python3.6/site-packages(from sqlalchemy->sqlalchemy-gbasedbt) (2.0.2)

Requirement already satisfied: importlib-metadata in/usr/local/lib/python3.6/site-packages(from sqlalchemy->sqlalchemy-gbasedbt) (4.8.3)

Requirement already satisfied: typing-extensions>=3.6.4 in/usr/local/lib/python3.6/site-packages(from importlib-metadata->sqlalchemy->sqlalchemy-gbasedbt) (4.1.1)

Requirement already satisfied: zipp>=0.5 in/usr/local/lib/python3.6/site-packages(from importlib-metadata->sqlalchemy->sqlalchemy-gbasedbt) (3.6.0)

Using legacy setup.py installforDbtPy, since package wheelis not installed.

Installing collected packages: DbtPy, sqlalchemy-gbasedbt

Running setup.py installforDbtPy ... done

Successfully installed DbtPy-3.0.5.4 sqlalchemy-gbasedbt-0.2.4

　　将同时安装依赖包：sqlalchemy、greenlet、importlib-metadata、typing-extensions、zipp和DbtPy，安装后的pip3列表如下：

负载均衡

云数据库

域名注册

常见问题

云计算