database

Documentation

Index

• Constants
• func CreateInsertSql(tableName string, kv map[string]interface{}) (sql string, values []interface{})
• func Expr(expr string, args ...interface{}) clause.Expr
• func Get() *gorm.DB
• func GetWithContext(ctx context.Context) *gorm.DB
• func InitDataSource(option Option) *gorm.DB
• func InitDefault()
• func InitDefaultWithOption(option Option)
• func Transaction(ctx context.Context, fc func(txctx context.Context) error) error
• type Option

Constants

const (
	DB_DSN                 = "datasource.dsn"
	DB_URL_KEY             = "datasource.url"
	DB_USERNAME_KEY        = "datasource.username"
	DB_PWD_KEY             = "datasource.password"
	DB_CONN_MAX_LIFE_TIME  = "datasource.connMaxLifetime"
	DB_MAX_IDLE_CONNS      = "datasource.maxIdleConns"
	DB_MAX_OPEN_CONNS      = "datasource.maxOpenConns"
	DB_QueryFields         = "datasource.queryFields"
	DB_TYPE                = "datasource.type"
	DefaultConnMaxLifetime = 30 * time.Minute
	DefaultMaxIdleConns    = 10
	DefaultMaxOpenConns    = 50
	DB_TYPE_MYSQL          = "mysql"
)

Functions

func CreateInsertSql

func CreateInsertSql(tableName string, kv map[string]interface{}) (sql string, values []interface{})

func Expr

func Expr(expr string, args ...interface{}) clause.Expr

func Get

func Get() *gorm.DB

func GetWithContext

func GetWithContext(ctx context.Context) *gorm.DB

func InitDataSource

func InitDataSource(option Option) *gorm.DB

func InitDefault

func InitDefault()

根据项目env初始化

func InitDefaultWithOption

func InitDefaultWithOption(option Option)

func Transaction

func Transaction(ctx context.Context, fc func(txctx context.Context) error) error

Types

type Option

type Option struct {
	DSN string
	//打开数据库连接的最大数量，默认DefaultMaxOpenConns
	MaxOpenConns int
	//空闲连接池中连接的最大数量，默认DefaultMaxIdleConns
	MaxIdleConns int
	//连接可复用的最大时间。单位分钟，默认DefaultConnMaxLifetime
	ConnMaxLifetime int
	//QueryFields executes the SQL query with all fields of the table
	QueryFields bool
	//数据源类型：MySql
	Type string
}