Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

2.7 KB
Raw Blame
package snowflake

import (
	"testing"

	omniast "github.com/bytebase/omni/snowflake/ast"
	"github.com/stretchr/testify/require"

	storepb "github.com/bytebase/bytebase/backend/generated-go/store"
)

type testAST struct{}

func (testAST) ASTStartPosition() *storepb.Position {
	return nil
}

// TestParseSnowflakeStatementsOmniAST locks the omni-only contract: every
// non-empty statement carries an OmniAST wrapping a non-nil omni node
// (reachable via GetOmniNode); the legacy ANTLR tree is gone.
func TestParseSnowflakeStatementsOmniAST(t *testing.T) {
	parsed, err := parseSnowflakeStatements("CREATE TABLE t1(id INT);\nSELECT id FROM t1;")
	require.NoError(t, err)
	require.Len(t, parsed, 2)

	for i, ps := range parsed {
		omniAST, ok := ps.AST.(*OmniAST)
		require.True(t, ok, "stmt %d: AST must be *OmniAST", i)
		require.Equal(t, ps.Text, omniAST.Text, "stmt %d", i)

		// The omni node must be reachable through GetOmniNode.
		node, ok := GetOmniNode(ps.AST)
		require.True(t, ok, "stmt %d: GetOmniNode must work", i)
		require.NotNil(t, node, "stmt %d", i)

		// ASTStartPosition keeps the legacy shape (line-based, BaseLine()+1),
		// so position reporting is unchanged by the cutover.
		require.EqualValues(t, ps.BaseLine()+1, ps.AST.ASTStartPosition().GetLine(), "stmt %d", i)
	}

	node0, _ := GetOmniNode(parsed[0].AST)
	require.IsType(t, (*omniast.CreateTableStmt)(nil), node0)
	node1, _ := GetOmniNode(parsed[1].AST)
	require.IsType(t, (*omniast.SelectStmt)(nil), node1)
}

// TestParseSnowflakeStatementsEmptyAndError locks the surrounding behavior:
// empty/comment-only inputs produce no statements (omni-based SplitSQL drops
// empty segments), and an omni parse failure fails the whole batch exactly as
// the legacy ANTLR parser did.
func TestParseSnowflakeStatementsEmptyAndError(t *testing.T) {
	// Comments and bare semicolons yield no statements and no error.
	parsed, err := parseSnowflakeStatements(";; -- only a comment\n;")
	require.NoError(t, err)
	require.Empty(t, parsed)

	// Comment-only prefix does not shift the statement pairing.
	parsed, err = parseSnowflakeStatements("-- header\nSELECT 1;;SELECT 2;")
	require.NoError(t, err)
	require.Len(t, parsed, 2)
	for i, ps := range parsed {
		_, ok := GetOmniNode(ps.AST)
		require.True(t, ok, "stmt %d", i)
	}

	// Parse failure keeps the legacy error behavior: the whole batch fails.
	_, err = parseSnowflakeStatements("SELECT 1;\nSELECT * FROM;")
	require.Error(t, err)
}

// TestGetOmniNodeEdgeCases covers the accessor's non-OmniAST inputs.
func TestGetOmniNodeEdgeCases(t *testing.T) {
	node, ok := GetOmniNode(nil)
	require.False(t, ok)
	require.Nil(t, node)

	node, ok = GetOmniNode(testAST{})
	require.False(t, ok)
	require.Nil(t, node)
}