Documentation ¶
Overview ¶
自定义类型 type XXX byte const AAA XXX = '0'
Index ¶
- Variables
- func CreateSchema(schemaName string) error
- func CreateTable[T IEntity]() error
- func Delete[T IEntity](params map[string]any) (int, error)
- func DeleteObject[T IEntity](c *gin.Context)
- func DropTable[T IEntity]() error
- func GetColumnName(tblName string) []string
- func GetObjects[T IEntity](c *gin.Context)
- func GetPrimaryKey[T IEntity]() []string
- func GetPrimaryKeyWithName(tblName string) ([]string, error)
- func GetTableName[T IEntity]() string
- func InitDao(dmDSN string)
- func Insert[T IEntity](params map[string]any) error
- func InsertSlice[T IEntity](entities []T) (int, error)
- func InsertStruct[T IEntity](entity T) error
- func InsertWithTblName(tblName string, params map[string]any) error
- func MapToSetFinder(params map[string]any) *zorm.Finder
- func MapToUpper(params map[string]any) map[string]any
- func MapToWhereFinder(params map[string]any) *zorm.Finder
- func PostObject[T IEntity](c *gin.Context)
- func PutObject[T IEntity](c *gin.Context)
- func ResponseErr(c *gin.Context, err error, datas ...any)
- func ResponseOK(c *gin.Context, datas ...any)
- func Select[T IEntity](p *PageInfo, params map[string]any, sqlStrAppend ...string) ([]T, error)
- func SelectCount[T IEntity](where map[string]any) (int, error)
- func SelectCountByName(tblName string, where map[string]any) (int, error)
- func SelectMap[T IEntity](p *PageInfo, params map[string]any, sqlStrAppend ...string) ([]map[string]any, error)
- func SelectMapByName(tblName string, p *PageInfo, params map[string]any, sqlStrAppend ...string) ([]map[string]any, error)
- func SelectMapColumns[T IEntity](p *PageInfo, params map[string]any, columns []string, sqlStrAppend ...string) ([]map[string]any, error)
- func SelectMapColumnsByName(tblName string, p *PageInfo, params map[string]any, columns []string, ...) ([]map[string]any, error)
- func SelectRow[T IEntity](columnName string, params map[string]any, sqlStrAppend ...string) (any, error)
- func SelectRowByName(tblName string, columnName string, params map[string]any, ...) (any, error)
- func TableExists(tblName string) bool
- func ToJsonStruct[T IEntity]() string
- func ToLittleCamelJson(t any) string
- func ToLittleCamelMap(t any) map[string]any
- func ToMap(t any) map[string]any
- func ToUpperMap(t any) map[string]any
- func Transaction(fun func() error) error
- func TrunTable[T IEntity]() error
- func Update[T IEntity](wheres []map[string]any, set map[string]any) (int, error)
- func UpdateOne[T IEntity](where map[string]any, set map[string]any) (int, error)
- func UpdateOneWithTblName(tblName string, where map[string]any, set map[string]any) (int, error)
- func UpdateWithTblName(tblName string, wheres []map[string]any, set map[string]any) (int, error)
- type Entity
- type EnumType
- type Error
- type IEntity
- type PageInfo
- type Response
- type TableColumn
Constants ¶
This section is empty.
Variables ¶
var SchemaName = "SYSDBA" // 模式
Functions ¶
func CreateSchema ¶
func CreateTable ¶
func GetPrimaryKeyWithName ¶
GetPrimaryKeyWithName 取指定表的主键
func GetTableName ¶
GetTableName 根据struct类型取表名(SchemaName+tblName) 大写
func InsertSlice ¶ added in v1.0.9
InsertSlice 插入多条数据(已开启事务)
func InsertStruct ¶ added in v1.0.9
InsertStruct 插入数据(struct)
func InsertWithTblName ¶
InsertWithTblName 根据表名插入数据 自定义 byte 类型需转换为 uint8 或 string
func MapToSetFinder ¶
MapToSetFinder 用于 insert update
func MapToWhereFinder ¶
MapToWhereFinder 用于 select
func Select ¶
Select 查询, 返回 struct p==nil 不分页; params==nil 查所有; fndAppend 附加查询(如Order Limit Group 等)
func SelectCount ¶
SelectCount count(1)
func SelectCountByName ¶ added in v1.0.9
SelectCount count(1)
func SelectMap ¶
func SelectMap[T IEntity](p *PageInfo, params map[string]any, sqlStrAppend ...string) ([]map[string]any, error)
SelectMap 查询返回 map p==nil 不分页; params==nil 查所有; fndAppend 附加查询(如Order Limit Group 等)
func SelectMapByName ¶
func SelectMapByName(tblName string, p *PageInfo, params map[string]any, sqlStrAppend ...string) ([]map[string]any, error)
SelectMapByName 根据表名查询, 返回 map
func SelectMapColumns ¶ added in v1.0.9
func SelectMapColumns[T IEntity](p *PageInfo, params map[string]any, columns []string, sqlStrAppend ...string) ([]map[string]any, error)
SelectMapColumns 返回 map, 指定字段名
func SelectMapColumnsByName ¶ added in v1.0.9
func SelectMapColumnsByName(tblName string, p *PageInfo, params map[string]any, columns []string, sqlStrAppend ...string) ([]map[string]any, error)
SelectMapColumnsByName 根据表名查询, 返回 map 指定列名
func SelectRow ¶ added in v1.0.9
func SelectRow[T IEntity](columnName string, params map[string]any, sqlStrAppend ...string) (any, error)
SelectRow 返回指定列首行, 无效查询返回 nil, nil
func SelectRowByName ¶ added in v1.0.9
func SelectRowByName(tblName string, columnName string, params map[string]any, sqlStrAppend ...string) (any, error)
SelectRowByName 返回指定列首行, 无效查询返回 nil, nil
func ToLittleCamelJson ¶
ToLittleCamelJson struct 转为(camel) json
func UpdateOneWithTblName ¶
UpdateOneWithTblName 根据表名更新(单个条件)
Types ¶
type Entity ¶
type Entity struct { InsertTime string `zorm:"size:19;index;comment:入库时间"` UpdateTime string `zorm:"size:19;index;comment:更新时间"` }
Entity 实现 IEntity
func (Entity) GetPKColumnName ¶
func (Entity) GetPkSequence ¶
func (Entity) GetPrimaryKey ¶
GetPrimaryKey 表的主键, 返回 nil 时忽略此函数; 否则以此函数为准忽略 tag中的 primaryKey 配置
func (Entity) GetTableName ¶
GetTableName 返回struct类型名;需要struct自行实现
type EnumType ¶
type EnumType struct{}
func (EnumType) ConverDriverValue ¶
func (e EnumType) ConverDriverValue(ctx context.Context, columnType *sql.ColumnType, tempDriverValue driver.Value, structFieldType *reflect.Type) (interface{}, error)
ConverDriverValue 数据库列类型,GetDriverValue返回的driver.Value的临时接收值,struct属性类型 非struct类型接收,无法获取到structFieldType,会传入nil 返回符合接收类型值的指针,指针,指针!!!!
type IEntity ¶
type IEntity interface { zorm.IEntityStruct GetPrimaryKey() []string // 主键 }