sqlassert

README

sqlassert

Go package with assertion helpers for SQL databases

Use sqlassert in your integration tests or write assertions for schema changes and migraton scripts.

Usage

go get github.com/pengux/sqlassert

Example:

package migration_test

import (
	"testing"

	"github.com/pengux/sqlassert"
)

func TestMigration(t *testing.T) {
	...
	// db is *sql.DB
	pgassert := sqlassert.NewPostgresAsserter(db)

	table := "table_name"
	column := "column_name"
	index := "index_name"
	constraint := "constraint_name"
	id := "123"

	pgassert.TableExists(t, table)
	pgassert.ColumnExists(t, table, column)
	pgassert.ConstraintExists(t, table, column, constraint)
	pgassert.RowExists(t, table, map[string]interface{}{
		"id": id,
	})
	pgassert.IndexExists(t, table, index)
}

Supported databases

• Postgresql
• Mysql
• SQLite
• Microsoft SQL Server
• Oracle

Documentation

Index

• type MysqlAsserter
  • func NewMysqlAsserter(db *sql.DB) *MysqlAsserter
  • func (pa *MysqlAsserter) ColumnExists(t testingT, table, column string) bool
  • func (pa *MysqlAsserter) ColumnNotExists(t testingT, table, column string) bool
  • func (pa *MysqlAsserter) ColumnOfType(t testingT, table, column, dataType string) bool
  • func (pa *MysqlAsserter) ConstraintExists(t testingT, table, constraint string) bool
  • func (pa *MysqlAsserter) ConstraintNotExists(t testingT, table, constraint string) bool
  • func (pa *MysqlAsserter) IndexExists(t testingT, table, index string) bool
  • func (pa *MysqlAsserter) IndexNotExists(t testingT, table, index string) bool
  • func (pa *MysqlAsserter) RowExists(t testingT, table string, colVals map[string]interface{}) bool
  • func (pa *MysqlAsserter) RowNotExists(t testingT, table string, colVals map[string]interface{}) bool
  • func (pa *MysqlAsserter) TableExists(t testingT, table string) bool
  • func (pa *MysqlAsserter) TableNotExists(t testingT, table string) bool
• type PostgresAsserter
  • func NewPostgresAsserter(db *sql.DB) *PostgresAsserter
  • func (pa *PostgresAsserter) ColumnExists(t testingT, table, column string) bool
  • func (pa *PostgresAsserter) ColumnNotExists(t testingT, table, column string) bool
  • func (pa *PostgresAsserter) ColumnOfType(t testingT, table, column, dataType string) bool
  • func (pa *PostgresAsserter) ConstraintExists(t testingT, table, constraint string) bool
  • func (pa *PostgresAsserter) ConstraintNotExists(t testingT, table, constraint string) bool
  • func (pa *PostgresAsserter) IndexExists(t testingT, table, index string) bool
  • func (pa *PostgresAsserter) IndexNotExists(t testingT, table, index string) bool
  • func (pa *PostgresAsserter) RowExists(t testingT, table string, colVals map[string]interface{}) bool
  • func (pa *PostgresAsserter) RowNotExists(t testingT, table string, colVals map[string]interface{}) bool
  • func (pa *PostgresAsserter) TableExists(t testingT, table string) bool
  • func (pa *PostgresAsserter) TableNotExists(t testingT, table string) bool

Types

type MysqlAsserter

type MysqlAsserter struct {
	// contains filtered or unexported fields
}

MysqlAsserter contains assertion helpers for mysqlql databases

func NewMysqlAsserter

func NewMysqlAsserter(db *sql.DB) *MysqlAsserter

func (*MysqlAsserter) ColumnExists

func (pa *MysqlAsserter) ColumnExists(t testingT, table, column string) bool

func (*MysqlAsserter) ColumnNotExists

func (pa *MysqlAsserter) ColumnNotExists(t testingT, table, column string) bool

func (*MysqlAsserter) ColumnOfType

func (pa *MysqlAsserter) ColumnOfType(t testingT, table, column, dataType string) bool

func (*MysqlAsserter) ConstraintExists

func (pa *MysqlAsserter) ConstraintExists(t testingT, table, constraint string) bool

func (*MysqlAsserter) ConstraintNotExists

func (pa *MysqlAsserter) ConstraintNotExists(t testingT, table, constraint string) bool

func (*MysqlAsserter) IndexExists

func (pa *MysqlAsserter) IndexExists(t testingT, table, index string) bool

func (*MysqlAsserter) IndexNotExists

func (pa *MysqlAsserter) IndexNotExists(t testingT, table, index string) bool

func (*MysqlAsserter) RowExists

func (pa *MysqlAsserter) RowExists(t testingT, table string, colVals map[string]interface{}) bool

func (*MysqlAsserter) RowNotExists

func (pa *MysqlAsserter) RowNotExists(t testingT, table string, colVals map[string]interface{}) bool

func (*MysqlAsserter) TableExists

func (pa *MysqlAsserter) TableExists(t testingT, table string) bool

func (*MysqlAsserter) TableNotExists

func (pa *MysqlAsserter) TableNotExists(t testingT, table string) bool

type PostgresAsserter

type PostgresAsserter struct {
	// contains filtered or unexported fields
}

PostgresAsserter contains assertion helpers for Postgresql databases

func NewPostgresAsserter

func NewPostgresAsserter(db *sql.DB) *PostgresAsserter

func (*PostgresAsserter) ColumnExists

func (pa *PostgresAsserter) ColumnExists(t testingT, table, column string) bool

func (*PostgresAsserter) ColumnNotExists

func (pa *PostgresAsserter) ColumnNotExists(t testingT, table, column string) bool

func (*PostgresAsserter) ColumnOfType

func (pa *PostgresAsserter) ColumnOfType(t testingT, table, column, dataType string) bool

func (*PostgresAsserter) ConstraintExists

func (pa *PostgresAsserter) ConstraintExists(t testingT, table, constraint string) bool

func (*PostgresAsserter) ConstraintNotExists

func (pa *PostgresAsserter) ConstraintNotExists(t testingT, table, constraint string) bool

func (*PostgresAsserter) IndexExists

func (pa *PostgresAsserter) IndexExists(t testingT, table, index string) bool

func (*PostgresAsserter) IndexNotExists

func (pa *PostgresAsserter) IndexNotExists(t testingT, table, index string) bool

func (*PostgresAsserter) RowExists

func (pa *PostgresAsserter) RowExists(t testingT, table string, colVals map[string]interface{}) bool

func (*PostgresAsserter) RowNotExists

func (pa *PostgresAsserter) RowNotExists(t testingT, table string, colVals map[string]interface{}) bool

func (*PostgresAsserter) TableExists

func (pa *PostgresAsserter) TableExists(t testingT, table string) bool

func (*PostgresAsserter) TableNotExists

func (pa *PostgresAsserter) TableNotExists(t testingT, table string) bool