mysql

Documentation

Index

• func CreateDatabase(db *sql.DB) error
• func CreateTable(db *sql.DB) error
• type AdminserviceProvider
  • func (*AdminserviceProvider) Create(db *sql.DB, name, pwd, realName, mobile, email *string) error
  • func (*AdminserviceProvider) IsActive(db *sql.DB, id uint32) (bool, error)
  • func (*AdminserviceProvider) Login(db *sql.DB, name, pwd *string) (uint32, error)
  • func (*AdminserviceProvider) ModifyActive(db *sql.DB, id uint32, active bool) error
  • func (*AdminserviceProvider) ModifyEmail(db *sql.DB, id uint32, email *string) error
  • func (*AdminserviceProvider) ModifyMobile(db *sql.DB, id uint32, mobile *string) error
  • func (*AdminserviceProvider) ModifyPwd(db *sql.DB, id uint32, pwd, newPwd *string) error

Functions

func CreateDatabase

func CreateDatabase(db *sql.DB) error

CreateDatabase create database admin.

func CreateTable

func CreateTable(db *sql.DB) error

CreateTable create admin.user table.

Types

type AdminserviceProvider

type AdminserviceProvider struct{}

var (
	AdminServer *AdminserviceProvider

	ErrNoRows = errors.New("there is no such data in database")
)

func (*AdminserviceProvider) Create

func (*AdminserviceProvider) Create(db *sql.DB, name, pwd, realName, mobile, email *string) error

CreateAdmin create a new user account.

func (*AdminserviceProvider) IsActive

func (*AdminserviceProvider) IsActive(db *sql.DB, id uint32) (bool, error)

IsActive return user.Active and nil if query success.

func (*AdminserviceProvider) Login

func (*AdminserviceProvider) Login(db *sql.DB, name, pwd *string) (uint32, error)

Login return user id and nil if login success.

func (*AdminserviceProvider) ModifyActive

func (*AdminserviceProvider) ModifyActive(db *sql.DB, id uint32, active bool) error

func (*AdminserviceProvider) ModifyEmail

func (*AdminserviceProvider) ModifyEmail(db *sql.DB, id uint32, email *string) error

AddEmail modify user email.

func (*AdminserviceProvider) ModifyMobile

func (*AdminserviceProvider) ModifyMobile(db *sql.DB, id uint32, mobile *string) error

AddMobile modify user mobile.

func (*AdminserviceProvider) ModifyPwd

func (*AdminserviceProvider) ModifyPwd(db *sql.DB, id uint32, pwd, newPwd *string) error

ModifyPwd modify user password.