-
Notifications
You must be signed in to change notification settings - Fork 0
/
table_pattern.go
135 lines (117 loc) · 4.22 KB
/
table_pattern.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
// Copyright 2016 The Cockroach Authors.
//
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
// implied. See the License for the specific language governing
// permissions and limitations under the License.
package parser
import (
"bytes"
"fmt"
"github.com/cockroachdb/cockroach/pkg/sql/pgwire/pgerror"
)
// Table patterns are used by e.g. GRANT statements, to designate
// zero, one or more table names. For example:
// GRANT ... ON foo ...
// GRANT ... ON * ...
// GRANT ... ON db.* ...
//
// The other syntax nodes hold a TablePattern reference. This is
// initially populated during parsing with an UnresolvedName, which
// can be transformed to either a TableName (single name) or
// AllTablesSelector instance (all tables of a given database) using
// NormalizeTablePattern().
// TablePattern is the common interface to UnresolvedName, TableName
// and AllTablesSelector.
type TablePattern interface {
fmt.Stringer
NodeFormatter
NormalizeTablePattern() (TablePattern, error)
}
// DatabaseQualifiable identifiers can be qualifed with a database name.
type DatabaseQualifiable interface {
QualifyWithDatabase(database string) error
}
var _ TablePattern = UnresolvedName{}
var _ TablePattern = &TableName{}
var _ TablePattern = &AllTablesSelector{}
var _ DatabaseQualifiable = &AllTablesSelector{}
var _ DatabaseQualifiable = &TableName{}
// NormalizeTablePattern resolves an UnresolvedName to either a
// TableName or AllTablesSelector.
func (n UnresolvedName) NormalizeTablePattern() (TablePattern, error) {
if len(n) == 0 || len(n) > 2 {
return nil, pgerror.NewErrorf(pgerror.CodeInvalidNameError, "invalid table name: %q", n)
}
var db Name
dbOmitted := true
if len(n) > 1 {
dbName, ok := n[0].(Name)
if !ok {
return nil, pgerror.NewErrorf(pgerror.CodeInvalidNameError, "invalid database name: %q", n[0])
}
db = dbName
dbOmitted = false
}
switch t := n[len(n)-1].(type) {
case UnqualifiedStar:
return &AllTablesSelector{Database: db, DBNameOriginallyOmitted: dbOmitted}, nil
case Name:
if len(t) == 0 {
return nil, pgerror.NewErrorf(pgerror.CodeInvalidNameError, "empty table name: %q", n)
}
return &TableName{DatabaseName: db, TableName: t, DBNameOriginallyOmitted: dbOmitted}, nil
default:
return nil, pgerror.NewErrorf(pgerror.CodeInvalidNameError, "invalid table pattern: %q", n)
}
}
// NormalizeTablePattern implements the TablePattern interface.
func (t *TableName) NormalizeTablePattern() (TablePattern, error) { return t, nil }
// AllTablesSelector corresponds to a selection of all
// tables in a database, e.g. when used with GRANT.
type AllTablesSelector struct {
Database Name
DBNameOriginallyOmitted bool
}
// Format implements the NodeFormatter interface.
func (at *AllTablesSelector) Format(buf *bytes.Buffer, f FmtFlags) {
if !at.DBNameOriginallyOmitted {
FormatNode(buf, f, at.Database)
buf.WriteByte('.')
}
buf.WriteByte('*')
}
func (at *AllTablesSelector) String() string { return AsString(at) }
// NormalizeTablePattern implements the TablePattern interface.
func (at *AllTablesSelector) NormalizeTablePattern() (TablePattern, error) { return at, nil }
// QualifyWithDatabase adds an indirection for the database, if it's missing.
// It transforms: * -> database.*
func (at *AllTablesSelector) QualifyWithDatabase(database string) error {
if !at.DBNameOriginallyOmitted {
return nil
}
if database == "" {
return pgerror.NewErrorf(pgerror.CodeInvalidDatabaseDefinitionError, "no database specified: %q", at)
}
at.Database = Name(database)
return nil
}
// TablePatterns implement a comma-separated list of table patterns.
// Used by e.g. the GRANT statement.
type TablePatterns []TablePattern
// Format implements the NodeFormatter interface.
func (tt TablePatterns) Format(buf *bytes.Buffer, f FmtFlags) {
for i, t := range tt {
if i > 0 {
buf.WriteString(", ")
}
FormatNode(buf, f, t)
}
}