db

package

v1.0.3 Latest Latest Go to latest Published: Jan 22, 2020 License: MIT Imports: 12 Imported by: 2

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 Scrape() <-chan lotto.Result

Scrape archive for data

type AppDB struct {
	*sql.DB
}

AppDB is a wrapper for *sql.DB so I can extend it by adding my own methods

func Connect(path string) *AppDB

Connect returns a DB connection wrapper

func (db *AppDB) DataRange() (time.Time, time.Time, error)

DataRange retrieves the first and last record dates

func (db *AppDB) Exists(t time.Time) bool

Exists returns true if a record with t timestamp exists

func (db *AppDB) LastDraw() (lotto.Result, error)

LastDraw retrieves the most recent set of results

func (db *AppDB) MachineSetFreq(begin time.Time, end time.Time) ([]MacSetFreq, error)

MachineSetFreq returns date constrained set displaying which combinations of machine/set have been drawn and how many times

func (db *AppDB) Machines(begin time.Time, end time.Time, sets []int) ([]string, error)

Machines returns the distinct machine names constrained by date and sets

func (db *AppDB) Result(t time.Time) (lotto.Result, error)

Result retrieves a single record

func (db *AppDB) Results(begin, end time.Time, machines []string, sets []int, orderDesc bool) <-chan lotto.Result

Results returns a channel of records

func (db *AppDB) Sets(begin time.Time, end time.Time, machines []string) ([]int, error)

Sets returns the distinct sets constrained by date and machines

func (db *AppDB) Update() error

Update scrapes the archive site and adds newer records until an existing record is found.

type MacSetFreq struct {
	Machine string
	Set     int
	Freq    int
}

MacSetFreq provides a struct for recording the frequency of a machine/set combination in draws