国产数据库南大通用gbase8s安装及使用

docker search gbase8sdocker pull liaosnet/gbase8s:latestdocker run -itd --name=gbase8s -p 9088:9088 liaosnet/gbase8s:latest

package main
import (  "database/sql"  "fmt"
  _ "github.com/alexbrainman/odbc")
func main() {  fmt.Printf("GO ODBC测试程序开始运行.nn")
    // odbcgbase ODBC数据源名称 UID账号 PWD密码  db, err := sql.Open("odbc", "DSN=odbcgbase;UID=gbasedbt;PWD=GBase123")  if err != nil {    panic(err)  }  defer db.Close()
  rows, err := db.Query("SELECT tabid,tabname FROM systables where tabid < 10")  checkErr(err)
  for rows.Next() {    var tabid int    var tabname string    err = rows.Scan(&tabid, &tabname)    checkErr(err)    fmt.Printf("%dt%sn", tabid, tabname)  }  rows.Close()
  fmt.Printf("nGO ODBC测试程序结束运行.n")}
func checkErr(err error) {  if err != nil {    panic(err)  }}

PS D:gosrcbackupgbasetest> go run .GO ODBC测试程序开始运行.
4 api.SQLSMALLINT12 api.SQLSMALLINT1       systables2       syscolumns3       sysindices4       systabauth5       syscolauth6       sysviews7       sysusers8       sysdepend9       syssynonyms
GO ODBC测试程序结束运行.

groupadd gbasedbtuseradd -g gbasedbt -d /home/gbasedbt -s /bin/bash -m gbasedbt

cd /home/gbasedbt
# 下载linux下驱动wget  https://gbasedbt.com/dl/odbc/GBase8s_3.0-Linux64-ODBC-Driver.tar.gz
# 解压缩并修改目录名称tar -zxvf GBase8s_3.0-Linux64-ODBC-Driver.tar.gzmv gbase8s-odbc-driver gbase8s
# 进入etc配置目录cd /home/gbasedbt/gbase8s/etc
# 实例服务名gbase01的sqlhost配置vi sqlhost.gbase01

gbase01         onsoctcp        10.80.31.151        9088

# 在用户目录下cd /home/gbasedbt
# 创建odbc.ini文件vi odbc.ini

;---------------------------------------------------------------------------; GBase ODBC Sample File;; File:         odbc.ini;;---------------------------------------------------------------------------[ODBC Data Sources]odbcgbase=GBase ODBC DRIVER                              # 数据源名称、自定义
[odbcgbase]                                              # 数据源配置Driver=/home/gbasedbt/gbase8s/lib/cli/iclis09b.so        # 驱动地址Description=GBase ODBC DRIVER                            # 描述Database=movies                                          # 数据库LogonID=gbasedbt                                         # 登录账号pwd=GBase123                                             # 登录密码Servername=gbase01                                       # 实例名称CursorBehavior=0                                         CLIENT_LOCALE=zh_CN.utf8                                 # 客户端编码DB_LOCALE=zh_CN.utf8                                     # 数据库编码TRANSLATIONDLL=/home/gbasedbt/gbase8s/lib/esql/igo4a304.so
[ODBC]UNICODE=UCS-2                                           # 注意：必须使用UNICODE编码            # Trace=0TraceFile=/tmp/odbctrace.outInstallDir=/home/gbasedbt/gbase8s                        #安装路径TRACEDLL=idmrs09a.so

vi /etc/profile

export GBASEDBTDIR=/home/gbasedbt/gbase8sexport PATH=$GBASEDBTDIR/bin:$PATHexport LD_LIBRARY_PATH=$GBASEDBTDIR/lib:$GBASEDBTDIR/lib/cli:$GBASEDBTDIR/lib/esql:$LD_LIBRARY_PATHexport GBASEDBTSQLHOSTS=$GBASEDBTDIR/etc/sqlhosts.gbase01export ODBCINI=/home/gbasedbt/odbc.ini

source /etc/profile

# odbcbase 数据源名称odbc.iniisql -v odbcgbase
# 查询服务名称select dbservername::varchar(40) from dual;# 查询所有表select tabname from systables where tabid >= 100 and tabtype = 'T';

package main
import (        "database/sql"        "log"        "net/http"
        _ "github.com/alexbrainman/odbc"        "github.com/gin-gonic/gin")
type user struct {        Id   int        Name string        Age  int}
func main() {        db, err := sql.Open("odbc", "DSN=odbcgbase;UID=gbasedbt;PWD=GBase123")        if err != nil {                log.Fatal(err)        }
        r := gin.Default()
        serve := http.Server{                Addr:    ":1234",                Handler: r,        }
        go serve.ListenAndServe()
        r.GET("/", func(ctx *gin.Context) {                rows, err := db.Query("SELECT * FROM users where id >1")                if err != nil {                        log.Panic("异常", err)                }                users := make([]user, 0)                for rows.Next() {                      u := user{}                      rows.Scan(&u.Id, &u.Name, &u.Age)                      users = append(users, u)                }                rows.Close()                ctx.JSON(http.StatusOK, gin.H{"users": users})        })
        select {}
}

go run .