mysql

Documentation

Index

• func DuplicateEntry(err error) bool
• func Escape(value string) string
• type DB
  • func New(ctx context.Context, dsn string, opts ...Option) (*DB, error)
  • func (impl *DB) QueryResult(ctx context.Context, sql string) ([]map[string]any, error)
• type Option
  • func WithConnMaxIdleTime(t time.Duration) Option
  • func WithConnMaxLifetime(t time.Duration) Option
  • func WithMaxIdleConns(n int) Option
  • func WithMaxOpenConns(n int) Option
• type Options

Functions

func DuplicateEntry

func DuplicateEntry(err error) bool

func Escape

func Escape(value string) string

Types

type DB

type DB struct {
	*sql.DB
}

func New

func New(ctx context.Context, dsn string, opts ...Option) (*DB, error)

func (*DB) QueryResult

func (impl *DB) QueryResult(ctx context.Context, sql string) ([]map[string]any, error)

type Option

type Option func(*Options)

func WithConnMaxIdleTime

func WithConnMaxIdleTime(t time.Duration) Option

func WithConnMaxLifetime

func WithConnMaxLifetime(t time.Duration) Option

func WithMaxIdleConns

func WithMaxIdleConns(n int) Option

func WithMaxOpenConns

func WithMaxOpenConns(n int) Option

type Options

type Options struct {
	MaxIdleConns    int           // 最大空闲连接数
	MaxOpenConns    int           // 最大打开连接数
	ConnMaxLifetime time.Duration // 连接重用最大时间
	ConnMaxIdleTime time.Duration // 连接空闲最大时间
}