db

Documentation

Index

• Constants
• func FetchAll[M iTable](pool *ConnPool, whereOrQueryStmt string, args ...any) (collection.Slice[M], error)
• func FetchOne[M iTable](pool *ConnPool, whereOrQueryStmt string, args ...any) (M, error)
• type Column
• type Columns
  • func (c Columns) Compare(exists ...string) (mustAdd, recommendedAdd []Column, mustDel []string)
• type ConnPool
  • func OpenPool(connStr string, params ...int) (pool *ConnPool, err error)
  • func (pool *ConnPool) Close() error
  • func (pool *ConnPool) Count(sqlStmt string) int
  • func (pool *ConnPool) Exec(query string, args ...any) (n int64, err error)
  • func (pool *ConnPool) GetColumns(schema, table string) (Columns, error)
• type Table
  • func (t Table) IsDataNotNull() bool

Constants

const (
	ExcludedFieldName = "Table"
	TableName         = "TableName"
	ModelTagKeyName   = "db"
	TagNameForTable   = "name"
)

Functions

func FetchAll

func FetchAll[M iTable](pool *ConnPool, whereOrQueryStmt string, args ...any) (collection.Slice[M], error)

FetchAll 支持查询多条数据

func FetchOne

func FetchOne[M iTable](pool *ConnPool, whereOrQueryStmt string, args ...any) (M, error)

FetchOne 查询单条数据

Types

type Column

type Column struct {
	Name       string      `json:"name"`
	Type       string      `json:"type"`
	IsNullable int         `json:"isNullable"`
	Default    interface{} `json:"default"`
	Extra      string      `json:"extra"`
}

type Columns

type Columns struct {
	Cols []Column
}

func (Columns) Compare

func (c Columns) Compare(exists ...string) (mustAdd, recommendedAdd []Column, mustDel []string)

type ConnPool

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

func OpenPool

func OpenPool(connStr string, params ...int) (pool *ConnPool, err error)

func (*ConnPool) Close

func (pool *ConnPool) Close() error

func (*ConnPool) Count

func (pool *ConnPool) Count(sqlStmt string) int

func (*ConnPool) Exec

func (pool *ConnPool) Exec(query string, args ...any) (n int64, err error)

Exec 支持数据库增/删/改

func (*ConnPool) GetColumns

func (pool *ConnPool) GetColumns(schema, table string) (Columns, error)

type Table

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

func (Table) IsDataNotNull

func (t Table) IsDataNotNull() bool