db_test.go raw

   1  package test
   2  
   3  import (
   4  	"strconv"
   5  	"testing"
   6  
   7  	"github.com/sirupsen/logrus"
   8  
   9  	"github.com/getAlby/hub/logger"
  10  	"github.com/getAlby/hub/tests/db"
  11  
  12  	"github.com/stretchr/testify/assert"
  13  	"github.com/stretchr/testify/require"
  14  )
  15  
  16  func TestTempStorePragmaIsApplied(t *testing.T) {
  17  	logger.Init(strconv.Itoa(int(logrus.DebugLevel)))
  18  	gormDb, err := db.NewDB(t)
  19  	require.NoError(t, err)
  20  	defer db.CloseDB(gormDb)
  21  
  22  	if gormDb.Dialector.Name() != "sqlite" {
  23  		t.Skip("Skipping non-sqlite dialector")
  24  	}
  25  
  26  	var result string
  27  	err = gormDb.Raw("PRAGMA temp_store").Scan(&result).Error
  28  	require.NoError(t, err)
  29  
  30  	// PRAGMA temp_store = MEMORY
  31  	// MEMORY = 2
  32  	assert.Equal(t, "2", result)
  33  }
  34