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 JSONObject(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 IntStringMap
  • func (s *IntStringMap) Scan(value interface{}) error
  • func (s IntStringMap) Value() (driver.Value, 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 JSONObject

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

JSONObject returns the JSON encoding of v object.

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 IntStringMap

type IntStringMap map[int64]string

IntStringMap db column value type.

func (*IntStringMap) Scan

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

Scan implements the sql.Scanner interface.

func (IntStringMap) Value

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

Value implements the driver.Valuer interface.

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.