tsql

Documentation

Index

• func BatchInsert[T any](db *gorm.DB, table string, values []*T) (int64, error)
• func Delete[T any](db *gorm.DB, table string, condition map[string]interface{}) (int64, error)
• func ExecuteRaw(db *gorm.DB, raw string, values ...interface{}) error
• func Insert[T any](db *gorm.DB, table string, value *T) (int64, error)
• func IsNotFoundErr(err error) bool
• func JSONArray(v interface{}, isNil bool) (driver.Value, error)
• func JSONScan(value, v interface{}) error
• func Select[T any](db *gorm.DB, table string, condition map[string]interface{}) ([]T, error)
• func SelectAll[T any](data T, prefix ...string) string
• func SelectById[T any](db *gorm.DB, table string, id int64, columns ...string) (T, error)
• func SelectPluck[T any, K any](db *gorm.DB, table string, condition map[string]interface{}, column string) ([]K, error)
• func SelectRaw[T any](db *gorm.DB, raw string, values ...interface{}) ([]T, error)
• func Update[T any](db *gorm.DB, table string, condition map[string]interface{}, ...) (int64, error)
• type SecTimestamp
  • func NewSecTimestamp(t time.Time) SecTimestamp
  • func (s *SecTimestamp) Scan(src interface{}) error
  • func (s *SecTimestamp) Time() time.Time
  • func (s *SecTimestamp) Value() (driver.Value, error)
• type Strings
  • func (s *Strings) Scan(value interface{}) error
  • func (s Strings) Value() (driver.Value, error)

Functions

func BatchInsert

func BatchInsert[T any](db *gorm.DB, table string, values []*T) (int64, error)

func Delete

func Delete[T any](db *gorm.DB, table string, condition map[string]interface{}) (int64, error)

func ExecuteRaw

func ExecuteRaw(db *gorm.DB, raw string, values ...interface{}) error

func Insert

func Insert[T any](db *gorm.DB, table string, value *T) (int64, error)

func IsNotFoundErr

func IsNotFoundErr(err error) bool

func JSONArray

func JSONArray(v interface{}, isNil bool) (driver.Value, error)

JSONArray returns the JSON encoding of v array.

func JSONScan

func JSONScan(value, v interface{}) error

JSONScan parses the JSON-encoded data and stores the result in the value pointed to by v.

func Select

func Select[T any](db *gorm.DB, table string, condition map[string]interface{}) ([]T, error)

func SelectAll

func SelectAll[T any](data T, prefix ...string) string

SelectAll 生成select a, b, c, d 前缀

func SelectById

func SelectById[T any](db *gorm.DB, table string, id int64, columns ...string) (T, error)

func SelectPluck

func SelectPluck[T any, K any](db *gorm.DB, table string, condition map[string]interface{}, column string) ([]K, error)

func SelectRaw

func SelectRaw[T any](db *gorm.DB, raw string, values ...interface{}) ([]T, error)

func Update

func Update[T any](db *gorm.DB, table string, condition map[string]interface{}, values map[string]interface{}) (int64, error)

Types

type SecTimestamp

type SecTimestamp int64

SecTimestamp 用于mysql的秒时间戳类型

func NewSecTimestamp

func NewSecTimestamp(t time.Time) SecTimestamp

func (*SecTimestamp) Scan

func (s *SecTimestamp) Scan(src interface{}) error

func (*SecTimestamp) Time

func (s *SecTimestamp) Time() time.Time

func (*SecTimestamp) Value

func (s *SecTimestamp) Value() (driver.Value, error)

type Strings

type Strings []string

Strings db column value type.

func (*Strings) Scan

func (s *Strings) Scan(value interface{}) error

Scan implements the sql.Scanner interface.

func (Strings) Value

func (s Strings) Value() (driver.Value, error)

Value implements the driver.Valuer interface.