mysql

Documentation

Index

• func Paginate(page, pageSize int) func(db *gorm.DB) *gorm.DB
• type Admin
  • func (u *Admin) BeforeCreate(_ *gorm.DB) (err error)
• type AdminManager
  • func NewAdminManager(db *gorm.DB, salt string) *AdminManager
  • func (m *AdminManager) GetAdminByAccountId(aid string) (*Admin, error)
  • func (m *AdminManager) GetAdminByName(name string) (*Admin, error)
  • func (m *AdminManager) UpdateAdminPassword(aid string, password string) error
• type User
  • func (u *User) BeforeCreate(_ *gorm.DB) (err error)
• type UserManager
  • func NewUserManager(db *gorm.DB, salt string) *UserManager
  • func (m *UserManager) CreateUser(user *User) (*User, error)
  • func (m *UserManager) DeleteUser(aid string) error
  • func (m *UserManager) GetAllUsers() ([]*User, error)
  • func (m *UserManager) GetSomeUsers() ([]*User, error)
  • func (m *UserManager) GetUserByAccountId(aid string) (*User, error)
  • func (m *UserManager) GetUserByOpenId(openID string) (*User, error)
  • func (m *UserManager) UpdateUser(user *User) error

Functions

func Paginate

func Paginate(page, pageSize int) func(db *gorm.DB) *gorm.DB

Paginate is responsible for pagination.

Types

type Admin

type Admin struct {
	ID       string `gorm:"primarykey"`
	Username string `gorm:"type:varchar(40);uniqueIndex"`
	Password string `gorm:"type:varchar(40)"`
}

func (*Admin) BeforeCreate

func (u *Admin) BeforeCreate(_ *gorm.DB) (err error)

BeforeCreate uses snowflake to generate an ID.

type AdminManager

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

func NewAdminManager

func NewAdminManager(db *gorm.DB, salt string) *AdminManager

NewAdminManager creates a mysql manager.

func (*AdminManager) GetAdminByAccountId

func (m *AdminManager) GetAdminByAccountId(aid string) (*Admin, error)

GetAdminByAccountId get admin by account id.

func (*AdminManager) GetAdminByName

func (m *AdminManager) GetAdminByName(name string) (*Admin, error)

func (*AdminManager) UpdateAdminPassword

func (m *AdminManager) UpdateAdminPassword(aid string, password string) error

UpdateAdminPassword updates admin password.

type User

type User struct {
	ID           string `gorm:"primarykey"`
	PhoneNumber  string
	AvatarBlobId string
	Username     string `gorm:"type:varchar(40)"`
	OpenID       string `gorm:"column:openid;type:varchar(100);uniqueIndex"`
	Balance      int32  `gorm:"column:balance"`
	Deleted      gorm.DeletedAt
}

func (*User) BeforeCreate

func (u *User) BeforeCreate(_ *gorm.DB) (err error)

BeforeCreate uses snowflake to generate an ID.

type UserManager

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

func NewUserManager

func NewUserManager(db *gorm.DB, salt string) *UserManager

NewUserManager creates a mysql manager.

func (*UserManager) CreateUser

func (m *UserManager) CreateUser(user *User) (*User, error)

func (*UserManager) DeleteUser

func (m *UserManager) DeleteUser(aid string) error

func (*UserManager) GetAllUsers

func (m *UserManager) GetAllUsers() ([]*User, error)

func (*UserManager) GetSomeUsers

func (m *UserManager) GetSomeUsers() ([]*User, error)

func (*UserManager) GetUserByAccountId

func (m *UserManager) GetUserByAccountId(aid string) (*User, error)

func (*UserManager) GetUserByOpenId

func (m *UserManager) GetUserByOpenId(openID string) (*User, error)

func (*UserManager) UpdateUser

func (m *UserManager) UpdateUser(user *User) error