database

type Connection struct {
	Database *sql.DB   // database struct
	Conn     *sql.Conn // connection struct
}

type DBWrapper interface {
	// MakeSchema initializes a schema
	MakeSchema() (sql.Result, error)

	// EnterData enters data into the database without returning any rows
	EnterData(cmd string) (sql.Result, error)

	// AddIntRecord makes a single integer entry into the database for a given tag
	AddIntRecord(tag, value int) (sql.Result, error)

	// AddFloatRecord makes a single float entry into the database for a given tag
	AddFloatRecord(tag int, value float64) (sql.Result, error)

	// Tally runs sql command to count database entries for a given topic
	Tally(tag int) int

	// GetLastRecord gets the last record for a given tag
	GetLastRecord(tag int) int

	// GetSingleInt returns the first result of any SQL query that gives at least one integer result
	// simple function for confirming correct value was entered for, say, temperature
	GetSingleInt(query string) int
}

type Sqlite struct {
	File     *os.File // name of the .db file
	FullPath string   // full POSIX path
	Driver   string   // sqlite driver
}