query

Documentation

Overview

Package query implements helpers around database/sql to execute various kinds of very common SQL queries.

Index

• func SelectIntegers(tx *sql.Tx, query string) ([]int, error)
• func SelectStrings(tx *sql.Tx, query string) ([]string, error)
• func Transaction(db *sql.DB, f func(*sql.Tx) error) error

Functions

func SelectIntegers

func SelectIntegers(tx *sql.Tx, query string) ([]int, error)

SelectIntegers executes a statement which must yield rows with a single integer column. It returns the list of column values.

func SelectStrings

func SelectStrings(tx *sql.Tx, query string) ([]string, error)

SelectStrings executes a statement which must yield rows with a single string column. It returns the list of column values.

func Transaction

func Transaction(db *sql.DB, f func(*sql.Tx) error) error

Transaction executes the given function within a database transaction.