Gorm操作Oracle数据库

前置条件
首先安装oci8和oracle数据库客户端，之后配置好环境变量LD_LIBRARY_PATH

获取Gorm-Oracle驱动

go get github.com/CengSin/oracle

在文件加载的时候初始化数据库连接

package main

import (
	"GoModuleDemo/oracle/oci8/model"
	"encoding/json"
	"fmt"
	"github.com/cengsin/oracle"
	"gorm.io/gorm"
	"gorm.io/gorm/clause"
	"gorm.io/gorm/logger"
	"log"
	"math/rand"
	"os"
	"strconv"
	"time"
)

var (
	db *gorm.DB
)

func init() {
   
	log.Println("initial database connect……")
	con, err := gorm.Open(oracle.Open("system/oracle@127.0.0.1:1521/XE"), &gorm.Config{
   
		Logger: logger.New(log.New(os.Stdout, "\r\n", log.LstdFlags), logger.Config{
   
			SlowThreshold: 1 * time.Millisecond,
			LogLevel:      logger.Warn,
			Colorful:      true,
		}),
		//SkipDefaultTransaction: true,
	})

	if err != nil {
   
		log.Fatalln(err)
	}

	// 初始化各种结构
	db = con
	if err = db.AutoMigrate(
		&model.ClassInfo{
   },
		&model.UserInfo{
   },
		&model.Email{
   },
		&model.UserModel{
   },
		&model.CreditCard{
   }