mysql

package

v0.0.0-...-097943f Latest Latest Go to latest Published: Mar 28, 2021 License: MIT Imports: 4 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

This section is empty.

This section is empty.

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

CreateTable -

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

DeleteByID delete by id

func InsertBanner(db *sql.DB, tableName string, name string, imagePath string, eventPath string, startDate time.Time, endDate time.Time) (int, error)

InsertBanner return id

type Banner struct {
	BannerID  int
	Name      string
	ImagePath string
	EventPath string
	StartDate string
	EndDate   string
}

Banner -

func InfoByID(db *sql.DB, tableName string, id int) (*Banner, error)

InfoByID squery by id

func LisitValidBannerByUnixDate(db *sql.DB, tableName string, unixtime int64) ([]*Banner, error)

LisitValidBannerByUnixDate return banner list which have valid date