Skip to content

SeaweedFS is a distributed storage system for object storage (S3), file systems, Iceberg table buckets, and Lance vector buckets, designed to handle billions of files with O(1) disk access and effortless horizontal scaling.

3.0 KB
Raw Blame
package sqlutil

import (
	"strings"
)

// SplitStatements splits a query string into individual SQL statements.
// This robust implementation handles SQL comments, quoted strings, and escaped characters.
//
// Features:
// - Handles single-line comments (-- comment)
// - Handles multi-line comments (/* comment */)
// - Properly escapes single quotes in strings ('don”t')
// - Properly escapes double quotes in identifiers ("column""name")
// - Ignores semicolons within quoted strings and comments
// - Returns clean, trimmed statements with empty statements filtered out
func SplitStatements(query string) []string {
	var statements []string
	var current strings.Builder

	query = strings.TrimSpace(query)
	if query == "" {
		return []string{}
	}

	runes := []rune(query)
	i := 0

	for i < len(runes) {
		char := runes[i]

		// Handle single-line comments (-- comment)
		if char == '-' && i+1 < len(runes) && runes[i+1] == '-' {
			// Skip the entire comment without including it in any statement
			for i < len(runes) && runes[i] != '\n' && runes[i] != '\r' {
				i++
			}
			// Skip the newline if present
			if i < len(runes) {
				i++
			}
			continue
		}

		// Handle multi-line comments (/* comment */)
		if char == '/' && i+1 < len(runes) && runes[i+1] == '*' {
			// Skip the /* opening
			i++
			i++

			// Skip to end of comment or end of input without including content
			for i < len(runes) {
				if runes[i] == '*' && i+1 < len(runes) && runes[i+1] == '/' {
					i++ // Skip the *
					i++ // Skip the /
					break
				}
				i++
			}
			continue
		}

		// Handle single-quoted strings
		if char == '\'' {
			current.WriteRune(char)
			i++

			for i < len(runes) {
				char = runes[i]
				current.WriteRune(char)

				if char == '\'' {
					// Check if it's an escaped quote
					if i+1 < len(runes) && runes[i+1] == '\'' {
						i++ // Skip the next quote (it's escaped)
						if i < len(runes) {
							current.WriteRune(runes[i])
						}
					} else {
						break // End of string
					}
				}
				i++
			}
			i++
			continue
		}

		// Handle double-quoted identifiers
		if char == '"' {
			current.WriteRune(char)
			i++

			for i < len(runes) {
				char = runes[i]
				current.WriteRune(char)

				if char == '"' {
					// Check if it's an escaped quote
					if i+1 < len(runes) && runes[i+1] == '"' {
						i++ // Skip the next quote (it's escaped)
						if i < len(runes) {
							current.WriteRune(runes[i])
						}
					} else {
						break // End of identifier
					}
				}
				i++
			}
			i++
			continue
		}

		// Handle semicolon (statement separator)
		if char == ';' {
			stmt := strings.TrimSpace(current.String())
			if stmt != "" {
				statements = append(statements, stmt)
			}
			current.Reset()
		} else {
			current.WriteRune(char)
		}
		i++
	}

	// Add any remaining statement
	if current.Len() > 0 {
		stmt := strings.TrimSpace(current.String())
		if stmt != "" {
			statements = append(statements, stmt)
		}
	}

	if len(statements) == 0 {
		return []string{}
	}
	return statements
}