Function createTestDB

tools/search/provider_test.go:750–776

NB! Don't forget to call `db.Close()` at the end of the test.

()

// NB! Don't forget to call `db.Close()` at the end of the test.
func createTestDB() (*testDB, error) {
	// using a shared cache to allow multiple connections access to
	// the same in memory database https://www.sqlite.org/inmemorydb.html
	sqlDB, err := sql.Open("sqlite", "file::memory:?cache=shared")
	if err != nil {
		return nil, err
	}

	db := testDB{DB: dbx.NewFromDB(sqlDB, "sqlite")}
	db.CreateTable("test", map[string]string{
		"id":                                    "int default 0",
		"test1":                                 "int default 0",
		"test2":                                 "text default ''",
		"test3":                                 "text default ''",
		strings.Repeat("a", MaxSortFieldLength): "text default ''",
		strings.Repeat("b", MaxSortFieldLength+1): "text default ''",
	}).Execute()
	db.Insert("test", dbx.Params{"id": 1, "test1": 1, "test2": "test2.1"}).Execute()
	db.Insert("test", dbx.Params{"id": 2, "test1": 2, "test2": "test2.2"}).Execute()
	db.QueryLogFunc = func(ctx context.Context, t time.Duration, sql string, rows *sql.Rows, err error) {
		db.mu.Lock()
		defer db.mu.Unlock()
		db.CalledQueries = append(db.CalledQueries, sql)
	}

	return &db, nil
}

// ---