pagedb

package
v1.0.2-dev-10 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Dec 8, 2024 License: MulanPSL-2.0 Imports: 23 Imported by: 0

Documentation

Index

Constants

View Source 
const DefaultTable = metadata.DefaultTable //"rules"

@Title 文件名称: pagedb_request.go @Description 描述: PagedbRequest

@Author 作者: leijianming@163.com 时间(2024-02-21 22:38:21) @Update 作者: leijianming@163.com 时间(2024-02-21 22:38:21)

Variables

View Source 
var DefaultFields = strings.Join(metadata.DefaultFields, ",") //"rule_id,rule_key"

Functions

func InjectSubTableDto 

func InjectSubTableDto(s *SubTableDto)

func LoadSubTableDto 

func LoadSubTableDto() baseiface.ISingleton

func Stru2Map 

func Stru2Map(stru any) map[string]any

Types

type CmdRequest 

type CmdRequest struct {
	PkeyValue any `json:"pkey_value,omitempty"`
	// map or struct
	UpdateRecord map[string]any `json:"update_record,omitempty"`
	GroupFields  string         `json:"group_fields"`
	StatFields   string         `json:"stat_fields"`
}

type PagedbGroup 

type PagedbGroup struct {
	*PagedbRequest
	CmdRequest
	// contains filtered or unexported fields
}

func DefaultDbGroup 

func DefaultDbGroup() *PagedbGroup

func NewPagedbGroup 

func NewPagedbGroup() *PagedbGroup

func (*PagedbGroup) CreateDbTableStru 

func (self *PagedbGroup) CreateDbTableStru(meta *metadata.MetadataTable) reflect.Value

func (*PagedbGroup) CreateStatStru 

func (self *PagedbGroup) CreateStatStru(groupFields string, statField ...string) any

func (*PagedbGroup) CreateTableRecord 

func (self *PagedbGroup) CreateTableRecord() (any, error)

func (*PagedbGroup) CreateTableStru 

func (self *PagedbGroup) CreateTableStru() (reflect.Value, error)

func (*PagedbGroup) DbGroupStat 

func (self *PagedbGroup) DbGroupStat(groupFields string, statfields ...string) ([]map[string]any, error)

func (*PagedbGroup) DbStat 

func (self *PagedbGroup) DbStat(statfield ...string) (map[string]any, error)

var sql = `select groupFields, sum(statField) ,max(statField),count(statField) , 

min(statField),count(statField) ,avg(statField)	from ` + self.TableName

func (*PagedbGroup) DeleteById 

func (self *PagedbGroup) DeleteById(pkeyValue any) error

func (*PagedbGroup) DeleteWhere 

func (self *PagedbGroup) DeleteWhere() error

func (*PagedbGroup) FindById 

func (self *PagedbGroup) FindById(pkey any) (any, bool, error)

func (*PagedbGroup) FindMeta 

func (self *PagedbGroup) FindMeta() *metadata.MetadataTable

func (*PagedbGroup) FindPkName 

func (self *PagedbGroup) FindPkName() string

func (*PagedbGroup) GeneralScanTable 

func (self *PagedbGroup) GeneralScanTable() *page.PageResult

func (*PagedbGroup) Init 

func (self *PagedbGroup) Init()

func (*PagedbGroup) Insert 

func (self *PagedbGroup) Insert(entity any) (map[string]any, error)

func (*PagedbGroup) InsertEntity 

func (self *PagedbGroup) InsertEntity(entity baseiface.IbaseProxy) (any, error)

func (*PagedbGroup) InsertMap 

func (self *PagedbGroup) InsertMap(record map[string]any) (map[string]any, error)

func (*PagedbGroup) Save 

func (self *PagedbGroup) Save(entity any, pk string, v any) (any, error)

no primary key will insert

func (*PagedbGroup) SetField 

func (self *PagedbGroup) SetField(entity any, key *metadata.MetadataGoField, value any) error

func (*PagedbGroup) Update 

func (self *PagedbGroup) Update(entity any, pkeyValue any) (any, error)

func (*PagedbGroup) UpdateEntity 

func (self *PagedbGroup) UpdateEntity(entity baseiface.IbaseProxy, pkeyValue any) (any, error)

func (*PagedbGroup) UpdateMap 

func (self *PagedbGroup) UpdateMap(record map[string]any, pkeyValue any) (any, error)

func (*PagedbGroup) UpdateNotNull 

func (self *PagedbGroup) UpdateNotNull(maps map[string]any, pkeyValue any) (any, error)

type PagedbRequest 

type PagedbRequest struct {
	page.PageRequest

	//表名
	TableName string `json:"table_name"`
	//字段列表，分隔
	FieldsName string `json:"fields_name"`
	//返回日期转为int64
	TimeToInt  bool `json:"time_to_int"`
	Camel2Case bool `json:"-"`

	SubTable  *SubTableDto `json:"sub_table,omitempty"`
	JoinTable *SubTableDto `json:"join_table,omitempty"`
	// contains filtered or unexported fields
}

通用表查询请求数据

func Default 

func Default() *PagedbRequest

func DefaultCockdb 

func DefaultCockdb() *PagedbRequest

func DefaultMysql 

func DefaultMysql() *PagedbRequest

func NewPageDbRequest 

func NewPageDbRequest(pageSize int) *PagedbRequest

func (*PagedbRequest) Clear 

func (self *PagedbRequest) Clear() *PagedbRequest

func (*PagedbRequest) CreateDbTableStru 

func (self *PagedbRequest) CreateDbTableStru(meta *metadata.MetadataTable) reflect.Value

func (*PagedbRequest) CreateDynacStru 

func (self *PagedbRequest) CreateDynacStru() reflect.Value

func (*PagedbRequest) CreateStatStru 

func (self *PagedbRequest) CreateStatStru(groupFields string) any

func (*PagedbRequest) DefaultTableFields 

func (self *PagedbRequest) DefaultTableFields() *PagedbRequest

func (*PagedbRequest) FieldNames2SnakeCase 

func (self *PagedbRequest) FieldNames2SnakeCase()

func (*PagedbRequest) FindRecords 

func (self *PagedbRequest) FindRecords(result *page.PageResult) *page.PageResult

func (*PagedbRequest) FindScanTable 

func (self *PagedbRequest) FindScanTable() *gorm.DB

func (*PagedbRequest) FindTable 

func (self *PagedbRequest) FindTable() *gorm.DB

func (*PagedbRequest) GeneralQuery 

func (self *PagedbRequest) GeneralQuery() *page.PageResult

func (*PagedbRequest) GeneralQueryDto 

func (self *PagedbRequest) GeneralQueryDto() *page.PageResult

func (*PagedbRequest) GeneralRows 

func (self *PagedbRequest) GeneralRows() *page.PageResult

func (*PagedbRequest) GeneralScanTable 

func (self *PagedbRequest) GeneralScanTable() *page.PageResult

func (*PagedbRequest) GeneralTakeTable 

func (self *PagedbRequest) GeneralTakeTable() *page.PageResult

func (*PagedbRequest) GroupStat 

func (self *PagedbRequest) GroupStat(groupFields, statfield string) ([]map[string]any, error)

func (*PagedbRequest) IfExistField 

func (self *PagedbRequest) IfExistField(field string) bool

func (*PagedbRequest) IfSubTable 

func (self *PagedbRequest) IfSubTable() bool

func (*PagedbRequest) InitFields 

func (self *PagedbRequest) InitFields() *page.PageResult

func (*PagedbRequest) InitPage 

func (self *PagedbRequest) InitPage()

func (*PagedbRequest) MetadataQuery 

func (self *PagedbRequest) MetadataQuery() *basedto.IchubResult

func (*PagedbRequest) MetadataQuery2PageResult 

func (self *PagedbRequest) MetadataQuery2PageResult() *page.PageResult

func (*PagedbRequest) NewSubTable 

func (self *PagedbRequest) NewSubTable() *PagedbRequest

func (*PagedbRequest) QuerySubTable 

func (self *PagedbRequest) QuerySubTable(records []map[string]interface{})

func (*PagedbRequest) ScanTable 

func (self *PagedbRequest) ScanTable(dbentity any) (any, error)

func (*PagedbRequest) SetFieldsName 

func (self *PagedbRequest) SetFieldsName(fieldsName string) *PagedbRequest

func (*PagedbRequest) SetPageSize 

func (self *PagedbRequest) SetPageSize(pagesize int) *PagedbRequest

func (*PagedbRequest) SetTableName 

func (self *PagedbRequest) SetTableName(tablename string) *PagedbRequest

func (*PagedbRequest) Stat 

func (self *PagedbRequest) Stat(statfield string) (map[string]any, error)

func (*PagedbRequest) ValueOfPageRequest 

func (self *PagedbRequest) ValueOfPageRequest(that *PagedbRequest) *PagedbRequest

func (*PagedbRequest) WriteDaoFile 

func (self *PagedbRequest) WriteDaoFile() error

type SubTableDto 

type SubTableDto struct {
	basedto.BaseEntity

	TableName  string            `json:"table_name"`
	FieldsName string            `json:"fields_name"`
	PageSize   int               `json:"page_size"`
	JoinKeys   map[string]string `json:"join_keys"`
}

func FindBeanSubTableDto 

func FindBeanSubTableDto() *SubTableDto

func NewSubTableDto 

func NewSubTableDto() *SubTableDto

Source Files

View all Source files

Directories

Path Synopsis

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.