sqlparser

package
v0.0.0-...-b26f8fd Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: May 24, 2016 License: Apache-2.0 Imports: 8 Imported by: 2

Documentation

Index

Constants

View Source
const (
	ForUpdateStr = " for update"
	ShareModeStr = " lock in share mode"
)

Select.Lock

View Source
const (
	UnionStr     = "union"
	UnionAllStr  = "union all"
	SetMinusStr  = "minus"
	ExceptStr    = "except"
	IntersectStr = "intersect"
)

Union.Type

View Source
const (
	CreateStr = "create"
	AlterStr  = "alter"
	DropStr   = "drop"
	RenameStr = "rename"
)

DDL strings.

View Source
const (
	JoinStr             = "join"
	StraightJoinStr     = "straight_join"
	LeftJoinStr         = "left join"
	RightJoinStr        = "right join"
	NaturalJoinStr      = "natural join"
	NaturalLeftJoinStr  = "natural left join"
	NaturalRightJoinStr = "natural right join"
)

JoinTableExpr.Join

View Source
const (
	UseStr    = "use "
	IgnoreStr = "ignore "
	ForceStr  = "force "
)

Index hints.

View Source
const (
	WhereStr  = "where"
	HavingStr = "having"
)

Where.Type

View Source
const (
	EqualStr         = "="
	LessThanStr      = "<"
	GreaterThanStr   = ">"
	LessEqualStr     = "<="
	GreaterEqualStr  = ">="
	NotEqualStr      = "!="
	NullSafeEqualStr = "<=>"
	InStr            = "in"
	NotInStr         = "not in"
	LikeStr          = "like"
	NotLikeStr       = "not like"
	RegexpStr        = "regexp"
	NotRegexpStr     = "not regexp"
)

ComparisonExpr.Operator

View Source
const (
	BetweenStr    = "between"
	NotBetweenStr = "not between"
)

RangeCond.Operator

View Source
const (
	IsNullStr     = "is null"
	IsNotNullStr  = "is not null"
	IsTrueStr     = "is true"
	IsNotTrueStr  = "is not true"
	IsFalseStr    = "is false"
	IsNotFalseStr = "is not false"
)

IsExpr.Operator

View Source
const (
	BitAndStr     = "&"
	BitOrStr      = "|"
	BitXorStr     = "^"
	PlusStr       = "+"
	MinusStr      = "-"
	MultStr       = "*"
	DivStr        = "/"
	ModStr        = "%"
	ShiftLeftStr  = "<<"
	ShiftRightStr = ">>"
)

BinaryExpr.Operator

View Source
const (
	UPlusStr  = '+'
	UMinusStr = '-'
	TildaStr  = '~'
)

UnaryExpr.Operator

View Source
const (
	AscScr  = "asc"
	DescScr = "desc"
)

Order.Direction

View Source
const ALL = 57363
View Source
const ALTER = 57419
View Source
const ANALYZE = 57422
View Source
const AND = 57399
View Source
const AS = 57365
View Source
const ASC = 57367
View Source
const BETWEEN = 57401
View Source
const BY = 57360
View Source
const CASE = 57402
View Source
const COMMENT = 57394
View Source
const CREATE = 57418
View Source
const CROSS = 57384
View Source
const DATABASE = 57424
View Source
const DEFAULT = 57372
View Source
const DELETE = 57354
View Source
const DESC = 57368
View Source
const DESCRIBE = 57433
View Source
const DISTINCT = 57364
View Source
const DROP = 57420
View Source
const DUPLICATE = 57370
View Source
const (
	DistinctStr = "distinct "
)

Select.Distinct

View Source
const ELSE = 57405
View Source
const END = 57417
View Source
const EXCEPT = 57349
View Source
const EXISTS = 57366
View Source
const EXPLAIN = 57434
View Source
const FALSE = 57397
View Source
const FOR = 57362
View Source
const FORCE = 57387
View Source
const FROM = 57355
View Source
const GE = 57407
View Source
const GROUP = 57357
View Source
const HAVING = 57358
View Source
const ID = 57389
View Source
const IF = 57429
View Source
const IGNORE = 57428
View Source
const IN = 57413
View Source
const INDEX = 57425
View Source
const INNER = 57382
View Source
const INSERT = 57352
View Source
const INTERSECT = 57350
View Source
const INTO = 57369
View Source
const IS = 57410
View Source
const JOIN = 57378
View Source
const KEY = 57371
View Source
const KEYRANGE = 57375
View Source
const LAST_INSERT_ID = 57377
View Source
const LE = 57406
View Source
const LEFT = 57380
View Source
const LEX_ERROR = 57346
View Source
const LIKE = 57411
View Source
const LIMIT = 57361
View Source
const LIST_ARG = 57393
View Source
const LOCK = 57374
View Source
const MINUS = 57348
View Source
const NATURAL = 57385
View Source
const NE = 57408
View Source
const NOT = 57400
View Source
const NULL = 57395
View Source
const NULL_SAFE_EQUAL = 57409
View Source
const NUMBER = 57391
View Source
const ON = 57388
View Source
const OR = 57398
View Source
const ORDER = 57359
View Source
const OUTER = 57383
View Source
const REGEXP = 57412
View Source
const RENAME = 57421
View Source
const RIGHT = 57381
View Source
const SELECT = 57351
View Source
const SET = 57373
View Source
const SHIFT_LEFT = 57414
View Source
const SHIFT_RIGHT = 57415
View Source
const SHOW = 57432
View Source
const STRAIGHT_JOIN = 57379
View Source
const STRING = 57390
View Source
const TABLE = 57423
View Source
const THEN = 57404
View Source
const TO = 57427
View Source
const TRUE = 57396
View Source
const UNARY = 57416
View Source
const UNION = 57347
View Source
const UNIQUE = 57430
View Source
const UPDATE = 57353
View Source
const USE = 57386
View Source
const USING = 57431
View Source
const VALUES = 57376
View Source
const VALUE_ARG = 57392
View Source
const VIEW = 57426
View Source
const WHEN = 57403
View Source
const WHERE = 57356

Variables

View Source
var Aggregates = map[string]bool{
	"avg":          true,
	"bit_and":      true,
	"bit_or":       true,
	"bit_xor":      true,
	"count":        true,
	"group_concat": true,
	"max":          true,
	"min":          true,
	"std":          true,
	"stddev_pop":   true,
	"stddev_samp":  true,
	"stddev":       true,
	"sum":          true,
	"var_pop":      true,
	"var_samp":     true,
	"variance":     true,
}

Aggregates is a map of all aggregate functions.

View Source
var AllExprs = []Expr{
	&AndExpr{},
	&OrExpr{},
	&NotExpr{},
	&ParenBoolExpr{},
	&ComparisonExpr{},
	&RangeCond{},
	&IsExpr{},
	&ExistsExpr{},
	&KeyrangeExpr{},
	StrVal(""),
	NumVal(""),
	ValArg(""),
	&NullVal{},
	BoolVal(false),
	&ColName{},
	ValTuple{},
	&Subquery{},
	ListArg(""),
	&BinaryExpr{},
	&UnaryExpr{},
	&FuncExpr{},
	&CaseExpr{},
}

AllExprs must contain one variable for each AST type that satisfies Expr. This allows for external packages to verify that they're not missing on any types.

Functions

func IsNodeHasValue

func IsNodeHasValue(node SQLNode) bool

func ParseDDL

func ParseDDL(sql string) (ast.StmtNode, error)

ParseDDL only use to parse ddl sql, no longer use. sqlparser will native support DDL.

func String

func String(node SQLNode) string

String returns a string representation of an SQLNode.

Types

type AliasedTableExpr

type AliasedTableExpr struct {
	Expr  SimpleTableExpr
	As    SQLName
	Hints *IndexHints
}

AliasedTableExpr represents a table expression coupled with an optional alias or index hint.

func (*AliasedTableExpr) Format

func (node *AliasedTableExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*AliasedTableExpr) Nodes

func (node *AliasedTableExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type AndExpr

type AndExpr struct {
	Left, Right BoolExpr
}

AndExpr represents an AND expression.

func (*AndExpr) Format

func (node *AndExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*AndExpr) Nodes

func (node *AndExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type BinaryExpr

type BinaryExpr struct {
	Operator    string
	Left, Right Expr
}

BinaryExpr represents a binary value expression.

func (*BinaryExpr) Format

func (node *BinaryExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*BinaryExpr) Nodes

func (node *BinaryExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type BoolExpr

type BoolExpr interface {
	Expr
	// contains filtered or unexported methods
}

BoolExpr represents a boolean expression.

type BoolVal

type BoolVal bool

BoolVal is true or false.

func (BoolVal) Format

func (node BoolVal) Format(buf *TrackedBuffer)

Format formats the node.

func (BoolVal) Nodes

func (node BoolVal) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type CaseExpr

type CaseExpr struct {
	Expr  ValExpr
	Whens []*When
	Else  ValExpr
}

CaseExpr represents a CASE expression.

func (*CaseExpr) Format

func (node *CaseExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*CaseExpr) Nodes

func (node *CaseExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type ColName

type ColName struct {
	Name      SQLName
	Qualifier SQLName
}

ColName represents a column name.

func (*ColName) Format

func (node *ColName) Format(buf *TrackedBuffer)

Format formats the node.

func (*ColName) Nodes

func (node *ColName) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type ColTuple

type ColTuple interface {
	ValExpr
	// contains filtered or unexported methods
}

ColTuple represents a list of column values. It can be ValTuple, Subquery, ListArg.

type ColumnDef

type ColumnDef struct {
	Name    *ColName
	Type    *FieldType
	Options []*ColumnOption
}

ColumnDef is used for parsing column definition from SQL.

type ColumnOption

type ColumnOption struct {
	Tp ColumnOptionType
	// The value For Default or On Update.
	Expr Expr
}

ColumnOption is used for parsing column constraint info from SQL.

type ColumnOptionType

type ColumnOptionType int

ColumnOptionType is the type for ColumnOption.

const (
	ColumnOptionNoOption ColumnOptionType = iota
	ColumnOptionPrimaryKey
	ColumnOptionNotNull
	ColumnOptionAutoIncrement
	ColumnOptionDefaultValue
	ColumnOptionUniq
	ColumnOptionIndex
	ColumnOptionUniqIndex
	ColumnOptionKey
	ColumnOptionUniqKey
	ColumnOptionNull
	ColumnOptionOnUpdate // For Timestamp and Datetime only.
	ColumnOptionFulltext
	ColumnOptionComment
)

ColumnOption types.

type Columns

type Columns []SelectExpr

Columns represents an insert column list. The syntax for Columns is a subset of SelectExprs. So, it's castable to a SelectExprs and can be analyzed as such.

func (Columns) Format

func (node Columns) Format(buf *TrackedBuffer)

Format formats the node.

func (Columns) Nodes

func (node Columns) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Comments

type Comments [][]byte

Comments represents a list of comments.

func (Comments) Format

func (node Comments) Format(buf *TrackedBuffer)

Format formats the node.

func (Comments) Nodes

func (node Comments) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type ComparisonExpr

type ComparisonExpr struct {
	Operator    string
	Left, Right ValExpr
}

ComparisonExpr represents a two-value comparison expression.

func (*ComparisonExpr) Format

func (node *ComparisonExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*ComparisonExpr) Nodes

func (node *ComparisonExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Constraint

type Constraint struct {
}

type CreateTable

type CreateTable struct {
	IfNotExists bool
	Table       *TableName
	Cols        []*ColumnDef
	Constraints []*Constraint
	Options     []*TableOption
}

CreateTable is a create table ddl

type DDL

type DDL struct {
	Action  string
	Table   SQLName
	NewName SQLName
	IsDB    bool
}

DDL represents a CREATE, ALTER, DROP or RENAME statement. Table is set for AlterStr, DropStr, RenameStr. NewName is set for AlterStr, CreateStr, RenameStr.

func (*DDL) Format

func (node *DDL) Format(buf *TrackedBuffer)

Format formats the node.

func (*DDL) Nodes

func (node *DDL) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type DatabaseOptionType

type DatabaseOptionType int
const (
	DatabaseOptionNone DatabaseOptionType = iota
	DatabaseOptionCharset
	DatabaseOptionCollate
)

Database option types.

type Delete

type Delete struct {
	Comments Comments
	Table    *TableName
	Where    *Where
	OrderBy  OrderBy
	Limit    *Limit
}

Delete represents a DELETE statement.

func (*Delete) Format

func (node *Delete) Format(buf *TrackedBuffer)

Format formats the node.

func (*Delete) Nodes

func (node *Delete) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type ExistsExpr

type ExistsExpr struct {
	Subquery *Subquery
}

ExistsExpr represents an EXISTS expression.

func (*ExistsExpr) Format

func (node *ExistsExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*ExistsExpr) Nodes

func (node *ExistsExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Explain

type Explain struct {
	SQL Statement
}

Explain represents a EXPALAIN statement.

func (*Explain) Format

func (node *Explain) Format(buf *TrackedBuffer)

Format formats the node.

func (*Explain) Nodes

func (node *Explain) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Expr

type Expr interface {
	SQLNode
	// contains filtered or unexported methods
}

Expr represents an expression.

type FieldType

type FieldType struct {
}

type FuncExpr

type FuncExpr struct {
	Name     string
	Distinct bool
	Exprs    SelectExprs
}

FuncExpr represents a function call.

func (*FuncExpr) Format

func (node *FuncExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*FuncExpr) IsAggregate

func (node *FuncExpr) IsAggregate() bool

IsAggregate returns true if the function is an aggregate.

func (*FuncExpr) Nodes

func (node *FuncExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type GroupBy

type GroupBy []ValExpr

GroupBy represents a GROUP BY clause.

func (GroupBy) Format

func (node GroupBy) Format(buf *TrackedBuffer)

Format formats the node.

func (GroupBy) Nodes

func (node GroupBy) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type IndexHints

type IndexHints struct {
	Type    string
	Indexes []SQLName
}

IndexHints represents a list of index hints.

func (*IndexHints) Format

func (node *IndexHints) Format(buf *TrackedBuffer)

Format formats the node.

func (*IndexHints) Nodes

func (node *IndexHints) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Insert

type Insert struct {
	Comments Comments
	Ignore   string
	Table    *TableName
	Columns  Columns
	Rows     InsertRows
	OnDup    OnDup
}

Insert represents an INSERT statement.

func (*Insert) Format

func (node *Insert) Format(buf *TrackedBuffer)

Format formats the node.

func (*Insert) Nodes

func (node *Insert) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type InsertRows

type InsertRows interface {
	SQLNode
	// contains filtered or unexported methods
}

InsertRows represents the rows for an INSERT statement.

type IsExpr

type IsExpr struct {
	Operator string
	Expr     Expr
}

IsExpr represents an IS ... or an IS NOT ... expression.

func (*IsExpr) Format

func (node *IsExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*IsExpr) Nodes

func (node *IsExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type JoinTableExpr

type JoinTableExpr struct {
	LeftExpr  TableExpr
	Join      string
	RightExpr TableExpr
	On        BoolExpr
}

JoinTableExpr represents a TableExpr that's a JOIN operation.

func (*JoinTableExpr) Format

func (node *JoinTableExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*JoinTableExpr) Nodes

func (node *JoinTableExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type KeyrangeExpr

type KeyrangeExpr struct {
	Start, End ValExpr
}

KeyrangeExpr represents a KEYRANGE expression.

func (*KeyrangeExpr) Format

func (node *KeyrangeExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*KeyrangeExpr) Nodes

func (node *KeyrangeExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Limit

type Limit struct {
	Offset, Rowcount ValExpr
}

Limit represents a LIMIT clause.

func (*Limit) Format

func (node *Limit) Format(buf *TrackedBuffer)

Format formats the node.

func (*Limit) Limits

func (node *Limit) Limits() (offset, rowcount interface{}, err error)

Limits returns the values of the LIMIT clause as interfaces. The returned values can be nil for absent field, string for bind variable names, or int64 for an actual number. Otherwise, it's an error.

func (*Limit) Nodes

func (node *Limit) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type ListArg

type ListArg []byte

ListArg represents a named list argument.

func (ListArg) Format

func (node ListArg) Format(buf *TrackedBuffer)

Format formats the node.

func (ListArg) Nodes

func (node ListArg) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type NonStarExpr

type NonStarExpr struct {
	Expr Expr
	As   SQLName
}

NonStarExpr defines a non-'*' select expr.

func (*NonStarExpr) Format

func (node *NonStarExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*NonStarExpr) Nodes

func (node *NonStarExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type NotExpr

type NotExpr struct {
	Expr BoolExpr
}

NotExpr represents a NOT expression.

func (*NotExpr) Format

func (node *NotExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*NotExpr) Nodes

func (node *NotExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type NullVal

type NullVal struct{}

NullVal represents a NULL value.

func (*NullVal) Format

func (node *NullVal) Format(buf *TrackedBuffer)

Format formats the node.

func (*NullVal) Nodes

func (node *NullVal) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type NumVal

type NumVal []byte

NumVal represents a number.

func (NumVal) Format

func (node NumVal) Format(buf *TrackedBuffer)

Format formats the node.

func (NumVal) Nodes

func (node NumVal) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type OnDup

type OnDup UpdateExprs

OnDup represents an ON DUPLICATE KEY clause.

func (OnDup) Format

func (node OnDup) Format(buf *TrackedBuffer)

Format formats the node.

func (OnDup) Nodes

func (node OnDup) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type OrExpr

type OrExpr struct {
	Left, Right BoolExpr
}

OrExpr represents an OR expression.

func (*OrExpr) Format

func (node *OrExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*OrExpr) Nodes

func (node *OrExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Order

type Order struct {
	Expr      ValExpr
	Direction string
}

Order represents an ordering expression.

func (*Order) Format

func (node *Order) Format(buf *TrackedBuffer)

Format formats the node.

func (*Order) Nodes

func (node *Order) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type OrderBy

type OrderBy []*Order

OrderBy represents an ORDER By clause.

func (OrderBy) Format

func (node OrderBy) Format(buf *TrackedBuffer)

Format formats the node.

func (OrderBy) Nodes

func (node OrderBy) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Other

type Other struct{}

Other represents a SHOW, or DESCRIBE statement. It should be used only as an indicator. It does not contain the full AST for the statement.

func (*Other) Format

func (node *Other) Format(buf *TrackedBuffer)

Format formats the node.

func (*Other) Nodes

func (node *Other) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type ParenBoolExpr

type ParenBoolExpr struct {
	Expr BoolExpr
}

ParenBoolExpr represents a parenthesized boolean expression.

func (*ParenBoolExpr) Format

func (node *ParenBoolExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*ParenBoolExpr) Nodes

func (node *ParenBoolExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type ParenTableExpr

type ParenTableExpr struct {
	Exprs TableExprs
}

ParenTableExpr represents a parenthesized list of TableExpr.

func (*ParenTableExpr) Format

func (node *ParenTableExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*ParenTableExpr) Nodes

func (node *ParenTableExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type ParsedQuery

type ParsedQuery struct {
	Query string
	// contains filtered or unexported fields
}

ParsedQuery represents a parsed query where bind locations are precompued for fast substitutions.

func GenerateParsedQuery

func GenerateParsedQuery(node SQLNode) *ParsedQuery

GenerateParsedQuery returns a ParsedQuery of the ast.

type RangeCond

type RangeCond struct {
	Operator string
	Left     ValExpr
	From, To ValExpr
}

RangeCond represents a BETWEEN or a NOT BETWEEN expression.

func (*RangeCond) Format

func (node *RangeCond) Format(buf *TrackedBuffer)

Format formats the node.

func (*RangeCond) Nodes

func (node *RangeCond) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type RowTuple

type RowTuple interface {
	ValExpr
	// contains filtered or unexported methods
}

RowTuple represents a row of values. It can be ValTuple, Subquery.

type SQLName

type SQLName string

SQLName is an SQL identifier. It will be escaped with backquotes if it matches a keyword.

func (SQLName) Format

func (node SQLName) Format(buf *TrackedBuffer)

Format formats the node.

func (SQLName) Nodes

func (node SQLName) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type SQLNode

type SQLNode interface {
	Format(buf *TrackedBuffer)
	Nodes() []SQLNode
}

SQLNode defines the interface for all nodes generated by the parser.

type Select

type Select struct {
	Comments    Comments
	Distinct    string
	SelectExprs SelectExprs
	From        TableExprs
	Where       *Where
	GroupBy     GroupBy
	Having      *Where
	OrderBy     OrderBy
	Limit       *Limit
	Lock        string
}

Select represents a SELECT statement.

func (*Select) Format

func (node *Select) Format(buf *TrackedBuffer)

Format formats the node.

func (*Select) Nodes

func (node *Select) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type SelectExpr

type SelectExpr interface {
	SQLNode
	// contains filtered or unexported methods
}

SelectExpr represents a SELECT expression.

type SelectExprs

type SelectExprs []SelectExpr

SelectExprs represents SELECT expressions.

func (SelectExprs) Format

func (node SelectExprs) Format(buf *TrackedBuffer)

Format formats the node.

func (SelectExprs) Nodes

func (node SelectExprs) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type SelectStatement

type SelectStatement interface {
	SQLNode
	// contains filtered or unexported methods
}

SelectStatement any SELECT statement.

type Set

type Set struct {
	Comments Comments
	Exprs    UpdateExprs
}

Set represents a SET statement.

func (*Set) Format

func (node *Set) Format(buf *TrackedBuffer)

Format formats the node.

func (*Set) Nodes

func (node *Set) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Show

type Show struct {
	Key   string
	From  TableExprs
	Where *Where
	Like  *ComparisonExpr
}

func (*Show) Format

func (node *Show) Format(buf *TrackedBuffer)

func (*Show) Nodes

func (node *Show) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type SimpleTableExpr

type SimpleTableExpr interface {
	SQLNode
	// contains filtered or unexported methods
}

SimpleTableExpr represents a simple table expression.

type StarExpr

type StarExpr struct {
	TableName SQLName
}

StarExpr defines a '*' or 'table.*' expression.

func (*StarExpr) Format

func (node *StarExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*StarExpr) Nodes

func (node *StarExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Statement

type Statement interface {
	SQLNode
	// contains filtered or unexported methods
}

Statement represents a statement.

func Parse

func Parse(sql string) (Statement, error)

Parse parses the sql and returns a Statement, which is the AST representation of the query.

type Str

type Str string

func (Str) Format

func (node Str) Format(buf *TrackedBuffer)

Format formats the node.

func (Str) Nodes

func (node Str) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type StrVal

type StrVal []byte

StrVal represents a string value.

func (StrVal) Format

func (node StrVal) Format(buf *TrackedBuffer)

Format formats the node.

func (StrVal) Nodes

func (node StrVal) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Subquery

type Subquery struct {
	Select SelectStatement
}

Subquery represents a subquery.

func (*Subquery) Format

func (node *Subquery) Format(buf *TrackedBuffer)

Format formats the node.

func (*Subquery) Nodes

func (node *Subquery) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type TableExpr

type TableExpr interface {
	SQLNode
	// contains filtered or unexported methods
}

TableExpr represents a table expression.

type TableExprs

type TableExprs []TableExpr

TableExprs represents a list of table expressions.

func (TableExprs) Format

func (node TableExprs) Format(buf *TrackedBuffer)

Format formats the node.

func (TableExprs) Nodes

func (node TableExprs) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type TableName

type TableName struct {
	Name, Qualifier SQLName
}

TableName represents a table name.

func (*TableName) Format

func (node *TableName) Format(buf *TrackedBuffer)

Format formats the node.

func (*TableName) Nodes

func (node *TableName) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type TableOption

type TableOption struct {
}

type TableOptionType

type TableOptionType int

TableOptionType is the type for TableOption

const (
	TableOptionNone TableOptionType = iota
	TableOptionEngine
	TableOptionCharset
	TableOptionCollate
	TableOptionAutoIncrement
	TableOptionComment
	TableOptionAvgRowLength
	TableOptionCheckSum
	TableOptionCompression
	TableOptionConnection
	TableOptionPassword
	TableOptionKeyBlockSize
	TableOptionMaxRows
	TableOptionMinRows
	TableOptionDelayKeyWrite
)

TableOption types.

type Tokenizer

type Tokenizer struct {
	InStream      *strings.Reader
	AllowComments bool
	ForceEOF      bool

	Position int

	LastError string

	ParseTree Statement
	// contains filtered or unexported fields
}

Tokenizer is the struct used to generate SQL tokens for the parser.

func NewStringTokenizer

func NewStringTokenizer(sql string) *Tokenizer

NewStringTokenizer creates a new Tokenizer for the sql string.

func (*Tokenizer) Error

func (tkn *Tokenizer) Error(err string)

Error is called by go yacc if there's a parsing error.

func (*Tokenizer) Lex

func (tkn *Tokenizer) Lex(lval *yySymType) int

Lex returns the next token form the Tokenizer. This function is used by go yacc.

func (*Tokenizer) Scan

func (tkn *Tokenizer) Scan() (int, []byte)

Scan scans the tokenizer for the next token and returns the token type and an optional value.

type TrackedBuffer

type TrackedBuffer struct {
	*bytes.Buffer
	// contains filtered or unexported fields
}

TrackedBuffer is used to rebuild a query from the ast. bindLocations keeps track of locations in the buffer that use bind variables for efficient future substitutions. nodeFormatter is the formatting function the buffer will use to format a node. By default(nil), it's FormatNode. But you can supply a different formatting function if you want to generate a query that's different from the default.

func NewTrackedBuffer

func NewTrackedBuffer(nodeFormatter func(buf *TrackedBuffer, node SQLNode)) *TrackedBuffer

NewTrackedBuffer creates a new TrackedBuffer.

func (*TrackedBuffer) HasBindVars

func (buf *TrackedBuffer) HasBindVars() bool

HasBindVars returns true if the parsed query uses bind vars.

func (*TrackedBuffer) Myprintf

func (buf *TrackedBuffer) Myprintf(format string, values ...interface{})

Myprintf mimics fmt.Fprintf(buf, ...), but limited to Node(%v), Node.Value(%s) and string(%s). It also allows a %a for a value argument, in which case it adds tracking info for future substitutions.

The name must be something other than the usual Printf() to avoid "go vet" warnings due to our custom format specifiers.

func (*TrackedBuffer) ParsedQuery

func (buf *TrackedBuffer) ParsedQuery() *ParsedQuery

ParsedQuery returns a ParsedQuery that contains bind locations for easy substitution.

func (*TrackedBuffer) WriteArg

func (buf *TrackedBuffer) WriteArg(arg string)

WriteArg writes a value argument into the buffer along with tracking information for future substitutions. arg must contain the ":" or "::" prefix.

type Tree

type Tree struct {
	Nodes [][]*TreeNode
	// contains filtered or unexported fields
}

func NewTree

func NewTree() *Tree

func (*Tree) AddNode

func (t *Tree) AddNode(tnode *TreeNode, depth int)

func (*Tree) GetValue

func (t *Tree) GetValue(node interface{}) string

func (*Tree) SetTree

func (t *Tree) SetTree(node SQLNode)

type TreeNode

type TreeNode struct {
	Id     int
	Parent int
	Name   string
	IsEnd  bool
}

type UnaryExpr

type UnaryExpr struct {
	Operator byte
	Expr     Expr
}

UnaryExpr represents a unary value expression.

func (*UnaryExpr) Format

func (node *UnaryExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*UnaryExpr) Nodes

func (node *UnaryExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Union

type Union struct {
	Type        string
	Left, Right SelectStatement
}

Union represents a UNION statement.

func (*Union) Format

func (node *Union) Format(buf *TrackedBuffer)

Format formats the node.

func (*Union) Nodes

func (node *Union) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Update

type Update struct {
	Comments Comments
	Table    *TableName
	Exprs    UpdateExprs
	Where    *Where
	OrderBy  OrderBy
	Limit    *Limit
}

Update represents an UPDATE statement.

func (*Update) Format

func (node *Update) Format(buf *TrackedBuffer)

Format formats the node.

func (*Update) Nodes

func (node *Update) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type UpdateExpr

type UpdateExpr struct {
	Name *ColName
	Expr ValExpr
}

UpdateExpr represents an update expression.

func (*UpdateExpr) Format

func (node *UpdateExpr) Format(buf *TrackedBuffer)

Format formats the node.

func (*UpdateExpr) Nodes

func (node *UpdateExpr) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type UpdateExprs

type UpdateExprs []*UpdateExpr

UpdateExprs represents a list of update expressions.

func (UpdateExprs) Format

func (node UpdateExprs) Format(buf *TrackedBuffer)

Format formats the node.

func (UpdateExprs) Nodes

func (node UpdateExprs) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type UseDB

type UseDB struct {
	DB string
}

func (*UseDB) Format

func (node *UseDB) Format(buf *TrackedBuffer)

func (*UseDB) Nodes

func (node *UseDB) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type ValArg

type ValArg []byte

ValArg represents a named bind var argument.

func (ValArg) Format

func (node ValArg) Format(buf *TrackedBuffer)

Format formats the node.

func (ValArg) Nodes

func (node ValArg) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type ValExpr

type ValExpr interface {
	Expr
	// contains filtered or unexported methods
}

ValExpr represents a value expression.

type ValExprs

type ValExprs []ValExpr

ValExprs represents a list of value expressions. It's not a valid expression because it's not parenthesized.

func (ValExprs) Format

func (node ValExprs) Format(buf *TrackedBuffer)

Format formats the node.

func (ValExprs) Nodes

func (node ValExprs) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type ValTuple

type ValTuple ValExprs

ValTuple represents a tuple of actual values.

func (ValTuple) Format

func (node ValTuple) Format(buf *TrackedBuffer)

Format formats the node.

func (ValTuple) Nodes

func (node ValTuple) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Values

type Values []RowTuple

Values represents a VALUES clause.

func (Values) Format

func (node Values) Format(buf *TrackedBuffer)

Format formats the node.

func (Values) Nodes

func (node Values) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type When

type When struct {
	Cond BoolExpr
	Val  ValExpr
}

When represents a WHEN sub-expression.

func (*When) Format

func (node *When) Format(buf *TrackedBuffer)

Format formats the node.

func (*When) Nodes

func (node *When) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

type Where

type Where struct {
	Type string
	Expr BoolExpr
}

Where represents a WHERE or HAVING clause.

func NewWhere

func NewWhere(typ string, expr BoolExpr) *Where

NewWhere creates a WHERE or HAVING clause out of a BoolExpr. If the expression is nil, it returns nil.

func (*Where) Format

func (node *Where) Format(buf *TrackedBuffer)

Format formats the node.

func (*Where) Nodes

func (node *Where) Nodes() []SQLNode

Nodes renturn this sqlnode's all children node.

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL