app

const (
	SQL_ERR_NO_ROWS  = `sql: no rows in result set`
	DATE_LAYOUT      = `2006-01-02`
	DATE_TIME_LAYOUT = `2006-01-02 15:04:05 MST`
	START_YEAR       = 2003
	START_MONTH      = time.November

	// SQL queries {{{
	Q_HITS = `` /* 450-byte string literal not displayed */

	Q_BINGOS = `` /* 196-byte string literal not displayed */

	Q_ADJACENT_COUNTIES = `` /* 245-byte string literal not displayed */

	Q_LAST_50_HIT_IDS = `select id from hits order by entdate desc, id desc limit 50`

	Q_LAST_50_DENOM_SERIES = `
		select
			b.%s,
			count(1)
		from
			bills b,
			hits h
		where
			b.id=h.bill_id and h.id in
				(` + Q_LAST_50_HIT_IDS + `)
		group by
			b.%s
		order by
			b.%s
	`

	Q_LAST_50_STATES = `
		select cm.state, count(1)
		from hits h, counties_master cm
		where h.id in (` + Q_LAST_50_HIT_IDS + `) and cm.id = h.county_id and country = 'US'
		group by cm.state
		union
		  select state, count(1)
		  from hits
		  where id in (` + Q_LAST_50_HIT_IDS + `) and country = 'Canada'
		  group by state
		  union
		    select country, count(1)
		    from hits
		    where id in (` + Q_LAST_50_HIT_IDS + `) and country not in ('US', 'Canada')
		    group by country
		order by count desc, state asc
	`

	Q_LAST_50_COUNTIES = `
		select cm.state, cm.county, count(1)
		from hits h, counties_master cm
		where h.id in (` + Q_LAST_50_HIT_IDS + `) and cm.id = h.county_id and country = 'US'
		group by cm.state, cm.county
		union
		  select state, city, count(1)
		  from hits
		  where id in (` + Q_LAST_50_HIT_IDS + `) and country = 'Canada'
		  group by state, city
		  union
		    select country, city, count(1)
		    from hits
		    where id in (` + Q_LAST_50_HIT_IDS + `) and country not in ('US', 'Canada')
		    group by country, city
		order by count desc, state asc, county asc
	`

	Q_HITS_CALENDAR = `
		select
			substr(entdate::text, 6) as date,
			count(1)
		from
			hits
		group by
			date
	`

	SERIAL_RE_BASE = `[A-L][0-9\-]{8}[A-NP-Y\*]$`
)