mysql

Documentation

Index

• Constants
• type DeleteBuilder
  • func NewDeleteSQL() DeleteBuilder
• type InsertBuilder
  • func NewInsertSQL() InsertBuilder
• type SelectBuilder
  • func NewSelectSQL() SelectBuilder
• type UpdateBuilder
  • func NewUpdateSQL() UpdateBuilder

Constants

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

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