mysql

Documentation

Index

• Constants
• func BackupMySQL(dbUser, dbPassword, dbName, backupPath string, cmdModifier func() []string) (fullFile string, err error)
• func DockerExecCmd(containerName string) []string
• func Sum[E any](field string, defaultV E, newField string) string
• func UNIXSecToDate(field string, format string, newField string) string
• type DeleteBuilder
  • func NewDeleteSQL() DeleteBuilder
• type InsertBuilder
  • func NewInsertSQL() InsertBuilder
• type SelectBuilder
  • func NewSelectSQL() SelectBuilder
• type UpdateBuilder
  • func NewUpdateSQL() UpdateBuilder

Constants

const (
	DateFormatDef = "YYYY-MM-DD HH:MM:SS"
	DateFormatYMD = "%Y-%m-%d"
	DateFormatYM  = "%Y-%m"
)

const (
	DateFormatter1 = "%Y-%m-%d %H:%i:%s"
)

Functions

func BackupMySQL

func BackupMySQL(dbUser, dbPassword, dbName, backupPath string, cmdModifier func() []string) (fullFile string, err error)

func DockerExecCmd

func DockerExecCmd(containerName string) []string

func Sum

func Sum[E any](field string, defaultV E, newField string) string

func UNIXSecToDate

func UNIXSecToDate(field string, format string, newField string) string

Types

type DeleteBuilder

type DeleteBuilder interface {
	Table(name string) DeleteBuilder
	Where(query string, args ...any) DeleteBuilder
	Or(query string, args ...any) DeleteBuilder
	ToSql() string
}

func NewDeleteSQL

func NewDeleteSQL() DeleteBuilder

type InsertBuilder

type InsertBuilder interface {
	Table(name string) InsertBuilder
	Columns(col ...string) InsertBuilder
	AppendValues(v ...any) InsertBuilder
	ToSql() string
}

func NewInsertSQL

func NewInsertSQL() InsertBuilder

type SelectBuilder

type SelectBuilder interface {
	Table(query string) SelectBuilder
	Select(column ...string) SelectBuilder
	Joins(query string, args ...any) SelectBuilder
	Where(query string, args ...any) SelectBuilder
	Having(query string, args ...any) SelectBuilder
	Or(query string, args ...any) SelectBuilder
	Group(name string) SelectBuilder
	Order(v string) SelectBuilder
	PageLimit(page, limit int) SelectBuilder
	ToCountSql() string
	ToSql() string
}

func NewSelectSQL

func NewSelectSQL() SelectBuilder

type UpdateBuilder

type UpdateBuilder interface {
	Table(name string) UpdateBuilder
	Where(query string, args ...any) UpdateBuilder
	Or(query string, args ...any) UpdateBuilder
	Update(column string, v any) UpdateBuilder
	ToSql() string
}

func NewUpdateSQL

func NewUpdateSQL() UpdateBuilder