github.com/dolthub/dolt/go@v0.40.5-0.20240520175717-68db7794bea6/libraries/doltcore/sqle/database_test.go (about)

     1  // Copyright 2019-2020 Dolthub, Inc.
     2  //
     3  // Licensed under the Apache License, Version 2.0 (the "License");
     4  // you may not use this file except in compliance with the License.
     5  // You may obtain a copy of the License at
     6  //
     7  //     http://www.apache.org/licenses/LICENSE-2.0
     8  //
     9  // Unless required by applicable law or agreed to in writing, software
    10  // distributed under the License is distributed on an "AS IS" BASIS,
    11  // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    12  // See the License for the specific language governing permissions and
    13  // limitations under the License.
    14  
    15  package sqle
    16  
    17  import (
    18  	"context"
    19  	"testing"
    20  	"time"
    21  
    22  	"github.com/stretchr/testify/assert"
    23  	"github.com/stretchr/testify/require"
    24  
    25  	"github.com/dolthub/dolt/go/libraries/doltcore/dtestutils"
    26  	"github.com/dolthub/dolt/go/libraries/doltcore/sqle/dsess"
    27  	"github.com/dolthub/dolt/go/libraries/doltcore/table/editor"
    28  )
    29  
    30  func testKeyFunc(t *testing.T, keyFunc func(string) (bool, string), testVal string, expectedIsKey bool, expectedDBName string) {
    31  	isKey, dbName := keyFunc(testVal)
    32  	assert.Equal(t, expectedIsKey, isKey)
    33  	assert.Equal(t, expectedDBName, dbName)
    34  }
    35  
    36  func TestIsKeyFuncs(t *testing.T) {
    37  	testKeyFunc(t, dsess.IsHeadKey, "", false, "")
    38  	testKeyFunc(t, dsess.IsWorkingKey, "", false, "")
    39  	testKeyFunc(t, dsess.IsHeadKey, "dolt_head", true, "dolt")
    40  	testKeyFunc(t, dsess.IsWorkingKey, "dolt_head", false, "")
    41  	testKeyFunc(t, dsess.IsHeadKey, "dolt_working", false, "")
    42  	testKeyFunc(t, dsess.IsWorkingKey, "dolt_working", true, "dolt")
    43  }
    44  
    45  func TestNeedsToReloadEvents(t *testing.T) {
    46  	dEnv := dtestutils.CreateTestEnv()
    47  	tmpDir, err := dEnv.TempTableFilesDir()
    48  	require.NoError(t, err)
    49  	opts := editor.Options{Deaf: dEnv.DbEaFactory(), Tempdir: tmpDir}
    50  
    51  	timestamp := time.Now().Truncate(time.Minute).UTC()
    52  
    53  	db, err := NewDatabase(context.Background(), "dolt", dEnv.DbData(), opts)
    54  	require.NoError(t, err)
    55  
    56  	_, ctx, err := NewTestEngine(dEnv, context.Background(), db)
    57  	require.NoError(t, err)
    58  
    59  	var token any
    60  
    61  	t.Run("empty schema table doesn't need to be reloaded", func(t *testing.T) {
    62  		needsReload, err := db.NeedsToReloadEvents(ctx, token)
    63  		require.NoError(t, err)
    64  		assert.False(t, needsReload)
    65  	})
    66  
    67  	eventDefn := `CREATE EVENT testEvent
    68  ON SCHEDULE
    69      EVERY 1 DAY
    70      STARTS now()
    71  DO
    72  BEGIN
    73      CALL archive_order_history(DATE_SUB(CURDATE(), INTERVAL 1 YEAR));
    74  END`
    75  
    76  	err = db.addFragToSchemasTable(ctx, "event", "testEvent", eventDefn, timestamp, nil)
    77  	require.NoError(t, err)
    78  
    79  	t.Run("events need to be reloaded after addition", func(t *testing.T) {
    80  		needsReload, err := db.NeedsToReloadEvents(ctx, token)
    81  		require.NoError(t, err)
    82  		assert.True(t, needsReload)
    83  	})
    84  
    85  	_, token, err = db.GetEvents(ctx)
    86  	require.NoError(t, err)
    87  
    88  	t.Run("events do not need to be reloaded after no change", func(t *testing.T) {
    89  		needsReload, err := db.NeedsToReloadEvents(ctx, token)
    90  		require.NoError(t, err)
    91  		assert.False(t, needsReload)
    92  	})
    93  
    94  	err = db.dropFragFromSchemasTable(ctx, "event", "testEvent", nil)
    95  	require.NoError(t, err)
    96  
    97  	t.Run("events need to be reloaded after dropping one", func(t *testing.T) {
    98  		needsReload, err := db.NeedsToReloadEvents(ctx, token)
    99  		require.NoError(t, err)
   100  		assert.True(t, needsReload)
   101  	})
   102  
   103  	_, token, err = db.GetEvents(ctx)
   104  	require.NoError(t, err)
   105  
   106  	t.Run("events do not need to be reloaded after no change", func(t *testing.T) {
   107  		needsReload, err := db.NeedsToReloadEvents(ctx, token)
   108  		require.NoError(t, err)
   109  		assert.False(t, needsReload)
   110  	})
   111  }