db

Documentation

Index

• Constants
• Variables
• type Db
  • 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
  • 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
• type PasswordDecode
• type TableSize

Constants

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

Variables

var MAX_IDLE_CONNS = 0

var MAX_OPEN_CONNS = 500

Types

type Db

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

func NewDb

func NewDb() *Db

func (*Db) AddDb

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

func (*Db) CreateDb

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

func (*Db) CreateUser

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

func (*Db) GrantUserPrivileges

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

func (*Db) SizeDb

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

func (*Db) SizeTable

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

type DbConfig

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

func NewDbConfig

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

func (*DbConfig) GetHost

func (dbc *DbConfig) GetHost() string

func (*DbConfig) GetSqlConfig

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

type DbInstruct

type DbInstruct func(database *sql.DB) bool

type PasswordDecode

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

type TableSize

type TableSize struct {
	Table string
	Size  float32
}