mapper

Documentation

Index

• type UserMapper
  • func NewUserMapper(db *sql.DB) *UserMapper
  • func (userMapper *UserMapper) CheckUserUsernameExist(username string) (bool, error)
  • func (userMapper *UserMapper) QueryUserById(id int64) (user *model.User, err error)
  • func (userMapper *UserMapper) QueryUserByUsername(username string) (user *model.User, err error)
  • func (userMapper *UserMapper) SaveUser(user *model.User) (int64, error)
  • func (userMapper *UserMapper) UpdateUserProfilePictureById(id int64, profilePicture string) error
  • func (userMapper *UserMapper) UpdateUserUsernameById(id int64, username string) error

Types

type UserMapper

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

UserMapper 用户数据库操作

func NewUserMapper

func NewUserMapper(db *sql.DB) *UserMapper

NewUserMapper 创建 UserMapper

func (*UserMapper) CheckUserUsernameExist

func (userMapper *UserMapper) CheckUserUsernameExist(username string) (bool, error)

CheckUserUsernameExist 检查用户名是否已存在 MySQL比较字符串在大小写敏感的情况下，必须转binary 在binary下，查询username无法走index_username 为了保证性能，用户名的大小写不敏感

func (*UserMapper) QueryUserById

func (userMapper *UserMapper) QueryUserById(id int64) (user *model.User, err error)

QueryUserById 根据id查询用户信息

func (*UserMapper) QueryUserByUsername

func (userMapper *UserMapper) QueryUserByUsername(username string) (user *model.User, err error)

QueryUserByUsername 根据username查询用户信息

func (*UserMapper) SaveUser

func (userMapper *UserMapper) SaveUser(user *model.User) (int64, error)

SaveUser 保存用户信息

func (*UserMapper) UpdateUserProfilePictureById

func (userMapper *UserMapper) UpdateUserProfilePictureById(id int64, profilePicture string) error

UpdateUserProfilePictureById 根据id更新用户头像

func (*UserMapper) UpdateUserUsernameById

func (userMapper *UserMapper) UpdateUserUsernameById(id int64, username string) error

UpdateUserUsernameById 根据id更新用户名