Documentation ¶
Overview ¶
自定义类型 type XXX byte const AAA XXX = '0'
自定义类型 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 DeleteByName(tblName string, 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 GetPrimaryKeyByName(tblName string) ([]string, error)
- func GetTableName[T IEntity]() string
- func InitDao(dmDSN string) (context.Context, error)
- func InitDaoOracle(crmsDSN string) (context.Context, error)
- func Insert[T IEntity](entities ...T) error
- func InsertMap[T IEntity](entities ...map[string]any) error
- func InsertMapByName(tblName string, entities ...map[string]any) error
- func InsertNotZero[T IEntity](entities ...T) error
- func MapToSetFinder(params map[string]any) *zorm.Finder
- func MapToWhereFinder(params map[string]any) *zorm.Finder
- func PostObject[T IEntity](c *gin.Context)
- func PutObject[T IEntity](c *gin.Context)
- func QueryMap(sqlStr string, values ...any) ([]map[string]any, error)
- 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 SelectByStruct[T IEntity](p *PageInfo, t T, 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 SetDefaultCtx(ctx context.Context)
- func StructToJson[T IEntity]() string
- func TableExists(tblName string) bool
- 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](entities ...T) (int, error)
- func UpdateMap[T IEntity](where map[string]any, set map[string]any) (int, error)
- func UpdateMapByName(tblName string, where map[string]any, set map[string]any) (int, error)
- func UpdateMapConditions[T IEntity](wheres []map[string]any, set map[string]any) (int, error)
- func UpdateMapConditionsByName(tblName string, wheres []map[string]any, set map[string]any) (int, error)
- type Entity
- type EnumType
- type Error
- type IEntity
- type NumericType
- type PageInfo
- type Response
- type TableColumn
Constants ¶
This section is empty.
Variables ¶
var SchemaName = "SYSDBA" // 模式
Functions ¶
func CreateSchema ¶
func CreateTable ¶
func DeleteByName ¶ added in v1.0.12
DeleteByName 根据表名删除
func GetPrimaryKeyByName ¶ added in v1.0.13
GetPrimaryKeyByName 取指定表的主键(从库中查询)
func GetTableName ¶
GetTableName 根据struct类型取表名(SchemaName+tblName) 大写
func InitDaoOracle ¶ added in v1.0.16
InitDaoOracle 初始化 oracle 应用需要 import _ "github.com/godror/godror" 基于[email protected] 需修改 dbdao.go 995行 valus[i]=new(float64), 以返回 NUMBER 类型
func InsertMapByName ¶ added in v1.0.12
InsertMapByName 根据表名插入数据 Insert 基于此
func InsertNotZero ¶ added in v1.0.16
InsertNotZero 插入数据, 过滤0值(bool:false, int:0, string:"")
func MapToSetFinder ¶
MapToSetFinder 用于 update
func MapToWhereFinder ¶
MapToWhereFinder 用于 select update
func Select ¶
Select 查询, 返回 struct p==nil 不分页; params==nil 查所有; fndAppend 附加查询(如Order Limit Group 等)
func SelectByStruct ¶ added in v1.0.16
SelectByStruct 查询,条件用 IEntity 实例, 返回 struct p==nil 不分页; t==T{} 查所有; fndAppend 附加查询(如Order Limit Group 等) t 接受非0值, 若查查询 bool:false int:0 string:"" 的条件,可在 sqlStrAppend 拼接
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 p==nil 不分页; params==nil 查所有; fndAppend 附加查询(如Order Limit Group 等)
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, 指定字段名 p==nil 不分页; params==nil 查所有; fndAppend 附加查询(如Order Limit Group 等) columns 指定查询列名
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 指定列名 p==nil 不分页; params==nil 查所有; fndAppend 附加查询(如Order Limit Group 等) columns 指定查询列名 所有 SelectMap 基于此
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 SetDefaultCtx ¶ added in v1.0.16
func StructToJson ¶ added in v1.0.12
StructToJson 转为json 为apiFox使用
func UpdateMapByName ¶ added in v1.0.12
UpdateMapByName 根据表名更新(单个条件)
func UpdateMapConditions ¶ added in v1.0.12
UpdateMapConditions 更新(多条件)
Types ¶
type Entity ¶
type Entity struct{}
Entity 实现 IEntity
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 // 主键 }
type NumericType ¶ added in v1.0.14
type NumericType struct{}
func (NumericType) ConverDriverValue ¶ added in v1.0.14
func (e NumericType) ConverDriverValue(ctx context.Context, columnType *sql.ColumnType, tempDriverValue driver.Value, structFieldType *reflect.Type) (interface{}, error)
ConverDriverValue 数据库列类型,GetDriverValue返回的driver.Value的临时接收值,struct属性类型 非struct类型接收,无法获取到structFieldType,会传入nil 返回符合接收类型值的指针,指针,指针!!!!
func (NumericType) GetDriverValue ¶ added in v1.0.14
func (e NumericType) GetDriverValue(ctx context.Context, columnType *sql.ColumnType, structFieldType *reflect.Type) (driver.Value, error)
GetDriverValue 根据数据库列类型,返回driver.Value的实例,struct属性类型 非struct类型接收,无法获取到structFieldType,会传入nil