1package main
 2
 3import (
 4	"database/sql"
 5	"log"
 6	"net/http"
 7	"os"
 8
 9	_ "github.com/mattn/go-sqlite3"
10)
11
12var visitDB datasource
13
14func main() {
15	visitDB = &prodDB{}
16	os.Remove("./visitr.db")
17	db, err := sql.Open("sqlite3", "./visitr.db")
18	defer db.Close()
19
20	createVisitTable := `
21  create table visit (
22		id text not null primary key, 
23		username text,
24		first text,
25		last string,
26		type int,
27		affiliation text,
28		us_citizen integer,
29		access_type integer,
30		date_of_birth datetime,
31		birth_country text,
32		birth_state text);
33	`
34
35	_, err = db.Exec(createVisitTable)
36	if err != nil {
37		log.Printf("%q: %s\n", err, createVisitTable)
38		return
39	}
40
41	http.ListenAndServe(":8080", VisitrApp())
42}