mysql

Documentation

Index

• func CreateTable(db *sql.DB, tableName string) error
• func DeleteByID(db *sql.DB, tableName string, shopId int) error
• func InsertShop(db *sql.DB, tableName, shopName, address, cover, article string, like bool) (int, error)
• type Shop
  • func InfoByID(db *sql.DB, tableName string, shopId uint64) (*Shop, error)
  • func ListShop(db *sql.DB, tableName string) ([]*Shop, error)

Functions

func CreateTable

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

CreateTable -

func DeleteByID

func DeleteByID(db *sql.DB, tableName string, shopId int) error

DeleteByID delete by id

func InsertShop

func InsertShop(db *sql.DB, tableName, shopName, address, cover, article string, like bool) (int, error)

InsertShop return id

Types

type Shop

type Shop struct {
	ShopID   uint64
	ShopName string
	Address  string
	Cover    string
	Article  string
	Like     bool
}

func InfoByID

func InfoByID(db *sql.DB, tableName string, shopId uint64) (*Shop, error)

InfoByID query by id

func ListShop

func ListShop(db *sql.DB, tableName string) ([]*Shop, error)

listShop return shop list