Go SQL Queries

datastore.go

package datastore

import (
	"database/sql"
)

const (
	createUser = `
INSERT INTO users (name, email)
VALUES(?,
       ?)`

	findUser = `
SELECT id,
       name,
       email
FROM users
WHERE email = ? LIMIT 1`
)

var stmts = struct {
	createUser *sql.Stmt
	findUser   *sql.Stmt
}{}

var stmtSql = map[**sql.Stmt]string{
	&stmts.createUser: createUser,
	&stmts.findUser:   findUser,
}

// initQueries loops through all of the statements and prepares them to make sure they're valid.
func initQueries(db *sql.DB) error {
	var err error
	for stmt, sql := range stmtSql {
		*stmt, err = db.Prepare(sql)
		if err != nil {
			return err
		}
	}
	return nil
}