ArrayToMap 数组转映射.

Column extract column from table * First Argument:table * Second Argument:column name result := query.Column(users, "UserID") userIDs := result.([]int).

ColumnMacroRegister 注册.

ColumnMap generate a map from table,key is column value and value is it's row * First Argument:table * Second Argument:column name result = query.ColumnMap(users, "UserID") userMap := result.(map[int]User).

ColumnMapMacroRegister 注册.

Combine combine data from two table , one by one * First Argument:left table * Second Argument:right table * Third Argument:combine rule result = query.Combine(admins, users, func(admin Admin, user User) AdminUser { return AdminUser{ AdminID: admin.AdminID, Level: admin.Level, Name: user.Name, CreateTime: user.CreateTime, } }) combine := result.([]AdminUser).

CombineMacroRegister 注册.

Distinct unique by column result := query.Distinct([]User{}, "Name") dis := result.([]User{}).

Group group data from table * First Argument: left table * Second Argument: group column name * Third Argument: group rule result = query.Group(users, "UserID", func(users []User) Department { return Department{ Employees: users, } }) group := result.([]Department).

GroupMacroRegister 注册.

InnerJoin see LeftJoin.

Join see LeftJoin.

JoinMacroRegister 注册.

LeftJoin join data from two table，support LeftJoin,RightJoin,InnerJoin和OuterJoin * First Argument: left table * Second Argument: right table * Third Argument: join condition * Forth Argument: join rule result = query.LeftJoin(admins, users, "AdminID = UserID", func(admin Admin, user User) AdminUser { return AdminUser{ AdminID: admin.AdminID, Level: admin.Level, Name: user.Name, CreateTime: user.CreateTime, } }) join := result.([]AdminUser).

MapToArray 映射转数组.

Max get max value from table.

Min get min value from table.

OuterJoin see LeftJoin.

Reduce reduce from list to single query.Reduce([]User{}, func(sum int, singleData User) int { return 1 }, 0).

ReflectWarning 警告.

Reverse reverse data in table query.Reverse( []User{}, ).

RightJoin see LeftJoin.

Select select data from table * First Argument:table * Second Argument:select rule result = query.Select(users, func(a User) Sex { if len(a.Name) >= 3 && a.Name[0:3] == "Man" { return Sex{IsMale: true} } return Sex{IsMale: false} }) sel := result.([]Sex).

SelectMacroRegister 注册器.

Sort sort data from table,support multiple column,for Example: UserID desc,Age asc * First Argument:table * Second Argument:sort condition result = query.Sort(users, "UserID asc") sort := result.([]User).

SortInternal 排序.

SortMacroRegister 注册.

Sum get the sum of data.

Where filter data from table * First Argument:table * Second Argument:filter rule result = query.Where(users, func(a User) bool { if len(a.Name) >= 3 && a.Name[0:3] == "Man" { return true } return false }) where := result.([]User).

WhereMacroRegister 注册器.

ColumnMacroHandler 扩展类函数 QueryColumn.

ColumnMapMacroHandler 扩展类函数 QueryColumnMap.

CombineMacroHandler 扩展累函数 QueryCombine.

GroupMacroHandler 基础类函数 QueryGroup.

JoinMacroHandler 基础类函数QueryJoin.

SelectMacroHandler 基础类函数QuerySelect.

SortMacroHandler 处理器.

WhereMacroHandler 基础类函数QueryWhere.