Function TestIsSelect

backend/plugin/db/util/statement_parser_test.go:496–561

(t *testing.T)

}

func TestIsSelect(t *testing.T) {
	tests := []struct {
		name     string
		query    string
		expected bool
	}{
		{
			name:     "simple SELECT",
			query:    "SELECT * FROM users",
			expected: true,
		},
		{
			name:     "SELECT with WHERE clause",
			query:    "SELECT id, name FROM users WHERE age > 18",
			expected: true,
		},
		{
			name:     "SELECT lowercase",
			query:    "select * from users",
			expected: true,
		},
		{
			name:     "CTE with SELECT (starts with WITH)",
			query:    "WITH cte AS (SELECT * FROM users) SELECT * FROM cte",
			expected: true,
		},
		{
			name:     "INSERT statement",
			query:    "INSERT INTO test_table (id, name) VALUES (1, 'test')",
			expected: false,
		},
		{
			name:     "UPDATE statement",
			query:    "UPDATE test_table SET name = 'updated' WHERE id = 1",
			expected: false,
		},
		{
			name:     "DELETE statement",
			query:    "DELETE FROM test_table WHERE id = 1",
			expected: false,
		},
		{
			name:     "CREATE TABLE",
			query:    "CREATE TABLE test (id INT64, name STRING(100))",
			expected: false,
		},
		{
			name:     "DROP TABLE",
			query:    "DROP TABLE test",
			expected: false,
		},
		{
			name:     "ALTER TABLE",
			query:    "ALTER TABLE test ADD COLUMN age INT64",
			expected: false,
		},
	}