From 2212743dcf34fa34aeebbb2292152cc4d9d6dcdf Mon Sep 17 00:00:00 2001 From: Eugene Triguba Date: Sat, 13 Jan 2024 23:21:39 -0500 Subject: Add support for turning off transaction execution --- internal/sqlparse/sqlparse.go | 44 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 44 insertions(+) create mode 100644 internal/sqlparse/sqlparse.go (limited to 'internal/sqlparse/sqlparse.go') diff --git a/internal/sqlparse/sqlparse.go b/internal/sqlparse/sqlparse.go new file mode 100644 index 0000000..9ded618 --- /dev/null +++ b/internal/sqlparse/sqlparse.go @@ -0,0 +1,44 @@ +package sqlparse + +import ( + "bufio" + "io" + "strings" +) + +type SqlParser struct { + reader io.Reader +} + +type ExecutionOptions struct { + UseTransaction bool +} + +func NewSqlParser(reader io.Reader) *SqlParser { + return &SqlParser{reader: reader} +} + +func (sp *SqlParser) Parse() (*ExecutionOptions, error) { + options := &ExecutionOptions{UseTransaction: true} + + scanner := bufio.NewScanner(sp.reader) + if scanner.Scan() { + firstLine := strings.ToLower(strings.TrimSpace(scanner.Text())) + if strings.HasPrefix(firstLine, "-- bolt:") { + parts := strings.Split(firstLine, " ") + // Skip the first two parts ("--" and "bolt:") + for _, part := range parts[2:] { + if part == "no-transaction" { + options.UseTransaction = false + break + } + } + } + } + + if err := scanner.Err(); err != nil { + return nil, err + } + + return options, nil +} -- cgit v1.2.3