forked from vitessio/vitess
-
Notifications
You must be signed in to change notification settings - Fork 1
/
sqlannotation.go
160 lines (147 loc) · 5.3 KB
/
sqlannotation.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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
// Copyright 2015, Google Inc. All rights reserved.
// Use of this source code is governed by a BSD-style
// license that can be found in the LICENSE file.
// Package sqlannotation provides functions
// for annotating DML statements with keyspace-id
// comments and parsing them. These annotations
// are used during filtered-replication to route
// the DML statement to the correct shard.
// TOOD(erez): Move the code for the "_stream" annotations
// from vttablet to here.
package sqlannotation
import (
"encoding/hex"
"fmt"
"log"
"strings"
"bytes"
"github.com/youtube/vitess/go/stats"
"github.com/youtube/vitess/go/vt/sqlparser"
)
const (
filteredReplicationUnfriendlyAnnotation = "/* vtgate:: filtered_replication_unfriendly */"
)
var (
filteredReplicationUnfriendlyStatementsCount = stats.NewInt("FilteredReplicationUnfriendlyStatementsCount")
)
// AnnotateIfDML annotates 'sql' based on 'keyspaceIDs'
//
// If 'sql' is not a DML statement no annotation is added.
// If 'sql' is a DML statement and contains exactly one keyspaceID
// it is used to annotate 'sql'
// Otherwise 'sql' is annotated as replication-unfriendly.
func AnnotateIfDML(sql string, keyspaceIDs [][]byte) string {
if !sqlparser.IsDML(sql) {
return sql
}
if len(keyspaceIDs) == 1 {
return AddKeyspaceIDs(sql, keyspaceIDs, "")
}
filteredReplicationUnfriendlyStatementsCount.Add(1)
return sql + filteredReplicationUnfriendlyAnnotation
}
// AddKeyspaceIDs returns a copy of 'sql' annotated
// with the given keyspace id. It also appends the
// additional trailingComments, if any.
func AddKeyspaceIDs(sql string, keyspaceIDs [][]byte, trailingComments string) string {
encodedIDs := make([][]byte, len(keyspaceIDs))
for i, src := range keyspaceIDs {
encodedIDs[i] = make([]byte, hex.EncodedLen(len(src)))
hex.Encode(encodedIDs[i], src)
}
return fmt.Sprintf("%s /* vtgate:: keyspace_id:%s */%s",
sql, bytes.Join(encodedIDs, []byte(",")), trailingComments)
}
// ExtractKeyspaceIDS parses the annotation of the given statement and tries
// to extract the keyspace id.
// If a keyspace-id comment exists 'keyspaceID' is set to the parsed keyspace id
// and err is set to nil; otherwise, if a filtered-replication-unfriendly comment exists
// or some other parsing error occured, keyspaceID is set to nil and err is set to a non-nil
// error value.
func ExtractKeyspaceIDS(sql string) (keyspaceIDs [][]byte, err error) {
_, comments := sqlparser.SplitTrailingComments(sql)
keyspaceIDString, hasKeyspaceID := extractStringBetween(comments, "/* vtgate:: keyspace_id:", " ")
hasUnfriendlyAnnotation := (strings.Index(sql, filteredReplicationUnfriendlyAnnotation) != -1)
if !hasKeyspaceID {
if hasUnfriendlyAnnotation {
return nil, &ExtractKeySpaceIDError{
Kind: ExtractKeySpaceIDReplicationUnfriendlyError,
Message: fmt.Sprintf("Statement: %v", sql),
}
}
// No annotations.
return nil, &ExtractKeySpaceIDError{
Kind: ExtractKeySpaceIDParseError,
Message: fmt.Sprintf("No annotation found in '%v'", sql),
}
}
if hasUnfriendlyAnnotation {
return nil, &ExtractKeySpaceIDError{
Kind: ExtractKeySpaceIDParseError,
Message: fmt.Sprintf("Conflicting annotations in statement '%v'", sql),
}
}
ksidStr := strings.Split(keyspaceIDString, ",")
keyspaceIDs = make([][]byte, len(ksidStr))
for row, ksid := range ksidStr {
err = nil
keyspaceIDs[row], err = hex.DecodeString(ksid)
if err != nil {
keyspaceIDs[row] = nil
err = &ExtractKeySpaceIDError{
Kind: ExtractKeySpaceIDParseError,
Message: fmt.Sprintf(
"Error parsing keyspace id value in statement: %v (%v)", sql, err),
}
}
}
return
}
// Extracts the string from source contained between the leftmost instance of
// 'leftDelim' and the next instance of 'rightDelim'. If there is no next instance
// of 'rightDelim', returns the string contained between the end of the leftmost instance
// of 'leftDelim' to the end of 'source'. If 'leftDelim' does not appear in 'source',
// sets 'found' to false and 'match' to the empty string, otherwise 'found' is set to true
// and 'match' is set to the extracted string.
func extractStringBetween(source string, leftDelim string, rightDelim string) (match string, found bool) {
leftDelimStart := strings.Index(source, leftDelim)
if leftDelimStart == -1 {
found = false
match = ""
return
}
found = true
matchStart := leftDelimStart + len(leftDelim)
matchEnd := strings.Index(source[matchStart:], rightDelim)
if matchEnd != -1 {
match = source[matchStart : matchStart+matchEnd]
return
}
match = source[matchStart:]
return
}
// ExtractKeySpaceIDError is the error type returned
// from ExtractKeySpaceID
// Kind is a numeric code for the error (see constants below)
// and Message is an error message string.
type ExtractKeySpaceIDError struct {
Kind int
Message string
}
// Possible values for ExtractKeySpaceIDError.Kind
const (
ExtractKeySpaceIDParseError = iota
ExtractKeySpaceIDReplicationUnfriendlyError = iota
)
func (err ExtractKeySpaceIDError) Error() string {
switch err.Kind {
case ExtractKeySpaceIDParseError:
return fmt.Sprintf("Parse-Error. %v", err.Message)
case ExtractKeySpaceIDReplicationUnfriendlyError:
return fmt.Sprintf(
"Statement is filtered-replication-unfriendly. %v", err.Message)
default:
log.Fatalf("Unknown error type: %v", err)
return "" // Unreachable.
}
}