util

Documentation

Index

• Constants
• func CountyHasHits(id int) (bool, error)
• func DbSanitize(input string) string
• func GetAdjacentWithHits(state, county string) ([]string, error)
• func GetCounties(state string) ([]app.Region, error)
• func GetCountyById(id int) (app.USCounty, error)
• func GetCurrentResidence() (string, error)
• func GetFRBFromSerial(serial string) string
• func GetFirstHits(regionType string) ([]app.Hit, error)
• func GetHits(whereGroupOrder string) ([]app.Hit, error)
• func GetHomeRegion(regionColumn string) string
• func GetPrefs() ([]app.UserPrefs, error)
• func GetResidences() ([]string, error)
• func GetSerialSeries(serial_in, series_in string, denom int) (string, string, error)
• func GetStateCountyCityFromZIP(zip string) (string, string, string, error)
• func GetStates(country string) ([]string, error)
• func GetTZList() ([]app.TZRec, error)
• func PrepMonthEnts() (*sql.Stmt, error)
• func SetTimeZone(tz_in string) error
• func StatsData(returnType string) interface{}

Constants

const (
	Q_REGIONS = `
		select distinct
			%s %s
		from
			%s
		order by
			%s
	`

	Q_HOME_REGION = `
		select
			%s
		from
			counties_master cm,
			residences r
		where
			r.label = '_all' and
			r.home = cm.id
	`

	Q_RESLIST = `
		select
			label
		from
			residences
		where
			label <> '_all'
		order by
			label
	`

	Q_CURRENT_RESIDENCE = `` /* 145-byte string literal not displayed */

	DATE_LIST_LAYOUT  = `2006-01-02`
	STATS_START_YEAR  = 2003
	STATS_START_MONTH = time.November
)

Functions

func CountyHasHits

func CountyHasHits(id int) (bool, error)

func DbSanitize

func DbSanitize(input string) string

func GetAdjacentWithHits

func GetAdjacentWithHits(state, county string) ([]string, error)

func GetCounties

func GetCounties(state string) ([]app.Region, error)

func GetCountyById

func GetCountyById(id int) (app.USCounty, error)

func GetCurrentResidence

func GetCurrentResidence() (string, error)

func GetFRBFromSerial

func GetFRBFromSerial(serial string) string

func GetFirstHits

func GetFirstHits(regionType string) ([]app.Hit, error)

func GetHits

func GetHits(whereGroupOrder string) ([]app.Hit, error)

func GetHomeRegion

func GetHomeRegion(regionColumn string) string

func GetPrefs

func GetPrefs() ([]app.UserPrefs, error)

func GetResidences

func GetResidences() ([]string, error)

func GetSerialSeries

func GetSerialSeries(serial_in, series_in string, denom int) (string, string, error)

func GetStateCountyCityFromZIP

func GetStateCountyCityFromZIP(zip string) (string, string, string, error)

func GetStates

func GetStates(country string) ([]string, error)

func GetTZList

func GetTZList() ([]app.TZRec, error)

func PrepMonthEnts

func PrepMonthEnts() (*sql.Stmt, error)

func SetTimeZone

func SetTimeZone(tz_in string) error

func StatsData

func StatsData(returnType string) interface{}