-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqlreader.go
82 lines (66 loc) · 1.26 KB
/
sqlreader.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
package gofSQL
import (
"bufio"
"bytes"
"io"
)
const (
typeCreate QueryType = iota
typeInsert
typeQuery
typePrepare
typeUnset
)
type QueryType int
type Query struct {
Value string
QType QueryType
}
type Tag string
type Queries map[Tag]Query
func parseReader(reader io.Reader) (Queries, error) {
var (
queries = make(Queries)
currTag Tag = ""
skipNext = false
)
scanner := bufio.NewScanner(reader)
for scanner.Scan() {
line := scanner.Text()
parsedLine := ParseLine(line)
if skipNext && parsedLine.Type != lineTag {
continue
}
switch parsedLine.Type {
case lineEmpty, lineComment:
continue
case lineIgnore:
skipNext = true
case lineTag:
skipNext = false
currTag = Tag(parsedLine.Value)
case lineQuery:
query := getQuery(parsedLine.Value, scanner)
if query != "" {
queries[currTag] = Query{
Value: query,
QType: typeUnset,
}
}
}
}
return queries, nil
}
func getQuery(part string, scanner *bufio.Scanner) string {
var queryBuffer bytes.Buffer
queryBuffer.WriteString(part + " ")
for scanner.Scan() {
parsedLine := ParseLine(scanner.Text())
if parsedLine.Type == lineQuery {
queryBuffer.WriteString(parsedLine.Value)
} else {
break
}
}
return queryBuffer.String()
}