Function OpenSQLDB

internal/testingutil/testingutil.go:59–87

OpenSQLDB opens a connection to a SQLite database.

(tb testing.TB, dsn string)

// OpenSQLDB opens a connection to a SQLite database.
func OpenSQLDB(tb testing.TB, dsn string) *sql.DB {
	tb.Helper()

	db, err := sql.Open("sqlite3", dsn)
	if err != nil {
		tb.Fatal(err)
	}

	if *pageSize != 0 {
		if _, err := db.Exec(fmt.Sprintf(`PRAGMA page_size = %d`, *pageSize)); err != nil {
			tb.Fatal(err)
		}
	}

	if _, err := db.Exec(`PRAGMA busy_timeout = 5000`); err != nil {
		tb.Fatal(err)
	}
	if _, err := db.Exec(`PRAGMA journal_mode = ` + *journalMode); err != nil {
		tb.Fatal(err)
	}

	tb.Cleanup(func() {
		if err := db.Close(); err != nil {
			tb.Fatal(err)
		}
	})

	return db
}

// ReopenSQLDB closes the existing database connection and reopens it with the DSN.
func ReopenSQLDB(tb testing.TB, db **sql.DB, dsn string) {