db

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)
• 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"
	DefaultConnMaxLifetime = 30 * time.Minute
	DefaultMaxIdleConns    = 10
	DefaultMaxOpenConns    = 50
)

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)

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
}