pgtest

func NewTestDB ¶

func NewTestDB(t *testing.T, cleanUp func(*pg.DB)) *pg.DB

NewTestDB creates a new test database. Provide a cleanup function for actions to perform before the DB is closed. On test completion, the cleanup function is run followed by closing the DB. The suggested method for cleanup is simply to have an outermost Tx that is rolled back at the end of the test. By default, this will attempt to connect to the "kwil_test_db" database on TCP port 5432. To change the DB name or port, use NewTestDBNamed.

func NewTestDBNamed ¶

func NewTestDBNamed(t *testing.T, dbName string, port int, cleanUp func(*pg.DB)) *pg.DB

NewTestDBNamed is like NewTestDBNamed but allows specifying the DB name and TCP port to use.

func NewTestDBWithCfg ¶

func NewTestDBWithCfg(t *testing.T, dbCfg *pg.DBConfig, cleanUp func(*pg.DB)) *pg.DB

func NewTestPool ¶

func NewTestPool(ctx context.Context, dropSchemas []string, dropTables ...string) (*pg.Pool, func(), error)