mysql

Documentation

Index

• Constants
• func CreateAdmin(db *sql.DB, name, password *string) error
• func CreateDatabase(db *sql.DB) error
• func CreateTable(db *sql.DB, name, password *string) error
• func IsActive(db *sql.DB, id uint64) (bool, error)
• func Login(db *sql.DB, name, password *string) (uint32, error)
• func ModifyAdminActive(db *sql.DB, id uint32, active bool) error
• func ModifyEmail(db *sql.DB, id uint32, email *string) error
• func ModifyMobile(db *sql.DB, id uint32, mobile *string) error
• func ModifyPassword(db *sql.DB, id uint32, password, newPassword *string) error

Constants

const (
	DBName    = "admin"
	TableName = "admin"
)

Functions

func CreateAdmin

func CreateAdmin(db *sql.DB, name, password *string) error

CreateAdmin create an administrative user

func CreateDatabase

func CreateDatabase(db *sql.DB) error

CreateDatabase create admin table.

func CreateTable

func CreateTable(db *sql.DB, name, password *string) error

CreateTable create admin table.

func IsActive

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

IsActive return user.Active and nil if query success.

func Login

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

Login the administrative user logins

func ModifyAdminActive

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

ModifyAdminActive the administrative user updates active

func ModifyEmail

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

ModifyEmail the administrative user updates email

func ModifyMobile

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

ModifyMobile the administrative user updates mobile

func ModifyPassword

func ModifyPassword(db *sql.DB, id uint32, password, newPassword *string) error

ModifyPassword the administrative user updates password