mysql

Documentation

Index

• func CreateTable(db *sql.DB, tableName string) error
• func DeleteByID(db *sql.DB, tableName string, id uint64) error
• func InsertPet(db *sql.DB, tableName string, adminID uint64, name, category, avatar string, ...) (int, error)
• func ModifyAvatar(db *sql.DB, id uint64, avatar string) error
• func ModifyBirthday(db *sql.DB, id uint64, birthday time.Time) error
• func ModifyCategory(db *sql.DB, id uint64, category string) error
• func ModifyGender(db *sql.DB, id uint64, gender string) error
• func ModifyHobbies(db *sql.DB, id uint64, hobbies string) error
• func ModifyMedicalCurrent(db *sql.DB, id uint64, MedicalCurrent string) error
• func ModifyName(db *sql.DB, id uint64, name string) error
• type Pet
  • func InfoByID(db *sql.DB, tableName string, id uint64) (*Pet, error)
  • func ListPetByAdminID(db *sql.DB, tableName string, adminID uint64) ([]*Pet, error)

Functions

func CreateTable

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

CreateTable -

func DeleteByID

func DeleteByID(db *sql.DB, tableName string, id uint64) error

DeleteByID delete by id

func InsertPet

func InsertPet(db *sql.DB, tableName string, adminID uint64, name, category, avatar string, birthday time.Time, medical_current, hobbies, gender string) (int, error)

InsertPet return id

func ModifyAvatar

func ModifyAvatar(db *sql.DB, id uint64, avatar string) error

func ModifyBirthday

func ModifyBirthday(db *sql.DB, id uint64, birthday time.Time) error

ModifyEmail the administrative user updates email

func ModifyCategory

func ModifyCategory(db *sql.DB, id uint64, category string) error

ModifyEmail the administrative user updates email

func ModifyGender

func ModifyGender(db *sql.DB, id uint64, gender string) error

ModifyEmail the administrative user updates email

func ModifyHobbies

func ModifyHobbies(db *sql.DB, id uint64, hobbies string) error

ModifyEmail the administrative user updates email

func ModifyMedicalCurrent

func ModifyMedicalCurrent(db *sql.DB, id uint64, MedicalCurrent string) error

ModifyEmail the administrative user updates email

func ModifyName

func ModifyName(db *sql.DB, id uint64, name string) error

ModifyEmail the administrative user updates email

Types

type Pet

type Pet struct {
	PetID          uint64
	AdminID        uint64
	Name           string
	Category       string
	Avatar         string
	Birthday       time.Time
	MedicalCurrent string
	Hobbies        string
	Gender         string
}

Pet -

func InfoByID

func InfoByID(db *sql.DB, tableName string, id uint64) (*Pet, error)

InfoByID squery by id

func ListPetByAdminID

func ListPetByAdminID(db *sql.DB, tableName string, adminID uint64) ([]*Pet, error)

ListValidPetByUnixDate return schedule list which have valid date