dbuser

Documentation

Overview

Code generated by gdbx_cache. DO NOT EDIT. gdbx version: 0.1.0 beta source: user_cache.gdb.cah

Code generated by gdbx_sql. DO NOT EDIT. gdbx version: 0.1.0 beta source: user_mysql.gdb.sql

Index

• func AddUser(db sqlutil.IDB, o *User) (sql.Result, error)
• func AddUserBatch(db sqlutil.IDB, os []*User) (sql.Result, error)
• func AddUserDetail(db sqlutil.IDB, o *UserDetail) (sql.Result, error)
• func AddUserDetailBatch(db sqlutil.IDB, os []*UserDetail) (sql.Result, error)
• func RemoveUser(db sqlutil.IDB, o *User) (sql.Result, error)
• func RemoveUserDetail(db sqlutil.IDB, o *UserDetail) (sql.Result, error)
• func UpdateUser(db sqlutil.IDB, o *User) (sql.Result, error)
• func UpdateUserDetail(db sqlutil.IDB, o *UserDetail) (sql.Result, error)
• func UpsertUser(db sqlutil.IDB, o *User) (sql.Result, error)
• func UpsertUserDetail(db sqlutil.IDB, o *UserDetail) (sql.Result, error)
• type User
  • func FindUserById(db sqlutil.IDB, id interface{}) (o *User, err error)
  • func (o *User) Save(db sqlutil.IDB) (sql.Result, error)
• type UserCache
  • func NewUserCache(cfg cache.Config) *UserCache
  • func (c *UserCache) Get(key cache.Key) (*UserQuery, error)
  • func (c *UserCache) Update(key cache.Key, oper interface{}) (*UserQuery, error)
• type UserDetail
  • func FindUserDetailById(db sqlutil.IDB, id interface{}) (o *UserDetail, err error)
  • func (o *UserDetail) Save(db sqlutil.IDB) (sql.Result, error)
• type UserQuery

Functions

func AddUser

func AddUser(db sqlutil.IDB, o *User) (sql.Result, error)

AddUser exec insert-one on table user

func AddUserBatch

func AddUserBatch(db sqlutil.IDB, os []*User) (sql.Result, error)

AddUserBatch exec insert-batch on table user

func AddUserDetail

func AddUserDetail(db sqlutil.IDB, o *UserDetail) (sql.Result, error)

AddUserDetail exec insert-one on table user_detail

func AddUserDetailBatch

func AddUserDetailBatch(db sqlutil.IDB, os []*UserDetail) (sql.Result, error)

AddUserDetailBatch exec insert-batch on table user_detail

func RemoveUser

func RemoveUser(db sqlutil.IDB, o *User) (sql.Result, error)

RemoveUser exec delete-by-id on table user

func RemoveUserDetail

func RemoveUserDetail(db sqlutil.IDB, o *UserDetail) (sql.Result, error)

RemoveUserDetail exec delete-by-id on table user_detail

func UpdateUser

func UpdateUser(db sqlutil.IDB, o *User) (sql.Result, error)

UpdateUser exec update-by-id on table user

func UpdateUserDetail

func UpdateUserDetail(db sqlutil.IDB, o *UserDetail) (sql.Result, error)

UpdateUserDetail exec update-by-id on table user_detail

func UpsertUser

func UpsertUser(db sqlutil.IDB, o *User) (sql.Result, error)

UpsertUser exec upsert-by-id on table user

func UpsertUserDetail

func UpsertUserDetail(db sqlutil.IDB, o *UserDetail) (sql.Result, error)

UpsertUserDetail exec upsert-by-id on table user_detail

Types

type User

type User struct {
	// 用户id
	Id sqlutil.SetI64 `table:"user" field:"id" id:"true"`
	// 用户名
	Name sqlutil.SetString `table:"user" field:"name"`
	// 用户邮箱
	Email sqlutil.SetString `table:"user" field:"email"`
	// 用户电话
	Phone sqlutil.SetString `table:"user" field:"phone"`
	// 用户年龄
	Age sqlutil.SetI32 `table:"user" field:"age"`
	// 创建时间
	CreateTime sqlutil.SetTime `table:"user" field:"create_time"`
	// 用户密码
	Password sqlutil.SetString `table:"user" field:"password"`
	// 是否是管理员 0-不是  1-是
	IsAdmin sqlutil.SetBool `table:"user" field:"is_admin"`
	//
	IsDelete sqlutil.SetI32 `table:"user" field:"is_delete"`
}

User

func FindUserById

func FindUserById(db sqlutil.IDB, id interface{}) (o *User, err error)

FindUserById exec find-by-id for table user

func (*User) Save

func (o *User) Save(db sqlutil.IDB) (sql.Result, error)

type UserCache

type UserCache struct {
	// contains filtered or unexported fields
}

func NewUserCache

func NewUserCache(cfg cache.Config) *UserCache

func (*UserCache) Get

func (c *UserCache) Get(key cache.Key) (*UserQuery, error)

func (*UserCache) Update

func (c *UserCache) Update(key cache.Key, oper interface{}) (*UserQuery, error)

type UserDetail

type UserDetail struct {
	// 用户id
	UserId sqlutil.SetI64 `table:"user_detail" field:"user_id" id:"true"`
	// 用户得分
	Score sqlutil.SetI32 `table:"user_detail" field:"score"`
	// 用户余额
	Balance sqlutil.SetI32 `table:"user_detail" field:"balance"`
	// 用户详细文本描述
	Text sqlutil.SetString `table:"user_detail" field:"text"`
}

UserDetail

func FindUserDetailById

func FindUserDetailById(db sqlutil.IDB, id interface{}) (o *UserDetail, err error)

FindUserDetailById exec find-by-id for table user_detail

func (*UserDetail) Save

func (o *UserDetail) Save(db sqlutil.IDB) (sql.Result, error)

type UserQuery

type UserQuery struct {
	//
	User *User `table:"user"`
	//
	Detail *UserDetail `table:"user_detail"`
}

UserQuery auto-return struct generated by searchUser