db

package

v0.0.62 Latest Latest Go to latest Published: Apr 13, 2024 License: GPL-3.0 Imports: 6 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

View Source

const USER_DEFAULT_PRIVILEGES = "CREATE, CREATE VIEW, CREATE TEMPORARY TABLES, SELECT, INSERT, UPDATE, DELETE, EXECUTE, LOCK TABLES, TRIGGER"

View Source

var MAX_IDLE_CONNS = 0

View Source

var MAX_OPEN_CONNS = 500

This section is empty.

type Db struct {
	// contains filtered or unexported fields
}

func NewDb() *Db

func (db *Db) AddDb(dbconf *DbConfig, passwdGet ...PasswordDecode)

func (db *Db) CreateDb(dbname string, collate string) bool

func (db *Db) CreateUser(username string, hostname string, passwd string) bool

func (db *Db) GrantUserPrivileges(dbname string, username string, hostname string) bool

func (db *Db) SizeDb(dbname string) float32

func (db *Db) SizeTable(dbname string) []TableSize

type DbConfig struct {
	// contains filtered or unexported fields
}

func NewDbConfig(host string, dbname string, user string, passwd string, port int) *DbConfig

func (dbc *DbConfig) GetHost() string

func (dbc *DbConfig) GetSqlConfig(passwdGet ...PasswordDecode) *mysql.Config

type DbInstruct func(database *sql.DB) bool

type PasswordDecode func(in string) (string, bool)

type TableSize struct {
	Table string
	Size  float32
}