sqlp

Feb 22, 2025

Changes in this version

+ func DeleteObj[T Repo](obj T) error

+ func GetAllWhere[T Repo](where string, args ...any) ([]T, error)

+ func GetAll[T Repo]() ([]T, error)

+ func GetByPk[T Repo](pk any) (T, error)

+ func GetSingleWhere[T Repo](where string, args ...any) (res T, err error)

Dec 24, 2024

Changes in this version

+ func GetR[T Repo]() ([]T, error)

+ func GetSingleWhereR[T Repo](where string, args ...any) (res T, err error)

+ func GetWhereR[T Repo](where string, args ...any) ([]T, error)

Nov 25, 2024

Changes in this version

+ func DeleteRdb[T Repo](db *sql.DB, obj T) error

+ func InsertRdb[T Repo](db *sql.DB, obj T) (int, error)

+ func UpdateRdb[T Repo](db *sql.DB, obj T) error

Nov 25, 2024

Changes in this version

+ func InDb(db *sql.DB, query string, args ...any) error

+ func QueryBasicDb[T string | int | int64 | float32 | float64](db *sql.DB, query string, args ...any) (results []T, err error)

+ func QueryBasicRowDb[T string | int | int64 | float32 | float64](db *sql.DB, query string, args ...any) (result T, err error)

+ func QueryDb[T any](db *sql.DB, query string, args ...any) (results []T, err error)

+ func QueryRowDb[T any](db *sql.DB, query string, args ...any) (result T, err error)

Nov 25, 2024

Changes in this version

+ func DeleteDb[T any](db *sql.DB, pk any, table string) error

+ func InsertDb[T any](db *sql.DB, obj T, table string) (int, error)

+ func UpdateDb[T any](db *sql.DB, obj T, table string) error

Nov 11, 2024

Changes in this version

+ func DeleteR[T Repo](obj T) error

+ func InsertR[T Repo](obj T) (int, error)

+ func UpdateR[T Repo](obj T) error

+ type Repo interface

+ TableName func() string

May 20, 2024

Changes in this version

+ func ToAny(s any) []any

May 18, 2024

Changes in this version

+ func InQuery(query string, args []any) (string, []any)

May 7, 2024

Changes in this version

+ func In(query string, args ...any) error

May 3, 2024

Changes in this version

+ func QueryBasicRow[T string | int | int64 | float32 | float64](query string, args ...any) (result T, err error)

May 3, 2024

Changes in this version

+ var IgnoreTagName = "sql-ign"

May 1, 2024

Changes in this version

+ func Delete[T any](pk any, table string) error

May 1, 2024

Changes in this version

+ var AutoGenTagName = "sql-auto"

+ var ErrNotSet = errors.New("sqlp: database not set")

+ var InQueryReplace = "(*)"

+ var NameMapper = strings.ToLower

+ var QueryReplace = "*"

+ var TagName = "sql"

+ func Columns[T any]() string

+ func Insert[T any](obj T, table string) (int64, error)

+ func QueryBasic[T string | int | int64 | float32 | float64](query string, args ...any) (results []T, err error)

+ func QueryRow[T any](query string, args ...any) (stru T, err error)

+ func Query[T any](query string, args ...any) (slice []T, err error)

+ func Scan[T any](dest *T, rows Rows) error

+ func SetDatabase(sqldb *sql.DB)

+ func ToSnakeCase(src string) string

+ func Update[T any](obj T, table string) error

+ type Rows interface

+ Columns func() ([]string, error)

+ Scan func(...any) error

+ type Scanner interface

+ Scan func(src any) error