前置条件
首先安装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{
}