Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
package snowflake
import (
"io"
"os"
"path/filepath"
"testing"
"github.com/stretchr/testify/require"
"gopkg.in/yaml.v3"
"github.com/bytebase/bytebase/backend/common/yamltest"
)
func TestGetStatementWithResultLimit(t *testing.T) {
runLimitTest(t, "test_limit.yaml", false /* record */)
}
type limitTestData struct {
Stmt string `yaml:"stmt"`
Limit int `yaml:"limit"`
Want string `yaml:"want"`
}
func runLimitTest(t *testing.T, file string, record bool) {
var testCases []limitTestData
filepath := filepath.Join("test-data", file)
yamlFile, err := os.Open(filepath)
require.NoError(t, err)
defer yamlFile.Close()
byteValue, err := io.ReadAll(yamlFile)
require.NoError(t, err)
err = yaml.Unmarshal(byteValue, &testCases)
require.NoError(t, err)
for i, tc := range testCases {
want := statementWithResultLimit(tc.Stmt, tc.Limit, "")
if record {
testCases[i].Want = want
} else {
require.Equal(t, tc.Want, want, tc.Stmt)
}
}
if record {
err := yamlFile.Close()
require.NoError(t, err)
yamltest.Record(t, filepath, testCases)
}
}