mysql

package
v0.0.0-...-a14fa2b Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Oct 23, 2020 License: MIT Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

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

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL