db

package
v0.1.2 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: May 17, 2022 License: MIT Imports: 7 Imported by: 0

Documentation

Overview

Package db provide useful functions to manipulate mysql instance.

Index

Constants

View Source
const (
	ConfigDBKey = "mysql"

	DefaultHost                  = "127.0.0.1:3306"
	DefaultMaxIdleConnections    = 100
	DefaultMaxOpenConnections    = 100
	DefaultMaxConnectionLifeTime = "10s"
)
View Source
const (
	DefaultOffset = 0
	DefaultLimit  = 1000
)

Variables

This section is empty.

Functions

func GetInstanceID

func GetInstanceID(uid uint64, prefix string) string

GetInstanceID returns id format like: secret-2v69o5

Types

type DBBuilder

type DBBuilder struct {
	Host                  string
	Username              string
	Password              string
	Database              string
	MaxIdleConnections    int    `mapstructure:"max-idle-connections"`
	MaxOpenConnections    int    `mapstructure:"max-open-connections"`
	MaxConnectionLifeTime string `mapstructure:"max-connection-life-time"`
	// contains filtered or unexported fields
}

DBBuilder defines options for building a db instance.

func NewDBBuilder

func NewDBBuilder() *DBBuilder

NewDBBuilder is used to build a db instance.

func (*DBBuilder) Build

func (b *DBBuilder) Build() (*gorm.DB, error)

Build builds a gorm db instance.

type OffsetLimit added in v0.0.6

type OffsetLimit struct {
	Offset int
	Limit  int
}

OffsetLimit is used to retrieve the records in the db by page.

func NewOffsetLimit added in v0.0.6

func NewOffsetLimit(offset *int, limit *int) *OffsetLimit

NewOffsetLimit uses offset/DefaultOffset and limit/DefaultLimit to generate an OffsetLimit.

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL