dbtestutil

Documentation

Index

• func DumpOnFailure(t testing.TB, connectionURL string)
• func NewDB(t testing.TB, opts ...Option) (database.Store, pubsub.Pubsub)
• func NewDBWithSQLDB(t testing.TB, opts ...Option) (database.Store, pubsub.Pubsub, *sql.DB)
• func WillUsePostgres() bool
• type Option
  • func WithDumpOnFailure() Option
  • func WithTimezone(tz string) Option

Functions

func DumpOnFailure

func DumpOnFailure(t testing.TB, connectionURL string)

DumpOnFailure exports the database referenced by connectionURL to a file corresponding to the current test, with a suffix indicating the time the test was run. To import this into a new database (assuming you have already run make test-postgres-docker):

• Create a new test database: go run ./scripts/migrate-ci/main.go and note the database name it outputs
• Import the file into the above database: psql 'postgres://postgres:postgres@127.0.0.1:5432/<dbname>?sslmode=disable' -f <path to file.test.sql>
• Run a dev server against that database: ./scripts/coder-dev.sh server --postgres-url='postgres://postgres:postgres@127.0.0.1:5432/<dbname>?sslmode=disable'

func NewDB

func NewDB(t testing.TB, opts ...Option) (database.Store, pubsub.Pubsub)

func NewDBWithSQLDB

func NewDBWithSQLDB(t testing.TB, opts ...Option) (database.Store, pubsub.Pubsub, *sql.DB)

func WillUsePostgres

func WillUsePostgres() bool

WillUsePostgres returns true if a call to NewDB() will return a real, postgres-backed Store and Pubsub.

Types

type Option

type Option func(*options)

func WithDumpOnFailure

func WithDumpOnFailure() Option

WithDumpOnFailure will dump the entire database on test failure.

func WithTimezone

func WithTimezone(tz string) Option

WithTimezone sets the database to the defined timezone.