DB

Documentation

Overview

* @Author: i@douxuefeng.cn * @Date: 2023-04-15 09:18:31 * @LastEditTime: 2023-04-15 09:20:44 * @LastEditors: i@douxuefeng.cn * @Description: * @FilePath: /nodes/Volumes/Data/jobs/go-utils/DB/sqlite.go

Index

• func CloseDb()
• func GetDb() *gorm.DB
• func InitDb(opt *Opt) error
• func InitSqlite(opt *SqliteOpt) error
• type BaseModel
• type CommModel
• type DBCondition
  • func GetNameLikeCondition(name string) DBCondition
  • func GetOrder(order string) DBCondition
  • func GetTitleLikeCondition(title string) DBCondition
  • func Paginate(page, pageSize int) DBCondition
• type Opt
• type SqliteOpt

Functions

func CloseDb

func CloseDb()

func GetDb

func GetDb() *gorm.DB

func InitDb

func InitDb(opt *Opt) error

func InitSqlite

func InitSqlite(opt *SqliteOpt) error

Types

type BaseModel

type BaseModel struct {
	Id        int64           `json:"id"  gorm:"primaryKey"`
	CreatedAt *time.Time      `json:"created_at,omitempty" `
	UpdatedAt *time.Time      `json:"updated_at,omitempty" `
	DeletedAt *gorm.DeletedAt `json:"deleted_at,omitempty" `
}

添加软删除

type CommModel

type CommModel struct {
	Id        int64      `json:"id"  gorm:"primaryKey"`
	CreatedAt *time.Time `json:"created_at,omitempty" `
	UpdatedAt *time.Time `json:"updated_at,omitempty" `
}

type DBCondition

type DBCondition func(db *gorm.DB) *gorm.DB

func GetNameLikeCondition

func GetNameLikeCondition(name string) DBCondition

func GetOrder

func GetOrder(order string) DBCondition

func GetTitleLikeCondition

func GetTitleLikeCondition(title string) DBCondition

func Paginate

func Paginate(page, pageSize int) DBCondition

type Opt

type Opt struct {
	Dsn                                      string //master
	MaxIdle                                  int
	MaxOpen                                  int
	LogMode                                  logger.LogLevel
	Models                                   []any
	EnableMigrate                            bool
	DisableForeignKeyConstraintWhenMigrating bool
}

type SqliteOpt

type SqliteOpt struct {
	SqlFile                           string
	MaxIdle                           int
	MaxOpen                           int
	LogMode                           logger.LogLevel
	Models                            []any
	DisableForeignKeyCheckWhenMigrate bool
	EnableMigrate                     bool
}