SQL1999

Documentation

Index

• func CompareExecResults(t *testing.T, svDB *sql.DB, slDB *sql.DB, query string, testName string)
• func CompareQueryResults(t *testing.T, svDB *sql.DB, slDB *sql.DB, query string, testName string)
• func FetchAllRowsSQLite(rows *sql.Rows) ([]map[string]interface{}, error)
• type QueryResult
  • func QueryRows(t *testing.T, db *sql.DB, query string, args ...interface{}) *QueryResult
  • func QuerySqlvibeOnly(t *testing.T, db *sql.DB, query string, testName string) *QueryResult

Functions

func CompareExecResults

func CompareExecResults(t *testing.T, svDB *sql.DB, slDB *sql.DB, query string, testName string)

CompareExecResults executes a statement against both databases and checks that they both succeed or both fail.

func CompareQueryResults

func CompareQueryResults(t *testing.T, svDB *sql.DB, slDB *sql.DB, query string, testName string)

CompareQueryResults executes query against both databases and compares results.

func FetchAllRowsSQLite

func FetchAllRowsSQLite(rows *sql.Rows) ([]map[string]interface{}, error)

FetchAllRowsSQLite fetches all rows from a SQLite *sql.Rows into a map slice.

Types

type QueryResult

type QueryResult struct {
	// Columns holds the column names returned by the query.
	Columns []string
	// Data holds the row data; each element is a slice of column values.
	Data [][]interface{}
}

QueryResult holds the result of a SQL query executed via the driver interface. It mirrors the field names of sqlvibe.Rows so that existing test code that accesses .Data and .Columns keeps working after the driver/ migration.

func QueryRows

func QueryRows(t *testing.T, db *sql.DB, query string, args ...interface{}) *QueryResult

QueryRows executes query against db and returns all rows as a *QueryResult.

func QuerySqlvibeOnly

func QuerySqlvibeOnly(t *testing.T, db *sql.DB, query string, testName string) *QueryResult

QuerySqlvibeOnly executes a query only on sqlvibe and validates it succeeds. Returns a *QueryResult whose .Data and .Columns fields can be read directly.