sql

Documentation

Index

• func CreateTable(client *sql.DB) error
• func DropTable(client *sql.DB) error
• func NewData(record []string)
• func UploadDataToDatabase(client *sql.DB, filePath string, locations map[string]Location) error
• func UploadToSQL(client *sql.DB)
• type Data
• type Location

Functions

func CreateTable

func CreateTable(client *sql.DB) error

func DropTable

func DropTable(client *sql.DB) error

func NewData

func NewData(record []string)

func UploadDataToDatabase

func UploadDataToDatabase(client *sql.DB, filePath string, locations map[string]Location) error

func UploadToSQL

func UploadToSQL(client *sql.DB)

Types

type Data

type Data struct {
	UID         int
	Name        string
	Day         int8
	StartTime   int8
	EndTime     int8
	CourtName   string
	Address     string
	FromLevel   int8
	ToLevel     int8
	CourtCount  int8
	FeeM        int16
	FeeF        int16
	MinBallType int8
	Note        string
}

type Location

type Location struct {
	Lon float64
	Lat float64
}