Detailed explanation of the steps to connect to GBase 8s database using sqlalchemy-gbasedbt

[root@localhost test]# python3 -V
Python 3.6.8

[root@localhost test]# python3 -m pip install --upgrade --force-reinstall pip
WARNING: Running pip install with root privileges is generally not a good idea. Try `__main__.py install --user` instead.
Collecting pip
  Downloading /packages/a4/6d/6463d49a933f547439d6b5b98b46af8742cc03ae83543e4d7688c2420f8b/pip-21.3. (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 in a future version of pip.
Please see /pypa/pip/issues/5599 for advice on fixing the underlying issue.
To avoid this problem you can invoke Python with '-m pip' instead of running pip directly.
Package    Version
---------- -------
pip        21.3.1
setuptools 39.2.0

[root@localhost test]# ll
Total usage 35188
-rw-r--r--. 1 root root 36029237 3moon  11 20:52 GBase8s_3.0.0_1
[root@localhost test]# tar -zxf GBase8s_3.0.0_1 -C /opt/
[root@localhost test]# cd /opt/
[root@localhost opt]# ll
Total usage 4
drwxr-xr-x. 20 gbasedbt gbasedbt 4096 3moon  10 15:14 gbase
drwxrwxr-x.  9     1001     1003   88 12moon 13 2020 gbase8s-odbc-driver
drwxr-xr-x.  2 root     root        6 10moon 31 2018 rh

export GBASEDBTDIR=/opt/gbase8s-odbc-driver
export CSDK_HOME=/opt/gbase8s-odbc-driver
export PATH=$GBASEDBTDIR/bin:$PATH
export LD_LIBRARY_PATH=$GBASEDBTDIR/lib:$GBASEDBTDIR/lib/cli:$GBASEDBTDIR/lib/esql:$LD_LIBRARY_PATH

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

[root@localhost test]# pip3 install sqlalchemy-gbasedbt
Collecting sqlalchemy-gbasedbt
  Using cached sqlalchemy_gbasedbt-0.2. (10 kB)
Collecting DbtPy
  Using cached DbtPy-3.0.5. (162 kB)
  Preparing metadata () ... 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 ' install' for DbtPy, since package 'wheel' is not installed.
Installing collected packages: DbtPy, sqlalchemy-gbasedbt
    Running  install for DbtPy ... done
Successfully installed DbtPy-3.0.5.4 sqlalchemy-gbasedbt-0.2.4

[root@localhost test]# pip3 list
Package             Version
------------------- -------
DbtPy               3.0.5.4
greenlet            2.0.2
importlib-metadata  4.8.3
pip                 21.3.1
setuptools          39.2.0
SQLAlchemy          1.4.46
sqlalchemy-gbasedbt 0.2.4
typing_extensions   4.1.1
zipp                3.6.0

#!/usr/bin/env python3
# Filename: testSqlalchemy_gbasedbt

from sqlalchemy import MetaData, Table, Column, String, create_engine
from  import registry
from  import sessionmaker
from  import declarative_base

("gbasedbt", "sqlalchemy_gbasedbt.dbtdb", "GBasedbtDialect")

# Create the base class of the object:Base = declarative_base()

# Define User object:class User(Base):
    # Table name:    __tablename__ = 'user'

    # Table structure:    id = Column(String(20), primary_key=True)
    name = Column(String(20))

# Initialize the database connection:# ConStr = 'gbasedbt://<username>:<password>@<host name>:<port number>/<databasename>;SERVER=<server name>'
ConStr = 'gbasedbt://gbasedbt:GBase123@:9088/testdb;SERVER=gbase01;DB_LOCALE=zh_CN.utf8;CLIENT_LOCALE=zh_CN.utf8;DELIMIDENT=y'
engine = create_engine(ConStr)

# Create an object.create_all(engine)

# Create a DBSession type:DBSession = sessionmaker(bind=engine)

# Create a session object:session = DBSession()

# Create a new User object:new_user = User(id='2', name='Test the user')
# Add to session:(new_user)
# Submit and save to the database:()
# Close session:()

# Create Session:session = DBSession()
# Create a Query query, filter is where condition, and finally call one() to return the only row, and if all() is called, return all rows:user = (User).filter(=='2').one()
# Print type and object name attributes:print('type:', type(user))
print('name:', )
# Close Session:()